Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Google v201101
-
Fix Version/s: unspecified
-
Component/s: Google
-
Labels:None
-
Environment:
Bid Manager - Trunk Mavenized Pulse build 141 (latest deployed to production)
Description
In Ad Performance report pulled for sepull3.sh (specifically googlemcc.sh), if cost for a particular campaignID/adGroupID/adID/keywordID is in the thousands, anything after the first comma is truncated when it's put in `staging`.`googleMccV2011`
Example from the report that gets downloaded from Google (this was for 2011-11-15 for Flowers user 2517):
<row campaignID="16470601" adGroupID="1849839921" adID="6620256561" keywordID="10416460" avgPosition="3.16" clicks="291" impressions="9030" cost="1,195.25" conv1PerClick="32" convManyPerClick="154" network="Search Network"/>
In this example, cost goes into the database as 1 instead of 1195.25
In that report, there were also these row with cost in the thousands
<row campaignID="16470541" adGroupID="342919801" adID="5915673321" keywordID="10898390" avgPosition="1.5" clicks="1421" impressions="19565" cost="6,904.92" conv1PerClick="276" convManyPerClick="1420" network="Search Network"/>
<row campaignID="16470541" adGroupID="1906749801" adID="6734090601" keywordID="10898390" avgPosition="1.98" clicks="1044" impressions="17454" cost="4,183.66" conv1PerClick="183" convManyPerClick="910" network="Search Network"/>
This is causing data discrepancies.
TO REPRODUCE
Run sepull3.sh for Flowers user 2517 with build 141. Then run the data checker. You should see discrepancies.
For the above example you would expect the discrepancies to be a total (for SEU 2517) of:
1,195.25+6,904.92+4,183.66 = 12283.83
Entered in db as (respectively) 1, 6 and 4 - so subtract that
12283.83 - 1 - 6 - 4 = 12272.83