Tag Archives: Data Studio

Data Studio now globally available

Last month we announced we removed the five report limit in Data Studio, allowing you to create and share as many reports as needed — all for free. Today we are opening up access to 180+ countries, enabling even more businesses to easily connect to data and create beautiful, informative reports that are easy to read, easy to share, and fully customizable.

New, powerful features

In addition to making Data Studio accessible in more countries, we’re also adding more powerful features to help you better analyze and report on your data, including:

Filters

You can now filter your data in more ways, and it's easier to reuse filters on multiple charts. This new functionality includes:
  1. Reuse – Create a filter once and then use it on as many different components on the report as you want. No more recreating identical filters!
  2. Compound filtering – Combine multiple AND and OR filter conditions together into one reusable filter.
  3. Metric filters – Filter metric values that are too large, too small, or within a specified range.
Learn more in the Filter Help Center article.

New Filters UI

Google Analytics segments

You can now apply Google Analytics segments to your charts!

A Google Analytics segment represents a subset of your data, for example, Returning Users. You can now see all your Google Analytics segments in Data Studio and apply them to any chart. And, if you update the definition of your segments in Google Analytics, those changes will apply to the segments in Data Studio.

Learn more in the Segments Help Center article.

Data Studio allows you to link to your Google Analytics segments.

More powerful data connectors

We’ve improved several of our most popular data connectors, YouTube, DoubleClick Campaign Manager, and AdWords, by adding many new dimensions and metrics. Some highlights include adding YouTube video title, DoubleClick Campaign Manager revenue and cross-environment conversions broken out by app, AdWords campaign ID, and keyword quality score. For a full list of all the new fields, please see the Data Studio release notes.

Google Cloud Platform integrations
We’re also announcing tighter integration with the Google Cloud Platform to enable faster data reporting at scale and more powerful functionality.

File upload

Not all your data resides within SQL or Google databases. Data Studio now has the ability to upload up to 2GB of CSV data for free enabling you to bring in data from anywhere. Have more data? Upload directly into BigQuery using your BigQuery account to take advantage of the scalable processing power of Google's infrastructure.

Tighter BigQuery integration

Not only can you upload data directly into BigQuery, Data Studio now supports Standard SQL in BigQuery for custom queries and partitioned tables.

Learn more about these new features
Not sure where to start? You can browse our gallery of Data Studio templates. Need more information on these new features? Visit the Help Center articles for more details:


As always, your feedback and questions are welcome in the Data Studio community forum.

Happy reporting!
Posted by Dave Oleson, Data Studio Product Manager

Data Studio: Enhanced AdWords MCC Support

An AdWords manager account (MCC) is a powerful tool for handling multiple AdWords accounts. Manager accounts allow users to link several accounts so they can be viewed in a single location, and are frequently used by third-party advertisers such as agencies and marketing professionals.

Today the Data Studio team is releasing an enhanced AdWords connector, giving users the ability to select MCC sub-accounts and set up reports for accounts containing multiple sub-account currencies.

Click image for full-size version
New capabilities

There are two major enhancements to the AdWords connector:

1. Selecting sub-accounts: prior to this release it was only possible to connect to an entire MCC account as the data source for a Data Studio report. This enhancement allows users to define a data source by selecting up to 75 individual sub-accounts within an MCC account.

2. Filtering on currencies: one common challenge with MCC accounts occurs when sub-accounts are set to different currencies. While metrics such as impressions and clicks can be aggregated correctly across these sub-accounts, currency fields like Cost and Average CPC cannot. The enhanced AdWords connector allows MCC account holders to filter sub-accounts by currency to avoid this problem, and removes currency fields from the connector if multiple currencies are present.

Connecting to AdWords MCC accounts
To connect to MCC accounts, create a new Data Studio data source and select the AdWords connector. If you have access to an MCC account, a “MANAGER ACCOUNTS” option will appear. The account holder can then select sub-accounts they are interested in, or use the pull-down menu in the upper-right corner to filter for sub-account currencies.

Note that existing Data Studio connections to MCC accounts must be edited and reconnected or recreated from scratch to take advantage of the new enhancements.

Your feedback and questions is welcomed in the Data Studio community forums. 

Happy Reporting!

Posted by Alon Gotesman, Google Data Studio team

Data Studio: Search Console Connector

Google Search Console is a free service offered by Google that helps webmasters monitor and maintain their site's presence in Google Search results. Search Console helps users understand how Google views their site and allows them to optimize their performance in search results.

