Campaign and Product performance report

[Van Vu]

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

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

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

[Google Ads API Forum Advisor Prod]

Hi Van,

Yes, the GAQL you have prepared should already return output that is similar to the (custom) tables in your screenshots. However, if you will be comparing the Google Ads API reports to the Google Ads UI reports, the campaign resource should map directly to the campaigns tab.

As for the shopping report, the segments you choose may depend on which shopping (pre-defined reports) view you access in the Google Ads UI.

Thanks and regards,
Peter
Google Ads API Team

ref:_00D1U1174p._5001UAqCUL:ref

[Van Vu]

Thank you, lemme give it a go