Commerce7 Customer Query feature is a way to segment Customers based on certain conditions. It is a powerful tool which will enhance your marketing efforts and allow you to send tailored marketing material to a targeted group.
Here are some suggested Queries to help you effectively segment your customer base and how you can act on them:
- Former Club Members
Former Club Members
This will provide you with a list of customers who used to be Club Members but are no longer active in any Clubs. When marketing to this customer segment, your goal should be to entice them to re-join as Club Members. For example, you can provide them with Coupon Codes or temporarily enable Club Benefits such as discounts and access to limited edition products to encourage them to come back.
High LTV Non-Club Members
This Query will provide you with a list of customers who have spent over $1000 at your winery but hasn't signed up for a Club Membership. These are customers who enjoy your wines and may be considering joining your Club. When marketing to this customer segment, your goal should be to convert them to a Club Member. For example, you can temporarily enable Club Benefits such as discounts and access to limited edition products/reservations so they can experience what it's like to be a Club Member.
This gets you a list of all customers with a September birthday. Birthday month is a great time to encourage purchases as there are celebration and festivities around it.
You can provide them with a HAPPYBIRTHDAY Coupon Code for a free gift or to provide additional discounts.
First Order in X Month
This Query will generate a list of customers who made their first order in July. A great way to turn these first-time customers into returning customers would be to send marketing material about your company's mission and story.
You can also provide a one-time use Coupon Code to encourage these customers to re-order.
Subscribers without a purchase
This will provide you a list of Subscribers who have not made a purchase. Subscribing to a mailing list shows interest in learning more about your business. You should market to subscribers with purchases differently than those without purchases. They are likely still evaluating your offerings and feeling tentative to make that first purchase, so your marketing material should try to address these hesitations.
Purchased at POS but never online
This is a list of customers who have bought something at the tasting room but never purchased online.
When marketing to this customer segment, your goal should be to entice them to purchase online. For example, you can send them a link to your Magic Link page so they can create a login and/or provide them with Coupon Codes for Free Shipping to help them get over any hesitation around online orders.
Regular customers who have stopped ordering recently
This list helps you identify high-value customers who may be losing interest in your products or offerings. In the example above, it would generate a list of customers with 5 or more orders but hasn't made an order in 2020. It's a great opportunity to win their love back by encouraging them to purchase with coupon codes or additional perks.
This list will help find everyone who purchased certain skus. For example, list for everyone who purchased sku C7123, C7456, C7789 etc. You will need to set it up as conditional sets. Sets are as follows:
Searching for customer who purchased specific skus
- Marketing > Queries > Orders
- 1st set > and > sku purchased > is equal to > sku #/name
- Click on "add order query"
- Click on "add another set of conditions" and press save
- Continue repeating step 4 for all remaining skus