Ad Report for Google Ads API

[SaleSpider Ad Operations]

Hi,

I want to create a query like this but in Ad level

SELECT segments.date, campaign.name, metrics.impressions, metrics.active_view_impressions, metrics.clicks, metrics.all_conversions, metrics.cost_micros  FROM campaign 'WHERE segments.date DURING LAST_30_DAYS

I bolded the new column to be selected.

I want to select Date, Campaign Name, Ad Name, Impressions, Active View, Viewable Impressions, Clicks, and All Conversions

but I can't seem to find the right table.

Let me know if you know the answer.

Thanks!

Romaine

[Google Ads API Forum Advisor]

Hi Romaine,

Thank you for reaching to the Google Ads API team.

Moving forward, upon seeing your query and the column that you want to add, I noticed that you are using the campaign  report. Kindly note that the said report is for campaign level data and you can't use this report to retrieve the ad name. However, you can use the ad_group_ad report and include the ad_group_ad.ad.name field in your query.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2byR51:ref