Search Console’s Search Analytics feature shows webmasters how often their site appears in Google search results for various keywords. This data is extremely powerful but currently lives in Search Console’s Search Analytics Report and is hard to combine with other data sources.

Today we are announcing a new Data Studio connector for Search Console. With this launch users can pull their data into Data Studio to build reports that include impressions, clicks, and average position broken out by keyword, date, country, and device.


Search Console users can now build Data Studio reports to understand how their search traffic changes over time, where traffic is coming from, and what search queries are most likely to drive traffic to their sites. Users can also filter reports for mobile traffic to improve mobile targeting, and to analyze clickthrough rates for various organic search terms.

As always, Data Studio report creators can add components from other data sources into a single report. With this new connector, users can use the Search Console and AdWords connectors to compare performance across paid and organic search, or add Google Analytics data to analyze site-side performance.

Note that Search Console metrics can be aggregated by either site or by page (URL). This is configured in the Data Source creation flow, where users can select either “Site Impression” or “URL Impression”. To learn more about the distinction between these two methods please see the Search Analytics Report Help Center article.

Want to learn more? Looking for a new connector in Data Studio?

To learn more about the new Search Console connector, please visit our Help Center or post your questions in the Data Studio community forums.

Is there a specific data service you wish to be able to access and visualize through Data Studio? We welcome your feedback via the connector feedback form — we read all responses and use them to prioritize new connectors.

Happy reporting!

Posted by The Data Studio team

Making Google Data Studio Free for Everyone

Today, Google's mission to organize the world's information and make it universally accessible and useful is even more relevant and broad reaching. And last year’s launch of both free and enterprise versions of Data Studio, a new dashboarding and reporting tool, is a testament to our commitment to this vision. Over the past 9 months we’ve received positive feedback and seen tremendous demand for the product. And we’ve continued to enhance the product making it even easier to use via templates and adding many new data connectors.

To enable more businesses to get full value from Data Studio we are making an important change — we are removing the 5 report limit in Data Studio. You now create and share as many reports as you need — all for free.

This change combined with a very exciting roadmap for 2017 are designed to accelerate our goal to help you fully leverage all your data across your organization and to ultimately make better decisions.

Thank you for using Google Data Studio and as always, please share your thoughts and feedback as to how we can improve the product. We’re excited by what the future holds! 

Happy Analyzing.

Posted By Nick Mihailovski, Product Manager, Google Data Studio

3 Ways to Better Support Marketing Decisions with Data

It’s often said that marketing is both an art and a science. The science side is increasingly in the spotlight as companies use data to optimize the customer experience at every touchpoint. But, ensuring that insights surfaced from that data lead to action requires the arts of communication and collaboration.

Highly data-driven organizations are three times more likely than others to report significant improvement in decision-making.1 Yet, 62% of executives still rely more on experience than data to make their decisions.2 When the stakes are high, decision-makers need information they can trust, easily consume, and understand.

Below are three ways marketing organizations can take action on their data to better support decisions:

1. Organize
Whether you have trouble connecting teams or data sources, silos can prevent your marketing organization from reaching current and potential customers. Data silos prevent you from gaining a holistic view of the customer journey. Organizational silos slow down the flow of information and ideas. What’s more, organizational silos are the number one barrier to improving customer experience.3

Outline a data strategy to organize and integrate information sources so you have the complete picture to your customers’ journeys. Collaboration and communication between departments is also key. Better yet, make sure marketers and analysts all have access to the same data sets and technology.

2. Visualize
Good data storytelling means making data easy to process. By taking the time to visualize your data, you’ll be able to tell a compelling story at a glance.

The goal of a revenue chart, heat map, or bar graph should be to simplify a complicated idea or communicate a body of information in seconds. Tools can help make data quickly actionable by taking multiple data sources and turning them into interactive reports and dashboards. Focus on reducing misinterpretations of your data and making it easy for decision makers to act.

3. Share
If the data can’t be understood, its insights cannot be acted on. But just as important, if the data and ideas are not shared with the right people at the right time, decision makers can’t fully leverage the power of marketing data.

“Real-time data is critically important. Otherwise, business leaders may be making decisions off data that is no longer relevant. The business landscape changes so quickly, and stale data may inadvertently lead to the wrong decision,” says Suzanne Mumford, head of marketing for the Google Analytics 360 Suite.

