ShopifyQL lets you query your Shopify analytics data directly — no BI tool required. If your CreatorCommerce links are tagged with a cc- prefix in utm_content, you can use that tag to isolate CC traffic inside Shopify and see exactly how it converts and how much it spends.

This article walks through two ready-to-run queries — one for a conversion funnel, one for average order value over time — and shows you exactly where to paste them inside Shopify's analytics explorations.

‍

Before you start

These queries assume every CreatorCommerce partner link carries a cc- prefix in its utm_content parameter. That prefix is what lets Shopify isolate CC traffic from the rest of your marketing mix.

If your links do not use a cc- prefix today, update your link-building conventions before relying on these queries. Without a consistent prefix, utm_content CONTAINS 'cc-' will not return the right slice.

For details on how CC structures attribution parameters, see Affiliate Link Tracking in the CC reference docs.

‍

How to run these queries in Shopify

The ShopifyQL editor lives inside Shopify's analytics explorations. Every query in this article is self-contained — paste it in, adjust the date range if you need a different window, and run it.

1. In your Shopify admin, open Analytics from the left-hand nav.
2. Click New exploration. This opens a blank ShopifyQL editor.
3. Delete any placeholder query in the editor, then paste in one of the queries from this article.
4. Click Run query. Shopify renders the visualization defined in the VISUALIZE clause — a funnel for Query 1, a line chart for Query 2.
5. To change the time window, edit the SINCE clause. For example, use SINCE -90d UNTIL today for a 90-day view, or SINCE 2026-01-01 UNTIL 2026-03-31 for a specific quarter.
6. Optionally, click Save to keep the exploration in your analytics library so you can rerun it later without re-pasting.

If you do not see New exploration in your Shopify admin, your plan may not include ShopifyQL explorations. The same queries can be used in Shopify's custom report builder on supported plans — the syntax is identical.

‍

What these queries help you answer

• How much CC-tagged traffic actually reaches cart, checkout, and purchase
• Whether CC traffic is converting better or worse than the previous period
• How average order value on CC-tagged sessions is trending over time

‍

Query 1: Conversion rate breakdown

‍

Use this query when you want a daily funnel view of CC traffic against Shopify's sessions dataset. It returns the four main funnel steps plus overall conversion rate, compared against the previous 30-day window.

FROM sessions
 SHOW sessions, sessions_with_cart_additions, sessions_that_reached_checkout,
   sessions_that_completed_checkout, conversion_rate
 WHERE utm_content CONTAINS 'cc-'
 TIMESERIES day WITH TOTALS, PERCENT_CHANGE
 SINCE -30d UNTIL today
 COMPARE TO previous_period
 ORDER BY day ASC
 LIMIT 1000
VISUALIZE conversion_rate TYPE funnel


What each clause does

• FROM sessions — pulls from Shopify's session dataset, which is where storefront funnel metrics live.
• WHERE utm_content CONTAINS 'cc-' — limits the result to CreatorCommerce-tagged traffic.
• SHOW sessions, sessions_with_cart_additions, sessions_that_reached_checkout, sessions_that_completed_checkout, conversion_rate — returns each funnel step plus the overall session-to-order conversion rate.
• TIMESERIES day WITH TOTALS, PERCENT_CHANGE — adds daily rows, a rolled-up total, and change columns for the comparison period.
• COMPARE TO previous_period — benchmarks the last 30 days against the preceding 30 days.
• VISUALIZE conversion_rate TYPE funnel — renders the result as a funnel chart keyed to conversion performance.

How to read the result

1. Compare sessions_with_cart_additions to sessions_that_reached_checkout. A big gap between these two usually points to mid-funnel friction — product page confusion, shipping surprises, or a weak cart experience.
2. Compare sessions_that_reached_checkout to sessions_that_completed_checkout. Drop-off here is a checkout problem — payment methods, forced account creation, or unexpected fees.
3. Watch the PERCENT_CHANGE column. A rising percentage means CC traffic quality is improving; a falling percentage means it is degrading versus the previous period.

‍

Query 2: Average order value over time

‍

Use this query when you want to know whether CC-tagged traffic is driving stronger or weaker order values over time. It pulls from the sales dataset and uses last-click attribution so the AOV line matches how Shopify attributes revenue in most reports.

FROM sales
 SHOW gross_sales, discounts, orders, average_order_value
 WHERE excludes_post_order_adjustments = 'true'
   AND utm_content CONTAINS 'cc-'
 GROUP BY day WITH TOTALS, PERCENT_CHANGE, LAST_CLICK_ATTRIBUTION
 TIMESERIES day
 SINCE -30d UNTIL today
 COMPARE TO previous_period
VISUALIZE average_order_value__last_click TYPE line


What each clause does

• FROM sales — pulls from Shopify's sales dataset, which is where revenue and order-value metrics live.
• WHERE excludes_post_order_adjustments = 'true' — keeps AOV anchored to the original order value, not adjusted by later refunds or edits.
• WHERE utm_content CONTAINS 'cc-' — limits results to CreatorCommerce-tagged traffic.
• GROUP BY day WITH TOTALS, PERCENT_CHANGE, LAST_CLICK_ATTRIBUTION — buckets results by day, adds comparison columns, and asks Shopify for last-click attributed metrics.
• TIMESERIES day — keeps output day-based for trend review and charting.
• VISUALIZE average_order_value__last_click TYPE line — plots the last-click-attributed AOV metric that Shopify exposes when LAST_CLICK_ATTRIBUTION is applied.

How to read the result

• Rising AOV with flat conversion usually means CC traffic is buying higher-priced bundles or adding more items per cart.
• Falling AOV can indicate discount-heavy traffic, a weaker product mix, or a funnel variant that is pulling more low-intent orders.
• AOV plus conversion read together tells you whether a change in CC performance is about efficiency (conversion) or basket size (AOV) — or both.

‍

Reading the two queries together

Neither query is useful in isolation. Run them side by side and look for the combination that matches the story you think your CC program is telling:

• Conversion up, AOV up — CC traffic is getting more efficient and spending more. This is the pattern you want.
• Conversion up, AOV down — you are likely getting more buyers, but at lower price points. Check whether a discount or lower-priced launch is driving it.
• Conversion down, AOV up — fewer but higher-value buyers. Often shows up when a specific high-AOV creator is driving a disproportionate share of orders.
• Conversion down, AOV down — worth a closer look. Start with the funnel drop-off steps from Query 1 to find where the friction is.

‍

Keep your link tagging consistent

All of this depends on the cc- prefix being present on every CreatorCommerce link. If different creators or campaigns use different conventions, the WHERE utm_content CONTAINS 'cc-' filter will silently exclude them and your numbers will be off.

If you are unsure whether your links are tagged correctly, pull up any active CC partner URL and inspect the utm_content parameter. If the prefix is missing, update your link templates before trusting these reports.

‍

Related

• Shopify integration — how CC connects to your Shopify store
• Track your funnel traffic — how CC traffic gets tagged end to end
• Affiliate link tracking — the full parameter structure on CC partner links
• SDK web pixel tracking — how CC's pixel works alongside Shopify's