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

Incorrect bid calculation when averagePosition<bouncePosition

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Diu
    • Fix Version/s: Diu
    • Labels:
      None
    • Environment:

      Diu
      bidmgr-distribution-2.3.1.diu-SNAPSHOT-BUILD_1-t20140310152215-bin.tar.gz

    • Sprint:
      Sprint 2

      Description

      4) Test for com.thesearchagency.admax.algorithms.sabb.bouncePosition.google
      My setting,

      com.thesearchagency.admax.algorithms.sabb.bouncePosition.google=1.2
      com.thesearchagency.admax.algorithms.sabb.bounceBidAdjustment.google.USD=-0.05

      a) SELECT * FROM `st-tracker`.admaxBids WHERE accountID=435
      accountID elementType elementID currentBid currentBidSetDate newBid newBidSetDate retryCount
      435 searchEngineAccount 1589 0.3 2014-03-13 0 (NULL) 0
      435 searchEngineAccount 1590 0.3 2014-03-13 0 (NULL) 0

      b) Inserted the following (only for GT)
      SELECT * FROM staging.googleMccAdMax WHERE campaignid =173464712
      date campaignid clicks cost averagePosition
      2014-03-14 173464712 2 500000 1.1

      c) Ran ABU for 2014-03-14

      SELECT * FROM `st-tracker`.admaxBids WHERE accountID=435
      accountID elementType elementID currentBid currentBidSetDate newBid newBidSetDate retryCount
      435 searchEngineAccount 1589 0.3 2014-03-13 0.55 2014-03-14 0
      435 searchEngineAccount 1590 0.3 2014-03-13 0.8 2014-03-14 0

      ABU output,

      [TSAApp@aml-qa4-core1 bidmgr]$ ./admax.sh -d3 -a 435 -T 2014-03-14
      2014-03-14 11:46:07.357 (3) [main]: Debug Level set to 3
      2014-03-14 11:46:07.358 (3) [main]: Licensing environment detected, loading configuration.
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.email=ffejsmb@gmail.com
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.password=brothereclipsesmb
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.applicationToken=none
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA
      2014-03-14 11:46:07.359 (3) [main]: Loaded property: tsa.timezone=UTC
      2014-03-14 11:46:07.365 (3) [main]: Debug Level set to 3
      2014-03-14 11:46:07.365 (3) [main]: AdMax Summarizer parameters: -d3 -a 435 -T 2014-03-14
      2014-03-14 11:46:07.761 (3) [main]: DatabasePool with a limit of 18 created
      2014-03-14 11:46:07.815 (3) [main]: Could not save process history start
      2014-03-14 11:46:07.815 (3) [main]: =============== Starting AdMax Summarizer ================
      2014-03-14 11:46:07.815 (3) [main]: ----------------AdMax Summarizer starting
      2014-03-14 11:46:07.870 (3) [P1T1]: Starting Account ID #435: 0f707ee2-0a88-4619-b622-6c9f1b64b4dd
      2014-03-14 11:46:07.912 (3) [P1T1]: DatabasePool with a limit of 18 created
      2014-03-14 11:46:07.938 (3) [P1T1]: DatabasePool with a limit of 18 created
      2014-03-14 11:46:07.987 (3) [P1T1]: DatabasePool with a limit of 18 created
      2014-03-14 11:46:08.016 (3) [P1T1]: Got migrator lock for Account ID #435
      2014-03-14 11:46:08.062 (3) [P1T1]: Applying algorithm [SABB] for Account ID #435 in distributions [3]
      2014-03-14 11:46:08.066 (3) [P1T1]: Processing data for 2014-03-14 00:00:00 UTC
      2014-03-14 11:46:08.140 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 825
      2014-03-14 11:46:08.144 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 825
      2014-03-14 11:46:08.154 (2) [P1T1]: AdMax campaign ID: 825 spent 0.5
      2014-03-14 11:46:08.178 (3) [P1T1]: AdMaxSABBBudgetSlosher theDate = Fri Mar 14 00:00:00 UTC 2014
      2014-03-14 11:46:08.406 (3) [P1T1]: Created shared sesystem connection rw
      2014-03-14 11:46:10.984 (3) [P1T1]: New bid for SE campaign 1589: 0.3 ==> 0.55
      2014-03-14 11:46:10.986 (3) [P1T1]: New bid for SE campaign 1590: 0.3 ==> 0.8
      2014-03-14 11:46:11.015 (3) [P1T1]: Finished applying algorithm [SABB] for account [435] in distributions [3]
      2014-03-14 11:46:11.016 (3) [P1T1]: Released migrator lock for Account ID #435
      2014-03-14 11:46:11.016 (3) [P1T1]: Completed Account ID #435: 0f707ee2-0a88-4619-b622-6c9f1b64b4dd
      2014-03-14 11:46:11.017 (3) [main]: ------------AdMax Summarizer done
      2014-03-14 11:46:11.017 (3) [main]: =============== Completed AdMax Summarizer ================
      2014-03-14 11:46:11.018 (3) [main]: Could not save process history stop
      2014-03-14 11:46:11.018 (3) [main]: =============== Stats ================
      2014-03-14 11:46:11.018 (3) [main]: — Process —
      2014-03-14 11:46:11.018 (3) [main]:
      2014-03-14 11:46:11.018 (3) [main]: ABU Process(start): Fri Mar 14 11:46:07 UTC 2014
      2014-03-14 11:46:11.018 (3) [main]: ABU Process(stop): Fri Mar 14 11:46:11 UTC 2014
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.019 (3) [main]: — Accounts —
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.019 (3) [main]: Accounts Processed: 1
      2014-03-14 11:46:11.019 (3) [main]: Accounts Skipped: 0
      2014-03-14 11:46:11.019 (3) [main]: Accounts Processed Successfully: 1
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.019 (3) [main]: — Campaigns —
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.019 (3) [main]: Campaigns Processed: 1
      2014-03-14 11:46:11.019 (3) [main]: Campaigns Processed Successfully: 1
      2014-03-14 11:46:11.019 (3) [main]: Campaign Budgets Capped: 0
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.019 (3) [main]: — SE Campaigns —
      2014-03-14 11:46:11.019 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: SE Campaigns Processed: 2
      2014-03-14 11:46:11.020 (3) [main]: SE Campaigns Processed Successfully: 2
      2014-03-14 11:46:11.020 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: — Budget/Spend —
      2014-03-14 11:46:11.020 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: SE Campaign Budgets Updated: 2
      2014-03-14 11:46:11.020 (3) [main]: SE Campaign Budgets Sent To Google: 2
      2014-03-14 11:46:11.020 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: Spend Total: 0.5
      2014-03-14 11:46:11.020 (3) [main]: Common Carryover Total: 1.5
      2014-03-14 11:46:11.020 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: — Bids —
      2014-03-14 11:46:11.020 (3) [main]:
      2014-03-14 11:46:11.020 (3) [main]: New Campaign Bids: 2
      2014-03-14 11:46:11.021 (3) [main]:
      2014-03-14 11:46:11.022 (3) [main]: AdMaxSummarizer: 3.570s
      2014-03-14 11:46:11.022 (3) [main]: by key:
      2014-03-14 11:46:11.022 (3) [main]: db: 0.076s
      2014-03-14 11:46:11.023 (3) [main]: by thread:
      2014-03-14 11:46:11.023 (3) [main]: P1T1: 0.071s
      2014-03-14 11:46:11.023 (3) [main]: main: 0.005s
      2014-03-14 11:46:11.023 (3) [main]: google: 1.959s
      2014-03-14 11:46:11.023 (3) [main]: other: 1.535s

      I am expecting the bid to change to 0.3-0.05=0.25. But I see 0.55 (1589) for which I spent $0.5 (Budget $1)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: