Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: TSA Pixel Tracking V2
-
Fix Version/s: TSA Pixel Tracking V2
-
Component/s: TSA Tracking
-
Labels:None
-
Environment:
production and v2 dev
Description
Baidu requires an entry in the distribution table:
INSERT INTO `distribution` VALUES (null,0,0,'organic search',3,1,NULL,NULL,'false',NULL,'false','Baidu Organic',NULL,NULL,NULL,NULL,NULL,NULL);
also, the searchEngineReferers table needs to be updated (xxx=new dist id):
INSERT INTO `searchEngineReferers` VALUES (NULL,xxx,30,'Baidu Organic Search','^https?\\:\\/\\/(?:.?\\.)baidu\\.(?:com|jp|cn)','\\&\\?(?:wd|word|kw|query)
=([^\\&])','',NULL,'0','','');
In addition, Baidu encodes its referring URLs in gb2312 rather than UTF-8. We will want to have this information captured in the searchEngineReferers table as a new column, and used in the v2 Waypoint's CachedSearchEngineRefererTableRow.parseKeyword() method, where it URL-decodes the referral string to get the keyword (URLCodec.decode()).
