Combining SearchQueryPerformance table with KeywordBasicStats table

[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 will be greatly appreciated!

[Google Ads API Forum Advisor]

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 googleadsa...@google.com alias instead.

 

Regards,

Kevin Gil Google Ads API Team

ref:_00D1U1174p._5004Q2ZKO7h:ref

[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 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  

[Google Ads API Forum Advisor]

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 outside of our scope already. This is because our team doesn't have access to the BigQuery platform, and is unable to investigate or troubleshoot the issues on our end.

That being said, as for your concern on reporting to bring together the KeywordBasicStats table with the SearchQueryPerformance table using BigQuery data transfer, you will need to get in touch with the BigQuery team by contacting them through the support channels available here.

Let us know if you have any further questions.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2ZKO7h:ref

[Casey Tilly]

My apologies, Thank you for the help!