Guides
Practical guides to getting your store and ad data into Google Sheets, and to the calculations you'll want once it's there. Where there's a free way to do something, we start with it.
Getting data into Google Sheets
- Get Shopify orders into Google Sheets. From a one-off export to a report that keeps itself current.
Formulas
- ROAS in Google Sheets. The formula, the averaging mistake, and why platform ROAS never matches your store.
- Blended ROAS and MER in Google Sheets. Total revenue over total ad spend, with Shopify, Google Ads and TikTok Ads as the worked example.