API for Reporting General Questions

[david....@zuto.com]

Hello,

I've been successful in implementing the 'Hello World' for the AdWords API and I'm now working on implementing downloading of reports. I've been searching around and looking at the API documentation for about three days and can't find the answers to my questions/locate the columns that I require.

I'm am trying to recreate a report that's on the AdWords web reporting interface and it's generated the following questions:

1. On the web interface, it seems that columns/data can be dragged and dropped from anywhere to combine into one report. The API looks like you have to download multiple reports then combine the reports together (I'll be putting the reports into a SQL DB) - is this true? Or is there an API report that will allow me to download every column/all data like in the web interface?
2. Using 'CampaignStatus' as an example, on the web interface it remains a 'Campaign Status' and has values like 'Eligable'. However, in the API 'CampaignStatus' is the field selected, which in the download becomes 'Campaign State' (fair enough, it's just a display name) but then the values are 'Enabled' etc. The question is, are these the same columns or are they different to what is in the web interface? As I say I've searched the documentation and downloaded the CSV for the enums etc. and can't really map them.

If I've missed something in the API documentation, please provide a link and then I can make sure that I re-read that section (if I didn't miss last time).

Regards,

Dave.

[Shwetha Vastrad (AdWords API Team)]

Hi Dave,

In AdWords API, a given report request can only include data for a particular report type from a single AdWords account. If you need to gather reporting data for different report types, you need to submit separate requests. You can use the chart provided here to choose the report type suited for your needs. You should include only those fields which are available for the specified report type in a report definition. You can use the ReportDefinitionService.getReportFields() method to obtain the list of available fields programmatically. 

You could consider using the ServingStatus field in Campaign Performance Report which indicates if the Campaign is serving ads. Please note that all the campaign statuses in the UI are not available in the API report.

Regards,

Shwetha, AdWords API Team.