We pulled in Google Adwords data into BigQuery. I'm using the tables that are created in the transformation of the data from Google Adwords to BigQuery. I'm looking to bring together the KeywordBasicStats table with the SearchQueryPerformance table so we can view keywords and there stats along with the query information as well.
If we need to get into more detail i can send you the full query where i am combining KeywordBasicStats for metrics at the keyword level. Also pulling from the Keyword table to get the actually Criteria (keywords). Along with pulling together the AdGroup table and Campaign table to bring in the Campaing/AdGroup names On Wednesday, April 6, 2022 at 9:03:40 PM UTC-5 adsapi wrote: > Hi Casey, > > > > I'm Kevin from the Google Ads API Team. > > > > Can you provide more details (e.g. a documentation link or some > screenshots) on where to find the KeywordBasicStats table? Also, please > further elaborate what you mean by combining data as it seems that there's > no JOIN statement in GAQL. You may send to me the information I requested > via *Reply privately to author* option. If this option is not available, > you may send the details directly to our [email protected] alias > instead. > > > > Regards, > [image: Google Logo] > Kevin Gil > Google Ads API Team > > > ref:_00D1U1174p._5004Q2ZKO7h:ref > -- This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 on the web visit https://groups.google.com/d/msgid/adwords-api/67bf8019-b9fb-42e3-b1d7-41bc04f83d4dn%40googlegroups.com.