Look for solutions that offer data visualization and built-in collaboration capabilities so you can start practicing all three steps right away:
The companies that shine at optimizing the customer experience go beyond analytics and measurement. The whole organization collaborates in order to connect the data dots and communicate the meaning and impact of insights surfaced. Leading marketing organizations build a culture of growth — one that uses data, testing, and optimization to improve the customer experience every day — and share insights in ways that everyone across the organization can understand and act on. 


Download “Measuring Marketing Insights,” a collection of Harvard Business Review articles, to learn more about how to turn data into action.

A version of this article first appeared as sponsor content on HBR.org in August 2016.

1 PwC's Global Data and Analytics Survey, Big Decisions™, Base: 1,135 senior executives, Global, May 2016 
2 PwC's Global Data and Analytics Survey, Big Decisions™, Base: 2,106 senior executives, Global, May 2016 
3 Harvard Business Review Analytic Services, "Marketing in the Driver's Seat: Using Analytics to Create Customer Value," 2015.


Posted by Karen Budell, Content Marketing Manager, Google Analytics 360 Suite

Data Studio: DoubleClick Campaign Manager Connector

Google Data Studio (beta) allows users to connect, transform, visualize, and share data no matter where it lives. Today we are happy to announce that DoubleClick Campaign Manager (DCM) customers can pull their data into Data Studio dashboards instantly!


With this new connector, DCM customers no longer need to import data into spreadsheets. Users can now quickly create dashboards with over 50 DCM metrics and dimensions. These dashboards are an effective way to track and optimize campaign performance and share reports with client and agency stakeholders.

Creating a new report with DCM data
Ready to get started? The first step is to connect to your DCM network or advertiser through the Data Sources page.



Next you can create a new report from scratch or use our DCM template. With just a few clicks, the dashboard is populated with your data.

Want to learn more? Looking for a new connector in Data Studio?

To learn more about the new DCM connector, please visit our Help Center or post your questions in the Data Studio community forums.

Is there a specific data service you wish to be able to access and visualize through Data Studio? We welcome your feedback via the connector feedback form — we read all responses and use them to prioritize new connectors.

Happy reporting!

The Data Studio team

Posted by Alon Gotesman, Google Data Studio team

How to Apply Holiday Shopping Insights to Your Analytics Strategies

The Year of the Supershopper
We all have that friend — the one who somehow knows the latest brands, the season’s must-have products, and where to find the best deals at the snap of a finger. In years past, this friend was an enigma, making us wonder how does he or she do it?

Today, we can all be that friend. With the ability to instantly discover, research, and purchase, shoppers around the world are more informed and more efficient than ever before - they’ve transformed into supershoppers seemingly overnight.

But what defines supershoppers? And what does this mean for retailers trying to win them over this holiday season? Let’s find out.


They Keep Their Options Open
Last year, more than 50% of holiday shoppers said they were open to purchasing from new retailers1. This is especially true online. More than three-quarters of smartphone shoppers who usually go to the same physical stores when they shop for products are very open to new retailers and brands online2. Why? Mobile makes it easy to explore all of your options no matter when or where you’re shopping. In fact, after searching on Google, 76% of mobile shoppers have changed their mind about which retailer or brand to purchase3.
Mobile is Their Muse
It used to be that shoppers would thumb through catalogues or stare longingly at the holiday window displays, but mobile is now the super shopper’s go-to source for inspiration. Sixty-four percent of smartphone shoppers turn to mobile search for ideas about what to buy before heading into a store4. And 1 in 4 mobile video viewers in the U.S. have visited YouTube for help with a purchase decision while they were at a store or visiting a store's website5.

But shoppers aren’t only making purchase decisions, they’re discovering new brands and products along the way: more than half of smartphone users have discovered a new company or product when conducting a search on their phones6.

They Want the Best - Not the Cheapest
In July we learned that shoppers are on the quest for the best — and this still rings true more than ever today. Last holiday, mobile searches related to “best gift” grew 70% year over year while mobile searches related to cheap or inexpensive gifts grew about 35%7. They’re also willing to do the research to the make the best decision: on YouTube, mobile watch time for product review videos has grown 60% year over year8.

But supershoppers don’t only want the best - they want personalized, unique, cool gifts. Mobile searches related to “unique gifts” grew more than 65% while mobile searches related to “cool gifts” grew a whopping 80%9.

Mobile is Their Door to the Store
Although more and more people are willing to buy on mobile, we know that mobile is still used predominantly as a door to the store. In fact, 76% of people who search for something nearby on their smartphone visit a related business within a day, and 28% of those searches result in a purchase10.

