Відео

I watched several videos on this topic and yours was the best by far. I finally made some progress! Thank you!

Legendary video. I have been trying to find somewhere that tells me how to see what page events were triggered on - Can't believe it is this simple. Thank you bro.

Can I create scorecards with the amount of the current year and then use the comparison value feature to compare it with the previous year? I've been trying to create this by using the data in the same table, but it doesn't work. If I create the scorecard, it sums everything from every year, and if I filter the scorecard, then I can't compare it with the previous year as it's excluding that data. What do to there? Or which other widget can I use to visualize the % increase between one year and the other?

Hey love it, you have a 404 on your leadmagnet tho

Very helpful, thank you!

hey guys, i built a tool that will backfill historical ga4 data into bigquery, interested to try it out?

Why tf is so hard to get Looker studio to understand dates correctly?

great content!

This is so over the top for making a boxplot. Is there seriously no other way than to bring my data into big query and writing a custom query?

Just to help… In FB, CTR is calculated as clicks over impressions. Unique CTR is clicks over estimated ad recallers. Also, for any CTR, clicks needs to be the value in the numerator and not the denominator like you are showing and describing. Also, if you are using BigQuery be very careful about pulling in any values based on Reach, of which estimated ad recallers is one of them, because BQ will aggregate the values as a sum instead of identifying the actual reach numbers per line item. Compare these metrics on your looker reports to the values in platform in FB to verify for yourself.

cannot run in free version bigQuery, because there is notification the billing ......

Hi, could you help me? I followed all the steps in the tutorial but when I try to customize the report in GA4, the CWV values ​​come in too large and I don't know what they mean or how to fix it. For example, For a path on my website: LCP: Web Vitals Value Rounded: 79.140.905 Can you help me determine what I'm doing wrong?

Had the pleasure to meet with JJ, and even though we weren't a large business he was extremely helpful. Would for sure consider them if our business expands!

Cool video. I like Looker Studio but have an annoying problem with Google Sheets. Why can't I upload Excel files (which automatically convert to Google Sheets with that option in Settings) to the folder where my Google Sheets reside without any changes to the report? People at Google recommend making changes directly in the Google Sheets, but this is not convenient when a report is based on several of these sheets. I thought it would be so easy to just replace the Google Sheets and reconnect, but no, it is not that simple. Any recommendations?

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?