We've made it possible to generate metric trends data from before the creation date of segments!
Explore the trends from the start of the period and last fiscal year's data. Initially, as a beta version, ECPower will create and reflect this data as a service.
If you're interested, please feel free to contact us via in-app support chat🚀
Background
A unique feature of ECPower, allowing you to check the trends in data such as the number of customers, repeat customer rate, LTV, and sales per customer segment, has been very well received by our users. However, a limitation where you could only check data from the date the customer segment was created has been a significant inconvenience for those who wanted to create and report data from the beginning of a period or compare it with data from the previous fiscal year.
Eventually, we aim to enable users to view past data with a single click. For now, we are starting the provision of a beta service where, upon request, the ECPower product team can create data and reflect it on the customer's screen for the purpose of testing the functionality.
Specifications
1. Please contact the support team with the customer segment you wish to analyze and the period for which you want to create the data.
2. Target data for creation: We will create all of the following data.
- Overview > Customer segment's "Customer counts," "Repeat Customer %," "Lifetime value," "Average Order Value," "Average Order Count," and "Purchase Interval"
- Orders > "Revenue," "Order count," "Order Activity History" from the customer segment
3. We aim to create past data within three business days and reflect it on the user's screen.
Regarding data accuracy and quality
Due to constraints on data that can be integrated with Shopify, the accuracy of the data may decrease depending on the conditions of the customer segment. The following three points particularly affect the accuracy of the data:
Customer tags are calculated based on the assumption that they have been applied since the customer's first purchase.
For example, assuming you have customer segments of 'customers with "Bronze Member" tag' and want to produce data back to 2022.
Creating 2022 data for a customer segment with the "Bronze Member" tag assumes the customer was a "Bronze Member" from 2022, even if they actually became one in 2023.
Conversely, customers who were "Bronze Members" in 2022 but are not at the current time will not be reflected in the data created.
This is because Shopify does not retain data on "customer tag history" or when the customer tag was changed.
*For this reason, segments related to customer tags are not recommended due to the inability to guarantee data accuracy. (Consider this data for reference only)
If product tags or product types associated with products have changed during the period, all calculations will be based on the current data.
For example, assuming you have customer segments of 'purchased product with "Recommended Product" tag' and want to produce data back to 2022.
If a product did not have a product tag in 2022 but was tagged as "Recommended Product" in 2023, the calculation will assume the tag was present in 2022.
This is because Shopify does not retain data on when product tags were changed.
If the product name was changed midway, data from before the change cannot be reflected.
For example, assuming you have customer segments of 'purchased [Recommended] Macaron Set' and want to produce data back to 2022.
If a product was named "Macaron Set" in 2022 and changed to "[Recommended] Macaron Set" in 2023, customers who ordered under the old product name will not be reflected in the data (the customer count will be zero).
This is a limitation of ECPower's specifications, and improvements are planned for the future.
Service eligibility and pricing:
This service is offered as a option to customers with a paid plan, without extra charge.