Marketing reports

What your marketing actually returned — sales, orders and customers attributed to each channel and campaign, under Shopify's own attribution, across every store.

3 built-in reports — every one opens in the report editor, runs across all connected stores in one currency, and can be saved, exported or scheduled. The query under each report is the whole report — readable, and yours to change.

Shop channel product impressions

How often your products were seen on the Shop channel, day by day, against the previous period.

FROM shop_product_impressions
  SHOW shop_product_impressions
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE shop_product_impressions TYPE line

Performance by referring channel

What each traffic source returned — sessions, attributed sales, orders and customers by referring channel and traffic type, including direct and organic.

FROM referring_channel_performance
  SHOW sessions, total_sales, orders, conversion_rate, average_order_value,
    new_customers, returning_customers
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY referring_channel, traffic_type WITH TOTALS, GROUP_TOTALS
  ORDER BY total_sales DESC, referring_channel ASC, traffic_type ASC
  LIMIT 1000
  VISUALIZE total_sales TYPE stacked_bar

Performance by marketing channel

What each marketing channel and campaign returned — attributed sales, orders, customers and engagement, under Shopify's last-non-direct-click attribution.

FROM marketing_performance
  SHOW sessions, total_sales, orders, conversion_rate, roas, cost_per_acquisition,
    customer_acquisition_cost, impressions, click_through_rate, average_order_value,
    new_customers, returning_customers
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY marketing_platform, marketing_activity_title WITH TOTALS, GROUP_TOTALS
  ORDER BY total_sales DESC, marketing_platform ASC, marketing_activity_title ASC
  LIMIT 1000
  VISUALIZE total_sales TYPE stacked_bar

FAQ

Do these marketing reports cover all my Shopify stores? Yes — every report on this page aggregates across all connected stores and converts to one currency. Group by store inside any of them for the per-store split.

Can I change what a report shows? Yes — every report opens in the report editor, where metrics, groupings, filters, date ranges and the chart are all editable, and your version saves to your own library.

Can I get these reports automatically? Yes — any report can be downloaded as CSV or Excel, or scheduled to arrive by email or FTP on the cadence you choose.