Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.0.2
-
Fix Version/s: Wickford
-
Component/s: Budget Management
-
Labels:None
-
Story Points:3
-
Sprint:Wickford - Sprint 6, Wickford - Sprint 7
Description
When a campaign is deleted on a given day, ABU will process the campaign the next day. It contributes its commonCarryover to the carryover pool, but it also contributes the previous day's commonCarryover to the carryover pool because it is treated as a deleted campaign too. This results in a carryover pool that is too large. If the account has other campaigns that are still active, the pool will return to normal the following day because the deleted campaign will be treated only as deleted.
mysql> select * from admaxCarryovers where admaxCampaignID = 38;
--------------------------------------------------------------------------------------
| id | admaxCampaignID | type | date | dedicatedCarryover | commonCarryover | pooledCarryover |
--------------------------------------------------------------------------------------
| 7624 | 38 | boosted | 2013-01-28 | 0 | 0 | 0 |
| 7625 | 38 | boosted | 2013-01-29 | 0 | 0.377935 | 0.377935 |
| 7626 | 38 | boosted | 2013-01-30 | 0 | 0.755871 | 0.755871 |
| 7627 | 38 | boosted | 2013-01-31 | 0 | 1.13381 | 1.13381 |
| 7628 | 38 | boosted | 2013-02-01 | 0 | 1.51174 | 1.51174 |
| 7629 | 38 | boosted | 2013-02-02 | 0 | 1.88968 | 1.88968 |
| 7630 | 38 | boosted | 2013-02-03 | 0 | 2.26761 | 2.26761 |
| 7631 | 38 | boosted | 2013-02-04 | 0 | 2.64555 | 2.64555 |
| 7632 | 38 | boosted | 2013-02-05 | 0 | 3.02348 | 5.66903 |
--------------------------------------------------------------------------------------
9 rows in set (0.06 sec)
