Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Bing-Integration
-
Fix Version/s: Bing-Integration
-
Component/s: AdMax
-
Labels:None
-
Environment:
hosts file matches yell-ec-xml2
Yell - Bid Manager - Bing Integration Pulse build 219
Description
staging.bingReports.CTR is supposed to map to tmp.searchEngineActivitySummaryYYYYMM.avgCTR but is not
COMMAND: /usr/local/tsa/bidmgr/bingreports.sh -d4 -force -date 2012-04-18 -U 20000023
mysql> select * from staging.bingReports where startTime='2012-04-18' and campaignid=80465720 and CTR > 0 limit 1\G;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 1. row ***************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
startTime: 2012-04-18
AccountId: 1494827
AdDistribution: Search
CTR: 12.5
campaignid: 80465720
adgroupid: 571392218
keywordid: 9273083775
keyword: tool hire
kwType: Broad
creativeid: 489424599
creativeDestUrl: www.harrisonhire.co.uk
kwDestUrl:
adwordsType: Text ad
maxCpc: 0
imps: 16
clicks: 2
cost: 0.09
pos: 3.06
conv: 0
transactions: 0
purchases: 0
purchaseValue: 0
leads: 0
leadValue: 0
signups: 0
signupValue: 0
pageviews: 0
pageviewValue: 0
defaultConv: 0
defaultConvValue: 0
1 row in set (0.00 sec)
COMMAND: ./sesummarize.sh -d4 --distribution 147 --date 2012-04-18 -U 20000023
mysql> SELECT * FROM tmp.searchEngineActivitySummary201204 where accountID=10000019 and avgCTR > 0 limit 1;
Empty Set
