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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions