Shop Campaigns Performance Data Now Available via ShopifyQL

Shopify has added the shop_campaign_insights schema to ShopifyQL, enabling analytics and reporting apps to query Shop Campaigns performance data programmatically. Apps can access this data on behalf of authorized merchants using the existing shopifyqlQuery field with the read_reports scope.

Available Metrics and Dimensions

The new schema provides campaign-level and segment-level metrics including ad spend, sales, orders, ROAS (return on ad spend), average order value, and average customer acquisition cost. Developers can query this data by campaign name, customer segment, and time dimensions ranging from hourly to yearly granularity.

Impact for Analytics App Developers

This update expands the data available through ShopifyQL, Shopify’s query language for analytics. Apps focused on marketing analytics, campaign reporting, or business intelligence can now integrate Shop Campaigns data alongside other merchant metrics without requiring separate API endpoints.

The implementation uses Shopify’s existing authentication and permission model through the read_reports scope, meaning apps that already have reporting capabilities can add Shop Campaigns data without requesting additional permissions from merchants.

Technical Considerations

Developers building or maintaining analytics apps should evaluate whether Shop Campaigns data fits their product roadmap. The time dimension flexibility allows for both real-time monitoring (hourly data) and long-term trend analysis (yearly aggregations). Apps serving merchants who actively use Shop Campaigns for customer acquisition may find this data particularly valuable for ROI tracking and campaign optimization features.

Read the full announcement →