Greetings!
I am working with the Shopping Performance View
<https://developers.google.com/google-ads/api/fields/v9/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. *
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/2d2a38d4-2af9-4edb-bd37-03fcad1a7d6fn%40googlegroups.com.
