Tresl Segments

??Advanced segmentation alert, read at your own risk?? A real person typed this query into our #FilterGPT: QUESTION: 初回購入日から最終購入日までの期間が210日以上あり、最終購入日から現在までの期間が240日未満。かつ「売り上げ累計」が25000円以上あるのお客様 Google Translate: The period from the first purchase date to the last purchase date is 210 days or more, and the period from the last purchase date to the present is less than 240 days. Customers with cumulative sales of 25,000 yen or more AI RESPONSE: { "reason": "using time_between_xth_order_y_order to calculate the time between the first and last purchase. Using last_ordered_days to calculate the period from the last purchase date to the present. Using total_spend to calculate the total sales", Filters: time_between_xth_order_y_order: xh_order = 1, yth_order = -1, number_of_days < 210 last_order_days < 240 total_spend >= ￥25000 This Shopify merchant sells CPG and is most likely trying to find out how many customers have made large orders in the past but should have run out of it by now. The dates are pretty specific, which tells me he knows his customers' average rate of consumption relative to the size of the goods. AFAIK we are the only service that offers this filtering on the market; correct me if I'm mistaken. - Type your query - Do it in a foreign language - Advanced filtering use cases (time between first and last purchase) - Return the segment with the right filters To have the ability to ask "what if" to your data with the right segmentation tool that answers this question on the spot feels pretty amazing. We're also working on #ReportGPT to make automated reports based on prompts, and you'll soon be able to send any report you create to your inbox with #ShopifyFlow. Stay tuned. #makedataeasy #treslsegments p.s. We are Shopify Plus certified.

Every year, we release our BFCM insights report to guide Shopify merchants on effective strategies that have worked in previous years. This year, our analysis covered 2023 BFCM data for over 140+ paying stores. These stores generated over $21 million in total revenue and received 210K+ orders. Here’s a quick look at some of the biggest revelations: ? 45% of customers were repeats, accounting for 49% of revenue ? 55% were first-time buyers, accounting for 51% of revenue ? Open rate for emails was much higher a week before Black Friday (T-8 days), but the biggest sales day was Black Friday by a long way, followed by Cyber Monday ? Discount level was steepest on Black Friday with the average store at 19%.? ? BFCM AOV was $99.63 Dive into the data with us in the full report! Link in the comments.

?? January 2024 Shopify E-Commerce Benchmark Metrics: Total number of orders analyzed: 583,026 (+10.04% YoY) Total Revenue: $46.8M, +10.09% Average Revenue per Store: $712.8K, +11.24% Total Customers: 519.2K, +8.73%? Average Order Value (AOV): $100.76, -4.05%? Average Number of Orders (ANO): 1.10, +0.65%? Average Revenue Per User (ARPU): $113.02, -3.08% Email Open Rate: 53.43%, -10.98%? Email Click Rate: 1.97%, -17.74% What I’m noticing: - The returning customer rate in January is almost as high as in November. It is likely due to additional clearance sales or new year/new you stuff. - The list growth is lower in Jan 2024 vs. a year ago, likely due to brands getting ready for upcoming deliverability compliance changes coming to Yahoo/Google in February. - Looking ahead there is one extra day of sales in February due to leap year (yay!), and March should see a bump in sales as warm weather returns #EcommerceBenchmarks #TreslSegments #shopify

Segment of the week: BFCM first-timers and Abandons Shopify reported?$9.3B?in sales over #BFCM — a?24% increase, but more importantly, how did BFCM go for you? Our?data?shows that first time customers during BFCM are 25% less profitable on average, especially given the insanely high CAC during this period. What can you do to get to break-even faster? Here are some segments you should create: 1. BFCM first-timers—keep them engaged Filter:?“First order date between Nov. 24 to Nov. 27” (see image 1) New customers acquired during BFCM are likely deal hunters. Create a segment to target and monitor the performance of this cohort of customers. We recommend sending unique personalized follow-up emails & SMS campaigns to this segment, strategically designed to keep them engaged in the brand. Depending on your brand and what they purchased during BFCM this might look like additional discounts, or more brand story-telling, or even more personalized content. 2.?BFCM abandon checkouts—offer extension Filter:?“Abandoned checkout during Nov. 24 to Nov. 27, and number of orders = 0” (see image 2) You’ll likely experience a higher than normal abandonment rate during BFCM as consumers browse for the best deals. Depending on your brand, consider giving them a?one-time only?BFCM deal extension, exclusively for this group of customers—you just might convert enough of them to pad your bottom line. Congrats on making it through BFCM, but it doesn’t stop here—top brands have likely already planned out their 2024 marketing calendars. #postbfcm #PartnerThursday #makedataeasy #treslsegments