Fantastic, this can be used to track every blog post performance metric (change country in this video to blog post url for monitoring)
@user-rr9fk3ts1j
Жыл бұрын
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.
@Vision-Labs
Жыл бұрын
So glad that you found us! Best of luck on your Looker Studio Journey! - JJ
@cristobalmontenegro7635
Жыл бұрын
Excellent and easy to understand/implement, Thanks!
@Vision-Labs
Жыл бұрын
Thanks for the comment Cristobal! - JJ
@paulabellido218
Жыл бұрын
I loved this video !!!
@user-ug4gi5we4g
Жыл бұрын
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?
@Vision-Labs
Жыл бұрын
Yes you can! Just right click on the filter and “make report level” TA-DA Happy report building! -JJ
@julianroman1662
Жыл бұрын
Thank you!!! I need something similar!!!
@JimmySmith1
Жыл бұрын
Incredible. Thanks so much. Super helpful.
@Vision-Labs
Жыл бұрын
So glad we can help!! -JJ
@gustavopichioni8172
2 жыл бұрын
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?
@Vision-Labs
2 жыл бұрын
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.
@ronenkorenful
Жыл бұрын
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.
@Vision-Labs
Жыл бұрын
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
@ronenkorenful
Жыл бұрын
@@Vision-Labs Clever :), i will give it a try.
@ronenkorenful
Жыл бұрын
@@Vision-Labs It works like a charm, Thank you.
@渡辺一夫-p7t
Жыл бұрын
@@Vision-Labs Adding "0000" on Default field of the Control is the most elegant solution to nullify the Reset button issue... ! Thanks so much!
@theneeldas
Жыл бұрын
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
@Vision-Labs
Жыл бұрын
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
@claschristensson340
Жыл бұрын
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.
@Vision-Labs
Жыл бұрын
Unfortunately it’s not possible to email schedules with filters applied dynamically. -JJ
@TheDanaZimmer
Жыл бұрын
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?
@Vision-Labs
Жыл бұрын
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
@wwannous
Жыл бұрын
thank you for the detailed instructions. Do you know if there is away to send the date range from to in the URL parameter?
@Vision-Labs
Жыл бұрын
Nope :( not possible Hopefully they update it on the future. There are work around but nothing that defaultly does it
@alvinjoseph5822
Жыл бұрын
Hi JJ, is it possible to do the same but get embed urls instead?
@Vision-Labs
Жыл бұрын
Unfortunately not :( You can not embed any dynamic content. It's against the terms of GDS :(
@namanster
2 жыл бұрын
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!!
@Vision-Labs
2 жыл бұрын
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!
@namanster
2 жыл бұрын
@@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!
@Vision-Labs
2 жыл бұрын
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.
@namanster
2 жыл бұрын
@@Vision-Labs I will try this and let you know how it works out!
@namanster
2 жыл бұрын
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!
@dlopez2198
Жыл бұрын
¡Hi! I have a cuestion, is necesary create an sheet about the links of every country por example?,
@Vision-Labs
Жыл бұрын
Hey! I am not 100% sure I understand your question :( In general, try to use the least number of data sources as possible. - JJ
@jacky14653
Жыл бұрын
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 ?
@Vision-Labs
Жыл бұрын
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.
@instantlearning3003
Жыл бұрын
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?
@Vision-Labs
Жыл бұрын
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.
@emilyhowe3751
Жыл бұрын
@@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.
@Vision-Labs
Жыл бұрын
@@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
@tijomonmathew
Жыл бұрын
Hi this is really helpful, can i use this with embedded options? so customers see only their graphs in our site?
@Vision-Labs
Жыл бұрын
If you can append the report they are supposed to see to the source of the you should be good to go!
@mobeensiddiqi8641
Жыл бұрын
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
@Vision-Labs
Жыл бұрын
Yay!!! So glad this worked well for you!!! - JJ
@veronicacastellanos-vasque7767
Жыл бұрын
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?
@Vision-Labs
Жыл бұрын
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
@veronicacastellanos-vasque7767
Жыл бұрын
@@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 [/
@veronicacastellanos-vasque7767
Жыл бұрын
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.
@Vision-Labs
Жыл бұрын
@@veronicacastellanos-vasque7767 Glad to hear it worked out for you!!! - JJ
@kassiowifried
2 жыл бұрын
Good job
@Vision-Labs
2 жыл бұрын
Thank You!
@Simon-tv8lq
2 жыл бұрын
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?
@Vision-Labs
2 жыл бұрын
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
@Simon-tv8lq
2 жыл бұрын
@@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?
@Vision-Labs
2 жыл бұрын
@@Simon-tv8lq Yes, unfortunately, it's the only way (I know of) to have the same report load differently for different people.
Пікірлер: 59