Posts tagged with google-ads-api

I'm trying to upload all customer data from BigQuery into Google Ads to improve our customer match on audiences.

I was able to make the integration, but for some reason I'm getting an unknown error and no data is being pulled.

Runs results

Error Details or lack of ...

This is the data we are sending, we have followed the requested format and not doing any data transformation to avoid weird issues.

I'm a bit lost on what else I should be checking on this - and I felt like google ads gives more instructions on how to upload CSV data rather than how to automate with BigQuery.

Anyone been through this or has any ideas?

Field Mapping

Thanks in advance :)

I am trying to integrate Google Ad Words and Salesforce and I am trying to fetch the campaign_budget.amount_micros and 'daily budget date'. I am getting the budget amount from campaign_budget.amount_micros. However, I am not sure the exact field which stores the date.

I tried checking the query validator but still couldn't figure out the exact field or even if the date is actually stored or not. https://developers.google.com/google-ads/api/fields/v16/campaign_query_builder

I am trying to connect to the Google Ads API, so I will be able to manage campaigns and apply rules to them but to maintain a connection I need an OAuth Refresh Token. In the Google documentation, it says to install the OAuth2l but I was not able to install it.

Is there an alternative way to generate a refresh token?

Note: I tried to install the OAuth2l from the git link in the Google documents but it was not successful!

I am new to Google Ads API, and I am following the following repository, which contains python samples for the dfa reporting API:

https://github.com/googleads/googleads-dfa-reporting-samples/blob/main/python/v4/

I am using an user account, and I am able to run authenticate_user_account.py obtaining authentification successful. However, when I am trying to run the get_campaigns.py I obtain a TypeError:

Traceback (most recent call last):   File "/Users/jozaita/Documents/googleads-dfa-reporting-samples/python/v4/get_campaigns.py", line 64, in <module>     main(sys.argv)   File "/Users/jozaita/Documents/googleads-dfa-reporting-samples/python/v4/get_campaigns.py", line 43, in main     request = service.campaigns().list(profileId=profile_id)               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   File "/Users/jozaita/Documents/googleads-dfa-reporting-samples/venv/lib/python3.12/site-packages/googleapiclient/discovery.py", line 1122, in method     for pvalue in pvalues: TypeError: 'int' object is not iterable 

I am running the command as :

python3 python/v4/get_campaigns.py  XXXXXXXXX 

Where XXXXXXXXX is a number.

Can anyone help to show which is my mistake, or how can I get over this issue?

Thank you very much in advance

I searched in google there is additional information , I have found the same mistake in the Google Ad GoogleGroups but I am not able to join or get to the GoogleGroups conversation