Note: Google Data Studio is now known as Looker Studio.

If you want to personalize the data shown to a user in a Looker studio report then use the ‘FILTER BY EMAIL’ setting of your data source schema:

Use the ‘FILTER BY EMAIL’ setting if your data source contains an email field that stores the email addresses of your report viewers and you want the viewers of your report to see only that row(s) of data which is associated with the email address they used to sign in to their Google account.

In other words, if you want your report to filter data by current viewer’s email address then use the ‘FILTER BY EMAIL’ setting. 

Note: If the email address of a report viewer is not present in the email field of the data source then he may not be able to see any data in the report. 

My step-by-step blueprint for using Looker Studio (formerly Google Data Studio)

Get the FREE ebook on Looker Studio (75 Pages)

Yes I want the FREE ebook

In order to use the ‘FILTER BY EMAIL’ setting follow the steps below:

Step-1: Edit the data source schema which is connected to the data source that contains the email addresses of your report viewers.

Step-2: Click on the ‘FILTER BY EMAIL’ link:

Step-3: Click on the checkbox ‘Filter data by viewer email‘:

Step-4: Click on the drop-down menu ‘Select email field‘

Step-5: Find and click on your email field:

Step-6: Click on the ‘All Fields’ link:

Step-7: Click on the ‘Create Report’ button:

Step-8: Click on the ‘Add to Report’ button:

Step-9: Looker studio will ask your permission to personalize your report based on the email address you used to sign in to your Google account. Click on the ‘Allow’ button:

Once I clicked on the ‘Allow’ button, Looker studio will show only that row of data which is associated with my email address:

Now let us suppose my email address was not present in the data source. In that case, when I access this report, I won’t see any data:

My step-by-step blueprint for using Looker Studio (formerly Google Data Studio)

Get the FREE ebook on Looker Studio (75 Pages)

Yes I want the FREE ebook

How to stop filtering by email?

Step-1: Edit the data source schema which is connected to the data source that contains the email addresses of your report viewers.

Step-2: Click on the ‘FILTER BY EMAIL’ link:

Step-3: Uncheck the checkbox ‘Filter data by viewer email‘:

Step-4: Click on the ‘All Fields’ link:

Avoid using a scheduled email to send the Looker studio report that is designed to filter data by the viewer’s email address. Such a report when sent via a scheduled email will not filter data by the viewer’s email address. Instead, it will show data of the person who created the schedule email.

If you want to send a report with email filtering turned on, Google recommends to directly send the report link instead of using scheduled email.

Related Articles

1. 8 Methods To Help You Lower Your Email Bounce Rate
2. Use these 18 notification emails to double your customer lifetime value.
3. Schedule email delivery of a report in Looker Studio

Other articles on Looker Studio

1. Looker Studio Alternative – Whatagraph
2. Looker Studio Parameters explained with examples
3. Looker Studio Number Formats / Data Types
4. How to Change Language in Looker Studio
5. Looker Studio Date Format and Time Explained
6. Looker Studio Tutorial with FREE PDF ebook
7. Looker Studio Functions, Formulas Tutorial
8. How to work with the Boolean field in Looker Studio
9. Looker Studio Page Navigation Tutorial
10. Understanding Report Editor in Looker Studio
11. Best practices for creating a report in Looker Studio
12. How to share reports in Looker Studio
13. Seven methods to create a new report in Looker Studio
14. Looker Studio Report Tutorial
15. How to invite people to view or edit a report in Looker Studio
16. How to share the link of your report in Looker Studio
17. Schedule email delivery of a report in Looker Studio
18. How to download Looker Studio report as PDF
19. How to embed a Looker Studio report on a website
20. Guide to Data Types in Looker Studio
21. Image function in Looker Studio
22. Image Link data type in Looker Studio
23. Image data type in Looker Studio
24. Looker Studio Geo Map – Latitude Longitude
25. Why You Should Avoid Using Functions and Calculated Fields in Looker Studio
26. Looker Studio Calculated Fields Tutorial
27. Working with the Text data type in Looker Studio
28. The Data Set Configuration Error in Looker Studio
29. Data Source Fields in Looker Studio – Tutorial
30. Refresh data source schema fields in Looker Studio
31. Looker Studio Data Sources – Tutorial
32. Looker Studio Dimension vs Metric
33. Looker Studio – Sharing Data Sources (aka data source schema)
34. Field editing in reports – Looker Studio
35. Data Source Version History in Looker Studio
36. Community Visualization Access in Looker Studio
37. Understanding Data Source Credentials in Looker Studio
38. Understanding Data Freshness in Looker Studio
39. How to create and configure a data source in Looker Studio
40. Looker Studio Aggregation Explained
41. How to Edit a Calculated Field in Looker Studio
42. Formula Rejection in Looker Studio
43. Doing Basic Maths on Numeric Fields via Calculated Fields