ryansapp
Board Regular
- Joined
- Apr 22, 2013
- Messages
- 54
<!--StartFragment--> Needing a month-to-date conversion tracking formula (based oncampaign_name, date [A], and summation of clicks [C]), assume column A is spanning all days and months through the end of year. Simple enough, I know,..but for whatever reason I'm struggling with setting up the date range start/end for the formula.
Next, I need a date monthly cap metformula (referencing the cap amount [D], and then referencing the sumifformula I needed from previous request. When that # is achieved, factor in 'bonus' amount toformula [CAMPAIGN_BONUS*every click after click cap is met]). I'm fairly decent with some nested IFs but this one in particular has me dumbfounded and I know its not too intense for the experts!
<!--EndFragment-->Layout below for reference...
<tbody>
</tbody>
Next, I need a date monthly cap metformula (referencing the cap amount [D], and then referencing the sumifformula I needed from previous request. When that # is achieved, factor in 'bonus' amount toformula [CAMPAIGN_BONUS*every click after click cap is met]). I'm fairly decent with some nested IFs but this one in particular has me dumbfounded and I know its not too intense for the experts!
<!--EndFragment-->Layout below for reference...
A | B | C | D | E | F | |
1 | DATE | CAMPAIGN_NAME | CLICKS | MONTHLY CLICK CAP | CAMPAIGN_BONUS | ? |
2 | 6/1/17 | Cars | 25 | 1000 | $1 | |
3 | 6/2/17 | Cars | 1300 | 1000 | $1 | |
4 | 7/15/17 | Trucks | 25 | 5 | $5 | |
5 | 7/16/17 | Cars | 900 | 1000 | $1 | |
6 | 7/18/17 | Cars | 100 | 1000 | $1 | |
7 | 7/30/17 | Cars | 100 | 1000 | $1 |
<tbody>
</tbody>