ad pacing algorithm excel template code example

Example 1: ad pacing algorithm excel template

Remaining Daily Spend = (Monthly Budget – $ Spent)/((Number of Days in Month)-(Day of Month)) or ($4,000-$1,500)/(30-8) = $113

Example 2: ad pacing algorithm excel template

Average Spent per Day = ($ Spent)/(Day of Month – 1) or $1,500/(8-1) = $214

Example 3: ad pacing algorithm excel template

Projected Spend for the Month = (Average Spent per Day)*(Number of Days in Month) or $214*30 = $6,420