Please enter a keyword
About EC Analysis
EC Analysis has Sales for store metrics and Items for product results. See supported stores, reports, Amazon and Stripe features, date ranges, and data updates.
Author: Cascade
EC Analysis lets you analyze data from connected ecommerce stores and payment services across sales, products, customers, and inventory. Combined with ad performance, this data helps you identify areas for improvement.
The EC section in the left menu has 5 pages: Sales for store-wide metrics, Items for product performance, Reviews for review topics, Catalog for per-product gross margins and Amazon A+ Content, and Pricing for Amazon selling prices and competitor prices. This article provides an overview of Sales and Items.
Prerequisites
Available on the Business plan.
Owners, Admins, Editors, and Viewers can view these pages. Guests cannot.
You must have connected one of the following: Shopify / Shopline / Colorme Shop / BASE / Amazon Sales / Rakuten Ichiba / Yahoo! Shopping / Qoo10 / TikTok Shop / Smaregi (physical stores) / Stripe (sales source).
If no service is connected, "EC Platform Not Connected" appears. Click Set Up Integrations to open Settings > Integrations, then connect a service under Commerce Integrations.
When you have 2 or more connections, use the tabs at the top of the screen to switch stores. If you connect both a seller and a vendor in Amazon Sales, switch between Seller and Vendor within the tab.
When to use Sales and Items
Page | What you see | Main cards |
|---|---|---|
Sales | Store-wide metrics, trends over time, and breakdowns | Sales Trend, Sales target, Ad Efficiency (TACoS / ACoS), Brand Store, Returns, Fees & Settlement, Settlement & fee breakdown, Sales by Channel, By Store, Subscriptions, Customer LTV Analysis, Traffic Channel Analysis, Returns & Refunds Analysis, Subscriptions (Stripe) |
Items | Performance by product (SKU, ASIN, or product ID) | Product Traffic (Amazon), Product ABC Analysis, Sales trend by item, Inventory Count, Product Sales Ranking, Return Rate by Product (SKU / Variant), Bundle Purchase Ranking, Shopify Exclusion Settings |
Use Sales to spot anomalies across the store, then Items to identify the products involved. The selected store tab and date range are shared between the 2 pages and remain selected as you switch between them.
The Total tab shows Sales Trend and Sales target in Sales, and Product Sales Ranking and Product ABC Analysis in Items. The Total tab does not convert currencies, so it combines only connections using Japanese yen. Connections with different currencies or days with missing data are excluded from the total with a note.
Available analyses by store
Analysis | Page | Description | Supported stores |
|---|---|---|---|
Sales Trend | Sales | Trends in gross sales, net sales, return amounts, orders, and average order value. Comparisons with the previous period and the same period last year. | All (gross sales only for stores that do not provide net sales or return amounts) |
Sales target | Sales | Progress toward monthly sales targets and projected final sales. Set targets in the Total tab. | All |
By Store | Sales | Net sales, sales share, refund amounts, customer counts, and member rates by store | Smaregi |
Product ABC Analysis | Items | Products classified as A / B / C based on their cumulative share of sales | All |
Product Sales Ranking | Items | Top 10 products by number of orders | All |
Inventory Count | Items | Inventory counts by product and inventory status calculated from average daily sales | All (Rakuten Ichiba requires enabling the inventory API in RMS) |
Bundle Purchase Ranking | Items | Combinations of products purchased together | All |
Sales trend by item | Items | Line charts of daily sales and units sold for products with sales during the period. The top 5 products by sales are shown by default. Use Items shown to select up to 5 products from the top 100 by sales. | Amazon Sales, Rakuten Ichiba, Yahoo! Shopping, Qoo10 |
Customer LTV Analysis | Sales | LTV by segment, distribution of purchase counts, and sales contribution from new and existing customers. Rakuten Ichiba and Qoo10 also show the F2 conversion rate and average LTV across all customers. | Shopify, Shopline, Colorme Shop, BASE, TikTok Shop, Rakuten Ichiba, Qoo10 |
Subscriptions | Sales | Subscription status from subscription apps (active, paused, new, canceled, churn rate, and retention rate) and subscription revenue based on orders | Shopify |
Returns & Refunds Analysis | Sales / Items | Sales shows return rates, refund amounts, and comparisons by discount status and new or returning customers. Items shows return rates by SKU and variant. | Shopify, Shopline, Colorme Shop, BASE, TikTok Shop |
Traffic Channel Analysis | Sales | Sessions, share, orders, and CVR by traffic source | Shopify, Shopline, Colorme Shop, BASE |
Sales by Channel | Sales | Sales by order source, such as the online store, POS, and connected apps (shown when there are 2 or more channels) | Shopify |
Settlement & fee breakdown | Sales | Estimated net revenue and fees based on settlement amounts in order data | Qoo10 |
Shopify Exclusion Settings | Items | Exclude items such as package inserts from product-level calculations. Exclusions apply to product-level calculations and Returns & Refunds Analysis in Sales. | Shopify |
Smaregi and Stripe do not have product-level data, so they do not appear as tabs in Items.
Analyses available only in the Amazon tab
Analysis | Page | Description |
|---|---|---|
Ad Efficiency (TACoS / ACoS) | Sales | View daily trends and period totals for ad spend as a percentage of total sales (TACoS) and ad-attributed sales (ACoS), based on Amazon Ads spend and sales. |
Brand Store | Sales | Brand Store performance by traffic source, attribution tag, and page. Shows estimated orders and sales within 14 days of a visit. |
Returns | Sales | Returned units and return rates included in sales reports (Amazon does not provide refund amounts or returns by product) |
Fees & Settlement | Sales | Breakdowns of selling fees, FBA shipping and storage, promotions, refunds, ads, and other costs, plus net proceeds (financial data is retained for the most recent 90 days) |
Product Traffic (Amazon) | Items | Product page sessions, page views, CVR, units sold, and ad traffic share (up to 2 years) |
Inventory-linked guard | Items (Ad guard settings in the Inventory Count card) | Detect products that are close to running out of stock and send notifications, or automatically pause ads for those products and resume them when inventory recovers (Amazon product ads only). |
Buy Box share drop alert | Items (same as above) | Receive a chat notification when a product's share of the Add to Cart button drops significantly. |
With a Vendor (1P) connection, you can switch Buyer type and Selling program in Sales Trend. You can also view the Open PO Count column in the Inventory Count card, along with Amazon's weekly demand forecasts and net profit margins.
Analyses available only in the Stripe tab
Subscriptions (Stripe) lets you view active subscriptions, new subscriptions, cancellations, churn rate, MRR, LTV, cancellation reasons, uncollected payments, cohort retention, purchase cohorts, and sales trends for Stripe payments. The Stripe tab appears only in Sales.
View Amazon and Rakuten Ichiba review topics in EC > Reviews. In Items, the tabs for stores that support reviews show the message "Review topics (customer voice) have moved to Reviews."
For details on each analysis, see the articles in this category (Sales Trend, Product ABC Analysis, Customer LTV Analysis, and others).
Select a date range
On each page, use the date range selector in the upper right to change the displayed period. The default is Last 14 Days. Your selected store tab and date range are shared between Sales and Items.
Choose from Today, Yesterday, 2 Days Ago, Last 1 day, Last 7 Days, Last 14 Days, Last 28 Days, Last 30 Days, This Week, Last Week, This Month, Last Month, This Year, Last Year, or a custom range with a start and end date. Periods restricted by the store's data retrieval limits are automatically removed from the options.
Amazon order details and financial data, as well as Rakuten Ichiba and Yahoo! Shopping order details, are retained only for the most recent 90 days. Analyses that compare with the previous period appear only when both the selected period and the previous period fall within those 90 days. Rakuten Ichiba's Product ABC Analysis, Product Sales Ranking, and Sales trend by item are not subject to this limit. TikTok Shop has a 92-day data retrieval limit.
Data update timing
Data from each store is imported automatically at least 1 time per day. Data for the current day appears the next day or later.
Historical data is imported during the initial connection setup (the past 2 years for Amazon daily data).
Immediately after you connect Rakuten Ichiba, orders from the most recent 90 days are imported first. Earlier history is filled in progressively during subsequent syncs. Once the import is complete, data syncs automatically about every 6 hours.
Due to Shopify's specifications, Sales by Channel for Shopify includes only orders from approximately the most recent 60 days.
Sales target progress and projected final sales use results through the previous day. They update each morning and when sales data finishes syncing.
Troubleshooting
Message | Cause | Solution |
|---|---|---|
"EC Platform Not Connected" | The commerce connection is not complete. | Click Set Up Integrations to open Settings > Integrations and connect a service. |
"Data retrieval for [X] has stopped" / "Syncing has stopped" | Syncing has stopped because the connection or the Yahoo! Shopping public key has expired. | Click Open integrations and follow the instructions to reconnect or update the public key. If you do not have permission, ask an Admin. |
"Failed to load data" | A temporary communication error with the connected service, or insufficient permissions. | Click Retry in the card, or wait a while and try again. |
"[X] cannot be displayed for this period" | The selected period exceeds the store's data retention period (the most recent 90 days). | Select a period that falls within the most recent 90 days, including the previous comparison period. |
"[X] is excluded from the total because sales during the period include multiple currencies" | Sales during the period include multiple currencies. | Shorten the date range and try again. |
"Syncing product data for the selected period" | Amazon product data has not finished syncing. | Data syncs 1 time per day. It appears automatically when syncing is complete. |
"None of the connected EC platforms support the analyses on this page" | You have connected only services that do not support Items (Smaregi and Stripe). | View sales from physical stores and Stripe in Sales. |
Related articles
More articles in this category
