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

No updates to Google for very small nominal daily budgets

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: Rushmore
    • Fix Version/s: Rushmore
    • Labels:
      None
    • Environment:

      bidmgr #556
      Core # 274

    • Sprint:
      Sprint 4

      Description

      When an order is deployed with very small budget say $0.2 or $0.4, there are no proper updates being sent to Google in case of US Taxonomy.

      Steps/Observation/Notes:

      Deployed the new bidmgr build #556 to verify aml-3310.

      1) Deployed a new order with budget $0.2 and ran abu
      SELECT * FROM `st-tracker`.admaxSearchEngineAccountActualDailyBudgets WHERE searchEngineAccountID IN (3938,3939)
      searchEngineAccountID date budget actualSEBudget budgetStatus
      3938 2015-01-14 0.00322581 0.01 Paused
      3938 2015-01-15 0.00645161 0.01 Active
      3939 2015-01-14 0.00322581 0.01 Paused
      3939 2015-01-15 0.00645161 0.01 Active

      I noticed that a budget increment of 0.006-0.003=$0.003 has sent updates to Google.
      Earlier it was such that only a budget increment of >=0.01 was sent to Google.
      Is this something that you have changed?
      And if so what is the minimum increment value that will send updates to Google or is it expected to send updates whenever the status shifts from ‘Paused’ to ‘Active’?
      Snippet of ABU log,

      2015-01-14 08:33:58.084 (3) [main]: SE Campaign Budgets Updated: 2
      2015-01-14 08:33:58.084 (3) [main]: SE Campaign Budgets Sent To Google: 2
      2015-01-14 08:33:58.084 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0
      2015-01-14 08:33:58.084 (3) [main]:
      2015-01-14 08:33:58.084 (3) [main]: Spend Total: 0.0
      2015-01-14 08:33:58.084 (3) [main]: Common Carryover Total: 0.0025806453

      Ross: Yes, a change in budget status will now result in a change at the search engine. This resulted from our discussion about AML-3310 last week and was noted in my comment in Jira.

      2) a) Deployed another order with budget $0.4 and ran abu
      SELECT * FROM `st-tracker`.admaxSearchEngineAccountActualDailyBudgets WHERE searchEngineAccountID IN (3940,3941)
      searchEngineAccountID date budget actualSEBudget budgetStatus
      3940 2015-01-14 0.00645161 0.01 Active
      3940 2015-01-15 0.0129032 0.01 Active
      3941 2015-01-14 0.00645161 0.01 Active
      3941 2015-01-15 0.0129032 0.01 Active
      Snippet of ABU log,

      2015-01-14 10:07:01.270 (3) [P1T1]: AdMaxSABBBudgetSlosher theDate = Wed Jan 14 00:00:00 UTC 2015
      2015-01-14 10:07:01.308 (3) [P1T1]: Budget (status) has not changed for campaign ID 3940

      2015-01-14 10:07:06.099 (3) [main]: SE Campaign Budgets Updated: 2
      2015-01-14 10:07:06.099 (3) [main]: SE Campaign Budgets Sent To Google: 1
      2015-01-14 10:07:06.100 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0
      2015-01-14 10:07:06.100 (3) [main]:
      2015-01-14 10:07:06.100 (3) [main]: Spend Total: 0.0
      2015-01-14 10:07:06.100 (3) [main]: Common Carryover Total: 0.0051612905

      In the above example there is only one update sent to Google though the budgets for both the campaigns are the same.

      Ross: As we have discussed, "random updates" occur in about 10% of budget changes. If you run this again it may result in 0, 1 or 2 updates

      b) Ran abu for the next day t+1
      SELECT * FROM `st-tracker`.admaxSearchEngineAccountActualDailyBudgets WHERE searchEngineAccountID IN (3940,3941)
      searchEngineAccountID date budget actualSEBudget budgetStatus
      3940 2015-01-14 0.00645161 0.01 Active
      3940 2015-01-15 0.0129032 0.01 Active
      3940 2015-01-16 0.0193549 0.02 Active
      3941 2015-01-14 0.00645161 0.01 Active
      3941 2015-01-15 0.0129032 0.01 Active
      3941 2015-01-16 0.0193549 0.02 Active

      Snippet of ABU log,
      2015-01-14 10:17:43.842 (3) [P1T1]: Budget (status) has not changed for campaign ID 3940
      2015-01-14 10:17:43.842 (3) [P1T1]: Budget (status) has not changed for campaign ID 3941

      2015-01-14 10:17:45.514 (3) [main]: SE Campaign Budgets Updated: 2
      2015-01-14 10:17:45.514 (3) [main]: SE Campaign Budgets Sent To Google: 0
      2015-01-14 10:17:45.514 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0
      2015-01-14 10:17:45.514 (3) [main]:
      2015-01-14 10:17:45.514 (3) [main]: Spend Total: 0.0
      2015-01-14 10:17:45.514 (3) [main]: Common Carryover Total: 0.010322597

      Though there is a change in budget, there are no updates sent to Google.
      No updates in Adwords

      Ross: The change in the `budget` column is used to determine whether to send the budget to the SE. If a change is indicated, the value sent is the one in the `actualSEBudget` column. This scenario is why we added the "random updates" so that very small budget changes would eventually get sent to the SE

      c) Ran abu for day t+2
      SELECT * FROM `st-tracker`.admaxSearchEngineAccountActualDailyBudgets WHERE searchEngineAccountID IN (3940,3941)
      searchEngineAccountID date budget actualSEBudget budgetStatus
      3940 2015-01-14 0.00645161 0.01 Active
      3940 2015-01-15 0.0129032 0.01 Active
      3940 2015-01-16 0.0193549 0.02 Active
      3940 2015-01-17 0.0258065 0.03 Active
      3941 2015-01-14 0.00645161 0.01 Active
      3941 2015-01-15 0.0129032 0.01 Active
      3941 2015-01-16 0.0193549 0.02 Active
      3941 2015-01-17 0.0258065 0.03 Active
      Snippet of ABU log,

      2015-01-14 10:32:50.171 (3) [P1T1]: Budget (status) has not changed for campaign ID 3941

      2015-01-14 10:32:55.161 (3) [main]: SE Campaign Budgets Updated: 2
      2015-01-14 10:32:55.161 (3) [main]: SE Campaign Budgets Sent To Google: 1
      2015-01-14 10:32:55.161 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0
      2015-01-14 10:32:55.161 (3) [main]:
      2015-01-14 10:32:55.161 (3) [main]: Spend Total: 0.0
      2015-01-14 10:32:55.162 (3) [main]: Common Carryover Total: 0.0154838795

      There is only one update sent to Google though there is a change in budget

      Ross: Same as 2a

        Attachments

          Activity

            People

            • Assignee:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
              Reporter:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: