CBPO

Tag: Studio”

A summary of Google Data Studio: Updates from April 2019

May 14, 2019 No Comments

April was a big month for Google Data Studio (GDS), with Google introducing some significant product updates to this already robust reporting tool.

For those not familiar with GDS, it is a free dashboard-style reporting tool that Google rolled out in June 2016. With Data Studio, users can connect to various data sources to visualize, and share data from a variety of web-based platforms.

GDS supports native integrations with most Google products including Analytics, Google Ads, Search Ads 360 (formerly Doubleclick Search), Google Sheets, YouTube Analytics, and Google BigQuery.

GDS supports connectors that users can purchase to import data from over one hundred third-party sources such as Bing Ads, Amazon Ads, and many others.  

Sample Google Data studio dashboard

Source: Google

1. Google introduces BigQuery BI Engine for integration with GDS

BigQuery is Google’s massive enterprise data warehouse. It enables extremely fast SQL queries by using the same technology that powers Google Search. Per Google,

“Every day, customers upload petabytes of new data into BigQuery, our exabyte-scale, serverless data warehouse, and the volume of data analyzed has grown by over 300 percent in just the last year.”

BigQuery BI Engine stores, analyzes, and finds insights on your data Image Source: Google

Source: Google

2. Enhanced data drill-down capabilities

You can now reveal additional levels of detail in a single chart using GDS’s enhanced data drill down (or drill up) capabilities.

You’ll need to enable this feature in each specific GDS chart and, once enabled, you can drill down from a higher level of detail to a lower one (for example, country to a city). You can also drill up from a lower level of detail to a higher one (for example, city to the country). You must be in “View” mode to drill up or drill down (as opposed to the “Edit” mode).

Here’s an example of drilling-up in a chart that uses Google’s sample data in GDS.

GDS chart showing clicks by month

Source: Google

To drill-up by year, right click on the chart in “View” mode and select “Drill up” as shown below.

GDS chart showing the option to “Drill up” the monthly data to yearly data

Visit the Data Studio Help website for detailed instructions on how to leverage this feature.

3. Improved formatting of tables

GDS now allows for more user-friendly and intuitive table formatting. This includes the ability to distribute columns evenly with just one click (by right-clicking the table), resizing only one column by dragging the column’s divider, and changing the justification of table contents to left, right, or center via the “Style” properties panel in “Edit” mode.

Example of editing, table properties tab in GDS

Source: Google

Detailed instructions on how to access this feature are located here.

4. The ability to hide pages in “View” mode

GDS users can now hide pages in “View” mode by right clicking on the specific page (accessed via the top submenu), clicking on the three vertical dots to the right of the page name, and selecting “Hide page in view mode”. This feature comes in handy when you’ve got pages you don’t want your client (or anyone) to see when presenting the GDS report.

The new “Hide page” feature in GDS

Source: Google

5. Page canvas size enhancements

Users can now customize each page’s size with a new feature that was rolled out on March 21st (we’re sneaking this into the April update because it’s a really neat feature).

Canvas size settings can be accessed from the page menu at the top of the GDS interface. Select Page>Current Page Settings, and then select “Style” from the settings area at the right of the screen. You can then choose your page size from a list of pre-configured sizes or set a custom size of your own.

GDS Page Settings Wizard

Source: Google

6. New Data Studio help community

As GDS adds more features and becomes more complex, it seems only fitting that Google would launch a community help forum for this tool. So, while this isn’t exactly a new feature to GDS itself, it is a new resource for GDS users that will hopefully make navigating GDS easier.

Users can access the GDS Help Community via Google’s support website or selecting “Help Options” from the top menu bar in GDS (indicated by a question mark icon) then click the “Visit Help Forum” link.

The Help menu within GDS

Source: Google

Conclusion

We hope that summarizing the latest GDS enhancements has made it a little easier to digest the many new changes that Google rolled out in April (and March). Remember, you can always get a list of updates, both new and old by visiting Google’s Support website here.

Jacqueline Dooley is the Director of Digital Strategy at CommonMind.

The post A summary of Google Data Studio: Updates from April 2019 appeared first on Search Engine Watch.

Search Engine Watch


Introducing the Data Studio Community Connector Codelab

May 12, 2018 No Comments

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.


Google Analytics Blog


Data Studio: Richer Visualizations and Analytical Functions

February 3, 2018 No Comments
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.


Google Analytics Blog


Open Source Community Connectors for Data Studio

January 27, 2018 No Comments

