Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Rushmore
-
Fix Version/s: Rushmore
-
Component/s: Reporting (Outbound Datafeeds)
-
Labels:None
-
Environment:
Ops scripts #690
-
Sprint:Sprint 6
Description
googleMcc, sesummarizer and whsumm scripts were run for 26th Feb.
Ran keyword-leads-data report to generate the internal csv file.
Match Type in the csv file shows NULL though the DB value shows up a particular match Type
Eg.,
Keyword: antique china cabinets
conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999_GT bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999 Antique Furniture Rhode Island antique china cabinets NULL
conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998_GT bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998 Antique Furniture United States antique china cabinets exact
Whereas the DB shows the following
SELECT s.searchEngineMatchType,s.keyword,sea.description FROM `st-tracker`.sources s JOIN tsacommon.searchEngineAccounts sea ON s.searchEngineAccountID = sea.id WHERE s.accountID = 1249 AND sea.searchEngineStatus != "deleted" AND s.keyword LIKE "%antique china cabinets%";
searchEngineMatchType keyword description
exact antique china cabinets bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998_GT
exact antique china cabinets bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999_GT
Expected Result: Internal csv report should show up the same 'Match Type' as that of the DB