Hello Google Ads API Community, I'm currently facing a challenge with recreating a specific report that I can view and filter directly via the Google Ads UI. My goal is to replicate this report using the API but I'm encountering difficulties due to the segregation of data across different tables.
Background: I routinely generate a report in the Google Ads UI where I use a filter to select specific campaign names to view conversions and conversion values tied to individual products. This report is crucial for my analysis as it combines both product details and campaign-specific information. Issue: While extracting data programmatically, I am using the ' *Shopping_performance_view_report*' table which provides detailed data on products and conversions. However, this table lacks campaign-related information which I need to filter by specific campaigns. I found other tables like *'user_location_view_by_campaign_report'*,* 'ad_group_report'*, and* 'ad_group_ad_report'* that contain '*campaign_name'* data but none of these include product details to allow a direct join on relevant keys like product IDs or similar identifiers. Is there a recommended method or a particular table in the Google Ads API that combines both product information and campaign details including conversions data? If not, could you suggest an efficient way to join or link data from the Shopping_performance_view_report with any of the campaign-specific tables to replicate the UI's capability of filtering by campaign name? Are there any best practices or examples you could share where such data consolidation has been implemented effectively using the API? I aim to automate this reporting process and need to ensure that the data extracted via the API aligns perfectly with what we can see and filter in the Google Ads UI. Any guidance, code snippets, or pointers to relevant documentation would be greatly appreciated. Thank you in advance for your help and looking forward to your expert suggestions! Best regards, Elahe Sharifisamani -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f29a4b61-7212-4cb1-9b28-b3c5874b5b2dn%40googlegroups.com.
