Best way to get Conversion data and clicks data from campaign performance report

[Raghu Kashyap]

The UI provides all the columns within the same report(Campaign performance). However, within the API we cannot combine the clicks,impression data and ConversionTypeName data such as LeadsConversion, SalesConversion etc.. within the same API call.

Whats the best way to get this data set? 

Is this the right way?

Create 2 reports, 1 with clicks data and other with conversion data(by adding the ConversionTypeName as the segment). Use 2 API calls to download the two reports. Also once you get this two data sets is there any unique identifier to combine these?(Account, timestamp,device,campaign)

Thanks

[Shwetha Vastrad (AdWords API Team)]

Hi Raghu,

You are right. The ConversionTypeName field in Campaign Performance Report is not compatible with Click or Impressions.  Even in the UI, if you segment based on Conversion Name, the Clicks and Impressions stats will be aggregated at the campaign level. You could probably query for Clicks and Impressions in one report and ConversionTypeName and related fields in another report. You would need to aggregate the conversions associated with campaigns for each conversion type. You can use the CampaignId to map the values. Please be careful when using fields that segment the report.

Regards,

Shwetha, AdWords API Team. 

[Raghu Kashyap]

Thank you. Trying to work with ConversionCategoryName and ConversionTypeName fields to actually extract all the conversions and conversion values.