Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: Mercury
-
Fix Version/s: Galileo
-
Component/s: None
-
Labels:None
-
Environment:
Mercury Final Builds
Description
Network Type is blank in Staging-BingClicks table
When Network Type is "AOL Search", the "network" field in staging.bingClicks table is blank.
Other networ types get populated.
It should either be AOL Search or unknown if we dont support'any of the networks.
Verified on QA4
Merchant UUID: 7328786f-a849-46d4-b7b8-10f703b66f03
Date of report generation: 2016-05-25
Initial jira story: aml-3708
Ad Extension Keyword report downloaded from BingAds has been attached.
SELECT * FROM staging.bingClicks WHERE campaignid IN (SELECT searchEngineIdentifier FROM tsacommon.searchEngineAccounts WHERE accountID=1462) AND startTime='2016-05-25' AND adExtensionType='Location Extension';
--------------------------------------------------------------------------------------------------------------------------+
| startTime | campaignid | adgroupid | keywordid | keyword | network | adExtensionType | clickType | deviceType | clicks |
--------------------------------------------------------------------------------------------------------------------------+
| 2016-05-25 | 248584858 | 4583000398 | 100167844184 | +salon +Providence | Location Extension | Ad title (headline) | Computer | 0 | |
| 2016-05-25 | 248584858 | 4583000398 | 100167844184 | +salon +Providence | Location Extension | Driving direction | Computer | 0 |
--------------------------------------------------------------------------------------------------------------------------+
