Hi, I'm trying to retrieve specific data from Google Performance Max campaigns using an SQL join across several tables. My goal is to pull detailed information about URLs, including the number of clicks each URL has received. However, I'm unable to find the appropriate way or the correct fields to accurately retrieve the number of clicks per URL within Performance Max.
Could you please guide me on how to perform this query correctly? Specifically, I'd appreciate your assistance in identifying the correct Google Performance Max tables, fields, and recommended joins to achieve this. Thank you for your support. Best regards, On Tuesday, 25 March 2025 at 16:02:31 UTC+1 Google Ads API Forum Advisor wrote: > Hi, > > Please be advised that the retrieval of a combination of all provided > fields within a single query is not possible. It is recommended that you > utilize distinct reporting mechanisms, specifically the > *asset_group_asset* > <https://developers.google.com/google-ads/api/fields/v19/asset_group_asset>, > *campaign* > <https://developers.google.com/google-ads/api/fields/v19/campaign> and > *performance_max_placement_view* > <https://developers.google.com/google-ads/api/fields/v19/performance_max_placement_view> > > reports. Comprehensive details regarding Performance Max reporting can be > found in the *API documentation* > <https://developers.google.com/google-ads/api/performance-max/reporting>. > > To facilitate further assistance, could you please confirm if you are able > to see all these fields together in the Google ads UI? If so, kindly > provide an earlier requested uncropped Google Ads UI screenshot where you > are able to get all the mentioned fields in a single page with the > visibility of the *customer Id* > <https://support.google.com/google-ads/answer/1704344?hl=en>. > > You can send the details via *Reply privately to the author option*, or > *direct > private reply* to this email. > > > Thanks, > > [image: Google Logo] Google Ads API Team > Feedback > How was our support today? > > [image: rating1] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vHCLyQAO> > > [image: rating2] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vHCLyQAO> > > [image: rating3] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vHCLyQAO> > > [image: rating4] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vHCLyQAO> > > [image: rating5] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vHCLyQAO> > > [2025-03-25 15:01:23Z GMT] This message is in relation to case > "ref:!00D1U01174p.!5004Q02vHCLy:ref" (ADR-00296324) > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/06be2a61-92a8-4032-8bf4-33914891eec4n%40googlegroups.com.
