Hi there, I'm really new to Google Ads report, I was tasked to produce the tables below but have no idea if the query is correct or not. Please advise whether my query could map 1-1 to the table fields, especially the FROM resource
*1- Campaign report* [image: campaign.jpg] The query: SELECT campaign.id, campaign.name, campaign.campaign_budget metrics.impressions, metrics.clicks, metrics.conversions, metrics.all_conversions_value, metrics.cost_per_conversion, metrics.cost_micros FROM *campaign* WHERE segments.date DURING LAST_30_DAYS *2- Product report* [image: product.jpg] The query: SELECT segments.product_merchant_id, campaign.id, segments.product_title metrics.impressions, metrics.clicks, metrics.conversions, metrics.all_conversions_value, metrics.cost_per_conversion, metrics.cost_micros FROM *shopping_performance_view* -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f0bfd16d-5490-4d5d-bf1b-6ce76df4cf98%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
