Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
betul_korkmaz_e
New Contributor

QVSOURCE - Adwords using Adwords Query Language

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

Tags (2)
5 Replies
chrisbrain
Valued Contributor

Re: QVSOURCE - Adwords using Adwords Query Language

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.

betul_korkmaz_e
New Contributor

Re: QVSOURCE - Adwords using Adwords Query Language

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

MVP
MVP

Re: QVSOURCE - Adwords using Adwords Query Language

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

betul_korkmaz_e
New Contributor

Re: QVSOURCE - Adwords using Adwords Query Language

Hi Steve,

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

Betul

chrisbrain
Valued Contributor

Re: QVSOURCE - Adwords using Adwords Query Language

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.

Community Browser