topic Re: QVSOURCE - Adwords using Adwords Query Language in QlikView

QVSOURCE - Adwords using Adwords Query Language

Anonymous — Tue, 01 Dec 2015 16:36:17 GMT

Hi,

How do I create a report with Ad performance report with conversion metrics, see listed below:

I'm using the Adwords Query Language (through QVSource).

,[conversions]

,[sales conversions]

,[leads conversions]

,[sign-up conversions]

,[other conversions]

Any help would be really appreciated!

Best,

Betul

Re: QVSOURCE - Adwords using Adwords Query Language

chrisbrain — Wed, 02 Dec 2015 08:04:28 GMT

Hi,

This is probably a question for the AdWords support forums rather than Qlik as QVSource is simply sending the AQL directly to the AdWords API.

However, did you check the ReportDefinition table in the connector? This lists all the available reports and for each one the fields which can be included.

Re: QVSOURCE - Adwords using Adwords Query Language

Anonymous — Wed, 02 Dec 2015 09:41:11 GMT

Hi Chris,

Thank you for your reply. I have also posted this in an adwords forum but thought there is no harm asking here too.

I have looked at the reportdefinition for the Ad performance report, the fields are not there. However you can create an ad performance report with thoose fields in the UI, which suggest it is possible through API reports also, I just need to find the solution.

Betul

Re: QVSOURCE - Adwords using Adwords Query Language

stevedark — Wed, 02 Dec 2015 13:51:13 GMT

Hi Betul,

Have you tried looking at the Google documentation on that API?

https://developers.google.com/adwords/api/docs/appendix/reports/ad-performance-report

Is it that the fields you are after are present in that list but have a different name?

Steve

Re: QVSOURCE - Adwords using Adwords Query Language

Anonymous — Wed, 02 Dec 2015 15:02:07 GMT

Hi Steve,

Thank you for your reply. Yes I've looked at the list and the conversions are not there.

Betul

Re: QVSOURCE - Adwords using Adwords Query Language

chrisbrain — Wed, 02 Dec 2015 17:58:29 GMT

This may not really help but I did just notice this page on Google:

https://developers.google.com/adwords/api/docs/guides/uireports#adsReport

Which states:

The Ads report maps to the AD_PERFORMANCE_REPORT type in the API.