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 ;)

Hey, I just want to say thank you! I learned a lot, my favorite video was when you taught we don't need blended datasets in some cases when you can use a custom field with the same id name. I grew a lot as an professional data analyst and you're part of this. (yes, I watched until the end haha)

HI @visionlabs Is it possible to show just 1 image? Or do i need to use a filter for that?

amazing, I have been trying to figure this out for awhile

Would unnesting all the column make it more expensive and would it have any chance of losing data if unnested please?

I have made buttons for filtering, but facing difficulty while making custom bookmarks for button filters. If you have done it before, please let me know how to do it.

Nice video!!! do you have a tutorial doing the events, for example the "aware lead"?

not a word about traffic acquisition in BQ which doesnt match GA4 if no adjustments to BQ tables made

I can see the UTM params tracking in GA4 but not real time data for today, just for the day before, is it delayed revenue? Is there a way to view today real time data for UTM tracking params? Thanks!

Great video guys, thanks for sharing

God Tier Tutorial man, you save my work. I am a student in practice from Chile, at work they ask me to make an indicator report. With your tutorial you fixed a problem where the program repeated the data from the actual months vs. the budget months. Thank you so much. One question, in the line graph, I want to make a historical comparison of the actual data vs the budget. The budget is displayed correctly month by month, but the actual data is added (example: January + February) over all months in the chart. You know how to fix that or the problem that causes it. Greetings!!

Hello, do you thing this could be used for filtering a blended source?

Hello, example in 1 page there is 6 diagrams and 1 controls, but i want that 1 control only for 2 diagrams, how can i manage it?

Thanks so much, useful as always

This was helpful! I didn't know about the grouping - I thought that was for visuals only! And cool tricks on the multiple filters with the geographic regions. What I am trying to figure out is how do you do dimensional controls on time series charts with 1 metric? I am basically trying to recreate the GA4 tech details report in Looker so other coworkers can view without needing GA4 access or training. But it seems like I keep breaking dimension scope with this?