mysql> SELECT * FROM admaxNominalMonthlyBudgets WHERE admaxCampaignID IN (2680,2681,2682); +------+-----------------+------------+------------+--------+ | id | admaxCampaignID | startDate | endDate | budget | +------+-----------------+------------+------------+--------+ | 3349 | 2680 | 2013-08-27 | NULL | 93 | | 3350 | 2681 | 2013-08-27 | NULL | 93 | | 3351 | 2682 | 2013-08-27 | NULL | 93 | +------+-----------------+------------+------------+--------+ Run ABU on 27th Aug. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | +--------+-----------------+---------+------------+--------+ 6 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 6 rows in set (0.00 sec) Run ABU on 28th Aug. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | +--------+-----------------+---------+------------+--------+ 9 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 9 rows in set (0.00 sec) Delete Campaign C1 on 28 Aug. mysql> SELECT * FROM admaxNominalMonthlyBudgets WHERE admaxCampaignID IN (2680,2681,2682); +------+-----------------+------------+------------+--------+ | id | admaxCampaignID | startDate | endDate | budget | +------+-----------------+------------+------------+--------+ | 3349 | 2680 | 2013-08-27 | 2013-08-27 | 93 | | 3350 | 2681 | 2013-08-27 | NULL | 139.5 | | 3351 | 2682 | 2013-08-27 | NULL | 139.5 | +------+-----------------+------------+------------+--------+ Run ABU on 29th Aug. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | +--------+-----------------+---------+------------+--------+ 11 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 11 rows in set (0.00 sec) Run ABU on 30th Aug. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | +--------+-----------------+---------+------------+--------+ 13 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 13 rows in set (0.00 sec) Delete Campaign C2 on 30th Aug. mysql> SELECT * FROM admaxNominalMonthlyBudgets WHERE admaxCampaignID IN (2680,2681,2682); +------+-----------------+------------+------------+--------+ | id | admaxCampaignID | startDate | endDate | budget | +------+-----------------+------------+------------+--------+ | 3349 | 2680 | 2013-08-27 | 2013-08-27 | 93 | | 3350 | 2681 | 2013-08-27 | 2013-08-27 | 139.5 | | 3351 | 2682 | 2013-08-27 | NULL | 279 | +------+-----------------+------------+------------+--------+ Run ABU on 31st Aug. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163195 | 2682 | boosted | 2013-09-01 | 46.5 | +--------+-----------------+---------+------------+--------+ 14 rows in set (0.01 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163181 | 2682 | boosted | 2013-09-01 | 0 | 18 | 37.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 14 rows in set (0.01 sec) Run ABU on 01st Sept. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163195 | 2682 | boosted | 2013-09-01 | 46.5 | | 163196 | 2682 | boosted | 2013-09-02 | 55.5 | +--------+-----------------+---------+------------+--------+ 15 rows in set (0.01 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163181 | 2682 | boosted | 2013-09-01 | 0 | 18 | 37.5 | | 163182 | 2682 | boosted | 2013-09-02 | 0 | 27 | 46.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 15 rows in set (0.00 sec) Run ABU on 02nd Sept. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | | 163195 | 2682 | boosted | 2013-09-01 | 46.5 | | 163196 | 2682 | boosted | 2013-09-02 | 55.5 | | 163197 | 2682 | boosted | 2013-09-03 | 64.5 | +--------+-----------------+---------+------------+--------+ 16 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | | 163181 | 2682 | boosted | 2013-09-01 | 0 | 18 | 37.5 | | 163182 | 2682 | boosted | 2013-09-02 | 0 | 27 | 46.5 | | 163183 | 2682 | boosted | 2013-09-03 | 0 | 36 | 55.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 16 rows in set (0.00 sec) Delete Campaign C3 on 2nd Sept. mysql> SELECT * FROM admaxNominalMonthlyBudgets WHERE admaxCampaignID IN (2680,2681,2682); +------+-----------------+------------+------------+--------+ | id | admaxCampaignID | startDate | endDate | budget | +------+-----------------+------------+------------+--------+ | 3349 | 2680 | 2013-08-27 | 2013-08-27 | 93 | | 3350 | 2681 | 2013-08-27 | 2013-08-27 | 139.5 | | 3351 | 2682 | 2013-08-27 | 2013-08-27 | 279 | +------+-----------------+------------+------------+--------+ Run ABU on 03rd Sept. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | | 163195 | 2682 | boosted | 2013-09-01 | 46.5 | | 163196 | 2682 | boosted | 2013-09-02 | 55.5 | | 163197 | 2682 | boosted | 2013-09-03 | 64.5 | +--------+-----------------+---------+------------+--------+ 16 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | | 163181 | 2682 | boosted | 2013-09-01 | 0 | 18 | 37.5 | | 163182 | 2682 | boosted | 2013-09-02 | 0 | 27 | 46.5 | | 163183 | 2682 | boosted | 2013-09-03 | 0 | 36 | 55.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 16 rows in set (0.00 sec) Run ABU on 04th Sept. mysql> SELECT * FROM admaxActualDailyBudgets WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------+ | id | admaxCampaignID | type | date | budget | +--------+-----------------+---------+------------+--------+ | 163182 | 2680 | boosted | 2013-08-27 | 3 | | 163184 | 2682 | boosted | 2013-08-27 | 3 | | 163183 | 2681 | boosted | 2013-08-27 | 3 | | 163187 | 2682 | boosted | 2013-08-28 | 4.5 | | 163186 | 2681 | boosted | 2013-08-28 | 6 | | 163185 | 2680 | boosted | 2013-08-28 | 7.5 | | 163190 | 2682 | boosted | 2013-08-29 | 6 | | 163188 | 2680 | boosted | 2013-08-29 | 12 | | 163189 | 2681 | boosted | 2013-08-29 | 9 | | 163191 | 2681 | boosted | 2013-08-30 | 20.5 | | 163192 | 2682 | boosted | 2013-08-30 | 12.5 | | 163193 | 2681 | boosted | 2013-08-31 | 26.5 | | 163194 | 2682 | boosted | 2013-08-31 | 15.5 | | 163195 | 2682 | boosted | 2013-09-01 | 46.5 | | 163196 | 2682 | boosted | 2013-09-02 | 55.5 | | 163197 | 2682 | boosted | 2013-09-03 | 64.5 | +--------+-----------------+---------+------------+--------+ 16 rows in set (0.00 sec) mysql> SELECT * FROM admaxCarryovers WHERE admaxCampaignID IN (2680,2681,2682) ORDER BY DATE; +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ | 163168 | 2680 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163170 | 2682 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163169 | 2681 | boosted | 2013-08-27 | 0 | 0 | 0 | | 163173 | 2682 | boosted | 2013-08-28 | 0 | 3 | 1.5 | | 163172 | 2681 | boosted | 2013-08-28 | 0 | 3 | 3 | | 163171 | 2680 | boosted | 2013-08-28 | 0 | 3 | 4.5 | | 163176 | 2682 | boosted | 2013-08-29 | 0 | 6 | 3 | | 163174 | 2680 | boosted | 2013-08-29 | 0 | 6 | 9 | | 163175 | 2681 | boosted | 2013-08-29 | 0 | 6 | 6 | | 163177 | 2681 | boosted | 2013-08-30 | 0 | 9 | 16 | | 163178 | 2682 | boosted | 2013-08-30 | 0 | 9 | 8 | | 163179 | 2681 | boosted | 2013-08-31 | 0 | 13.5 | 22 | | 163180 | 2682 | boosted | 2013-08-31 | 0 | 13.5 | 11 | | 163181 | 2682 | boosted | 2013-09-01 | 0 | 18 | 37.5 | | 163182 | 2682 | boosted | 2013-09-02 | 0 | 27 | 46.5 | | 163183 | 2682 | boosted | 2013-09-03 | 0 | 36 | 55.5 | +--------+-----------------+---------+------------+--------------------+-----------------+-----------------+ 16 rows in set (0.00 sec)