Once they’re inside your store, they expect the experience to be a seamless one: more than 40% of smartphone shoppers want retailers to automatically surface relevant information such as the location of the item in the store, a special deal or related products11.

They Shop ‘Til they Drop
Supershoppers live up to their name as the holiday season progresses. From November through mid-December we see online conversion rates increase across devices. Last year, on mobile alone, they jumped 30% on Black Friday and 50% on Cyber Monday when compared to November 112.



Tips to Using Analytics to Reach Today’s Shopper
Analytics is a critical marketing tool all year long. But that importance is amplified during the holiday season. Here are five ideas on how you can use analytics to get the most out of the holiday shopping season.

1. Understand which days drive the most sales — be there. In order to develop a successful holiday retail strategy, it’s important to first understand the days that drive the most sales for your business. Once you understand this, you can craft strategy — across mobile, desktop, and tablet — that optimizes your media and promotion not only for these days, but for the entire holiday season.
For example, adjust bids for auction-based media and use the lift in transaction rates over the average transaction rate as your bid multiplier. Use Smart Bidding in AdWords or DoubleClick Search to maximize your performance.

2. Get personal when engaging with window shoppers. The great thing about the holidays is that you can start shopping at any time — and then wait for discounts. Many consumers may already be browsing your site looking for gift ideas. This is an audience that may convert at a higher rate. Use Google Analytics to create remarketing lists including these shoppers, and then customize your marketing campaigns to better suit their needs.

But don’t stop there: Remember, supershoppers crave personalization. Test different variations of your website with this same audience to offer more customized experiences. Try Google Optimize, our free site testing and personalization tool, to get started.

3. Act fast: Create a culture of optimization. Your holiday marketing plans are set long before the holiday season starts. It’s very important to monitor your activities to ensure they’re driving business growth. And if they’re not you need to take action by immediately identifying areas of opportunity and improvement.

Google Analytics offers a number of ways to help simplify reporting, sift through data, and spotlight insights for you. Custom reports, dashboards and shortcuts all let you customize reporting so you spend less time looking for data and more time analyzing important information. Or better yet, try Google Data Studio and create a holiday shopping dashboard for different teams in your organization.

4. Analyze your performance against your competitors. Benchmarking your business against your competitors helps you see the big picture. If you’re a Google Analytics user, you can tailor this analysis and approach, using your own data and the data available in our benchmarking reports. The benefit of using those reports is that they will provide you a comparison between your data and your competitors, using characteristics such as website traffic, country and detailed vertical information.

5. Start developing your New Year marketing strategy. With so many new shoppers entering your stores, sites, and apps, data and analytics are critical to helping you convert first-time shoppers into long-term, loyal customers. Use your website data to create lists of first-time customers during the holidays, and deliver personalized communication across channels to build relationships. With Google Analytics you can create remarketing lists and easily connect with this audience.

Happy analyzing!

Posted by Julie Krueger, Retail Managing Director, Google and Casey Carey, Director of Analytics Marketing, Google


  1. Google/ Ipsos, Post Holiday Shopping Intentions Study - Total Shoppers Report, Jan 2016, Base: US Holiday Shoppers, n=1,500
  2. Google/Euromonitor International, Micro-Moments Survey, US, July 2016, Smartphone shoppers = 1000, Same store shoppers = 801
  3. Google/Euromonitor International, Micro-Moments Survey, US, July 2016, Smartphone shoppers = 1000
  4. Google/Euromonitor International, Micro-Moments Survey, US, July 2016, Smartphone shoppers = 1000
  5. Google-commissioned Ipsos Brand Building on Mobile Survey, U.S., December 2015 n=1000, 18-54 year olds
  6. Google/Ipsos, "Consumers in the Micro-Moment," Wave 3, U.S., n=1291 online smartphone users 18+, August 2015
  7. Source: Google Search Data, Apparel, Home & garden, Beauty & personal care, Computers & electronics, Gifts, Toys & games, Photo & video, Nov-Dec 2014 vs Nov-Dec 2015, United States
  8. YouTube data, U.S., Classification as a “Product Review" video was based on public data such as headlines and tags, and may not account for every such video available on YouTube, Nov - Dec 2014 and Nov - Dec 2015
  9. Google Search Data, Apparel, Home & garden, Beauty & personal care, Computers & electronics, Gifts, Toys & games, Photo & video, Nov-Dec 2014 vs Nov-Dec 2015, United States
  10. Google/Purchased Digital Diary: How Consumers Solve Their Needs in the Moment, May 2016, Representative sample of US Smartphone users = 1000. Local searchers = 634, Purchases = 1,140
  11. Google/Euromonitor International, Micro-Moments Survey, US, July 2016, Smartphone shoppers = 1000
  12. Google Analytics Shopping category data, Nov 1, 2015–December 14, 2015, United States


