Category Archives: Data Studio

Data Studio: Richer Visualizations and Analytical Functions

The Data Studio team has been hard at work launching new features to allow for richer visualization and new views on data. Today, we'll highlight some of these recent launches.

Pivot Tables

Pivot tables let users narrow down a large data set or analyze relationships between data points. Additionally, they reorganize user's dimensions and metrics to help quickly summarize data and see relationships that might otherwise be hard to spot.

Example Pivot Table (Help center doc here)

Coordinated Coloring

Coordinated coloring allows users to bind colors to specific data. When a user creates visualizations, Data Studio automatically binds colors to data, so that color:data pairs stay consistent between visualizations and when filtering. This feature is automatically turned on for all new reports, and available in old reports.

Example Coordinated Coloring (Help center doc here)

Google Analytics Sampling Indicator

Google Analytics samples data in order to provide accurate reporting in a timely manner. Data Studio now shows a sampling indicator in Data Studio reports when a component contains sampled Analytics data.

GA Sampling indicator (Help center doc here)

Field Reports Editing

Data Studio has also recently added new options to the chips in reporting. These new options allow you to:
  • Rename fields
  • Change aggregation types
  • Change semantic types
  • Change date functions
  • Apply % of total, difference from total, or percent difference from total to a metric from within the report.
Example of new field editing options (Help center doc here).

Submitting and voting for new features

The Data Studio team will continue to introduce new features and product enhancements based on your submissions. You can view requests submitted by other users, upvote your favorites, or create new ones. Learn more here.


Referensi: Google Analytics Blog - Data Studio: Richer Visualizations and Analytical Functions.


Google Data Studio: quicker and broader access to data

Over the past 6 months we’ve launched over 25 new features in Google Data Studio including: making the product free and available globally, adding support for PostgreSQL and MySQL, and providing many new report layout options. Overall feedback has been great!

Now we’re adding new features to make it quicker to access your data.

Community Connectors Developer Launch
We want to make it easy to access all your data within Data Studio. Today we are launching a new Data Studio “Community Connectors” developer program allowing you to visualize data from any source.

Community connectors are created using Google Apps Scripts and are easy to build! (our UX team even built one to monitor bitcoin prices). Once created, a connector can be shared with other users, who can use the connector to access their own data.

Today we have over 10 partners who have built connectors to over 200 sources and we’re excited to welcome more developers and data providers to the Data Studio community.  Check out the Community Connector Gallery to explore what our partners built.

Data Studio Community Connector Gallery

Embedded Reports

Many customers want to bring Data Studio reports into their workflows or publish Data Studio reports on their own website. Now you can embed Data Studio reports in your websites and apps using simple iframe embedding. To see your report in your site, edit it, select Report > File > Embed report, then put the HTML code snippet into an iframe. Embeds can be fully interactive, and support both private, public, and non-logged in access, giving you fine-grained control over who can see your data.This new capability will allow you to share compelling data stories through your public websites and blogs, or share critical insights using your own business applications for no additional cost.


Data Control
Large organizations and agencies often have access to many accounts; for example, thousands of AdWords accounts, or hundreds YouTube channels. To simplify reporting, the new data control allows you to reuse a single report across all your accounts, dramatically reducing the time it takes to view data in a report. The data control can also be used to templatize reports, allowing viewers to see their data in a report without having to create anything in Data Studio. The data control supports the following connectors: AdWords (Account & MCC), YouTube Analytics, Search Console, DoubleClick Campaign Manager, and Google Analytics.e plan to add support for more connectors in the future.


Data Studio report with AdWords, Search Console, YouTube, and DoubleClick Data Controls

And a few other updates
We’ve also added a couple of additional capabilities. You can now export any chart data directly to Google Sheets. We added a new Google Cloud Storage connector, making it easy to use Data Studio with your data in Google Cloud Storage. We’ve added SSL support for the MySQL connector. We’ve added the ability to see the totals in the table visualization. And finally, we’ve made the product available in Russia.

These announcements make accessing your data within Google Data Studio easier than ever. We’re excited to see what people do with them. For more information, check out:


Thanks!

Posted by Nick Mihailovski, oh behalf of the entire Data Studio team


Referensi: Google Analytics Blog - Google Data Studio: quicker and broader access to data.


Google Data Studio: New Feature Roundup

The Data Studio team is constantly working on new features to improve the user experience for both report creators and viewers! In this blog post we’ll highlight some recent launches that you may have missed.

Filter controls: search 
Filters give report viewers a powerful way to slice data by specific segments. But filters with hundreds or even thousands of possible values to choose from were previously difficult to use, requiring scrolling through very long lists of filter items. We recently added a search feature within the filter component, letting users quickly find and select or deselect specific items.


Filter controls: single-select 
There are also scenarios when it only makes sense to filter a report on a single value, as filtering on multiple values would return confusing or nonsensical data. Report creators now have the ability to configure filters to allow for single-selection only.


Combo charts
New Combo charts allow users to create a line chart with a non-time-based dimension on the X-axis (previously only time-based dimensions were supported). The new component can plot a single dimension with up to 5 metrics, or 2 dimensions with a single metric. Learn more about Combo charts here.


Links in tabular data 
Tables in Data Studio reports can now display clickable links! This feature introduces a new type of interactivity, as viewers can now be redirected to to relevant content outside the report. To use this feature, report owners must use a data source containing a column of URLs. Data Studio will detect this column and assign it to the URL field type (if automatic detection does not work data source owners can also set the field type to URL manually). Learn more about this here.


Submitting and voting for new features
The Data Studio team will continue to introduce new features and product enhancements. Have a feature request? You can view requests submitted by other users, upvote your favorites, or create new ones. Learn more here.

Posted by Alon Gotesman, Product Manager, Google Data Studio

Referensi: Google Analytics Blog - Google Data Studio: New Feature Roundup.


New Data Studio Data Control

Today we’ve made it dramatically easier to view your Google Analytics data in Data Studio using the new Data control. When a report is created using the Data Control, all viewers can see their own data in the report, without creating anything.

Check out these quick video to see this feature in action
Try it out now! 
We added the Data control to these templates so you test it out with your data:  

Overview Report

Ecommerce Template

This feature is great if you:
Are an agency or large organization with access to many Google Analytics views and do not want to create a Data Studio report for each view. For example, if you have a set of charts and data you monitor every day, you can now build a report in Data Studio with those charts and data, add the Data Control, and quickly go between any of the views you have access to, allowing you to monitor your entire business very fast.

Are a large organization with many websites across: different brands, different regions, or different business units, and want to unify reporting and KPIs across your entire organization. Now you can build a template report in Data Studio, add the Data Control, and share the report across your organization. Every user will be able to see their data, in your curated report.

The data control is public for all users.

Read the Help Center for more details on how to use it.

If you build an exciting report, please submit to our gallery, so we can showcase it.

Posted By Nick Mihailovski, Product Manager, Data Studio 

Referensi: Google Analytics Blog - New Data Studio Data Control.


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

Referensi: Google Analytics Blog - Data Studio now globally available.


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

Referensi: Google Analytics Blog - Data Studio: Enhanced AdWords MCC Support.


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

Referensi: Google Analytics Blog - Data Studio: Search Console Connector.


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

Referensi: Google Analytics Blog - Making Google Data Studio Free for Everyone.


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.



Referensi: Google Analytics Blog - 3 Ways to Better Support Marketing Decisions with Data.


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


Referensi: Google Analytics Blog - Data Studio: DoubleClick Campaign Manager Connector.