Write Report to Variable?

[Nellle Rickchards]

The reporting documentation provides this example:

report_downloader.DownloadReportWithAwql(

    report_query, 'CSV', sys.stdin, skip_report_header=False,

    skip_column_header=False, skip_report_summary=False,

    include_zero_impressions=True)

I have updated that code to  download to to a CSV file and then I read the CSV file into my script and output the values.

 

This feels redundant. How can I save the report to something like a python list?

[Teja Makani]

Hello Nellle,

Based on the how you need the data you may need to download the report as a string or stream. However getting the data directly in that format may not be possible. Please check the code samples in reporting for different available options. 

Regards,
Sai Teja, AdWords API Team.

[Nellle Rickchards]

I'm trying to save data directly to a database. It's not a lot as I only need account level data. I was hoping I could do this without downloading to a CSV first.

[Teja Makani]

Hello Nellle,

I am afraid that the options described in my previous response might be the only options. Were you able to try those?

[Zweitze]

You may want to look for add-ons for your DBMS.
For instance, if you use Microsoft SQL Server, multiple SSIS components are available. Search for "SSIS AdWords".

(Disclaimer: I never used any of these and cannot recommend one. I do know that such components have to be updated regularly because AdWords API is updated every few months.)