Super Fast Reports using Google Sheets, BigQuery, and Looker Studio

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 9

  • @Cheryl.Spencer
    @Cheryl.Spencer Рік тому +1

    How would you set things up to track multiple Convertboxes? I have 8 opt-ins and 50+ ConvertBoxes.

    • @Vision-Labs
      @Vision-Labs  Рік тому +1

      ohh, that is a good one.
      On the browser side, check this out ->ua-cam.com/video/Pu6YCCpMWkI/v-deo.html&ab_channel=BetterThanData
      Then, on the database side, you will need to have a way of storing those leads similar to this video.
      You could also ddo that in your CRM.
      For example your CRM ingests the convertbox then snends the webhook. Lots of options...
      Feel free to join the newsletter & hit reply with more details and we are happy to help -> Betterthandata.com/quiz

  • @vincenzonosso7400
    @vincenzonosso7400 Рік тому

    Interesting video and nice GUI!
    How did you build the top menu ?

    • @Vision-Labs
      @Vision-Labs  Рік тому +1

      Its in Page Layout > Top Bar
      Easy Peasy :)

  • @GermanRodriguezqndq
    @GermanRodriguezqndq 7 місяців тому

    quick question, what is th ebes way to update the table by using google sheet, for example if everyday I replace the data on the google sheet how can I append the new data in to the table?

    • @Vision-Labs
      @Vision-Labs  7 місяців тому

      Simple run a schedule and append query that appends the google sheet data to a big query data every day or week

    • @GermanRodriguezqndq
      @GermanRodriguezqndq 7 місяців тому

      @@Vision-Labs final question, what should i so when I get Data Set Configuration Error -- looker can not connect to your data set, I am able to see the fields on the data are at the right

  • @spiggott
    @spiggott Рік тому

    Thanks for this video. Very helpful. So, is connecting to BQ significantly faster than connecting GDS directly to the Google Sheet?

    • @Vision-Labs
      @Vision-Labs  Рік тому +1

      Yes, it will be faster!
      The only caveat with what I ran through in the video is that you will run out of Google Sheets space since you are relying on google sheets to still hold all the data.