Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Third Party Data
-
Labels:None
-
Environment:
BUILD :/usr/local/tsa/tsa-build-bidmgr-2010-10-20-p44-r27718
Client-st,
Staing-xml1,
Staging-jboss5
Description
It has been observed that for Facebook DataFeed , description is not inserting correctly to the table-sources and also CampaignID as ZERO.
/usr/local/tsa/bidmgr$ ./load-publisher.sh -d5 -F -XN Facebook.xml -XL /var/local/tsa/datafeedConfig/ 2>&1 | tee /tmp/facebook15Oct.log
Data Feed has 2 rows: (Also attached)
cat /var/local/tsa/publishers/17/177/17_FB_20100810.csv.done
Date,Campaign Name,Campaign ID,Ad Name,Ad ID,Impressions,Clicks,Click Rate,Actions,Action Rate,Conversions,Cost Per Conversion,CPC,CPM,Spent (USD),Unique Impressions,Unique Clicks,Unique Click Rate
8/10/2010,Test Camapign,6.58E+12,FB23405110017 | Class of 80s - 80 color - 6/18 Expand test12,6.58E+12,70472,39,0.06%,0,0.00%,0,0,0.42,0.23,16.2,25572,39,0.15%
8/10/2010,Test Camapign,6.58E+12,FB23405110018 | Class of 80s - 81 Metro - 7/12 Expand test12,6.58E+12,32449,16,0.05%,0,0.00%,0,0,0.54,0.27,8.64,12745,16,0.13%
And sources table :
SELECT * FROM sources WHERE accountID=17 AND distributionID=177 ORDER BY id DESC limit 2;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | altKey | accountID | siteID | searchEngineAccountID | keywordID | distributionID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | isBiddable | campaignID | description | type | keyword | sourceURL | cost | maxCost | waypointID | landingURL | passParams | trackPerformance | searchEngineStatus | searchEngineStatusText | lastChecked |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 558001951 | fb23405110018 | 17 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | Class of 80s - 81 Metro - 7/12 Expand test12 | 1 | class of 80s - 81 metro - 7/12 expand test12 | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
| 558001941 | fb23405110017 | 17 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | Class of 80s - 80 color - 6/18 Expand test12 | 1 | class of 80s - 80 color - 6/18 expand test12 | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.02 sec)
Here the description has mapped to "Ad Name" and CampaignID=0
Find the DataFeed,Configuration XML and Log file attached.
