Integrations 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick integrations google-analytics analytics reporting

Build the Shopify Half of a Merged GA4 + Store Analytics Report

Get Sidekick to build a real ShopifyQL report on your store data, plus a fill-in template for the GA4 metrics you pull manually — Sidekick cannot query Google Analytics itself.

📋 Prompt
Run in Sidekick
Reality check: Sidekick only knows what’s in your Shopify store — it cannot query
Google Analytics 4 or any external analytics tool. It’s strong at building
ShopifyQL reports from plain language, so use it for the Shopify-side numbers, then
paste in your GA4 numbers by hand using the template below to get one merged view.

Report period: [DATE RANGE, e.g., last 30 days]
Compare to: [PREVIOUS PERIOD / SAME PERIOD LAST YEAR / NONE]

Build a Shopify Analytics/ShopifyQL report covering:

  Total revenue and order count for the period, with % change vs. the comparison period.
  Sessions and conversion rate by traffic source, if UTM-tagged campaigns are present.
  Top 10 products by revenue and by units sold.
  Average order value and repeat purchase rate.
  Revenue by device type (mobile/desktop/tablet), if available.


Export this as a table I can drop into a spreadsheet.

Manual step — fill in from GA4 yourself (Sidekick cannot pull these):


  
    
      Metric
      Shopify Analytics (from Sidekick)
      GA4 (fill in manually)
    
  
  
    
      Sessions
       
       
    
    
      Users (new vs. returning)
       
       
    
    
      Bounce rate / engagement rate
       
       
    
    
      Channel grouping breakdown (organic, paid, direct, referral, email)
       
       
    
    
      Goal/conversion events outside checkout (e.g., sign-ups, add-to-cart)
       
       
    
    
      Landing page performance
       
       
    
  


Handoff steps (outside Sidekick):

  In GA4, go to Reports → Acquisition (or Explore) for the same date range and comparison period as above, and fill in the right-hand column.
  Watch for a mismatch in session/order counts between GA4 and Shopify Analytics — this is expected (different attribution windows, ad blockers affect GA4 more) and isn’t a Sidekick error; don’t ask Sidekick to reconcile it, it has no visibility into GA4’s methodology.
  Repeat this pairing manually each reporting cycle — there’s no live sync between the two.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions