How to embed a report with parameters/filters in Looker Studio?
You’re not managing to embed a filtered report from Looker Studio on your website? No worries, we’ve got a solution for you :)
So, your report is well polished, filters are set-up. Everything is ready for you to publish your filtered report on an external website. But still, report can’t be displayed, or worst, it can be displayed but then all data are shown, whilst you only want to show a filtered view. In this article, we’ll show you how to embed a report with parameters/filters in Looker Studio.
Top Looker Studio connectors we love and use on a daily basis (all with free trials): PMA - Windsor - Supermetrics - Catchr - Funnel - Dataslayer. Reviews here and there.
Not sure which one to pick? Have a question? Need a pro to get a project done? Contact us on LinkedIn or by e-mail, and we’ll clear up any doubt you might have.
Enable embed & Share Unlisted
Sounds obvious, but just in case, make sure you’ve enable the Embed functionnality in your report. Go to File -> Embed report, and then Enable embedding. Decide if whether or not you’ll want to show report navigation in embedded mode, ajust the width and height of your iframe, and copy the code that is under Embed Code:
But this is not enough. To be sure that the report gets visible on everyone’s screen (even people that were not granted access, idea here is behind able to share your report to the world), make sure it’s Unlisted. Click Share top right of your screen, and then select Unlisted (everyone will be able to see the report, but it won’t be referenced on Search Engine like Google. If you’d want to do so, please select Public). And make sure permissions are set to Viewer and not Editor.
Last but not least, make sure that, if you’re working with Publishing, you’ve published the version you want to share on your site.
Enable viewer filters in report link
Now, back to File -> Report settings, and tick the Custom bookmark links: Enable viewer filters in report link. It’ll allow you to see the parameters directly in the url of the page:
Now, anytime you make a selection in a filter, your url gets updated. This is where the magic happen: copy the whole URL into a text editor, and not only the params string (if you did so, the formatting wouldn’t be the one expected by your browser, as you can see here: I’ve copied first the full url, and second only the params string part, not the same result. Most of the time, this is where people are making the mistake that leads to failure):
Embed your code adding the parameters to the url
We’re almost there! Go to your website, copy/paste the embed code, and at the end of the src url, add the ?params=xxx string copied from the full url.
And that’s it! Now when you embed your report on your website, the first view will be the filtered one (but beware, depending on your report, and whether or not selectors are available, savvy viewers could still be able to change filters and access more data, do not use this feature for sensitive data).
PROBLEM SOLVED !
Top Looker Studio connectors we love and use on a daily basis (all with free trials): PMA - Windsor - Supermetrics - Catchr - Funnel - Dataslayer. Reviews here and there.
Not sure which one to pick? Have a question? Need a pro to get a project done? Contact us on LinkedIn or by e-mail, and we’ll clear up any doubt you might have.
Communicate and browse privately. Check Proton Mail and Proton VPN
Website hosted by Tropical Server