Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Not a Bug
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Campaign Service
-
Labels:None
-
Environment:
Core #342
Bidmgr #743
-
Sprint:Sprint 3
Description
Incorrect BoostMultiplier calculation at distribution level for Bing
Boost Multiplier considers "global" value as well when it is set for a specific distribution.
Scenario 1: Calculation when boostMultiplier is set only at distribution level:
admaxNominalDailyBudgets for all dates=$4 (no spend)
SELECT * FROM `st-tracker`.admaxBoosts;
id elementType elementID startDate endDate boostMultiplier boostCap
1 global 0 2012-01-01 \N 0 0
2 distribution 147 2015-01-01 \N 4 0
This is run for date 16th
Actual Daily budget for 17th =(boostMultiplier*Nominal Daily Budget of previous day)+carryover of previous day
=(4*4)+52
=68 (Expected)
SELECT * FROM `st-tracker`.admaxCarryovers WHERE admaxCampaignID IN (1008);
id admaxCampaignID type date dedicatedCarryover commonCarryover pooledCarryover
5472 1008 boosted 2015-07-14 0 0 0
5473 1008 boosted 2015-07-15 0 4 4
5476 1008 boosted 2015-07-16 0 52 52
5477 1008 boosted 2015-07-17 0 68 68
5478 1008 boosted 2015-07-18 0 84 84
SELECT * FROM `st-tracker`.admaxActualDailyBudgets WHERE admaxCampaignID IN (1008);
id admaxCampaignID type date budget
5456 1008 boosted 2015-07-14 4
5457 1008 boosted 2015-07-15 52
5460 1008 boosted 2015-07-16 68
5461 1008 boosted 2015-07-17 84
5462 1008 boosted 2015-07-18 108
Scenario 2: Calculation when boostMultiplier is set at both distribution and global level:
SELECT * FROM `st-tracker`.admaxBoosts;
id elementType elementID startDate endDate boostMultiplier boostCap
1 global 0 2012-01-01 \N 2 0
2 distribution 147 2015-01-01 \N 3 0
This is run for date 17th
Expected: Actual Daily Budget for 18th=(3*4)+84
=96
Actual: (3*2*4)+84
=108