Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

5 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Anonymous
Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Not applicable
Author

Hi Steve,

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

Betul

chrisbrain
Partner - Specialist II
Partner - Specialist II

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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense