Re: Combining SearchQueryPerformance table with KeywordBasicStats table

2022-04-07 Thread Casey Tilly
My apologies, Thank you for the help! On Thursday, April 7, 2022 at 3:17:13 AM UTC-5 adsapi wrote: > Hi Casey, > > Thanks for getting back to us. > > Since you mentioned you are pulling Google Adwords data into BigQuery > using Big query transfer, note that this is implementation of the Google

Re: Combining SearchQueryPerformance table with KeywordBasicStats table

2022-04-07 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hi Casey, Thanks for getting back to us. Since you mentioned you are pulling Google Adwords data into BigQuery using Big query transfer, note that this is implementation of the Google Ads to the BigQuery platform, and implementation of the Google Ads API / AdWords API to any platform is outsid

Re: Combining SearchQueryPerformance table with KeywordBasicStats table

2022-04-06 Thread Casey Tilly
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

RE: Combining SearchQueryPerformance table with KeywordBasicStats table

2022-04-06 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
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

Combining SearchQueryPerformance table with KeywordBasicStats table

2022-04-06 Thread Casey Tilly
I am trying to combine SearchQueryPerformance table with KeywordBasicStats table. I saw in this link you mentioned to use KeywordTextMatchingQuery however that doesn't exist in our tables when we brought over Google Ads. https://groups.google.com/g/adwords-api/c/CNuiB9I8tAU Any help around this