Use URL Parameters To Build Hundreds of Unique Reports In Minutes using Google Data Studio
Вставка
- Опубліковано 22 лип 2024
- Learn how to use Google Data Studio's URL parameters to generate unique reports. This video uses the example of country-specific reports.
Feedback 👉 datastudio.vip/feedback
👇 Grab The Dashboard Cheat Sheet 👇
datastudio.vip/youtube
👇Explain It Data Studio Visualization👇
datastudio.vip/youtube
Learn About What I Am Trying to do
👉 datastudio.vip/learn
Timestamps:
0:00 - Intro
0:50 - DataStudio.Vip Feedback Request
1:43 - How to use URL Parameters
4:22 - Using URL Parameters for Custom Links
7:00 - Dynamic URL Parameters
12:48 - Recap
17:26 - Wrap-Up
Apply To Work With Us. (Done for you)
mediauthentic.com/youtube
Learn On Your Own!
datastudio.vip/learn
This is exactly what I am looking for!!
Thank you so much, JJ! There are many documentation for this but I couldn't find where to start. Glad I've found your video.
So glad that you found us!
Best of luck on your Looker Studio Journey!
- JJ
Fantastic, this can be used to track every blog post performance metric (change country in this video to blog post url for monitoring)
Excellent and easy to understand/implement, Thanks!
Thanks for the comment Cristobal!
- JJ
Thank you!!! I need something similar!!!
I loved this video !!!
Incredible. Thanks so much. Super helpful.
So glad we can help!! -JJ
THIS WAS AMAZING! YOU ARE MY HERO! THANK YOU! Using your instruction, I was able to string together multiple data source IDs and create a very long, but incredibly helpful url! I am still stuck on one other issue, if you have a solution: I have a bar graph that tracks a stat from a game each day, the problem is that sometimes there is more than one game on one day and it adds the stats. I need to keep the stats separate and each game needs to be shown on the x axis as a separate event. Any ideas on how to do this?
Hey Dana! So glad you were able to get some things working!
What you can do is add the game name as a breakdown on the x Axis of your bar chart!
So you will have dimension of date & breakdown of “game name” or secondary dimension of “game name “
With downloads as the metrics 🤞
Hope that works for you!
-JJ
thank you for the detailed instructions. Do you know if there is away to send the date range from to in the URL parameter?
Nope :( not possible
Hopefully they update it on the future.
There are work around but nothing that defaultly does it
Hi this is really helpful, can i use this with embedded options? so customers see only their graphs in our site?
If you can append the report they are supposed to see to the source of the you should be good to go!
Good job
Thank You!
Great! I had much use of this. Is there anyone that has a similiar solution for scheduled emails? It would be great to use that feature. I would like to schedule to email the same report to different receivers with different filters active.
Unfortunately it’s not possible to email schedules with filters applied dynamically.
-JJ
Thanks for this, really useful. I have a question, how can it be applied to all pages of the report. Say you have 10+ pages, how can the dynamic link apply to all report pages instead of the page that you have the control on?
Yes you can!
Just right click on the filter and “make report level” TA-DA
Happy report building!
-JJ
Hey JJ - this is fantastic. Very timely for my project. Additional question on this: If I need to segregate the report between different clients is there a way to implement some kind of security on it, where clients cannot just change the URL params to view another client's information? I see this option: 'Allow to be modified in report URL' ...not sure if that would help my case. I basically want to create 1 report template and embed it for different clients who can only see their data (we have PHI). Not sure if it's similar to what Gustavo is saying.Thanks!!
Hmmm what we have done in the past is:
1. Create a case statement with a random string to create a "key" so website(.)com = '1boe13ijg', which only I know.
2. Then use the same method which you will use the string for in the URL instead of the actual value.
3. They will still be able to change the URL, but will not be able to find others since you are using a case statement to look for a random string instead of the actual value.
I hope you followed that lol,
I might make a video in the future on this, but we will see!
@@Vision-Labs I definitely followed! Would the case statement be in the custom report you created for the hyperlink, or just a new field altogether and then create a key/value pair for each client name? I was thinking about something similar as well...create a hash in my database for the client name and pull that through. And curious - you don't think parameters would be helpful here by any chance right? Thanks!
NICE! You are pretty advanced GDS user!!!
What I would do for future flexibility is create a new field: This field is your "Hostname Key" or whatever field you are using to differentiate who should see what.
This will allow you to easily create logic using regex or 'and' in the case statements.
Have the logic be something like
when hostname = 'coolsite' then "123ast"
If you use a parameter it ould be less flixbly, This would allow you to have two lines which return the same 'Key string" so you can adjust in the future.
Then use this Key Value to filter the report.
@@Vision-Labs I will try this and let you know how it works out!
Hey - circling back on this. So unfortunately, I hit a snag with this solution. which is essentially anyone can modify the URL to access the main report and see all the data. Params by themselves are not sufficient :\ I've reached out for help on the forum. Let me know if you think of any other ideas. Thanks!
I have a problem in which I have to show exclusive categories in a embedded platform. Using your video as an example, I need that USA viewers can only view USA info, vice versa. All in one embedded report, do you have any solution similar to what I'm looking for?
Hey! If you are embedding it in a platform, I would suggest that you use that platform to create the URL parameter which loads within the embed.
Might be a little complicated, but theoretically totally possible.
¡Hi!
I have a cuestion, is necesary create an sheet about the links of every country por example?,
Hey!
I am not 100% sure I understand your question :(
In general, try to use the least number of data sources as possible.
- JJ
Hi JJ, is it possible to do the same but get embed urls instead?
Unfortunately not :(
You can not embed any dynamic content.
It's against the terms of GDS :(
Thanks, I need to build a report where On opening Data is filtered by company. I want to pass parameter value embedded in url. Unfortunately I haven't got video or content on this topic
Yay!!! So glad this worked well for you!!!
- JJ
Thank you, very elegant approach.
The user that received the URL to the report can click the reset button, and view everything,
is there a way to control this.
Yes/No
By default, there is not method of doing it. BUT
You can change the control to have a default of 0000 so if someone hits reset it will display no data.
LMK if that makes sense @Ronen
- JJ
@@Vision-Labs Clever :), i will give it a try.
@@Vision-Labs It works like a charm, Thank you.
@@Vision-Labs Adding "0000" on Default field of the Control is the most elegant solution to nullify the Reset button issue... ! Thanks so much!
Hello , in GA 4 under user explore report. App instance I’d is coming. However, it is not coming on data studio. Could you please help me on this ?
Hey Jai! Not all fields are available within Looker Studio. You will either need to turn it into a "Custom Dimension" or use the API unfortunately.
Your information is very helpful.
But I am facing an issue. Can you please help? If they click on Reset from the top bar, it again selects all/ selects none.
I can hide the top bar initially but then again if they hover, it again comes. I tried using the URL on the embed way. But it is refusing to connect. Please Help
The only way you can hide the top bar is to embed it. But even then it might not be fully "Away"
AS for the "Reset" button.
One thing you can do it add a default value that is useless "000000" so when it resets, It simply show "no data"
Best of luck!
- JJ
Hey JJ, thank you for this tutorial. It solved my problem. Do you know where to find discord or slack community to discuss Google Data studio?
There are a couple Facebook communities Which discus things!
I believe Data Studio Experts is a great one with Ahmad Kanani as a moderator (he rocks)
Good luck!
- JJ
@@Vision-Labs Hey JJ, thanks for your reply. I still feel it is a little bit complicated to analyze the URL and obtain the parameters. Is this the only way to pass parameters in the URL and generate unique reports so far?
@@Simon-tv8lq Yes, unfortunately, it's the only way (I know of) to have the same report load differently for different people.
This has been really excellent. I've noticed that if I set a URL to open a Report with multiple pages, only the first page will be filtered consistent with the parameters. Using report level filters overrides the URL parms on open. Am I trying to do something that is not possible?
Make sure you aren't using publishing as that can throw you off & it's saved a previous version.
When the next page opens it will not have those report-level filters working.
What you are doing is totally possible!
- JJ
@@Vision-Labs Well, thanks. That both encouraging and disappointing because I'm out of in-box ideas. I have ensured that any and all report pages have "Enable viewer filters in report link" enabled (though I have tried toggling them), and I have played with manually and automatically publishing updates. Where you refer to "Saved", I assume you mean that the report is in View mode. I'm am not aware of another form of save. Bottom line is that if I have a single report page I get a [ \parameter string], BUT if I have more than one report then all report pages URLs get some short [/
Good news! The issue is solved. Effectively once you add the report page, you need to expose the control in the viewable area, go to View mode, select the filer value on each page. When you do that the first page URL will present the parms for all pages. That URL may be used as contemplated in this video. Then you can go back into the report and move the control out of the viewable area.
@@veronicacastellanos-vasque7767 Glad to hear it worked out for you!!!
- JJ
Hey JJ a very urgent question like i want to open this urls in the same tab not in new tab how can i do it?
Only if you are using the hyperlink feature within the set up tab can you have something open in the same window.
Any link that used they hyperlink() function will open in a new tab.
@@Vision-Labs Can you clarify what is the difference between the hyperlink feature and the hyperlink() function? I thought both were used via creating a new Dimension/Metric field.
@@emilyhowe3751 Hey!
The hyperlink function allows you to pull from data sets. Where the feature just allows you to hard code a url or put pages of the report