Posts under category Google

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

I have many campaigns and I want to summarize the spends by all the states (USA states) and based on from and to dates.

I went through the https://developers.google.com/google-ads/api/docs/reporting/overview but I dont see any point that can determine the spends based on states.

Which endpoint I need to use in Google Ads API: In the FB I am using https://graph.facebook.com/v13.0/act_2264578877108750/insights?access_token=<ACCESS_TOKEN>&fields=spend&breakdowns=region%2Ccountry&level=ad&time_range=%7B%27since%27%3A%272022-05-15%27%2C%27until%27%3A%272022-05-15%27%7D&limit=100&after=OTkZD

Any help is really appreciated.

Suppose if the value of Line item (Cost per Unit) is $45.45 in the report that we get from Google Ad Manager 360 UI , the same report when extracted through a java application using ad manager API gives value '45454000' . Why is this conversion done ? is it specific to any API version? I'm using v202111 in my application.

I have a user list on my Google Ads account. I can access it, but I do not know how to clear it via the REST API.

Do you have any idea or examples?

Here is the request to read the list:

curl -f --request POST "https://googleads.googleapis.com/v10/customers/1111111111/googleAds:searchStream" \      --header "Content-Type: application/json" \      --header "developer-token: ${DEVTOKEN}" \      --header "Authorization: Bearer ${TOKEN}" \      --header "login-customer-id: 2222222222" \      --data "{ query:'SELECT user_list.id, user_list.name FROM user_list'}" 

Thanks, Nicolas