Spotlight on Data Studio: Beautiful Reports and Collaboration Just Got Easier

We launched Google Data Studio (beta) in the U.S. earlier this year, and last week, we expanded availability to 21 additional countries.* We’re excited to offer Data Studio to companies across the globe so they can easily create and share reports and dashboards, and ultimately use insights and collaboration to make better business decisions.

Organizations today collect an increasingly large amount of data. In a world of web analytics, CRM systems, and third-party sources, data-driven decisions should be easier than ever before. However, all of this data has presented a significant challenge: making it easily accessible and useful.

Having multiple data sources that live in silos within your organization compromises your ability to spot critical business opportunities and issues when they matter most. This is a widespread challenge, with 84% of marketers saying they don’t believe their data sources are well-integrated, according to a 2016 Forrester study.

Data Studio solves this problem by allowing you to easily connect your data and create beautiful, informative reports that are easy to read, easy to share, and fully customizable. Create up to five custom reports with unlimited editing and sharing. All for free.

Get started today so you can:

  • Put all your data to work. Easily access the data sources you need to understand your business and make better decisions.
  • Transform your data. Quickly transform raw data into easy-to-follow reports and dashboards — no code or queries required.
  • Build engaging reports and dashboards. Data Studio gives you the ability to create meaningful, shareable charts and graphs that bring your data to life.
  • Leverage teamwork that works. Work together quickly, from anywhere, by sharing reports via Google Drive.

Not sure where to start? Good news: We’re releasing our first batch of templates today to remove that hurdle. Businesses can use a library of templates to get up and running in a matter of minutes.



Get started for free.

Happy reporting!
The Data Studio team

*Canada, Brazil, Germany, Netherlands, Spain, France, United Kingdom, Italy, Indonesia, India, Japan, South Korea, Australia, Hong Kong, Malaysia, New Zealand, Philippines, Singapore, Thailand, Taiwan, Vietnam

Posted by Kevin Fields, Product Marketing Manager, Data Studio

Which TV Ads Made the Podium During the 2016 Olympics?

Note: Now that the 2016 Games are over, we've updated the analysis from the original opening ceremonies post to look at TV ad performance for the entire Olympics.


When the 2016 Olympics kicked off almost three weeks ago, many TV advertisers were crossing their fingers that their strategy would pay off.  Reaching as many as an estimated 27.9 million total viewers in the U.S., they were hoping their ads delivered relevant and compelling creative to the right audiences.  To answer the pay-off question, advertisers will predominately look at three specific areas of performance:
  1. Which ads were noticed by the audience?
  2. Which ads drove interest, shifted perception, and increased intent?
  3. And, which ads drove actual consumer response?
To get some insights into these questions, Google evaluated the top 12 brands totaling over 3.5 billion impressions that aired ads during the NBC broadcasts of the event.  The analysis is based on a combination of consumer surveys and second-screen (mobile, desktop, and tablet) response data. Presented in a live Google Data Studio dashboard, the result is a unique view into the full-funnel performance of the ads evaluated.

Awareness

Commercials during large, live sporting events like the Olympics are often uniquely created to leverage both the scale of the audience and the context of the event.  Whether it is telling the personal story of an athlete or playing to our passions like patriotism, they are intended to strike an emotional connection, entertain us, or make us stand up and take notice.

Nike's "Unlimited" ads were the big winner with almost 35% of respondents having remembered seeing the ads when prompted. Including an ad with the first quadruple amputee to summit Mount Kilimanjaro, Nike's powerful ads outpaced typical recall rates in the 20%-25% range.  Coca Cola was a close second with their "That's gold" ads which mixed Olympic competition with everyday moments.  Tide, McDonald's, and Samsung rounded out the top five with respectable recall rates. On overage, ad recall rates for the top five improved 3% percentage points from the initial analysis following the opening ceremonies.
Olympics Ad Recall
Almost 35% of respondents remembered seeing the Nike ads.
Additionally, of those respondents recalling the ad, only 37% could recall the specific product or service featured in the ad.  The net is that only about 13% of viewers can recall both the brand and product in a specific advertisement.  Tide's"Small can be powerful" ad with Simone Biles had the highest product recall rate at just over 50%.

