get customer campaigns list, REST API

[Anna Lysak]

Hi again,

Could you please help me to find documentation to get all customer campaigns ? what query should I send and where ?

Thanks in advance.

[Anna Lysak]

This is what I tried:
I sent POST request to this : url = 'https://googleads.googleapis.com/v11/customers/6074981807/campaigns:search'
And this is the body:
params = {
 "query": "SELECT campaign.id, campaign.name, campaign.status FROM campaign ORDER BY campaign.id"
}

response = await aiohttp_session.post(url, json=params, headers=headers)

But I receive 404 status. Which is correct URL to get all customer campaigns ?

Thanks in advance.

[Google Ads API Forum Advisor]

Hi Anna,

Thanks for reaching out to the Google Ads API Forum.

The URL sent is incorrect, and this is the reason you received the error 404. Instead, you may use the ‘https://googleads.googleapis.com/v11/customers/6074981807/googleAds:search' to get all the campaigns.

Following are the two endpoints to fetch the objects from Google Ads:

 

search	POST /v11/customers/{customerId}/googleAds:search Returns all rows that match the search query.
searchStream	POST /v11/customers/{customerId}/googleAds:searchStream Returns all rows that match the search stream query.

To get the all the campaigns, you may use below GAQL:

SELECT

  campaign.name,

  campaign.status, 

 metrics.impressions,

  metrics.clicks,

  metrics.ctr,

  metrics.average_cpc,

  metrics.cost_micros

FROM campaign

ORDER BY campaign.id

You may refer to this example guide for the reports. Also, the Query Cookbook guide contains many reporting samples that correspond to some of the default Google Ads screens and work with the same environment variables used in this guide. Our interactive query builder tool is also a great resource for building custom queries interactively.

Regards,

Yasar Google Ads API Team

 

 

ref:_00D1U1174p._5004Q2dvToi:ref

[Anna Lysak]

Thank you very much! It works!