Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2935

Google v201101 reports getting cost in non-micro units causes cost > 999.99 to be truncated in database table

    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

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              caitlyn Caitlyn Duggan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: