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