Very helpful content. Could you please create a video for a non e-commerce website. You had mentioned that websites might use lead forms/blogs/articles. It would be really helpful to know what metrics might be relevant for such websites
Hi, I'm trying to build the report. At timestamp 10:20, you bring in a field 'USER CONVERSION RATE.' This field does not show up in my Looker Studio. Do you know how to fix this?
If it hasn't been defined in your reporting, you can create a calculated field. If you click on the metric box, at the bottom there is an option for "add calculated field". You can just create your formula there (e.g., transactions/users).
Hi, thank you for this video. I have a question. Will this dashboard update in real time by itself? So in a weeks time, will one then see the current relevant data?
It will pull in all historical data as soon as you create it (if that data exists in your data source, such as GA4). You can control the date range of the report and the individual charts, so it updates based on the range that you provide. Keep in mind, however, that GA4 is typically 24 hours behind in its reporting.
Hi, I would like to set revenue conversion tracking in Google Analytics to my e-commerce website. I am unable to setup it. Could you please share some inputs Thanks for this video!
How conversion tracking gets set up is really based on the platform that you're using. For instance, if you have a Shopify site, you can use the Google & UA-cam app to send shopping cart and purchase data to GA4. For other platforms, you'll need to implement a data layer that sends that information to GTM and GA4 via javascript. Let me know what platform you're using, and we can look at doing a video for that.
It depends on how you're pulling that data into Looker Studio. If you're using the data connector for GSC, then it should be the same if you're looking at the same dates. However, if you're pulling the data from GA4, there is often latency in the reporting by at least 24 hours. Some other factors that could impact this are: date ranges, filters or segmentation.
Good evening, I have a question for our honorable professor. Is it possible, through Looker Studio, that I can enter data into a table as is the case in an Excel sheet? I have another question: Can I hide the Google Sheet file menus and toolbar from the user when entering data and he cannot show the menus such as the File, Edit, or Format menu? Thank you and we apologize for the length
You can connect your Looker Studio dashboard directly to a Google Sheet, so that when someone adds data it is reflected in your dashboard, The only input option directly in a dashboard is an input box, which essentially acts as a search box. I imagine that you could accomplish this data entry by using a Google Form, which would feed the data points directly to your Sheet without giving the user access to the spreadsheet.
When I apply the filter always they show missing data when i reopen the report ? What is the solution for this? I am unable to share the report with the customers because of this problem
It's difficult to say without seeing your report, but you may need to ensure that there's not another report-wide or dashboard controller or setting that is overriding your filter.
thank you for this great video. One question. We have GA4 since July 2023, and universal analytics before that. And I believe this is what most people setup currently is. I wanna look at the year over year changes for all the metrics you showed. I do have both GA4 and universal analytics loaded on Looker Studio. How can I do this?
Great question. One thing to consider before doing this is that the metrics will not be exactly the same in Universal as they are in GA4, since GA4 fundamentally redefined how things like sessions, users, conversions, etc., are recorded (ua-cam.com/video/zDyzPFCvwEQ/v-deo.html). You can pull in your historic data from UA, and then create two different data sources and cards/graphs in Looker. You could then blend that data to create a unified report. We'll look at doing a video to walk through this, since I'm sure other people are having this issue as well.
Great idea. We're actually working with a company that creates sites for blogs and publishing companies, so we can show what we've been building for them.
Hi. Can you explain how to create a chart that shows your impressions in various cities? Currently I have a chart that breaks down views, bounce rate, and engagement rate of various cities in California. However, when I try to add "organic Google search impressions" as a metric the chart breaks. Do I have to blend data? And if so, can you explain how to do that?
Impressions data, which comes from Google Search Console only reports on metrics by country. Theoretically, you'll need to blend User geo location from GA4 with impression data from GSC. I haven't tried this myself, so it may not work. We'll look at doing a video about this since I'm sure it would be useful for other folks as well.
I would greatly look forward to that video because I've been banging my head against the wall on this (still new to Looker Studio) Thanks!@@apothecamarketing
It is frustrating, because some metrics that are available in GA4, are not available in Looker. We'll take a look and see if we can figure this out for a video.
I can't figure out how to create a field (not a row) in which the total amount will be calculated across the entire field and output to the gand total field
You'll need to use calculated metrics. Here's a quick link to Google's instructions. We'll also do a video on this since it's a question we get a lot. support.google.com/looker-studio/answer/9372465?hl=en
We like to look at engagement rate because the default Users metric in your GA4 traffic reporting is actually Engaged Users, not Total Users. Initially bounce rate wasn't available in GA4, but they brought it back, probably after a lot of complaints.
Well i don't even know if it is possible, but i've created a tag on GTM which now appears on GA4 but i'd like to show this event performances on Looker Studio but i don't know how to link them so i could put in my looker studio dashboard @@apothecamarketing
For the new event to be available in your reporting you'll need to add it as a custom dimension in GA4. In the new admin setup go to Admin > Data display > Custom definitions > Custom dimensions tab and click "create customer dimension".
I'm not sure what you mean by "month wise". But if you'd like to compare your results to a previous month, you can just select the "compare" dropdown in the chart settings on the right side. If you mean something different, just let me know and I'll try to clarify.
@@apothecamarketingStep by step instruction to build the following SEO REPORT IN Google looker studio from the search console dataset CATEGORIZED Average position (LIKE BELOW AND COUNTS by each month
That could be a lengthy conversation! There are many companies that can use assistance with setting up useful dashboards and reporting. One thing we've seen other companies doing is creating dashboard templates, which they then sell. So that's one possibility for you.
I like your video, but definitely you need to put a headshot and focus on the guide, it is not relevant to only see you talking about the GA4 platform etc, without being able to follow. Thanks!
Unfortunately the comparison is for the entire chart/table, so it will apply to all columns. You can create a table or card that just shows clicks, but otherwise the comparison applies to all the data.
@@apothecamarketing Maybe you can help me out? I am trying to do a calculation between two fields sessions and filtered organic sessions to show what percentage SEO traffic takes. And I cannot find a way to do it with filter applied (with the one you showed). Any ideas?
Your videos are so helpful.
Thanks a lot, you helped me a lot!!
Glad to hear that!
One of the most useful tutorial videos I've seen... thank you!
Glad it was helpful!
Nice tutorial. I am researching reporting tools and this was exactly what I was needing. Subscribed!
Great to hear! I'm glad it was helpful. Let us know if there are other topics or tools that you would like to learn more about.
Very helpful content. Could you please create a video for a non e-commerce website. You had mentioned that websites might use lead forms/blogs/articles. It would be really helpful to know what metrics might be relevant for such websites
Sure! Great idea.
Amazing! It's really a great stuff! Thanks a lot!
Glad it was helpful!
Hi, I'm trying to build the report. At timestamp 10:20, you bring in a field 'USER CONVERSION RATE.' This field does not show up in my Looker Studio. Do you know how to fix this?
If it hasn't been defined in your reporting, you can create a calculated field. If you click on the metric box, at the bottom there is an option for "add calculated field". You can just create your formula there (e.g., transactions/users).
love your video bro it is so useful we need more like this
Quick Note : Love your Smile
Keep the good work bro
Thank you so much 😀
really awesome. it helps me alot
Glad to hear that!
Thanks again.
my subscription count to 999 Nice Video
Nice! Thanks!!
Thank you!
What interesting video, I dont know english but I understand very well. Thank u
Thank you!
Hi, thank you for this video. I have a question. Will this dashboard update in real time by itself? So in a weeks time, will one then see the current relevant data?
It will pull in all historical data as soon as you create it (if that data exists in your data source, such as GA4). You can control the date range of the report and the individual charts, so it updates based on the range that you provide. Keep in mind, however, that GA4 is typically 24 hours behind in its reporting.
thanks for the initial laughter!
Poco pelo pero mucha sabiduría. Una joya perdida en UA-cam.
LOL. Thanks!
Hi, I would like to set revenue conversion tracking in Google Analytics to my e-commerce website. I am unable to setup it. Could you please share some inputs Thanks for this video!
How conversion tracking gets set up is really based on the platform that you're using. For instance, if you have a Shopify site, you can use the Google & UA-cam app to send shopping cart and purchase data to GA4. For other platforms, you'll need to implement a data layer that sends that information to GTM and GA4 via javascript. Let me know what platform you're using, and we can look at doing a video for that.
@@apothecamarketing Thanks for response.
It's really a great stuff! Thanks a lot!
Glad it was helpful!
Hello :) Thank you for a helpful content :) Do you know why average position in Looker Studio isn't the same as in Google Search Console?
It depends on how you're pulling that data into Looker Studio. If you're using the data connector for GSC, then it should be the same if you're looking at the same dates. However, if you're pulling the data from GA4, there is often latency in the reporting by at least 24 hours. Some other factors that could impact this are: date ranges, filters or segmentation.
Good evening, I have a question for our honorable professor. Is it possible, through Looker Studio, that I can enter data into a table as is the case in an Excel sheet? I have another question: Can I hide the Google Sheet file menus and toolbar from the user when entering data and he cannot show the menus such as the File, Edit, or Format menu? Thank you and we apologize for the length
You can connect your Looker Studio dashboard directly to a Google Sheet, so that when someone adds data it is reflected in your dashboard, The only input option directly in a dashboard is an input box, which essentially acts as a search box. I imagine that you could accomplish this data entry by using a Google Form, which would feed the data points directly to your Sheet without giving the user access to the spreadsheet.
When I apply the filter always they show missing data when i reopen the report ?
What is the solution for this?
I am unable to share the report with the customers because of this problem
It's difficult to say without seeing your report, but you may need to ensure that there's not another report-wide or dashboard controller or setting that is overriding your filter.
great tutorial!!!
Glad you liked it!
thank you for this great video. One question. We have GA4 since July 2023, and universal analytics before that. And I believe this is what most people setup currently is. I wanna look at the year over year changes for all the metrics you showed. I do have both GA4 and universal analytics loaded on Looker Studio. How can I do this?
Great question. One thing to consider before doing this is that the metrics will not be exactly the same in Universal as they are in GA4, since GA4 fundamentally redefined how things like sessions, users, conversions, etc., are recorded (ua-cam.com/video/zDyzPFCvwEQ/v-deo.html). You can pull in your historic data from UA, and then create two different data sources and cards/graphs in Looker. You could then blend that data to create a unified report. We'll look at doing a video to walk through this, since I'm sure other people are having this issue as well.
@@apothecamarketingwe definitely have this issue. Are you still making a video on this?
We did! ua-cam.com/video/si4j6USTcVc/v-deo.html
So helpful!!!! How about a blog analytics dashboard? We want to track the success of our blog posts in our e-commerce site.
Great idea. We're actually working with a company that creates sites for blogs and publishing companies, so we can show what we've been building for them.
@@apothecamarketing EXCITED FOR THE VIDEO!!
Hi. Can you explain how to create a chart that shows your impressions in various cities? Currently I have a chart that breaks down views, bounce rate, and engagement rate of various cities in California. However, when I try to add "organic Google search impressions" as a metric the chart breaks. Do I have to blend data? And if so, can you explain how to do that?
Impressions data, which comes from Google Search Console only reports on metrics by country. Theoretically, you'll need to blend User geo location from GA4 with impression data from GSC. I haven't tried this myself, so it may not work. We'll look at doing a video about this since I'm sure it would be useful for other folks as well.
I would greatly look forward to that video because I've been banging my head against the wall on this (still new to Looker Studio)
Thanks!@@apothecamarketing
It is frustrating, because some metrics that are available in GA4, are not available in Looker. We'll take a look and see if we can figure this out for a video.
I can't figure out how to create a field (not a row) in which the total amount will be calculated across the entire field and output to the gand total field
You'll need to use calculated metrics. Here's a quick link to Google's instructions. We'll also do a video on this since it's a question we get a lot. support.google.com/looker-studio/answer/9372465?hl=en
I always point out that bounce rate is just the opposite of engagement rate. It’s the opposite side of the same coin.
We like to look at engagement rate because the default Users metric in your GA4 traffic reporting is actually Engaged Users, not Total Users. Initially bounce rate wasn't available in GA4, but they brought it back, probably after a lot of complaints.
Great video, thank you!
Glad you liked it! Let us know what other content you'd like to see.
Well i don't even know if it is possible, but i've created a tag on GTM which now appears on GA4 but i'd like to show this event performances on Looker Studio but i don't know how to link them so i could put in my looker studio dashboard @@apothecamarketing
For the new event to be available in your reporting you'll need to add it as a custom dimension in GA4. In the new admin setup go to Admin > Data display > Custom definitions > Custom dimensions tab and click "create customer dimension".
@@apothecamarketing ok, i'll take a look at it. Thank you for your answer, have a nice day!
Thank you for the video :D
My pleasure! I hope it's useful for you.
0:23 @@apothecamarketing
Can i get a month wise report in keyword page?
I'm not sure what you mean by "month wise". But if you'd like to compare your results to a previous month, you can just select the "compare" dropdown in the chart settings on the right side. If you mean something different, just let me know and I'll try to clarify.
@@apothecamarketingStep by step instruction to build the following SEO REPORT IN Google looker studio from the search console dataset
CATEGORIZED Average position (LIKE BELOW AND COUNTS by each month
Please guide me how to get work by having a skill looker studio?
That could be a lengthy conversation! There are many companies that can use assistance with setting up useful dashboards and reporting. One thing we've seen other companies doing is creating dashboard templates, which they then sell. So that's one possibility for you.
that is very good , thanks
Glad you like it!
Thx for the video
I hope it was helpful!
THIS IS SO FKING USEFUL.
Thanks! I'm glad you find it useful. Let us know what other content you'd like to see.
I like your video, but definitely you need to put a headshot and focus on the guide, it is not relevant to only see you talking about the GA4 platform etc, without being able to follow.
Thanks!
Noted!
best
Thank you!
Hallo me only thas information
وإذا كنت لااملك كمبيوتر فقط هاتف 😮
I think this is one situation where you will need a desktop to effectively work with Looker Studio.
+1 subscriber! Any ideas on how to do a comparison on page 2 only for the clicks in the table, rather than all the columns?
Unfortunately the comparison is for the entire chart/table, so it will apply to all columns. You can create a table or card that just shows clicks, but otherwise the comparison applies to all the data.
@@apothecamarketing Thanks for a quick answer, I am waiting for more looker studio videos!
Let me know what you'd like to see in Looker.
@@apothecamarketing Maybe you can help me out? I am trying to do a calculation between two fields sessions and filtered organic sessions to show what percentage SEO traffic takes. And I cannot find a way to do it with filter applied (with the one you showed). Any ideas?
That's an interesting problem. Let me do some digging and get back to you.