Tag Archives: Data Studio

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.

2018: The Year in Data Studio Community Connectors

It's been a busy year for Data Studio Community Connectors. Since the developer launch, we've added over ten new features, had significant growth, seen partners grow their businesses, and collaborated with the community on open source projects. As we move forward, we're reflecting on what has been accomplished, and what's coming next for Community Connectors.

Where were we last year?

In late 2017, we launched Community Connectorsto allow Data Studio users to connect to their external data and started working with partners to bring access to new data sources. The developer preview provided a platform for developers to build connectors, but there were a lot of features to add and work to do before it was ready for a full launch. This is what we've been busy working on the last year. Since then, we've seen 140+ partner connectors, 500+ data sources, integrated solutions, and fun data sets.

Now that we've delivered on the key improvements and updates highlighted at the outset of the developer launch, we've concluding the developer preview phase. Let's look at what's been added in 2018.

New Developer Features

Throughout 2018, we‘ve added features to improve the connector developer experience and enabled new use-cases.

We introduced the community-connectors GitHub repository as a place to let the community contribute open source connector code.

There are new ways to authenticate a connector. Services that expect username & password, API tokens, or username and API key are easier to add. See Authentication for full details.

Connectors can define the semantic types for their schemas ahead of time. This means your users no longer have to tweak settings on the schema configuration page every time they make a data source from your connector.

The Data Studio Apps Scripts service is now available and provides useful builders & validation to make building a connector a breeze.

Error handling has been vastly improved. Through the Data Studio App Scripts service, you can clearly indicate to a user when something goes wrong (and hopefully how to fix it!).

Some other features worth mentioning:

What Partners Are Saying

Our connector partners and their customers have seen great success with community connectors. Mikael Thuneberg, CEO of Supermetrics, had this to say:

"The focus we’ve put on creating high-quality connectors has been rewarded by the large number of companies around the world who have chosen these as their primary cross-platform marketing reporting tool. [ … ] Data Studio connectors have become an exciting and rapidly growing business area for Supermetrics."

Marc Soares, Manager at Clickinsight, has also seen success through community connectors:

"[Community Connectors have] allowed us to fully take advantage of Data Studio as a central reporting platform. Thanks to community connectors, our analysts spend less time making reports and more time conducting meaningful analysis for our clients."

What's Coming Next?

Next year, we're planning to provide even more ways to configure connectors, extending existing features, and adding more educational content to help you get the most out of community connectors.

If you're new and want to get started making your own connector, check out the codelab and  documentation. To stay up to date with changes and the community, see support for options.

It’s been a great year, and we're excited for what's coming in the future.

New Google Marketing Platform connectors available in Data Studio

When marketers can access all of their data in one place, they are able to make smarter decisions about where and how to spend their resources. While data tends to be siloed and it can be a challenge to connect all of it in one place, your marketing investment will go further if you do.

Data Studio gives marketers access to a diverse and growing catalogue of connectors for over 500 data sources to help centralize your datasets for simple reporting and visualization in one place. And we’ve recently added two more. Earlier this fall we launched connectors for Display & Video 360 and Search Ads 360. These two connectors enable access to your Google Marketing Platform advertising data in your Data Studio dashboards and reports. Explore the data independently, or join it with your other marketing data from Google Analytics, Google Sheets, Google Ads, and other first party data sources to surface powerful insights you can easily share and take action on.

Once your Google Marketing Platform data is in Data Studio, you can customize your reports based on your needs. For example, you can add custom branding or repurpose visualizations like charts or graphs that your team already uses elsewhere to make it your own. And, Data Studio reports are easily shareable outside of the interface. With Display & Video 360 and Search Ads 360 data now accessible in Data Studio, you can share dynamic Google Marketing Platform advertising reports with anyone, using Google Drive sharing permissions you have complete control of.

Let’s say you want to build a report to compare how your advertising is performing across Display & Video 360, Search Ads 360 and Google Ads. You can use the out-of-the-box, new Google advertising performance template to view top-line metrics with your own data, or create a custom report, using connectors to import your data.  From there, you can use the Explorer functionality to experiment with visualizations and organize the data to your liking. You can also blend the data together and do analysis across all three (or more) datasets. Add your Google Analytics data for example, and see aggregate trends in customer behavior on your site alongside your advertising campaign performance. Then share with your media team or agency and take action to optimize your campaigns based on the insights you find.

With Data Studio’s rich visualization and reporting features, marketers can elevate insights from their ad campaigns and breakdown silos among many disparate datasets. By bringing Google Marketing Platform advertising data into Data Studio, you can now see a fuller picture across your customer touchpoints and make more informed, faster marketing decisions.

Announcing Kaggle integration with Google Data Studio

Kaggle and Data Studio

As of today, Kaggle is now officially integrated with Data Studio, Google’s serverless business intelligence and data visualization platform. You’ll be able to connect to and visualize Kaggle datasets directly from Data Studio using the Kaggle Community Connector.

Kaggle is the world's largest online community of data scientists. Its two million users come to the platform to explore, create, and share data projects using Kernels, a free hosted notebook IDE. Over 10,000 public datasets can be analyzed using Kernels, accessed via the web or Kaggle's public API. This new integration, users can analyze these datasets in Kaggle; and then visualize findings and publish their data stories using Data Studio.

Here’s an example dashboard in Data Studio using a Kaggle dataset:

As a free-to-use reporting solution, Data Studio makes it easier for users to understand their data, derive key insights, and effectively communicate findings using compelling interactive dashboards. Data Studio is creating an innovative landscape where users can spend less time building their data pipeline and more time on creating data stories and sharing them with the right audience.

With this integration, users can browse to a dataset in Kaggle, pick a file, and use the one-click integration button to launch Data Studio with the selected data. From there, users can create and publish their own interactive dashboard, which can be embedded in websites and blogs. Since there is no cost to use Data Studio and the infrastructure is handled by Google, users don't have to worry about scalability, even if millions of people view the dashboard.

Here’s a quick clip showing how easy it is to use this integration to build dashboards in Data Studio:


See Connecting Kaggle Datasets to Data Studio to learn more.

Data Studio helps data professionals bring the power of visual analytics to their data. The hassle-free publishing process means everyone can tell engaging stories, open up dashboards for others to interact with, and make better-informed decisions. We're also releasing the connector code for this integration in the Data Studio Open Source Repository. This should help both Data Studio developers and Kaggle users to build newer and better solutions.

To get started, try out a Kaggle maintained dataset and launch the Kaggle connector for Data Studio. Let’s analyze more data and build awesome dashboards!

Simplifying Data Studio embeds and social sharing

Today we are introducing two new features to make sharing your Data Studio visualizations easier, including enhanced support for embedding your reports across the web, and rich snippets of your reports when you share them on social networks.

Embed with Embed.ly

Data Studio now supports embedding interactive reports on Medium, Reddit and hundreds of other sites that use Embed.ly. To embed your report, simply paste the report URL in your article. Simply embed your report and it will sync in real time, making it possible for you to distribute your interactive reports. Learn more.

Here are some examples of embedded reports:

DS Embed 1

Medium article showing Stack Overflow trends. Link

DS Embed 2

Reddit post showing real time departures for BART (Bay Area Rapid Transit). Link

Share rich snippets on social

When you share your report link on social platforms or messaging apps, you will now see a rich snippet including the title, thumbnail and description of the report. Your audience will know what to expect from the link and have better visibility to your reports. Rich snippets also help make your content more searchable on social networks.

To generate rich snippets, post the report URL you intend to share.

Here's an example of a rich snippet:

DS Embed 3

Rich snippets work on any social platform or messaging app that supports Open Graph Protocol including Google+, Facebook, Twitter, LinkedIn, Reddit and apps like Hangouts, iMessage and Slack.

Data Studio’s new features help you tell more compelling stories

