Big Query SQL Tutorial - How to easy JOIN tables (Part #5)

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ธ.ค. 2024

ความคิดเห็น • 25

  • @marketingwatchhouse2704
    @marketingwatchhouse2704  4 ปีที่แล้ว +3

    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/

  • @aloisiolemos5022
    @aloisiolemos5022 ปีที่แล้ว

    This content is amazing! Tks guy!

  • @josephmaclean4153
    @josephmaclean4153 3 ปีที่แล้ว +1

    I have looked everywhere for this type of content. Thank you so much!

  • @gbemikeolowe8111
    @gbemikeolowe8111 ปีที่แล้ว

    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.

  • @sgibert
    @sgibert 2 ปีที่แล้ว +1

    Fantastic content! Thanks for taking the time to do these

  • @Videoorchard
    @Videoorchard 2 ปีที่แล้ว

    Hi, Whats the difference between fact and dimension. why do we join with a dimension?

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      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.

    • @Videoorchard
      @Videoorchard 2 ปีที่แล้ว

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

  • @ramiroproietto6747
    @ramiroproietto6747 2 ปีที่แล้ว +1

    amazing

  • @anuragvuppala4182
    @anuragvuppala4182 2 ปีที่แล้ว

    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.?

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      Sorry, I'm unsure how to answer the question since it's missing context. However you will find answers in the videos.

  • @data_kom
    @data_kom 2 ปีที่แล้ว +1

    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.

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      Hey! You can join as many tables as you need. 12 sounds a lot tho you sure you need to join them, not union?

  • @timakinola458
    @timakinola458 2 ปีที่แล้ว

    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?

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      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.

  • @tanipartner1319
    @tanipartner1319 2 ปีที่แล้ว

    Can you please explain why do we do left join of product array with hits .

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      Hey, sorry, don't understand your question.

    • @tanipartner1319
      @tanipartner1319 2 ปีที่แล้ว

      @@marketingwatchhouse2704 to access product from hits we do unnest left join product with hits. I did not understand why we are doing left join

  • @jamesleleji9470
    @jamesleleji9470 2 ปีที่แล้ว

    Can you freeze header row in big query like freeze panes in Excel? Thanks

    • @marketingwatchhouse2704
      @marketingwatchhouse2704  2 ปีที่แล้ว

      No, because it's not the data reporting tool .You can export it into Google Sheets and freeze the headers.

  • @AdnanKashemOxe
    @AdnanKashemOxe 3 ปีที่แล้ว +1

    Best tutorials 🔥🙏