Getting campaigns name with theirs photos

[Krzysztof Rodo]

Hi, 

I need to create table with these fields:

|Name of campaign||Impressions|Cost||Conversation Rate||Conversions||Date||Budget||Image/Video of this ad||

How my query should look like?

[Google Ads API Forum Advisor Prod]

Hello,

Unfortunately, you won't be able to get the image/video field with these reports. However, you can use the following query to get most of what you are looking for:

SELECT
     campaign.name,
     metrics.impressions,
     metrics.cost_micros,
     metrics.conversions_from_interactions_rate,
     metrics.conversions,
     campaign.campaign_budget
FROM
    campaign


Regards,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q27tSdD:ref

[Krzysztof Rodo]

So how can I fetch images of each campaign/ad and connect it with campaign?

[Google Ads API Forum Advisor Prod]

Hello,

You can run a report from the ad_group_ad level which will contain details on image ads.

Let me know if you face any issues.

Cheers,