In today’s ever-changing, multi-channel landscape, marketers need to quickly gather and visualize all their data in order to gain new insights. Data Studio helps marketers turn their raw data into informative, easy-to-read and easy-to-share reports—leading you to insights that can help drive businesses forward. Today, we’re launching three new features that make it easier for marketers to tell compelling data stories and make better, more informed business decisions.

Here’s a look at the three additions.

Explorer: Bring your data analysis together with one click

Get insights from your data faster—no coding required. Explorer eliminates the time-consuming work of combing through large amounts of data to find the insights you need. And with Data Studio’s one-click integration with BigQuery, it’s especially easy for businesses to find the insight they need. That speeds up the analyst workflow and opens up querying to non-technical users.

data studio explorer

Data Blending: See your data in a single visualization

Imagine you’re an enterprise business that wants to analyze and visualize information from multiple accounts across its organization. That could be data from Google Ads, from other products in Google Marketing Platform, or from other media providers. How do you get all this information into a single chart with the least amount of work? By using Data Blending, which lets you bring multiple data sources together to analyze and visualize right in Data Studio. Soon, you’ll also be able to add additional fields to create new calculations from the blended data. All this lets you tell your complete data story with an interactive, compelling chart that’s easy to create.

data studio data blending

Google Marketing Platform Report Gallery: Create comprehensive reports like never before

The new Google Marketing Platform Report Gallery has a series of report templates that help you quickly create consolidated and informative reports using data from any of Google Marketing Platform’s products. Use a report template and customize it to capture exactly what you need, all in a few minutes. This new feature was designed to help businesses avoid inefficiencies that can come from collecting data, and lets them get actionable insights quickly to share with their teams.

data studio report gallery

With these powerful new features launched and ready to go, you can start turning data into compelling visual insights right away. Create your first report today and start to create a fuller picture of your digital marketing strategy.

Introducing the Data Studio Community Connector Codelab

Posted by Minhaz Kazi, Developer Advocate, Google Data Studio

Data Studio is Google's free next gen business intelligence and data visualization platform. Community Connectors for Data Studio let you build connectors to any internet-accessible data source using Google Apps Script. You can build Community Connectors for commercial, enterprise, and personal use. Learn how to build Community Connectors using the Data Studio Community Connector Codelab.

Use the Community Connector Codelab

The Community Connector Codelab explains how Community Connectors work and provides a step by step tutorial for creating your first Community Connector. You can get started if you have a basic understanding of Javascript and web APIs. You should be able to build your first connector in 30 mins using the Codelab.

If you have previously imported data into Google Sheets using Apps Script, you can use this Codelab to get familiar with the Community Connectors and quickly port your code to fetch your data directly into Data Studio.

Why create your own Community Connector

Community Connectors can help you to quickly deliver an end-to-end visualization solution that is user-friendly and delivers high user value with low development efforts. Community Connectors can help you build a reporting solution for personal, public, enterprise, or commercial data, and also do explanatory visualizations.

  • If you provide a web based service to customers, you can create template dashboards or even let your users create their own visualization based on the users' data from your service.
  • Within an enterprise, you can create serverless and highly scalable reporting solutions where you have complete control over your data and sharing features.
  • You can create an aggregate view of all your metrics across different commercial platforms and service providers while providing drill down capabilities.
  • You can create connectors to public and open datasets. Sharing these connectors will enable other users to quickly gain access to these datasets and dive into analysis directly without writing any code.

By building a Community Connector, you can go from scratch to a push button customized dashboard solution for your service in a matter of hours.

The following dashboard uses Community Connectors to fetch data from Stack Overflow, GitHub, and Twitter. Try using the date filter to view changes across all sources:

This dashboard uses the following Community Connectors:

You can build your own connector to any preferred service and publish it in the Community Connector gallery. The Community Connector gallery now has over 70 Partner Connectors connecting to more than 400 data sources.

Once you have completed the Codelab, view the Community Connector documentation and sample code on the Data Studio open source repository to build your own connector.

What’s New in Google Data Studio?

The Data Studio team has been hard at work launching some new features, including clearer tables, colorful numbers, and more ways to visualize your data. Let's take a look at the highlights:
Need to narrow down a large data set? Pivot Tables take the rows in a standard table and pivot them so they become columns. This lets you reorganize metrics and dimensions, and group and summarize the data in ways a standard table can't provide. Pivot tables also help you analyze relationships between data points that might otherwise be hard to spot.

Learn more about pivot tables (and see how Sheets can now intelligently suggest them for you!) »
Coordinated Coloring binds colors to specific data for easy comparison of metrics and dimensions across different visualizations. When a new visualization is created, Data Studio automatically binds colors to the data, so that color:data pairs stay consistent with all filters and versions. Coordinated coloring is automatically turned on for all new reports, and you can add it yourself to old reports.

Learn more about coordinated coloring »

In this image, the table and pie charts both show sampled Google Analytics 
data (with orange indicator); the geo chart doesn't. 

Google Analytics often samples data to provide accurate reporting in a timely manner. Data Studio reports now includes a simple Google Analytics Sampling Indicator to show you any component that contains sampled Analytics data.

Learn more about sampling indicators »

Field Reports Editing: Data Studio has recently added new functionality that makes it easier to create and edit the visualizations that you need, rather than going back and forth to the data source. You can use these new options to:
  • Rename fields
  • Change aggregation types, semantic types and date functions
  • Apply % of total, difference from total, or % difference from total to metrics from within the report. 

Display Images in Tables: The new IMAGE function is a useful way to display images in tables -- for instance, adding YouTube video thumbnails or product images to your reports.

Data controls let each team select the accounts that are relevant to them. 

Data Control updates: Data Control lets every user bring their own data to existing Data Studio reports. This means every user can select from a list of their own accounts to populate the visualizations -- so there's no need to build new reports for every account and user. This makes it possible to scale report “templates” across a number of users with different access to accounts, an important use case for agencies or companies with subsidiaries. And now Data Control supports Attribution 360 (TV Attribution) and DFP (DoubleClick for Publishers) data sets.

Learn more about Data Control »

We hope these new features will help you continue to make the most from Data Studio. Keep the data rolling!

Note: Though not an official G Suite service, Data Studio is currently available globally for free.

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Get the most out of Data Studio Community Connectors

Data Studio Community Connectors enable direct connections from Data Studio to any internet accessible data source. Anyone can build their own Community Connector or use any available ones.

Try out the new Community Connectors in the gallery

We have recently added additional Community Connectors to the Data Studio Community Connector gallery from developers including: DataWorx, Digital Inspiration, G4interactive, Kevpedia, Marketing Miner, MarketLytics, Mito, Power My Analytics, ReportGarden, and Supermetrics. These connectors will let you access data from additional external sources, leveraging Data Studio as a free and powerful reporting and analysis solution. You can now use more than 50 Community Connectors from within the Gallery to access all your data.

Try out these free Community Connectors: Salesforce, Twitter, Facebook Marketing.

Find the connector you need

In the Data Studio Community Connector gallery, it is possible for multiple connectors to connect to the same data source. There are also instances where a single connector can connect to multiple data sources. To help users find the connector they need, we have added the Data Sources page where you can search for Data Sources and see what connectors are available to use. The connector list includes native connectors in Data Studio as well as verified and Open Source Community Connectors. You can directly use the connectors by clicking the direct links on the Data Sources page.

Vote for your data source

If your data source is not available to use through any existing connector, you can Vote for your data source. This will let developers know which Data Sources are most in demand. Developers should also let us know which Community Connector you are building. We will use this information to update the Data Sources page.

Tell us your story

If you have any interesting connector stories, ideas, or if you’d like to share some amazing reports you’ve created using Community Connectors please let us know by giving us a shout or send us your story at community-connector-feedback@google.com.