Home Test article
Automate reporting
Create dynamic reports or use the ready-to-go dashboard templates with Coupler.io
Get started for freeHere is a list of data set templates for Shopify
- Marketing funnel (Ads + GA4 + Shopify) — Full journey from ad engagement to site interaction to purchase, combining ad platforms, GA4, and Shopify data.
- Total sales by order — Shipping, customer, and order details for each Shopify order.
- Line items with shipping and taxes — Full line-item detail for every order, including shipping and tax data.
- Total sales by line item — Order-level data broken down by line item in a single data connection.
- Orders with COGS — Sales data grouped by order and date for tracking revenue trends against cost of goods sold.
- Line items with COGS — Line-item performance alongside COGS for profitability, tax, and margin analysis.
- Sales by new vs returning customers — Revenue split between new and returning customers across daily, weekly, and monthly views.
- Top selling products — Best-selling products by revenue with daily, weekly, and monthly trend tracking.
- Sales by billing location — Sales distribution by country/billing location to identify high-performing geographic markets.
- Total customers & avg order value — Customer count and average order value over time with aggregated and order-level views.
- Sales by order financial status — Orders grouped by payment status (pending, authorized, paid) with weekly and monthly trends.
- Sales by order fulfillment status — Orders grouped by fulfillment status with daily, weekly, and monthly patterns for operational tracking.
- Top customers — Highest-value customers by purchasing behavior and spending patterns.
- Sales by sources — Sales channel performance showing which traffic sources drive the most revenue.
- Sales by product variant — Performance of individual sizes, colors, or styles across multiple timeframes.
- Returning customer rate — New vs returning customer balance over time for retention and loyalty analysis.
- Shopify and GA4 daily performance — Shopify sales combined with GA4 behavioral data, tracked daily.
- Shopify and GA4 weekly performance — Same combination tracked weekly for mid-range trend identification.
- Shopify and GA4 monthly performance — Same combination tracked monthly for long-term trend analysis.
- Inventory daily stockout forecast — Stockout predictions based on current inventory vs daily sales velocity.
- Inventory weekly stockout forecast — Stockout predictions based on weekly sales velocity.
- Inventory monthly stockout forecast — Stockout forecast using available quantity, sales pace, and stock duration in months.
- Orders processing time — Order processing times with daily, weekly, and monthly views plus detailed order data.
Article by
