How to get your exports
Follow the steps for each platform. Both take about two minutes. Make sure to use the same date range for both exports before you start.
GA4Transactions export
- Log into GA4 at analytics.google.com and select your property
- In the left sidebar click Reports, then expand Monetization
- Click Transactions
- Set the date range in the top right corner to the period you want to check
- Click the download icon in the top right of the report and select Download CSV
If you see a blue banner at the top of GA4 saying data is being estimated to account for cookie consent, make a note of this. It means some of your GA4 transactions are modeled by Google, not directly observed. The tool will flag this in your results.
ShopifyPayments export
- In your Shopify admin go to Analytics, then Reports
- Click Create custom report in the top right corner
- Delete all the default text in the query editor
- Paste in the query below exactly as shown
- Update the SINCE and UNTIL dates to match your GA4 export
- Click Run report, then Export, then Export current report
FROM payments
SHOW transactions, transaction_amount, net_payments
GROUP BY order_id, transaction_kind,
payment_gateway, transaction_id
WITH GROUP_TOTALS, TOTALS
SINCE 2026-04-01 UNTIL 2026-04-30
ORDER BY order_id ASC
VISUALIZE transactions
SHOW transactions, transaction_amount, net_payments
GROUP BY order_id, transaction_kind,
payment_gateway, transaction_id
WITH GROUP_TOTALS, TOTALS
SINCE 2026-04-01 UNTIL 2026-04-30
ORDER BY order_id ASC
VISUALIZE transactions
If you do not see Create custom report, your Shopify plan may not support custom reports. You need the Basic plan or above. Contact your account owner to confirm.