I am seeking guidance on extracting data from the “Shop Campaigns Performance” analytics report, which details daily ad spend, for my store where Shop Pay is installed. Specifically, I would like to know which API endpoints or methods are appropriate for accessing this information, as I have not found relevant details in the GraphQL documentation.
Your assistance in directing me to the correct API or providing alternative solutions for retrieving this data would be greatly appreciated.
Hi there,
Typically you’d use ShopifyQL for analytics related to the reports you’d see on the admin - however this is only available for Plus stores, and it’s currently being sunset. I’d recommend testing out the marketingActivities and marketingActivity queries to see if they can access the data you need related to ad spend.
Hey @Level_Agency - returning to close the loop on this older thread here.
@Liam-Shopify’s December 2024 reply noted that the prior ShopifyQL option was being sunset, which it was at the time.
ShopifyQL has since been rebuilt and become a first-class platform surface, with versioned schema documentation:
As of August 11, 2026, Shop Campaigns performance data is available through the shop_campaign_insights ShopifyQL schema. You can query campaign-level and segment-level metrics, including ad spend, sales, orders, ROAS, average order value, and customer acquisition cost, using the existing shopifyqlQuery field with the read_reports scope. You can find the schema reference here: shop_campaign_insights, and the changelog reference here:
Hope this helps!