Ability to export the Adhoc AWQL query that gets generated when using a report.

[goutham vanka]

All,

I'm a BI Developer and as part of an enterprise level report development, we're trying to pull in data from AdWords.

I've been given access to AdWords reports and I see that creating a tabular view is pretty easy.

You drag and drop the attributes / measures and Google builds a report for you that you can download as a CSV file.

But, is there a way to actually export the AWQL query that the UI layer generates and triggers a database response?

Reason why I ask is because our BI tool (Qlik) has a connector that pulls AdWords data BUT IT ONLY ACCEPTS AWQL QUERY.

My question in short: Our BI tool accepts AWQL query to pull in the data.

For our report, we need to pull in metrics / attributes from different tables in AdWords (Like there have to be several joins performed across tables).

Unfortunately, the dynamic AdHoc query that Reports generate is not accessible (I think) to me in an AWQL format. Will appreciate your help. Sorry for this long post.

[Vincent Racaza (AdWords API Team)]

Hi Goutham,

It seems that the feature that you are using in the UI is the custom columns for reports. Currently, this feature is not supported via the AdWords API, therefore, it is not possible to export or create an AWQL query for custom columns or joined columns from different reports types. If you haven't done so, you can follow our blog for any future updates like new releases.

Thanks,

Vincent

AdWords API Team