Analytics / New

Shop Campaigns performance data
can now flow to external analytics tools via ShopifyQL

Shop Campaigns performance data — ad spend, sales, ROAS, and customer acquisition cost — is now available through ShopifyQL. Analytics apps and BI tools can view it side by side with your other marketing channels.

What's on this page
  1. In 30 seconds: what changed
  2. How the data flows
  3. The metrics you can pull
  4. By role: what to do next
  5. Three access routes compared
  6. Three steps to get started
  7. Five things developers should know
  8. Three practical use cases
  9. A one-line summary for your pitch

1In 30 seconds: what changed

Shop Campaigns performance data such as ad spend, sales, ROAS, and customer acquisition cost is nowavailable through ShopifyQL.
That means analytics apps and BI tools can pull Shop Campaigns data directly — so it sits on the same screen as your other ad channels for direct comparison.

Before: siloed

Shop Campaigns results lived inside the Shopify admin. External analytics dashboards showed only your other channels, so side-by-side comparison wasn't possible.

Now: on the same playing field

ShopifyQL becomes the data outlet, letting analytics apps and BI tools bring Shop Campaigns into the same dashboard as every other channel.

ShopifyQL : the language and interface for querying Shopify data. This change simply adds Shop Campaigns performance data to what you can query.

2How the data flows

Shop Campaigns Ad spend / sales ROAS / acquisition cost Campaign results ShopifyQL By segment and by time period Pulled per campaign A shared data outlet Query layer Analytics apps Triple Whale / Northbeam Elevar and others Availability depends on each provider Your own custom reports Power BI / Tableau Looker Studio Connect it yourself Shopify admin Analytics tab Advertising tab View directly, no tools required
The key point: the data now comes out through a single channel, ShopifyQL. Whether you go through an analytics app or your own BI stack, the underlying data is the same. You can also view it as-is in the Analytics / Advertising tabs of the admin (the orange dotted route).

3Metrics you can pull

What the article states explicitly is the granularity: campaign-level performance, broken down by customer segment and by time period. There are six metrics.

Ad spend
Amount spent on the campaign
Sales
Sales driven by the campaign
Orders
Number of orders generated
ROAS
Return on ad spend
return on ad spend
AOV
Average order value
average order value
¥
Average customer acquisition cost
average customer acquisition cost
Data refresh frequency, retention period, supported countries/plans, and the exact ShopifyQL query syntax are not stated in the article. You'll need to confirm against real data before building on it.

4By your situation: what to do

You use an analytics app

If you're on Triple Whale / Northbeam / Elevar or similar,providers can now integrate Shop Campaigns data into their own dashboards. When it actually ships is up to each vendor, so the move is to ask your provider about their timeline.

To do: contact your provider

You build custom reports in-house

If you build your own in Power BI / Tableau / Looker Studio, etc.,you can connect it yourself via ShopifyQL. No need to wait on anyone else.

To do: connect via ShopifyQL

You just want to look at it right now

Without any external tool,you can view Shop Campaigns directly from the Analytics tab or Advertising tab in the Shopify admin. Even if you're still evaluating tool integrations, start here to see the actual data granularity before deciding.

To do: open the admin

5The three access routes compared

ItemAdmin (Analytics / Advertising)Via an analytics appYour own BI (ShopifyQL connection)
When you can start Right now Depends on the provider Right now
What you need to do Nothing (just open the tab) Check with the provider Set up the connection and queries yourself
Integration with other channels Limited to what's inside Shopify Integrated into the app's dashboard Design it however you like
Typical example Shopify admin Triple Whale / Northbeam / Elevar Power BI / Tableau / Looker Studio
Customizability Low (default views) Depends on what the app offers High

6Three steps to get started

1

Look at the real data in the admin

Check the granularity and figures for Shop Campaigns in the Analytics / Advertising tab. See for yourself what's available.

2

Decide how you'll access it

If you use an analytics app, ask the provider when it will support this. If you have in-house BI, move ahead with the ShopifyQL connection.

3

Line it up with your other channels

Put ROAS and customer acquisition cost in the same report as your existing ad channels, so you can act on it when allocating budget.

7Five things developers should know

SQL-ish

1. The interface is ShopifyQL

Rather than a new dedicated API, this is more data added to the existing ShopifyQL. If you already build reports with ShopifyQL, chances are you only need to add a new data source.

seg Period

2. Granularity is "campaign × segment × period"

You can slice by campaign, broken down by customer segment and by period. These three axes are the starting point for your query design and your dashboard dimensions.

3. For third parties, it's only "now possible"

Triple Whale / Northbeam / Elevar and others are now able to integrate— not that they are already integrated. Check each vendor's release timing before putting this in your rollout plan.

spec ?

4. No schema or refresh frequency is documented

Table names, field names, data latency, and how far back history goes are all not documented. Before building these into production reports, it's safest to cross-check them against the numbers in the admin.

5. Align metric definitions first

ROAS, customer acquisition cost, and AOV often already have in-house definitions in your existing ad reports.If Shopify's definitions and your own definitions diverge and you still plot them on the same chart, the comparison stops meaning anything. Agreeing on "what counts as acquisition cost" before you integrate is the first job of the implementation.

8Three practical use cases

CHANNEL ROAS
USE CASE 1

Rebalance ad budgets with cross-channel ROAS comparison

Problem
Shop Campaigns results stay locked inside the Shopify admin, so they can't be compared in the same table as other ad channels, and budget allocation ends up being decided on gut feel.
Approach
Pull Shop Campaigns ad spend, sales, and ROAS into your existing ad reports via ShopifyQL, and build a view that lines them up by channel.
Impact
You can compare "where the next dollar should go" on a single consistent metric, giving allocation decisions a quantitative basis.
Technical note
First align the definitions of the ROAS denominator (when ad spend is recognized) and numerator (the sales attribution window) across channels. Lining them up without that alignment invites bad decisions.
New Existing CAC comparison By segment
USE CASE 2

Decide "who to go after" using acquisition cost by customer segment

Problem
You only see campaign-wide averages, so there's no way to tell which customer segments are expensive or cheap to acquire.
Approach
Pull average customer acquisition cost and AOV by customer segment, and build an "acquisition cost vs. average order value" matrix at the segment level.
Impact
You can focus on the segments that pencil out, and give targeting and creative direction a quantitative basis.
Technical note
ShopifyQL supports slicing by customer segment and by time period. Slicing periods too finely adds noise from small sample sizes, so wait until you have enough volume before drawing conclusions.
Integration BI
USE CASE 3

Automatically include Shop Campaigns in monthly client reports

Problem
In monthly reports for design and operations clients, only the Shop Campaigns numbers are copied over by hand from the admin, costing time and risking transcription errors.
Approach
Connect to ShopifyQL from Looker Studio, Power BI, or similar, and feed campaign results automatically into your existing monthly report template.
Impact
Manual transcription disappears, cutting reporting effort and improving number consistency at the same time. The more stores you manage, the bigger the payoff.
Technical notes
If the merchant you support already runs an analytics app (Triple Whale, etc.), waiting for the provider to add support is a valid alternative to building it yourself. Check timelines with each vendor.

9One-line summary you can use in a pitch

"Shop Campaigns ad spend, sales, ROAS, and customer acquisition cost are now available from ShopifyQL.
With an analytics app, you wait for the provider; with your own BI, you can connect right now; in the admin, you can view it today.
The fastest start is to look at the actual data in the Analytics / Advertising tab and begin preparing to report it alongside your other channels."