More than six hundred developers have signed up for developer access to Data Studio Community Connectors since the Developer Launch. Community Connectors give developers an opportunity to come up with innovative solutions for data access and broaden the scope of data sources users can connect to.

Based on community feedback, we recognized that many of you are looking to share your work on connectors with the community. Also, developers are looking for more examples to follow. With these community needs in mind, today, we are announcing the Open Source Community Connectors repository on GitHub.

Use open source Community Connectors

For every connector that is hosted in the open source repository, the Data Studio Developer Relations team will manage a deployment for the connector’s latest code. This managed deployment will enable all users to immediately try the connector in Data Studio by simply clicking a link. Managed deployments also make it easier for developers since you do not have to deploy and maintain the connectors yourself; we’ll take care of this for you.

You can try out the following Open Source connectors directly in Data Studio:

Example dashboards using these connectors:


Learn about best practices

If you want to connect to new Data Sources using Data Studio but have not yet looked into Community Connectors, now would be the best time to start since a variety of example connector code have become available. These examples will give you a head start and create a platform for you to learn and share with other community members.

Initially, we are releasing these connectors in our open source repository:

Contribute to the community

If want to submit your own open source connector to the repository, you can send us a pull request. Alternatively you can maintain your own repository and link to that from the official repository.

This Git repository is a small start where we plan to make new additions. We have already seen other open source Community Connectors like data.world and getSTAT. We are hoping that initiative will help developers and users to create connectors to new Data Sources and thus make more data accessible in Data Studio. Developers can also collaborate with each other as well as report new issues and fix existing ones through these open source connectors.

This collaboration platform gives developers the option to leverage support from the community. If you want to develop your own connector but are unable to maintain it in the long run, you can add it to our repository so that the community can support it.

Visit the repository and start building your own Community Connector today!

Posted by Minhaz Kazi, Google Analytics team


Google Analytics Blog


Get the most out of Data Studio Community Connectors

December 5, 2017 No Comments

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.


Google Analytics Blog


Access all of your data with Data Studio Community Connectors

October 1, 2017 No Comments

Since the recent developer launch of Data Studio Community Connectors, users have been able to easily connect to and report on data from over 250 new sources.

Partners are also now leveraging Data Studio + Community Connectors as a free and powerful reporting and analysis solution for their customers, with minimal development investment.

We’ve already seen a number of interesting use cases. For example, ClickInsight, a Data Studio certified partner, used Community Connectors to create interactive experiences for the weather forecast in Toronto, the NY Times most popular stories, and real time departures info for the Bay Area Rapid Transit system. They embedded these Data Studio reports in a blog post for anyone to try, Are You Ready to Get Creative with Data Studio Connectors?

Try Community Connectors

We have been working with a growing number of partners that are making it easy for users to directly access all of their data in Data Studio. Partners such as AdStage, Analytics Canvas, CallRail, data.world, Funnel, PowerMyAnalytics, and Supermetrics have enabled easy access to 250 data sets including: Facebook Ads, MailChimp, LinkedIn, Instagram, Pinterest, Reddit, Amazon, and many more available through the Community Connector Gallery.

Data Studio Community Connectors Gallery

Easily build your own Community Connector

You can develop your own Community Connectors and use them in Data Studio reports and dashboards. Your connector can fetch data from sources such as:
We’ve made it easy to build your own connector by leveraging the Google Apps Script platform which provides a multitude of services and resources to quickly build and deploy connectors. 
To learn more about building a Community Connector visit Getting Started with Community Connectors and the Community Connector Developer Program.

Share, publish or open-source your Community Connector

The reports you create using Community Connectors can be shared with others. In addition, you can let other Data Studio users use your connector. For example, you can directly share your connector with colleagues at your organization or make your connector available for all Data Studio users to find by publishing your connector in the Community Connector Gallery.

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.
As we continue to improve the Community Connector features be sure to regularly check the Community Connector Gallery for new additions that will enable greater access to all of your data in Data Studio.

Posted by Pete Frisella, on behalf of the entire Data Studio team


Google Analytics Blog


Google Data Studio: quicker and broader access to data

September 13, 2017 No Comments
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. We 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, on behalf of the entire Data Studio team


Google Analytics Blog


How To Pair The New Supermetrics Native Connectors To Data Studio

September 11, 2017 No Comments

A how-to guide on pairing new Supermetrics connectors with Google Data Studio for more in-depth reporting with third-party data.

Read more at PPCHero.com
PPC Hero


Google Data Studio: New Feature Roundup

August 2, 2017 No Comments
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


Google Analytics Blog


New Data Studio Data Control

July 26, 2017 No Comments
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 


Google Analytics Blog