Ok, so you just finished your data studio masterpiece and its time to share! How you share depends on who you want to share it with and how much access you want to give them.
One of the reasons Data Studio was developed was to increase the ways Google Analytics visualizations could be shared. While analytics had some decent dashboarding options within the application, it was difficult to share these beyond registered users.
Data Studio goes way beyond mere Google Analytics reporting, but sharing options are still a major reason for the adoption of the tool.
Check out the questions below to find the case you need. These answers start with giving the viewer the least amount of access and work to sharing with trusted collaborators.
How do I share a Data Studio Report through a public web page?
Answer: Use the Embed feature of Data Studio: FIle/Report/Embed menu option pops a dialog box with embedding options and code. Copy the embedding code into a web page and anyone who views the web page can then view the report that is embedded in the page. Here’s an example of an embedded data studio – this shows the top 5 web pages on the Helpfullee.com website, pulled from analytics – You can filter it by source.
Note that any embedded resource can be embedded on any number of pages. This means that other people can use your embedded resource on their own sites. Depending on your intent, you may want to use a background watermark of some kind. You can also include Google Analytics setup in your report so you can track the pages that users are viewing from.
Here are the steps to embed a Data Studio Report.
- Switch to Edit Mode.
- Select File/Embed Report.
- Click “Enable Embedding” checkbox.
- Select “Embed Code” or “Embed URL
- Optional – change the height and width parameters.
- Click Copy to Clipboard.
Here’s a video showing the whole process of embedding the widget into this page as you can see above.
For more tips on embedding see these resources:
Responsive `Google Data Studio` Inline Frame Embed Code – Short post on making your embeds resize nicely.
Data Studio Connectors from a Galaxy Far, Far Away – ClickInsight – A lot of little embedding examples
How can I share my Data Studio on Social Media?
Answer: You can share your report on social media platforms the same way you would any other web page. As of July 12, 2018, Data Studio supports the Open Graph Protocol tags that allow a better sharing experience including an automatic thumbnail and description of the report. It can now also be shared as an embed on sites like Medium.
ProTip – By default, the report will have the standard Data Studio description -“Google Data Studio (beta) turns your data ….” as seen in the Twitter preview below. This is what will show up if you share your link on Twitter, Facebook etc. But you can change this and you should!
How to change a Google Data Studio description for social media sharing
- Locate the Data Studio report on Google Drive. Through Drive, you have access to all editable Data Studio reports but as of this date, they DO NOT show up in search! You can find them by scrolling down your root “My Drive” contents.
- Click on the file and a file description panel will open on the right side of the screen. Scroll down a bit and you will see the default description. Click the edit button to set your description in the field and click anywhere outside of the box to save.
How do I share a Data Studio Report with the public so they can’t edit or copy it?
Answer: Use the Advanced Sharing options to keep users from copying and reusing your report:
- Select File/Share menu and it will pop the sharing dialog box. If you do not see the full sharing options click the “Advanced” link at the bottom of the box.
- In the “Who has access” section click the “Change” link.
- Select “On – Public on Web” or “On – Anyone with the link”.
- In the
ownersettings select the checkbox for “Disable editors and viewers from print, copy etc.”
- Click the Save button then Done button to complete setup.
Note: This also disables the ability to do CSV, Sheets or Excel export of graph data.
You can share the report by getting a share link – click on the share icon and copy the URL.
How can I share a Data Studio Report so public viewers can use it as a template for their own data sources and NOT able to edit my original report?
Answer: This is the default setting for Data Studio Reports. When you share a report the viewer will be able to copy the report and replace your data sources with their own.
Steps to share a Data Studio report so viewers can use as a template
- Select the share icon. The sharing dialog box appears.
- Click on “Get Shareable Link” top right.
- Use this link to share with users. They will be able to copy the report and use it as a template.
- Double check the sharing settings by clicking “Advanced” bottom right.
- Make sure the checkbox labeled “Disable options to download, print, and copy for commenters and viewers” is unchecked.
- Click “Save” if
Things to remember about basic data studio sharing
- When people copy your report your original is secure.
- Copiers will be prompted to use their own data sources. If they do not have similar data sources the visualizations will break.
- If you have created new dimensions or metrics in your data source, these are not copied with the report. If you have used these in your visualizations the copied report will break unless the new user creates those same dimensions and metrics in their data sources. A good practice is to include instructions for setting up the customer dimensions.
- If your report uses filters that are unique to your data source, like custom segments from Google Analytics, it may break the visualizations in the copy if the user does not have these also.
- ALWAYS TEST – Get someone else to copy your report and make sure it behaves as you expect. If you have to do this yourself, make sure you use a separate Google account from the one you created with.
Heads UP! This option to copy a report only shows to the viewer if they are currently logged in to a Google account. If they are not logged in they will not see the copy option!
This is the case in Chrome’s Incognito mode, and it is easy to get fooled into thinking the report is not available for copying if you are using this mode for testing.
When you first open an Incognito window you are an anonymous user. If you go to Google and log in with an account you will see the copy and share options, which are the default.
If you don’t want users to be able to copy your report, it is important to change those settings and test it with a logged in user just to be sure.
Again, you can share the report by clicking on the Share icon and copying the URL.
How can I share a Data Studio report with viewers so they can use their own data sources immediately without having to copy the report?
Answer: You can do this for a limited number of Data Sources through the dynamic data control selector. These selectors currently only allow the user to select their own sources for these products:
- Google Ads
- Attribution 360 (TV Attribution)
- Google Ad Manager
- Campaign Manager
- Google Analytics
- Search Console
Note that the viewer is limited to selecting data sources they actually have access to while looking at the report. A user that is not logged in will not even be able to see the data selector. Dynamic selectors will also not appear in embedded reports.
Your Awesome Site Stats
You can use this report right away with your own analytics accounts – Enjoy!
How can I share my Data Studio Report so viewers can only see graphs based on data sources they are allowed to access?
Answer: Change the “view with owner credentials” setting in the data source setup. This will allow you to share the report, but only people with access to the underlying data sources will be able to see the visualizations.
If you are using Google Sheets as a data source, using this setting will be based on the Google Drive sharing settings for that Sheet. If your viewer has view access to the Sheet on Drive from their account they will be able to see the visualizations.
Example: You have a have a web report based on Google Analytics, but only want users who actually have access to that Analytics account to be able to view the report.
- Edit the report. Select a Data Source and click the edit icon.
- Select the text “Using Owners Credentials”. This will pop a dialog box.
- Select “Viewers Credentials” then “Save” and “Done” to exit out of the Data Source editing mode.
Here is a snapshot of what it will look like for authorized and unauthorized users. Note: If you set to “Viewers Credentials” a user will be forced to log into Google to view the report whether they are authorized or not!
How can I share a Data Studio report with specific people so they can edit, but not have access to the data source?
Answer: This is pretty much the default setting when you share editing rights with an individual user. They will have the ability to use any existing fields available in the data source to modify the report, but they cannot modify the data source by adding new calculated dimensions or metrics, and they cannot modify any existing ones. If you want an editor to be able to add new fields, you will have to also share the data source – see the next section for more.
- Select the sharing icon next to the edit/view button.
- Input the email of a new editor. Note: Only emails with Google accounts will work here.
- Write a note if you wish. This will be sent to the editor in an edit notification email. Click Done.
The neweditor will get a notification that you are sharing edit rights with a link to the report.
How can I share a Data Studio report with an editor so they can add or modify custom fields?
When you share editing rights with other users they cannot add new fields or modify existing fields that you have created. They cannot even view the field settings or formulas used in these fields.
In order for editors to add or modify fields, you must also share the data sources used in the report.
First, make sure you are sharing editing rights to the report. Then modify the sharing settings for the data sources following the steps below….
- Starting at the main data studio page, select “Data Sources” (upper left side
) .You will see a list of all your data sources.
- Select the
three dotmenu on the right side of the data source listing. Select “Share” option. A sharing dialog box will appear similar to the ones used for setting report sharing options.
- Click “Advanced” on the bottom right. You will now see more sharing options.
- We suggest you click the “Prevent editors from changing access and adding new people” unless you really want other people to be able to add more editors to the connector! Click “Save”.
- Input the name of the editor you wish to be able to add or change fields in your data source. Add a message to send to your collaborator. They will be notified via
gmail. Click Done.
How Can I Transfer Ownership of a Data Studio Report based on Google Sheets?
Answer: The new owner must have a Google account. The new owner must copy the report, have full share access to the connector, and ownership rights to the Google Sheet.
So , this question came up recently: A freelancer developed a Data Studio report for a client. She would like to transfer all ownership to the client so she can wrap up the job. How is this done?
First, keep in mind that the Google Sheet you are using is kind of like a database: If you are the developer and are accessing it with your credentials the client needs similar access. If you want to turn this over to the new owner, they need full control of the sheet, rather like giving them a copy of a database.
In the video below I walk through the steps to transfer control from one of my Google accounts to another.
So, can you think of other sharing scenarios or use cases? I would love to hear from you – please share this or give me a shout out on Twitter @Helpfullee
Thank you for this post Lee. Very helpful information.
Thank you for the post.
I am interested in knowing whether Data Studio can be used to authenticate non-google users and based on the user credentials, can allow them to view specific graphs?
For e.g. email@example.com and firstname.lastname@example.org login -> company 1 and company 2 use the same data source. But data is being tagged with their respective company names. Can there be parameters passed during user login based on the company name as to instruct data studio to show the relevant company data for the relevant user?
HI Barani – Sorry for the delay posting a response here. I wanted to think about your question some before answering. So far, I haven’t seen any way to restrict data outside of Google’s identity systems. The Google system is pretty extensive, but outside of that I can only see making separate versions for individual users which is ok, but does not scale well. You could embed a report inside a page and protect that page , but that only gets you security , not personalization.
Just an update here – I was collaborating with some other people on this concept. There is a way to hack this , although the stats may flash for a brief instant for all when the page is loading. I cant give you the whole answer here as it is a little complicated, though I may write a post on it. Basically you need a select filter for the company name . Test that out , and if it works for your charts then you need the bookmarking turned on for the report. Select a company , and get the URL – you will see the company name in that selection. Then you can shrink or cover the selector with a graphics block. This keeps users from selecting a different user. Giving that URL to a user then restricts them to the selection.
Hi – thanks for this post!
Is there a way to define multiple owners for a report or a data source?
We are working as a team and need all team members to have maximum permissions and access to all functionality.
Any help is appreciated – thanks!!
Sorry I missed this question! I will have to look into that a bit more. For truly full access you need full access to the data set, and the connector, and the report. My guess is you cannot have full ownership between users of all these components, but you should have enough access rights to do what you want.
Thank you for the very informative post! Is it possible to have the following sharing options: “Anyone with link can access (no sign-in required)”, “Can View” and have the user (person shared with) be able to download PDF or Export to sheets? I tested with the shareable link in an Incognito browser and didn’t get the option to download or share. The only option on the hamburger menu next to my table, was Sort. I tested with “Can Edit” (same settings as above) in Incognito mode and didn’t even get the Edit button. It seems like the download / export should be the default and preventing the user from doing this, is done by selecting the “Disable options to download, print and copy for commenters and viewers” checkbox. But it doesn’t seem to work this way. Any help would be appreciated.
Hi Tessa – I just double checked this . The user gets the export as CSV and PDF download options only if they are logged in to their google account. That’s why it doesnt show in the incognito browner. If you log in as any users and then view you will see the options. If a user is not logged in the other options do not show either. This is also true for the data source selector – the filter won’t even show if the user is not logged in to a google account. It may be a good idea to put a link on the report if that is your goal reminded them the option is only available to logged in users.
It seems that one can only embed a single page of a report. I have a report with 5 pages. How do I embed a report and have the navigation in place to see the other pages?
Hi William, I haven’t seen this issue , but the page nav is hidden at the bottom of the embed, even if you use side page navigation in the report. One way to get around this is create links on the page that link to the other pages. I believe this takes care of the problem. In other words , you may want to make a simple link navigation (if you make it report level it will be on every page) that goes to the page directly. Does that make sense?
Thanks for the question!
How can I share a report on a website?
See the section for embedding in this post, or do a google search for “Embed Data Studio” or you and find more articles on embedding in the Google Data Studio Resource finder – Several articles there related to embedding. Here is the link https://datastudio.google.com/s/q2wSWrg6wMo
Thanks for this, but how do I share the report with download option, I wanted to share my report to another department, I choose the anyone with the link can view, however they don’t have download rights, the checkbox for preventing download links under the advance option is unchecked too.
Hi Lee Hurst.
Suddenly I can’t share any of my reports OUTSIDE my organization.
Can you please help me. Is it Google policy or what?
Late response, Sorry. You probably have this figured out by now , but yes this is controlled by internal company policy. You should be able to share with other user outside the organization if you specify their email and if they have a Google account for that email. Your organization could also limit any sharing outside of the organization as well. You cannot share with the world or simply get a share link to send unfortunately. This does not apply to external accounts however.
thanks for this comprehensive overview, but I am missing my use case here, I want to share my dashboards only inside my company’s confluence system (closed system to external users).
We use the HTML inlcude for this to embed the reports, but we are still seeing an error. Changing the sharing opportunities to everyboy did not change the situation?!
Best regards Thorsten
Hi Thorsten, I’ll send you an email and maybe I can get some more details. I’ve used confluence, but I haven’t tried embedding in the system. Im not sure the html include will work here, but there might be a trick to it.
HI Thorsten – I haven’t used confluence in some time – I dont recall being able to do an embed of other sites. You could try embedding the PDF version – not the same , but still useful.
I have 6 Pages in my studio dashboard and I want to give the view access only for one page out of six. Is it possible and if yes then how?
Thank you in advance.
Hi Neelabh, I dont know of any easy way to do this, except you can set the other pages to “Hide in View Mode”. You do this from the pages menu. This solves the immediate problem of setting only 1 page to visible. There is a problem with this solution though: Even the editor cannot see the page in view mode with this setting! That means you will only be able to see the page in edit mode with whatever the default settings are, and you will not be able to use filters or change date ranges etc.
Usually, in a case like this I simply copy the report and delete the pages I dont want to show. I use the other mode mostly for quick drafts and notes about the dashboard.
Hope that helps!
Thank you for this information. I know there is a way to Filter by email address, but is there a way to place multiple emails in that “email field”, so that those certain people can only see that row of information.
how to share my report where others can make changes and edit at their end with all functionalities but the main report remains intact
I cannot think of a way to share , allow changes , and not have the orginal report be changed. You can roll back versions of the report, but then the shared report would lose the changes made by others. The usual solution here is to require people who are customizing the report to make a copy and then modify so the original is not changed. In this way you can use the original as a template. I hope that helps!
I’ve accomplished the filtered URL views so I can share filtered reports with my clients. But it doesn’t seem that giving users that URL hides all the other data — they can still remove the filter ID parameter from the URL to see the whole report. Am I doing something wrong?
The trick here is you need to set the on page filter to a default that does not exist. This will be the default if a user loads the page without filter settings, and will show nothing to the user. Once you have this set up , simply slide the filter selector off page in edit mode and the user will not have access to it when viewing. Hope that answers the question!
Thanks for this post, really helped me getting started with Data Studio. I still have a question though.
At our company, we created some Data Studio dashboards for a client. They provided us with access to their Google Analytics, so we could set up the dashboards for them. The dashboards include custom dimensions and filters we created ourselves. However, when we wanted to handover the ownership of the dashboards to the client, they couldn’t see the data coming through the custom dimensions/filters we created. Even when both accounts had access to the same data sources in Analytics.
Are those custom dimensions linked to the account that created them? How can we give ownership of a dashboard to the client, while they’re still able to see the data in our custom dimensions/filters? Any advice?
HI Joris – Had some issues responding to this post so I sent you an email. Hope it helps!
First of all thanks for your post. I’ve two queries:
1) Is it possible that all the users will receive only .pdf file in their mailbox rather than this whole google studio screen and report preview? As I want my users to receive a generalized message and a .pdf attachment only.
2) How can I change the name of .pdf file as right now what we are getting in attachment is something like “Report_17wWlTxgYTFXkRUiXbGW4mDck3T_z6mxj.pdf”.
I have a question. I have a template ready but unfortunately not able to embed that. I am able to embed a report and make a report into a template separately. So is it possible to embed a template so that users can add their own data.