How to use Google Ads connector in ADF

[thang viet]

Hi all, 

I am struggling with trying to connect adf with google ads to fetch data, so that I can store it in our sql data ware house and make report out of it. 

I have obtain developer token for basic access. 
I dont know which type of Credentials to create. ( I watched some tutorials on youtube and it said I should use OAuth, but also I dont know which application type to choose) 

Then refresh token is also another confusing issue for me. 

Help! I searched google for step to step connect google ads to adf using google ads connector, but there is nothing. Seems like nobody using that. 
Anyone have experience on this? 

Thank you very much.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

With regard to your concern for the application type, as per this documentation (https://developers.google.com/google-ads/api/docs/oauth/cloud-project#create_a_client_id_and_client_secret) in creating client ID and client secret, you can select either Desktop app or Web application as the app type, depending on your use case. Then for the refresh token, if you're using our client library, you can check this documentation guide (https://developers.google.com/google-ads/api/docs/first-call/refresh-token) on how to generate it.

In addition to that, to enable API access, first obtain the required OAuth2 credentials. Then, add the authorization and account details to a config file. Once the config file is set up, you're ready to call the API. Kindly check this (https://developers.google.com/google-ads/api/docs/first-call/overview), for more information.

This message is in relation to case "ref:_00D1U1174p._5004Q2ncuP6:ref"

Thanks,
 

Google Ads API Team

[thang viet]

Hi, 

thank you for supporting,

From your previous response, could you explain more about "if you're using our client library"? 

I am going to use the Google ads connector on Azure Data Factory to get the data. After I read the guide to generate refresh token, I still don't know what I have to do.

[Google Ads API Forum Advisor]

Hi,

Thanks for getting back to us.

Kindly note that we have limited knowledge on third-party tools like Google ads connector on Azure Data Factory as our team specializes in Google Ads API related concerns and technical implementations only. 

With regards to your refresh token concern, as mentioned in our previous email, we highly recommend going through our Quickstart guide (https://developers.google.com/google-ads/api/docs/first-call/overview) and learn about the refresh token. Because OAuth2 access expires after a limited time, an OAuth2 refresh token is used to automatically renew OAuth2 access.

With regards to your concern about the client libraries, Google Ads API offers client libraries (https://developers.google.com/google-ads/api/docs/client-libs) that provide high-level views and basic building blocks of Google Ads API functionality, making it easier to develop apps quickly. It is highly recommended starting out with one if you're new to the API.