Why is the "averageCPC" value so high when I have not spent this much on my Google Ads?

[Marcus D'Suza]

Greetings! 

I am working with the Shopping Performance View report in Google Ads Script. I want to retrieve the clicks, conversion value, impressions, ctr, and the average cost per click for all products in my Google Ads account. 

Everything except the average cost per click and conversion value is good. Currently, I am not sure why the averageCost value for each product is high? This is shown in millions but I have not spent this much on Google Ads? Is it represented in other currency formats, if yes how can I convert it to regular format? I know it may sound silly to ask but I am not sure about the current format representation of averageCPC.

In addition to that, what is the difference between metrics.conversion and metrics.conversion_value?

The Google Ads Code I am using to get this data is; 

function productList() {
    var productsDetails = [];
   
    // Query to retrieve required data
    var query = 'SELECT segments.product_channel, segments.product_country, segments.product_language, segments.product_item_id, metrics.average_cpc, metrics.clicks, metrics.conversions, metrics.ctr, metrics.impressions FROM shopping_performance_view';
    var result = AdsApp.search(query, {apiVersion: 'v9'});
    while (result.hasNext()) {
      var row = result.next();
      productStats = {"metrics" : row['metrics'], "segments" : row['segments']};
     
      if (Object.keys(productStats['segments']).indexOf('productItemId') === -1) {
        continue;
      }
      productsDetails.push(productStats);
    }
    return productsDetails;

}

I know it's Google Adwords API forum, but the shooping performance view is part of Google Ads API that's why I am asking here. 

 

[Google Ads API Forum Advisor]

Hi Marcus,

You have reached the AdWords / Google Ads API support team. For further guidance on Google Ads Scripts related concerns, you may reach out to their support team via their forum channel instead.

As for cost related metrics, these are generally in micros so you would need to divide by 1,000,000 to acquire the actual value.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2Tm3LL:ref