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 ReportColumns* 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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/4349b849-f721-43c6-a3f2-ab0c3c2b2c76%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
