Subscribe to this channel. And follow the BQ Tutorial Playlist ua-cam.com/channels/GVixrs0am6EoF9O16C5lpQ.htmlplaylists Have a question or a project? - Me on LinkedIn: www.linkedin.com/in/rpetrochenkov/ - Me on UpWork: bit.ly/3hKa3qC-MWH
Hi Marketing Watch House, I am trying to find keyword performance for my campaigns. Since I do not have a Google Ads account, I created an empty one to transfer these tables and then create fake data to recreate the tables. I am not sure what field do I need to use to find out the keyword performance (let's say revenue or clicks) for a specific campaign. Any help would be appreciated.
Hi! It's actually very difficult to find a sample data. Although if you have advertising activity in your account at all (even a tiny one) you can simply import this ti bigquery and start practicing. The good part, is that with a scale the data structure does not change - so every report will work the same way.
@@marketingwatchhouse2704 cool In that case, would you mind posting some of the code you used in the video with labels Like top ad groups by spend etc.
Could you please specify a bit what are looking for? Do you look fir Google Ads Script or for SQL scriprt for BQ? You are also welcome to write Linkedin and I will help you to find what you need :)
@@alanf5615 Hey Alan! Sorry for a late reply. It appears I failed to push "send" button. You can access labels in Big Query to Analyze them, but you can't change or apply labels on Google Ads. In other words you have Read-only way of working. What you can do though, if you want to apply labels based on some logic, is to generate a list of IDs (of kws, campaigns or whatever) in BQ, export them to google sheets. And then apply through Google Ads Script. It also can be done with Python/R + BQ, but in both of the cases you need an additional technology to make it work. Reach me out on LnkedIn and I'll try to help you out.
@@marketingwatchhouse2704 Can you do a computed or generated column in Big query as you in MySQL so that the value in the generated column gets updated automatically based on values of the source column? Thanks
Hi Roman, I am trying to make the simple query, that you did in the end: SELECT * FROM `google_ads.Campaign_XXXXXXXXX` WHERE _LATEST_DATE = _DATA_DATE But i get an error message each time: Not found: Dataset compact-pier-298217:google_ads was not found in location EU My data is (or at least should be stored) in the us. under query settings i have changed to every single location that is possible, but always the same error code. Any Advice?
Hey Dennis! This is a very common problem. Something is configured in your data set wrongly. It's either the dataset itself (in other words: parameter of the folder under which you have your tables) or the import. My suggestion to you, if you just started, to re-create the dataset folder and re-create the import. Then to schedule backfill for the past week and try it out. It should fix 98% of all possible problems. But in case you got into unlikely 2% - write me and we will try to fix it together!
I got the same error. Double check the table name at the top of your selected Schema and replace it with what you have here 'Campaign_XXXXXXXXX'. In other words, you're not referring to the right table name. Update: actually you should select the right folder on the Google Ads folder on the left to be able to see the campaign data as shown in the video. For me, the "ads_Campaign_X" was not the first folder at the top, so just search "ads_Campaign_" and you should find it quickly.
Hey! There is a current instruction: cloud.google.com/bigquery/docs/adwords-transfer And for 2023 viewers upcoming instruction: cloud.google.com/bigquery/docs/google-ads-transfer
Subscribe to this channel. And follow the BQ Tutorial Playlist ua-cam.com/channels/GVixrs0am6EoF9O16C5lpQ.htmlplaylists
Have a question or a project?
- Me on LinkedIn: www.linkedin.com/in/rpetrochenkov/
- Me on UpWork: bit.ly/3hKa3qC-MWH
This video is so very easy to follow along! Thank you so much for the awesome content.
You are so welcome!
You are really the best! Love your video's!
Glad you like them!
Excelent video! Thanks!
Glad you liked it!
Hi Marketing Watch House,
I am trying to find keyword performance for my campaigns. Since I do not have a Google Ads account, I created an empty one to transfer these tables and then create fake data to recreate the tables. I am not sure what field do I need to use to find out the keyword performance (let's say revenue or clicks) for a specific campaign. Any help would be appreciated.
What do you retrieve data for Performance Max campaign?
I'm sorry, I don't think I understand the question
Hi, Can you please post a place to get sample adwords data so we can use these videos for practice
Hi! It's actually very difficult to find a sample data. Although if you have advertising activity in your account at all (even a tiny one) you can simply import this ti bigquery and start practicing. The good part, is that with a scale the data structure does not change - so every report will work the same way.
@@marketingwatchhouse2704 cool
In that case, would you mind posting some of the code you used in the video with labels
Like top ad groups by spend etc.
Could you please specify a bit what are looking for? Do you look fir Google Ads Script or for SQL scriprt for BQ? You are also welcome to write Linkedin and I will help you to find what you need :)
@@marketingwatchhouse2704
Sql script for BQ
I'm thinking somthing centered around the most commonly asked measures requested by companies
@@alanf5615 Hey Alan! Sorry for a late reply. It appears I failed to push "send" button. You can access labels in Big Query to Analyze them, but you can't change or apply labels on Google Ads. In other words you have Read-only way of working. What you can do though, if you want to apply labels based on some logic, is to generate a list of IDs (of kws, campaigns or whatever) in BQ, export them to google sheets. And then apply through Google Ads Script. It also can be done with Python/R + BQ, but in both of the cases you need an additional technology to make it work. Reach me out on LnkedIn and I'll try to help you out.
Can you freeze the header row in bigquery while scrolling down the table like freeze panes in Excel? Thanks
No, because it's not the data reporting tool .You can export it into Google Sheets and freeze the headers.
@@marketingwatchhouse2704 Can you rename temporary table in Bigquery instead of that default long name that bigquery generates for it
@@marketingwatchhouse2704 Can you do a computed or generated column in Big query as you in MySQL so that the value in the generated column gets updated automatically based on values of the source column? Thanks
Hi Roman, I am trying to make the simple query, that you did in the end: SELECT * FROM `google_ads.Campaign_XXXXXXXXX` WHERE _LATEST_DATE = _DATA_DATE
But i get an error message each time: Not found: Dataset compact-pier-298217:google_ads was not found in location EU
My data is (or at least should be stored) in the us. under query settings i have changed to every single location that is possible, but always the same error code.
Any Advice?
Hey Dennis! This is a very common problem. Something is configured in your data set wrongly. It's either the dataset itself (in other words: parameter of the folder under which you have your tables) or the import. My suggestion to you, if you just started, to re-create the dataset folder and re-create the import. Then to schedule backfill for the past week and try it out. It should fix 98% of all possible problems. But in case you got into unlikely 2% - write me and we will try to fix it together!
I got the same error. Double check the table name at the top of your selected Schema and replace it with what you have here 'Campaign_XXXXXXXXX'. In other words, you're not referring to the right table name.
Update: actually you should select the right folder on the Google Ads folder on the left to be able to see the campaign data as shown in the video. For me, the "ads_Campaign_X" was not the first folder at the top, so just search "ads_Campaign_" and you should find it quickly.
But how do you connect your ads account with your bigquery?
Hey! There is a current instruction: cloud.google.com/bigquery/docs/adwords-transfer
And for 2023 viewers upcoming instruction: cloud.google.com/bigquery/docs/google-ads-transfer