Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-2387

Budget reallocation is incorrect when a campaign is deleted

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Jamestown 2.3.0
    • Fix Version/s: Jamestown 2.3.0
    • Component/s: None
    • Labels:
      None
    • Story Points:
      8
    • Sprint:
      Sprint 8

      Description

      Delete a campaign and add a new one in the same order. The new campaign is added and the budget spread across the 2 campaigns. The original campaign is then terminated and all the budget is allocated to the new campaign, but the terminated campaign keeps its half. Here is an example from NTT's admaxNominalMonthlyBudgets:

      mysql> select * from admaxNominalMonthlyBudgets where admaxCampaignID in (59,141);
      ----------------------------------------------

      id admaxCampaignID startDate endDate budget

      ----------------------------------------------

      69 59 2013-08-01 2013-08-01 6100
      152 59 2013-08-02 2013-08-02 3050
      153 141 2013-08-02 NULL 6100

      ----------------------------------------------
      3 rows in set (0.06 sec)

      The budget on the day of the campaign deletion should be spread across all campaigns (including this deleted campaign). The account budget should be allocated to the remaining active/paused campaigns for the day following the campaign deletion. Campaign deletion should also remove any future admaxNominalMonthlyBudgets entry for the deleted campaign before reallocating the budget to the remaining campaigns.

      The scenario above should have resulted in:
      ----------------------------------------------

      id admaxCampaignID startDate endDate budget

      ----------------------------------------------

      69 59 2013-08-01 2013-08-01 6100
      152 59 2013-08-02 2013-08-02 3050
      153 141 2013-08-02 2013-08-02 3050
      153 141 2013-08-03 NULL 6100

      ----------------------------------------------

        Attachments

          Activity

            People

            • Assignee:
              atul.sanagar Atul Sanagar (Inactive)
              Reporter:
              rgardner Ross Gardner
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: