Tag Archives: Data Studio

New Enterprise IT Controls for Data Studio

As people use Data Studio throughout their organizations, IT administrators have asked to manage how Data Studio can be used. Today, we’re launching three free enterprise features providing IT administrators new visibility and control over Data Studio in their organization.

Organization management through Cloud Identity integration


Data Studio now integrates with Google Cloud Identity to provide organization-wide administrative capabilities. With this integration, Cloud Identity admins can manage who can use Data Studio and how they can use it. Existing G Suite and Cloud Identity customers get Data Studio integration out of the box, and can start using the new Data Studio administration features today. Customers using other identity providers, such as Active Directory, can synchronize their users with Google Cloud Identity, so that creating, suspending, and deleting users happens in one place. 


Enterprise audit logging


Data Studio now offers audit logging, providing IT admins organization-wide visibility into Data Studio usage, similar to that available for apps like Drive and Calendar. For example, admins can understand which users are creating Data Studio reports, and who they are sharing those reports with. Admins can also identify which reports have the most engagement, to scale successful reports across the organization. With custom alerts, you can monitor potentially risky activity like external sharing of data sources, and can export audit logs to BigQuery and use Data Studio to drill into the details. Learn more.
Audit Log

Organization sharing policies


New Data Studio sharing policies allow you to reduce the risk of data exfiltration. You can set limits to prevent users from sharing reports outside of your organization, or make sure they don’t expose company data by disabling public link sharing.


Sharing policies offer you the flexibility to define sharing permissions that meet your business needs. You can give certain users the ability to share reports externally, while allowing other users to share only within the organization. Learn more.


Organization sharing policies

There’s no charge for audit logging or sharing controls — they’re included with every edition of G Suite and Cloud Identity, including Cloud Identity Free. We’re committed to making Data Studio a solution that works for businesses of all sizes, and we’ll continue to build on this foundation. That way, everyone in your organization can uncover insights that matter, and you can rest assured knowing that your valuable business data is safe. 


Do more with Data Studio Community Visualizations

Data Studio Community Visualizations, currently in beta, allow you to create and integrate custom JavaScript components into your dashboards. You can use Community Visualizations to expand your chart selection, customize your report styling, or create custom components that perform advanced analysis or even in-browser machine learning.

New galleries for Data Studio Community Visualizations

Showcase gallery for Community Visualization reports

The Data Studio team recently launched the Community Visualization Report Gallery.

There, you can explore how others in the community have leveraged Community Visualizations to make the most of their data and dashboards.


Reports featuring Community Visualizations

Reports featuring Community Visualizations

Public Partner Visualization Gallery

Additionally, we’ve added a new gallery of Partner Community Visualizations that we’ve made available. Browse them in the new Data Studio Visualizations gallery.
The Data Studio Visualizations Gallery

The Data Studio Visualizations Gallery

Click-to-add Partner Visualizations

To add these Partner Visualizations to a report, click “Explore more” in the Community Visualizations drop down. There, you can browse and install a variety of partner-built charts, including funnel visualizations and Gantt charts.

The new in-product Partner Visualization gallery

The new in-product Partner Visualization gallery

Community Visualizations can add to a Data Studio dashboard in different ways - from providing custom charts and styling to integrating calculations with reporting.

Statistical analysis with Community Visualizations

Anvil Analytics + Insights works to bring data-driven decision making to all of their work, including optimized paid media campaigns. They used Community Visualizations to build their own Chi-Square statistical analyzer.


Several Anvil customers noticed that channels in Google Ads and Analytics converted at different rates, and wanted to know if the variance in conversion rates was statistically significant. 


Prior to using Community Visualizations, the Anvil Insights team manually exported the data out of Google Analytics into a separate tool, then ran the statistical analysis. Depending on where Anvil ran the analysis, the results were either stored separately from their reports, or not stored at all. Every time they wanted to test a different hypothesis or run a different variation of the test, they had to repeat the same time-intensive process.


In order to speed up hypothesis testing and integrate the tests and results into Data Studio reports, Anvil used Data Studio Community Visualizations and built a Chi-Square calculator within a week. 


Anvil’s calculator takes in data, just like any Data Studio chart. Once the calculation is complete, the analyzer presents the statistical significance, and either calls the viewer’s attention to a relationship in the data, or comments that there was nothing of note in the data. Now, all it takes to test new hypotheses is switching out the data for the component, just like you would for any other Data Studio chart. See it live.
Anvil Analytics + Insights Community Visualization Chi-Square Calculator

Anvil Analytics + Insights Community Visualization Chi-Square Calculator

“This has been a much faster way to find statistical significance in our campaigns and in other hypotheses we want to test. Anvil’s Director of Analytics and Decision Science, Brett Lohmeyer says, “The best part is that it gives us an easy way for our team to better communicate the value of using statistical significance to our clients.”

Try it yourself

Check out the new in-product Partner Visualizations Gallery to browse and add new partner-built Community Visualizations to your reports. To build your own Community Visualizations, check out the developer documentation.

Do more with Data Studio Community Visualizations

Data Studio Community Visualizations, currently in beta, allow you to create and integrate custom JavaScript components into your dashboards. You can use Community Visualizations to expand your chart selection, customize your report styling, or create custom components that perform advanced analysis or even in-browser machine learning.

New galleries for Data Studio Community Visualizations

Showcase gallery for Community Visualization reports

The Data Studio team recently launched the Community Visualization Report Gallery.

There, you can explore how others in the community have leveraged Community Visualizations to make the most of their data and dashboards.


Reports featuring Community Visualizations

Reports featuring Community Visualizations

Public Partner Visualization Gallery

Additionally, we’ve added a new gallery of Partner Community Visualizations that we’ve made available. Browse them in the new Data Studio Visualizations gallery.
The Data Studio Visualizations Gallery

The Data Studio Visualizations Gallery

Click-to-add Partner Visualizations

To add these Partner Visualizations to a report, click “Explore more” in the Community Visualizations drop down. There, you can browse and install a variety of partner-built charts, including funnel visualizations and Gantt charts.

The new in-product Partner Visualization gallery

The new in-product Partner Visualization gallery

Community Visualizations can add to a Data Studio dashboard in different ways - from providing custom charts and styling to integrating calculations with reporting.

Statistical analysis with Community Visualizations

Anvil Analytics + Insights works to bring data-driven decision making to all of their work, including optimized paid media campaigns. They used Community Visualizations to build their own Chi-Square statistical analyzer.


Several Anvil customers noticed that channels in Google Ads and Analytics converted at different rates, and wanted to know if the variance in conversion rates was statistically significant. 


Prior to using Community Visualizations, the Anvil Insights team manually exported the data out of Google Analytics into a separate tool, then ran the statistical analysis. Depending on where Anvil ran the analysis, the results were either stored separately from their reports, or not stored at all. Every time they wanted to test a different hypothesis or run a different variation of the test, they had to repeat the same time-intensive process.


In order to speed up hypothesis testing and integrate the tests and results into Data Studio reports, Anvil used Data Studio Community Visualizations and built a Chi-Square calculator within a week. 


Anvil’s calculator takes in data, just like any Data Studio chart. Once the calculation is complete, the analyzer presents the statistical significance, and either calls the viewer’s attention to a relationship in the data, or comments that there was nothing of note in the data. Now, all it takes to test new hypotheses is switching out the data for the component, just like you would for any other Data Studio chart. See it live.
Anvil Analytics + Insights Community Visualization Chi-Square Calculator

Anvil Analytics + Insights Community Visualization Chi-Square Calculator

“This has been a much faster way to find statistical significance in our campaigns and in other hypotheses we want to test. Anvil’s Director of Analytics and Decision Science, Brett Lohmeyer says, “The best part is that it gives us an easy way for our team to better communicate the value of using statistical significance to our clients.”

Try it yourself

Check out the new in-product Partner Visualizations Gallery to browse and add new partner-built Community Visualizations to your reports. To build your own Community Visualizations, check out the developer documentation.

“Up and to the right” with Data Studio

Millions of people from global enterprises, small businesses, governments and educational institutions are choosing Data Studio to make data-driven decisions. Over the last year, people used Data Studio to monitor ad performance, track brand performance, visualize student progress, and build machine learning models. 

Google Ads monitoring report by Search Foresight

In 2019, we launched more than 80 new features and over 50 new connectors to data. A heartfelt thanks to our users and developers who made 2019 a year to remember. Here are a few highlights. 


Visual Analysis

Throughout the year, we invested in visual analysis allowing faster data exploration and insights discovery. We made it possible to turn a chart into a filter using chart interaction controls. We also launched cross-chart interactions and drill downs. These investments, alongside updates like optional metrics, give users the tools they need to explore and interact with their data.
Drill Down GIF

Fast performance through In-Memory BI Engine

Having the right tools to interact with and analyze data is critical but if report performance is slow, analyzing and visualizing large data sets can be frustrating. In collaboration with the Google Cloud BigQuery team, we launched BI Engine to bring sub second performance to Data Studio. BI Engine is an in-memory analysis service that integrates with your BigQuery data to return blazingly fast results in Data Studio. No more waiting for the page to load!
BI Engine

Scheduled PDF export

Listening to what our users need has always been a priority for the Data Studio team. Two of the top requests we heard from our users was the need to create PDFs and schedule emails of reports. Users can now do both. We’re happy to let you know that as of last week you can now set a custom schedule for scheduled emails. Learn more.
Email Delivery

Conditional formatting

We recently launched conditional formatting, which allows users to apply formatting based on a set of rules, making it easier to tell a story with your data. We’re continuing to invest in conditional formatting and recently added  AND and OR conditions to support compound conditions. Learn more.
Conditional formatting

In 2020 the Data Studio team is committed to delivering a great product that helps our users make better decisions with data. To stay in the loop on what’s happening in Data Studio, subscribe to email updates under Settings > Marketing Preferences or check our Help Center each week to learn “What’s new.”


Get to insights quicker with Data Studio’s new home page

It should be easy for everyone to discover and share insights from their data. As of today, Data Studio has a new home page, making finding and creating reports more efficient. Together with recent improvements to chart interactivity and sharing, and the 25+ Data Studio features launched this year, you can go from data to insights to action faster than ever.

Data Studio Home Page

Create in a snap with a streamlined home page

Data Studio’s clean new look puts the focus on what’s most important, so you can start digging into your data right away. We’ve heard that you frequently use search to find reports, so we put the search box front and center. You can also create a Report, Data Source, or Explorer in less time with the new Create button. Finally, the new design should be familiar to users of G Suite products like Drive and Gmail, and is in line with our material design principles.

Data Studio Design

Reveal additional insights with interactive charts

Earlier this year, we introduced the ability to interact with charts to filter other charts on the report page. Since then, we’ve brought even more interactivity to charts. If a report viewer wants to sort a chart differently, you can now allow them to do so right from the chart, without needing to edit the report. If they want to see a breakdown at a lower level of detail—for example, by city rather than by country—you can now allow them to drill down right within the chart.

Data Studio Interactive Charts

Explore your data at the speed of thought with BigQuery BI Engine

We also launched support for BigQuery BI Engine (Beta), a super-fast in-memory engine for interactive visual analysis. Together, Data Studio and BigQuery BI Engine enable you to interact with your data and see results in a fraction of a second.

Visualize your marketing data to unlock new insights with Data Studio

Share insights with others through scheduled email

Want to send someone an offline copy or snapshot of a report? You can download a report as a PDF. Want to send someone a report on a regular basis? Automate the task with scheduled email delivery.

Data Studio Scheduled Email

Data Studio’s new home page and these new features make it easier than ever to find and create reports, discover insights, and share them with others. 

Introducing BigQuery parameters in Data Studio

If you’re one of the many Data Studio users writing custom queries for BigQuery, you can now run parameterized queries. This provides better customization and interaction options to your users while making your reports faster.


When connecting to BigQuery from Data Studio you can use special date parameters or define your own named parameters as part of a custom query. Parameters in custom queries introduce two key benefits: queries can be dynamically updated from the report - no need to create new data sources; this works even if the report user does not have edit access to the data source. You can optimize query cost and gain dashboard performance improvements since less data is passed from BigQuery to Data Studio for parameterized queries.

Creating parameterized custom queries


Let's say you're interested in analyzing word usage by corpus for a selected set of Shakepeare's works. The following BigQuery Public Dataset, bigquery-public-data.samples.shakespeare,is available to carry out this analysis:
BQ Public Dataset

To allow report editors to choose which corpus to analyze from Shakespeare’s works you can use the Custom Query interface of the BigQuery connector in Data Studio to define corpus as a parameter as part of a filter. You can define the type of UI element for the parameter (e.g., text input, single select, checkbox, etc.) and provide default values.


In the following example, the corpus parameter has been defined as a single-select dropdown with Hamlet as the default value along with other works as options such as Othello, King Lear, etc.

A BigQuery custom query with a custom corpus parameter

A BigQuery custom query with a custom corpus parameter

What’s really cool is that once you’ve defined the configuration, report editors will then be able to choose a specific corpus to analyze by using the dropdown from the parameters section of the report property panel:

Report Property Panel

E.g. The corpus parameter options in the

Data Studio property panel.

Using date parameters


Prior to date parameters, custom queries for date sharded or partitioned tables could not be limited to a date range based on a report’s date control. Instead, your custom query would have to fetch all rows for all dates, leaving Data Studio to do the job of filtering for the date range selected by the report user. The result is slower and less efficient reports.


With date parameters, you can use the reserved start and end date parameters as part of a custom query. When report users select a date range for analysis the dates selected will automatically be included as part of your custom query, resulting in a much more efficient query and fetching only the rows needed for the requested date range.


The following example custom query uses the @DS_START_DATE and @DS_END_DATE parameters as part of a filter on the creation date column of a table. The records produced by the query will be limited to the date range selected by the report user, reducing the number of records returned and resulting in a faster query:


BQ Custom Query

A BigQuery custom query using start and end date parameters

The standard Data Studio date settings and controls will determine the date values for your custom query. A report editor can set a default date or add a date control to a report and the start and end dates for your query will change based on the report date control.


In both cases, named and date parameters offer a more efficient way to retrieve data from a single BigQuery data source while giving your report users flexible options to analyze different data.


Try it out!

To learn more about how parameters work review data source parameters and connecting to BigQuery


As you have a chance to experiment with parameters, send us feedback or give us a shout out at @googleanalytics.


New Data Studio developer tools make building connectors and viz easier

Data Studio, Google’s data visualization platform, includes a developer features that expand the flexibility and functionality of your dashboards. Using Data Studio community connectors and community visualizations, you can connect to any internet-connected data source, and create custom visualizations tailored to your data and storytelling needs.

Recently, we created the Data Studio Community Component generator (dscc-gen), a command-line tool that streamlines building community connectors and community visualizations. dscc-gen provides working templates and opinionated workflows that make it quick and easy to create and deploy your projects.

Community Connectors tooling

Typically, developing a community connector means using the online Apps Scripts environment. The online editor is an excellent tool that can be used for all online tasks, but it doesn't support automating repetitive (and error-prone) tasks. By using a project generated from dscc-gen, updating a deployment becomes as easy as running npm run update_production and trying out your latest changes is just npm run open_latest.

To create a new community connector with dscc-gen, just run this command:

npx @google/dscc-gen connector

After the command finishes, you will have a working connector with a production deployment and best-practice deployment scripts. If you have an existing connector, you can still use dscc-gen to get the best-practice deployment scripts. See existing connectors for details.

For more information on commands that are available, see the local development developer documentation.  

Community Visualization tooling

Typically, developing a community visualization means editing local files, re-uploading the changes, and reloading a Data Studio report. This template provides a local development cycle and scripts that make bundling and deploying your code a breeze. By using a project generated by dscc-gen, deploying a visualization with caching enabled becomes as easy as running npm run build:prod && npm run push:prod.

To create a new community visualization with dscc-gen, just run this command:

npx @google/dscc-gen viz

After the command finishes, you will have a working visualization with a lightning-fast local workflow and best-practice build/deployment scripts.

For a rundown of how to best use this tool, visit the local development developer documentation.

Templates and use casesOur tooling supports the most common use-cases for connectors and visualizations. We’ve open sourced the library and code on GitHub, where you can make and request improvements.

Looking forward

We’re continually adding features to our developer platform. Community visualizations just added support for filter interactions, and connectors added many improvements throughout 2018. Sign up for updates on our the Data Studio developer ecosystem.

Introducing Data Studio Community Visualizations as Chart Interaction Filters

Community Visualizations as Chart Filters

At the beginning of 2019, we introduced richer interactivity in Data Studio, enabling charts to  act as filters, facilitating more interactive data explorations and faster time to insight. If you’ve been following the community visualizations developer preview, you may have noticed that community visualizations haven’t yet supported chart interaction filters.

Now, we’ve added the capability for developers to add filter interaction functionality to community visualizations. When interacting with a community visualization that supports filter interactions, your interactions with the community visualization can filter the rest of your dashboard.

For example: below is a community visualization heatmap that acts as a chart interaction filter.

Data Studio Community Visualizations

Temperature heatmap community visualization. Each cell is selectable and can filter the table underneath. See the report live.


Community visualizations acting as chart filters make even more custom, interactive charts possible in your reports. You can create calendar heatmaps where you can click-and-drag to select a date range, or a timeseries chart where you filter dragging a rolling window along your chart. You could even create a dendrogram of organizational chart data, and select different nodes to filter the dashboard by the individuals represented at each node.

Report editors can enable filter interactions for each visualization, and use them to filter other components on the dashboard, just like the Data Studio built-in charts.

We’re continuing to add features to make community visualizations more powerful and easier to use. Learn how to add filter interactions to your community visualization by reviewing our developer documentation, and sign up to keep up with the latest in Data Studio developer features.

Richer interactivity in Data Studio

To start 2019, the Data Studio team added a number of new features to allow for faster insights and richer reporting. Today, we’ll highlight some of these recent launches.

Interactive Charts

We’re extending Data Studio’s filtering capabilities directly into our charts. Editors can now turn any chart into a filter that filters other charts. When viewing a dashboard, you can now click or brush on any data in order to initiate filters, enabling much faster exploration and shortening the time to insight.

Interactive charts in action

Interactive charts in action. See help center article for more information.

Search Filters

Data Studio now gives the ability to search for any value in your data, whether you have hundreds or billions of unique records. For example, as In the instance below, you can search your name’s popularity over time by looking at a hundred years of USA name data, hosted in BigQuery, Google's serverless, highly scalable, enterprise data warehouse.

See the help center article here to learn more.

Embed External Content

We’re making it easy to bring in any content from the web to your report. Now, you can embed an entire webpage in a Data Studio report. You can add YouTube videos explaining your content, Google Sheets containing the source data for your report, Forms to get feedback on the usefulness of your report, or any embeddable content from the web.


Sample report with embedded YouTube video

Sample report with an embedded YouTube video. See help center article for more information.

As always, we will continue to introduce new features and enhancements based on your feedback. Please request features and upvote your favorites here.

Introducing the Data Studio Community Visualizations Developer Preview

Data Studio provides a variety of easy-to-use charts to help you tell stories with your data, allowing you to visualize data from different sources. Sometimes, though, you want a custom chart to convey information more effectively to your teams, or to customize style options for the kind of data you are presenting.


The new Data Studio Community Visualizations feature, in developer preview, allows you to build new charts and styling options, providing even more freedom and flexibility in the stories you tell with your data. Community visualizations integrate seamlessly with the rest of your Data Studio dashboard, including all of the data sources you bring together, to enable you to quickly gain insight from your data.

Community Visualizations

A community visualization Sankey diagram with style options in the property panel

What are Community Visualizations?

Community visualizations integrate seamlessly into your dashboards. You can use them with all of your data sources, and configure the data and styling options in the property panel, just like you would with a built-in chart.


ClickInsight, a Google Marketing Platform partner, says this about community visualizations:


"Choosing the right chart type is essential to effectively telling a story with data. Thanks to Community Visualizations, we now have the flexibility to build our own charts to suit every unique situation."

Developer preview launch

The Community Visualizations developer preview launch means that the Community Visualization feature is stable and enabled for all users. To build a community visualization, you should be comfortable with JavaScript, HTML, and writing visualization code. However, there are many features and improvements you can look forward to in the coming year.


To learn more about Community Visualizations and how to get started, visit Community Visualizations, Developer Preview. Once you’ve built a visualization you’d like to share, submit a report to the showcase and share your code with other Data Studio users.