I am morocain licensed optician Iwant yo work whid you

This is amazing!!!

When Looker Studio is connected with Firebase Events table in BQ, all data is queried & the date filter is applied at the end. Can verify this by looking at 'Job History' in BQ. Is there any way to avoid this? I have tried setting date filters in report, page & chart too, but everytime it queries the entire dataset

Thanks for the video, super helpful

Guys, I hope you're paying more attention to your work projects than to your videos) Thank you for the new insights, but there are always a few mistakes in them)) It's actually quite funny, because I'm sure you can fix them easily)

Hi, Stockton. What about the first new table? You didn't create a schedule for that one. Will it work properly considering that the second scheduled query relies on the first table, which is not scheduled?

Very helpful video, thanks for making it

Ask chatgpt for get document.title Now we are here.

Sound minus

It was a bit too fast and difficult to grasp the context 😞

Super helpful video, thanks Stockton! 🙌

Thank you, Stockton!

best video ever!😲

this was very helpful!!

1:00 I',m from Medellin Colombia and my breakfast was "calentado" (google it)

thank you very much. in summary, in what cases would i prefer connecting via custom query rather than direct to the table?

thank you very much. in summary, in what cases would i prefer connecting via custom query rather than direct to the table?

que capo!!! gracias parcero

After creating the UTM, should it be copied to the website URL on the Ad or leave it there

i want date clear date range control when click on button in looker studio.

icon page is redirecting to some other page. cab you help with sending the new URL

Hi! Would it be possible to use scheduled SQL queries directly on BigQuery to do the currency conversion?

This video is incredibly insightful! The breakdown of landing pages, standard pages, and items for eCommerce is so clear and informative. It's a must-watch for anyone looking to optimize their online store. Thanks for making complex concepts easy to understand!

Great video as always JJ! BTW - those floating 'likes' at 3:57 were on purpose or auto-generated by the recording software😂??

Thanks for sucha detailed video! Just a quick question - can we also store some user-provided data like emails and phone numbers in a 1st-party cookie tag and then send it back to google ads?

Your tutorial is awesome. but can you fix adjust your mic audio hehe

amazing video, can you make video on setting up facebook pixel and custom events using zaraz?

Great.

is there a way to download a report in Looker studio at this time with the image assets...? Even as a pdf? it appears blank when tried to download PDF report in Looker studio.

You should make a video of what is charged on BQ/Looker. For example are looker filters lien youve done charged? Or just any query made on Bi query sql. But can you also answer that question here quickly

Please can yu speak faster? Thx!🤣

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?

Valuable info! Is there any way to get the datasource without the connectors? They've all become pricey recently. Do you know any workarounds? Appreciate it:)

Great video guys Thanks for informative video

Does it matter that our data is in the EU? I tried and get an error saying that analytics[id] does not exist in location US

Great content, thanks a lot! For candlesticks, since you are running the calculation in bigQuery, does that mean you can't "filter" the data? In my dataset, I have the performance of 5 products in retail and I'd like to show candlesticks for different "price buckets" but with your approach, I wouldn't be able to filter by product right? Or I would have to create 5 different querys?

I am currently having the same problem as previously mentioned in the comments - When I click on the image, it opens in a new tab. Do we just have to wait for Google to fix this or is there a workaround ?

0:50, how the HELL did you get the Dashboard to listen to your voice on "Do More!" ??!??!

Hey! Can you create a video where you show. How to take google sheets and send it looker studio and recreate the type of visual presentation you are showcasing in your cheatsheets. A step by step tutorial. Just something simple so the workflow becomes clear.

great video as always! however, no need to create a custom JS variable for the page title. you can simply create a JS variable with the value 'document.title'

This is really interesting.

This is brilliant Stockton thank you for the overview of the latest on cookies. Literally answers so many Agency questions I have been getting this week.

Super helpful videos, thank you! Was wondering if you know of a way to do a blend to calculate the difference between two scorecards when one scorecard is within the button control field grouped filter and the other isn't. In this case both scorecards are for the same metric, just illustrating the difference between non-filtered and filtered metric. (ie; (Active Users in USA)/(Active users) = some%)

Very useful. I was a little scared by all those clickbait headlines like 'End of the digital marketing era' :) Thanks for calming me down! Subscribed to your channel

omg nice and ez. Thx!🎉

Greetings! I Struggle to get the following to work: - 5 Different Dates with Value X for clicks I calculate Max(X)-Min(X) as new Value P to represent the (P)rogress. Now I try to Visualize P on an Area/Line chart with all 5 Dates on the Bottom, BUT I want each of those 5 Dates to only consider each step as the Max Date to represent the P Value till that specific Step. Example for the Dates listed on the Bottom time chart: Date1: 0 (Because Min is Max) Date2: Date2 - Date1 Date3: Date3 - Date1 Date4: Date4 - Date1 Date5: Date5 - Date1 I tried for hours to make it work and failed, any Idea ? Could u look into it for a tip or something? Got Discord ?

I want to asked, in regards to best practice, which is better : 1.Save the sql script into view, and connecting to looker studio, or 2.Save the sql script into table(with scheduling.) and connecting to looker studio ?

hey, when i hit the image link (not opening in a new tab) the page still refreshes. Anyway to fix this and make it transition smoothly between pages like you have in the video?

how do I stop sending events like scroll and select_item and user_engagement with this setup? I don't need those sent to pixel but they're all coming in under the Setup Method of Manual Setup now. Thanks!

Hi JJ, thank you so much for the heads up! LookerStudioVIP articles helped me a lot over these years, thanks a lot for the great work! looking forward to join the lab in the next months ;)