Hey Guys! Just published a ready-to-go SQL Template for Keywords Reports. Check it our here: learn-ads.com/2020/03/30/google-bigquery-google-ads-keywordsreport-template-in-sql/
I've been trying to create custom queries from the google_ads data that schedule daily and append to a table. Was also wondering if the table could be exported to a google sheet where each appended data/update reflects in the google sheet.
Hey! Dimension table is a table that enrich our data with additional look up data. For example if your table contains all clicks of X campaign, you don't want to hold all campaign settings in the same table - that would make table too big. You store settings in a separate table, called dimensional. And you join it when you need it.
@@marketingwatchhouse2704 Right. Would this be a good practice in BQ, considering that join ops are not as performant as compared to having data sitting in one table (denormalised) form
Thanks for making the video, very kind of you. How can I join 12 seperate tables into a single table in Big Query. I have tried but keeping an error message.
fantastic and explicit too. Thanks for this video. However, still looking for a clue on joining or appending many identical tables,, meaning, they have all same columns and schema. Any help with that?
There is no dynamic indexing in the SQL, you can either build a dbt or python solution to run them dynamically. Otherwise you will need to union them together first manually.
Hey Guys! Just published a ready-to-go SQL Template for Keywords Reports. Check it our here: learn-ads.com/2020/03/30/google-bigquery-google-ads-keywordsreport-template-in-sql/
This content is amazing! Tks guy!
I have looked everywhere for this type of content. Thank you so much!
You're very welcome!
I've been trying to create custom queries from the google_ads data that schedule daily and append to a table. Was also wondering if the table could be exported to a google sheet where each appended data/update reflects in the google sheet.
Fantastic content! Thanks for taking the time to do these
Glad you like them!
Hi, Whats the difference between fact and dimension. why do we join with a dimension?
Hey! Dimension table is a table that enrich our data with additional look up data. For example if your table contains all clicks of X campaign, you don't want to hold all campaign settings in the same table - that would make table too big. You store settings in a separate table, called dimensional. And you join it when you need it.
@@marketingwatchhouse2704 Right. Would this be a good practice in BQ, considering that join ops are not as performant as compared to having data sitting in one table (denormalised) form
amazing
Thanks
Hey Im trying to join google ad, ad_group table they dont have a primary key. can you please help me out to join tables with out primary col.?
Sorry, I'm unsure how to answer the question since it's missing context. However you will find answers in the videos.
Thanks for making the video, very kind of you. How can I join 12 seperate tables into a single table in Big Query. I have tried but keeping an error message.
Hey! You can join as many tables as you need. 12 sounds a lot tho you sure you need to join them, not union?
fantastic and explicit too. Thanks for this video.
However, still looking for a clue on joining or appending many identical tables,, meaning, they have all same columns and schema. Any help with that?
There is no dynamic indexing in the SQL, you can either build a dbt or python solution to run them dynamically. Otherwise you will need to union them together first manually.
Can you please explain why do we do left join of product array with hits .
Hey, sorry, don't understand your question.
@@marketingwatchhouse2704 to access product from hits we do unnest left join product with hits. I did not understand why we are doing left join
Can you freeze header row in big query 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.
Best tutorials 🔥🙏
Glad you think so!