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)