How are Pacing Control Strategy Groups Metrics Calculated?

Updated 

Pacing Control helps you monitor your spend throughout the campaign duration. It provides a straightforward representation of how your advertising campaigns perform on a daily basis in order to minimize under or overspends while simultaneously achieving your advertising goals.

We have specified all the Pacing Control Metric Calculation details below:

Values Specified/Available

  • Pacing Control Total Lifetime Budget

  • Spent on each campaign tagged to the Pacing Control

  • Pacing Control Start/End date

  • Spend Cap for each campaign

Terms

Values Calculated

Overall Pacing Control

  • Expected Spent = Time Elapsed(%) * Total Budget

  • Time Elapsed % = (From Start Time to Present Time) v/s Total Time
    (difference in Start Time and End Time calculated on most granular level i.e. milliseconds and then divided by total time in milliseconds)

  • Total Spent = Sum of spend on each campaign tagged to the Pacing Control

  • Remaining Budget = Pacing Control Total Lifetime Budget - Total Spent

  • Underspending/Overspending = | Expected Spent - Total Spent | / Expected Spent (%)

  • Required Daily Spent = Pacing Control Total Lifetime Budget / Total Duration (in days)

  • Average Daily Spent = Total Spent till now / Days elapsed

  • Pacing Control Spent vs Ideal Pacing Percentage = (Spend to Date/Total Budget) – (Days Elapsed/Total Days in Flight)

  • Paid Initiative Pacing Control Spent vs Ideal Pacing Percentage = (Spend to Date/Total Budget) – (Days Elapsed/Total Days in Flight)

  • Ad Set Pacing Control Spent vs Ideal Pacing Percentage = (Spend to Date/Total Budget) – (Days Elapsed/Total Days in Flight)

  • Remaining Forecasted Optimization Goal = Remaining Budget / Cost per Optimization Goal

  • Total Forecasted Optimization Goal = Current Optimization Goal + Remaining Forecasted Optimization Goal

  • Yesterday Spend Deviation = Pacing Required Daily Budget - Pacing Control Yesterday Spent

  • Forecasted Spend to Meet Goal = Cost per Optimization Goal * Pacing Control Goal Metric Value

  • Custom Duration

  • Custom Spend Limit

For Each Campaign

Facebook (when CBO is off)

  • Calculated Budget = Spend Cap of Campaign (if available) else,

  • Calculated Budget = Sum of Ad Sets’ Lifetime Budgets (if available) else,

  • Calculated Budget = Summation over Ad Sets (Daily Budget * Duration of Ad Set)

Facebook (when CBO is on)

  • Calculated Budget = Campaign Lifetime Budget (if available) else,

  • Calculated Budget = Spend Cap at the Campaign level (if available) else,

  • Calculated Budget = Campaign Daily Budget * Duration of Campaign

LinkedIn

  • Calculated Budget = Spend Cap of PI (if available) else,

  • Calculated Budget = Sum of Ad Sets’ Lifetime Budgets (if available) else,

  • Calculated Budget = Summation over Ad Sets (Daily Budget * Duration of Ad Set)

Other Channels

  • Calculated Budget = Campaign Lifetime Budget (if available) else,

  • Calculated Budget = Campaign Spend Cap (if available) else,

  • Calculated Budget = Campaign Daily Budget * Duration of PI (if available) else,

  • Calculated Budget = Sum of Ad Sets Lifetime Budgets, else,

  • Calculated Budget = Summation over Ad Sets (Daily Budget * Duration of Ad Set)

Valid for All Channels

If Daily Budget changes in between,

  • Calculated Budget = Spent + (Remaining days * Current Daily Budget)

  • Average Daily Spent = Spent / Days Elapsed

  • Required Daily Budget = Remaining Budget / Remaining Duration (Days)

  • Expected Spent = (Calculated Budget / Duration (Days)) * Days Elapsed

  • Pacing Rate = (Expected Spent - Spent) / Expected Spent %

Note:

  • The Time-Duration filter on the dashboard has no effect on the Pacing dashboard except for the Pacing Distribution Along with Campaigns, Distribution of Spent by Channel, and Distribution of Spent by Account widgets. It only considers the time duration to filter campaigns and not the data.

  • Basically, the Time Duration filter only works at Campaign level widgets to filter the time range. However, it does not work for Pacing Control entities.