Interest

Advertisers also want the ad to shift perceptions and create interest in the product or service featured.  By surveying both viewers who did not see the ad (unexposed) and those who did see the ad (exposed), we are able to get insights into the impact of each ad’s messaging and creative. Overall, the results were impressive.  On average, respondents who saw the ads were 27% more positive about the associated brands than those who did not.  Likewise, respondents who saw the ads were 32% more likely to find out more and/or purchase the product being advertised.

Compared to the lift measured during the opening ceremonies, both favorability and intent increased significantly over the span of the Olympics increasing ten and twelve percentage points respectively.
Ad Lift in Favorability and Intent
Consumers who saw the ads, were on average, 25% more positive about the brand and were 28% more likely to find out more or purchase the product in the ads.
Interestingly, the baseline favorability and purchase intent for both non-sponsors and Olympic sponsors are relatively equal.  However, non-sponsors saw a greater lift than sponsors with three more percentage points for favorability and seven more percentage points for intent.

Desire

These commercials don’t just make us laugh or make us feel better about the brand — they also make us search and visit websites. Second-screen searching—whether it’s to re-engage with the ad or to learn more about the product — is a powerful indication of desire.  By measuring incremental search queries on Google during the broadcast that are specific and modeled to be attributable to ads shown, we are now able to include responses in our analysis.  During the broadcasts, TV ad driven searches were almost exclusively on mobile — 83% compared to an average of 55% for those brands when the ads were not airing.  For brands, that means a presence on the TV screen isn’t complete without a strategy for small screens, as well.
"83% of searches on Google as a result of seeing the ads occurred on phones and another 10% occurred on tablets making a second screen strategy key to TV advertising."
BMW featured multiple products including a "Performance wheelchair" and garnered the top spot on the podium with a response strength index of 3.21.  McDonald’s and Samsung fought it out for the silver and bronze with 2.01 and 1.57 respectively.  The answer to the question “Do emotional ads work as well as product ads?” is, in this instance, “Yes.”  Both emotional and product ad creatives drove 50% more searches on average.  Also interestingly, ads by non-sponsors drove 17% more searches than their sponsor counterparts.
Indexed Ad Driven Response
Compared to the average of the top 12 ads studied, BMW drove 3.2 times more searches.
Finally, Coca Cola was the overall winner with strong full-funnel performance placing in the top three across all three funnel stages.

Whether people are tuning into the Olympics or their favorite TV show, they use their smartphones to search for information triggered by what they’re seeing.  In these micro-moments, advertisers need to be there, be useful, and be accountable.  That means if you advertise on TV, you can now get a new view of performance across each stage of the funnel — using a combination of consumer surveys and digital response, all in a matter of days.  Armed with these new insights, advertisers are now able to better understand and improve the performance of these investments in concert with their digital media.

Sourcing

Using Google Consumer Surveys to provide consumer ad awareness and interest research, an online survey was conducted in the United States during the period 8/19 - 8/21/16 using a validated, representative sample with a minimum of 700 respondents.  Response data is based on incremental TV ad-driven search queries (Google) during the course of the broadcast that are specific to the ad shown and are modeled by Google Attribution 360 to be attributable to the airings of the commercials. Response data is normalized for total ad impressions during the broadcast for each advertiser.

Happy Analyzing,

Posted by Casey Carey, Director of Marketing, Google Analytics

Data Studio: New Google Cloud SQL and MySQL connector

Our vision for Google Data Studio is to enable customers to access, visualize, and share all their data, regardless of where that data resides. Today we are adding support for the popular Google Cloud SQL and MySQL databases. This is the beginning of making your first party data available through Data Studio.

Using the new Google Cloud SQL and MySQL connector, you can now access the data in your database to create amazing reports and dashboards. 

Example report accessing sales data by sales person from MySQL database 

To use the connector, select one of our new connectors. 
List of connectors now includes Cloud SQL and MySQL

Specify your database name, URL, username, and password, and click connect. 
Configuration screen to access your SQL database 

Visualizing data has never been easier! These new connectors are now available to all Data Studio users. Learn more about the connector in our MySQL Connector and Google Cloud SQL Connector help documentation.

Need a new connector in Data Studio? 
Is there a specific data service you wish to be able to access and visualize through Data Studio? Let us know through this Data Studio connector feedback form so we can prioritize and make it happen!

Posted by Anand Shah and Nick Mihailovski, Product Managers