How to Link click_performance_report to shopping_performance_report & keyword_preformance_report

[Mike Miller]

I am trying to link the click_performance_report to the following two tables.

1. keyword_performance_report
   
2. shopping_performance_report
   

What join key should I be using to link these tables together?  The goal is to be able to see the "gclid" value alongside the keyword and shopping campaigns reports.

The reporting outcome I am trying to create would have the following columns.

Report 1 - Keyword Performance Report

Columns

KEYWORDS_PERFORMANCE_REPORT.Date KEYWORDS_PERFORMANCE_REPORT.Device KEYWORDS_PERFORMANCE_REPORT.Status (keyword status) KEYWORDS_PERFORMANCE_REPORT.Criteria  (keyword) KEYWORDS_PERFORMANCE_REPORT.Conversions

CLICK_PERFORMANCE_REPORT.gclid Report 2 - Shopping Performance Report Columns SHOPPING_PERFORMANCE_REPORT.Date SHOPPING_PERFORMANCE_REPORT.Device SHOPPING_PERFORMANCE_REPORT.OfferId (item ID) SHOPPING_PERFORMANCE_REPORT.Clicks SHOPPING_PERFORMANCE_REPORT.Conversions SHOPPING_PERFORMANCE_REPORT.ConversionValue CLICK_PERFORMANCE_REPORT.gclid

[Shwetha Vastrad (AdWords API Team)]

Hi Mike, 

This guide describes how fields in the Click Performance Report map to fields in other reports. Please note that the fields in Click Performance Report are of type attribute and can be used to associate the click with a particular Campaign, AdGroup, Ad, Criterion etc. You'll not be able get the conversions associated with each click as multiple clicks could be attributed to the same Ad. You can get the conversions from other aggregated reports like Keywords Performance Report which is aggregated at the keyword level. 

Regards,

Shwetha, AdWords API Team.