This logic is designed to track how closely a campaign is performing against its budget over time by comparing actual spend with expected spend based on elapsed days in the campaign flight.
It uses campaign start and end dates, budget, and current date to calculate pacing percentage. This helps media teams detect under- or over-delivery early, make timely optimizations, and clearly communicate campaign health.
This approach is straightforward, reliable, and ideal for real-time campaign monitoring using channels in TapClicks.
Please see below for benefits and implementation steps.
Tracks overall campaign delivery against total budget in real time.
Identifies under- or over-delivery early in the flight.
Enables proactive optimizations based on pacing trends.
Simplifies performance monitoring for media teams.
Supports clear communication of campaign health to stakeholders.
Navigate to Data in the left navigation then choose Calculation and press the + button to create a new calculated field.
You’ll need to set up fields for:
Days Elapsed
Flight Days
Per Day Budget
Expected Spend
Pacing %
Use the following logic in calculated fields:
Days Elapsed
IF current_date < Stop_Date THEN
current_date - Start_Date
ELSE Stop_Date - Start_Date + 1
Per Day Budget
Budget / Flight_Days
Flight Days
Stop_Date - Start_Date + 1
Pacing (%)
(Spend / Expected_Spend_Till_Today) * 100
Expected Spend Till Today
Per_Day_Budget * Days_Elapsed
Test the calculation and save it by pressing the button at the bottom of the page.
Add the new calculation dimension to your dashboard widgets and reports.