Skip to main content

Budget pacing in Google Sheets

  • May 29, 2024
  • 1 reply
  • 224 views
Senni
Forum|alt.badge.img+1

Have you used Supermetrics for budget pacing? What kind of template have you created for it?

My colleagues Courtney and Milja hosted a webinar recently about budget pacing best practises, and they shared a template that you can start using for your own budget pacing sheet. 🤩 

Senni
Mariia
Aurora
davepuype

1 reply

Mariia
Forum|alt.badge.img+3
  • Mariia
  • Supermetrics Team
  • May 30, 2024

On a budget-pacing topic, here’s a tip to automate the budget-pacing reports in Google Sheets: 

 

💡 Use date formulas to automatically pull the date or number of days to your Google Sheets report. 

 

These formulas are the game changers: 

 

today                                       =today()

last of this month                    =EOMONTH(today(),0)

first of this month                    =EOMONTH(today(),-1)+1

total days this month              =DAYS(last of this month, first of this month)

days left this month                =DAYS(last of this month, today)

days passed this month         =DAYS(today, first of this month)

 
Senni
Terms & ConditionsCookie settingsAccessibility statement