CODEWITHSUNDEEP
node.jsgoogle-ads-apigoogle-api-nodejs-client
Divya Patel
Divya Patel

Reputation: 136

Google Ads API - How to get all campaigns that are created via google ads api (Node JS)

I am trying to find the total cost of google ads campaigns that are created via a particular manager account or via google ads api.

I tried the change event query where it gives me all the campaigns created via google ads but the issue is with change_event.change_date_time. It requires this filter otherwise it throws an error. Because of this filter, I am only getting campaigns that are created in this specific time period, but I need all campaigns.

SELECT
  change_event.campaign
FROM change_event
WHERE
  campaign.status != 'REMOVED'
  AND change_event.change_date_time >= '${from_date}'
  AND change_event.change_date_time <= '${to_date}'
  AND change_event.client_type = 'GOOGLE_ADS_API'
ORDER BY change_event.change_date_time ASC
LIMIT 10000

Reference Link: https://developers.google.com/google-ads/api/fields/v9/change_event_query_builder

Upvotes: 0

Views: 1178

Answers (1)

ricardofrancoli
ricardofrancoli

Reputation: 33

Unfortunately, change_event can only go retrieve data up to 30 days old (see here).

I've tried building a query that could get that information but using FROM campaign but it seems like only change_event has access to how a campaign was created.

A possible solution would be to create multiple from/to date on 30-day cycles, starting from the account creation date.

Otherwise, you can use change status for a slightly larger window of 90 days, with the limitation that you can't filter by change_event.client_type = 'GOOGLE_ADS_API', using simply change_status.resource_status = 'ADDED' instead.

SELECT
  change_status.campaign
FROM change_status
WHERE
  campaign.status != 'REMOVED'
AND change_status.resource_status = 'ADDED'
AND change_status.last_change_date_time >= '${from_date}'
AND change_status.last_change_date_time <= '${to_date}'
ORDER BY change_status.last_change_date_time ASC
LIMIT 10000

Upvotes: 1

Related Questions