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)