New to API - Ad performance report with conversions (sales, leads, sign-up, other, all)

[Betul Korkmaz]

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

[Umesh Dengale]

Hi Betul,

You could use the ConversionCategoryName field to get the values Download, Lead, Purchase/Sale, Signup, View of a key page, and Other in your report query. Please check out AD_PERFORMANCE_REPORT document for more details.

Regards,

Umesh, AdWords API Team.

[Betul Korkmaz]

Hi Umesh,

Thank you for your reply, however that's the not the same thing? Plus that field doesn't work in the Ad performance report. At least not using a script like this, is there another way?

SELECT

AccountDescriptiveName,

Clicks,

Cost,

CreativeFinalUrls,

CreativeDestinationUrl,

CreativeFinalAppUrls,

CreativeFinalMobileUrls,

CampaignName,

Month,

AccountCurrencyCode,

AdNetworkType1,

CampaignName,

Device,

DisplayUrl,

GmailSecondaryClicks,

GmailForwards,

Headline,

Id,

AdType,

Impressions,

AdGroupName,

ConvertedClicks,

AveragePosition,

ViewThroughConversions,

Description1,

Description2,

Status,

Ctr

FROM AD_PERFORMANCE_REPORT

Best,

Betul

[Umesh Dengale]

Hi Betul,

Thanks for providing the report query. The ConversionCategoryName field is not compatible with some of the fields (e.g. Clicks, Cost, GmailSecondaryClicks, GmailForwards, Impressions, AveragePosition etc.) from the above report query. Please see the Not compatible with the following fields section of the ConversionCategoryName. You need to remove the fields from the report query which are not compatible with ConversionCategoryName field in order to get the data.