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

Mismatch of value between Google Adwords and DB on running sedatacheck.sh

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: Apponaug
    • Fix Version/s: Apponaug
    • Component/s: Data Summarization
    • Labels:
      None
    • Environment:

      BidMgr (Apponaug build 15)
      Core – (Apponaug Build 14)

      Description

      Mismatch of number of impressions between Google Adwords and staging.googleSummaryCheck table on running sedatacheck.sh
      Steps to reproduce:

      1) Run the sedatacheck.sh from /usr/local/tsa/bidmgr mentioning the date range for a particular SearchEngineUserID
      e.g., ./sedatacheck.sh -d3 --date 2012-05-14 --end 2013-06-11 --force -U 39
      2) Check sum of impression on Google Adwords for that range
      3) Check the sum of impression for the same in staging.googleSummaryCheck

      Actual Result: Mismatch in number of impression
      Expected Result: Same

      Note:
      1. Number of Clicks and cost matches between Adwords and DB
      2. Works fine for Yell and Optus

      DB output:

      mysql> SELECT * FROM staging.googleSummaryCheck g WHERE g.campaignid IN (SELECT searchEngineIdentifier FROM tsacommon.searchEngineAccounts sea WHERE sea.description LIKE "%2eed7cf7-8329-49ed-b894-34d672907a90%");
      ----------------------------------------------------------------------------------------+

      acctname campaignid campaign imps clicks cost

      ----------------------------------------------------------------------------------------+

        116947974 2eed7cf7-8329-49ed-b894-34d672907a90_11262_1_166_GT 22 0 0
        116948214 2eed7cf7-8329-49ed-b894-34d672907a90_11262_1_166_MO 1652 7 1490000

      ----------------------------------------------------------------------------------------+
      2 rows in set (0.00 sec)

        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: