Google Ads API to MYSQL

[Tal Haguel]

So I finally manage to access the api, now to the next step.

I would like to run a query that will allow me to import all the information to mysql so it would be possible to generate reports.

Is that possible? is there any other way to do it?

[Google Ads API Forum Advisor Prod]

Hi Tal,

Thank you for reaching out. If you are using Adwords API, you could query a report and download it. This is a list of the available reports in the Adwords API. You could refer to this code example to generate a report in Adwords API. If you are using the Google Ads API, you could refer to the list of available resources and you could refer to this code example on how to generate reports.

Thanks and regards,
Xiaoming, Google Ads API Team

 

Xiaoming Google Ads API Team

ref:_00D1U1174p._5004Q275HoB:ref

[Tal Haguel]

Hi thank you!

You mean, download a report in CSV (for example) and then import it to MYSQL?

ב-יום רביעי, 28 באוקטובר 2020 בשעה 21:57:26 UTC+2, adsapiforumadvisor כתב/ה:

[Google Ads API Forum Advisor Prod]

Hi Tal,

Thank you for reaching out. Yes, you could download the report in CSV format or other available formats and then extract data and save them into MYSQL. Alternatively, you could use this code example to stream results using a BufferedReader and then process the returned data including the option to save to  MYSQL.

Thanks and regards,
Xiaoming, Google Ads API Team

[Tal Haguel]

Stream results is availbale only on Java? Couldn't find it for PHP

ב-יום חמישי, 29 באוקטובר 2020 בשעה 21:12:52 UTC+2, adsapiforumadvisor כתב/ה:

[Google Ads API Forum Advisor Prod]

Hi Tal,

Thank you for reaching out. There is no example for streaming of results from a report for the PHP client library. It is available for other client libraries such as Python and .Net client libraries.

Thanks and regards,
Xiaoming, Google Ads API Team