Need a formula that takes into account a ramp up period

Topic Labels: Formulas
172 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I'm building a dataset where i'm taking the total amount of something and breaking it down into a per day calculation.  However on the first couple of days these projected calculations aren't always hit.  Is there a way to build a formula that takes into account a ramp up period of some kind for the first couple of days?

Here it is in practice:

A brand wants to have a certain amount of budget set against a specific website that they're advertising on.  The budget of $100,000 over 10 days, or $10,000 / day. However in reality, hitting $10,000 in the first day or so is nearly impossible because of certain elements that need to be taken into account.  This is the ramp up period.  In reality it starts off with $1000 for day one, $3000 for day 2, $7000 on day 3, and then hitting the per day spend goal of $10,000.  Sometimes to compensate for this the website may over-spend on Day 4 and 5 to bring the average back to $10,000 a day. 

Is there any way to build a formula around this to compensate and project the per day spend with this ramp-up period?  It should be dynamic based on the duration of the campaign (if it's 5 days or 15 days or 30 days, etc.).

2 Replies 2

Do you want fields per day? Just for the first 3? 
Do you want to work with % of the total budget on day 1, 2 and 3? 
"Sometimes" compensating on "day 4 and 5" > How do you determine that "sometimes"? Always on day 4 and 5? 

4 - Data Explorer
4 - Data Explorer

This is where it can get tricky.  Sometimes if you have a campaign that's only running 1 or 2 days, it ramps up immediately and you need performance from the first hour.  For longer duration campaigns, or ones with multiple layers of audiences or targeting, it can take 3-4 days for those audiences to become populated with data which is the ramp up period.  I guess there might need to be some level of nesting based on campaign duration:

If(campaign duration < 5 days, ramp up period is 1 day, else ramp up is days 1-3). 

I have a target spend per day based on the campaign duration (total spend / duration).  So for day 1 it could be 5% of daily target spend.  Day 2 would be 25% of target spend.  Day 3 would be 75% of target spend, then by day 4 it should be 100%. It doesn't need to take into account the overspend / compensating spend to have it average out.  That might be too advanced to worry about at the moment.