Strategy Group Pacing Control Metrics

  1. Click the New Tab icon. Under the Sprinklr Marketing (Ads) tab, click Ads Manager within Analyze.

  2. In the top right corner of the Ads Manager window, click the Column Configuration icon.

  3. On the pop-up window, search and select Strategy Group Pacing Control Metrics in the search bar or select from the given options.

  4. Click Apply in the bottom right corner.

  5. Once applied, all the Strategy Group Pacing Control metrics can be seen as columns.

Overview of the Pacing Control Metrics within Ads Manager

Pacing Metrics in Sprinklr

  • Pacing Control Spent

  • Pacing Control Required Daily Budget

  • Pacing Control Average Daily Spent

  • Pacing Control Required Daily Spent

  • Pacing Control Expected Percentage Spent

  • Pacing Control Expected Spent

  • Pacing Control Expected Today Spent

  • Pacing Control Expected Today Percentage Spent

  • Pacing Control Percentage Spent

  • Pacing Control Today Spent

  • Pacing Control Today Percentage Spent

  • Pacing Control Yesterday Spent

  • Pacing Control Daily Spent Deviation

  • Pacing Control Yesterday Spend Deviation

  • Pacing Control Days Elapsed

  • Pacing Control Days Remaining

  • Pacing Control Spent vs Ideal Pacing Percentage

  • Pacing Control Remaining Budget

  • Pacing Control Remaining Today Budget

  • Pacing Control Time Elapsed Percentage

  • Pacing Control Remaining Forecasted Optimization Goal

  • Pacing Control Total Forecasted Optimization Goal

  • Pacing Control Forecasted Spend to Meet Goal

  • Pacing Control Goal Metric Value

  • Pacing Control Expected Goal Metric Value

  • Pacing Control Goal Metric Value Achieved

  • Pacing Control Goal Metric Value Achieved Percentage

  • Pacing Control Goal Metric Value Remaining

  • Paid Initiative Pacing Control Calculated Budget

  • Paid Initiative Pacing Control Spent

  • Paid Initiative Pacing Control Required Daily Budget

  • Paid Initiative Pacing Control Average Daily Spent

  • Paid Initiative Pacing Control Spent Percentage

  • Paid Initiative Pacing Control Daily Spent Deviation

  • Paid Initiative Pacing Control Deviation Rate (Percentage)

  • Paid Initiative Pacing Control Expected Daily Spent

  • Paid Initiative Pacing Control Expected Spent

  • Paid Initiative Pacing Control Ideal Pacing Percentage

  • Paid Initiative Pacing Control Spent vs Ideal Pacing Percentage

  • Paid Initiative Pacing Control Yesterday Spent

  • Paid Initiative Pacing Control Yesterday Spend Deviation

  • Paid Initiative Pacing Control Remaining Budget

  • Paid Initiative Pacing Control Duration (Days)

  • Paid Initiative Pacing Control Days Elapsed

  • Paid Initiative Pacing Control Days Remaining

  • Paid Initiative Pacing Control Time Elapsed Percentage

  • Paid Initiative Pacing Control Remaining Forecasted Optimization Goal

  • Paid Initiative Pacing Control Total Forecasted Optimization Goal

  • Ad Set Pacing Control Calculated Budget

  • Ad Set Pacing Control Required Daily Budget

  • Ad Set Pacing Control Average Daily Spent

  • Ad Set Pacing Control Daily Spent Deviation

  • Ad Set Pacing Control Deviation Rate (Percentage)

  • Ad Set Pacing Control Expected Daily Spent

  • Ad Set Pacing Control Expected Spent

  • Ad Set Pacing Control Spent

  • Ad Set Pacing Control Spent Percentage

  • Ad Set Pacing Control Ideal Pacing Percentage

  • Ad Set Pacing Control Spent vs Ideal Pacing Percentage

  • Ad Set Pacing Control Yesterday Spent

  • Ad Set Pacing Control Yesterday Spend Deviation

  • Ad Set Pacing Control Remaining Budget

  • Ad Set Pacing Control Duration (Days)

  • Ad Set Pacing Control Days Elapsed

  • Ad Set Pacing Control Days Remaining

  • Ad Set Pacing Control Time Elapsed Percentage

  • Ad Set Pacing Control Remaining Forecasted Optimization Goal

  • Ad Set Pacing Control Total Forecasted Optimization Goal