QVSOURCE - Adwords using Adwords Query Language

[Anonymous]

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

[chrisbrain]

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.

[Anonymous]

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

[stevedark]

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

[Anonymous]

Hi Steve,

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

Betul

[chrisbrain]

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.