Free Resources To Automate Your Reporting with SuperMetrics

Free trial of SuperMetrics: doubleyourcoursesales.com/try-supermetrics

Free in-depth reporting spreadsheet (for marketers & media buyers): doubleyourcoursesales.com/freebie-reporting-indepth

Free KPI tracking spreadsheet (simple client facing reports): doubleyourcoursesales.com/freebie-reporting-simple

Step-by-step guide: How to use Supermetrics to automate your Facebook ads and YouTube ads reporting

Remember to use ChatGPT if you need help with formulas. The most common formulas & features I use to create reporting spreadsheets are:

• VLOOKUPS – go find data from another tab and add it here when it matches up (with a date for example)
• COUNTIF – count the number of somethings (like applications) if something is true (like a date range)
• COUNTUNIQUEIFS – count the number of unique somethings (like emails) if something is true (like a date range)
• SUMIFS – add up the numbers of somethings (like ad spend) if something is true (like a date range)
• NAMED RANGES – make it easy to add a range to a formula
• SPARKLINE – create cool little charts inside a cell
• IFERRORS – get rid of that ugly #DIV to make your spreadsheets looks pretty