Building a dashboard with the Google Analytics Spreadsheet Add-on

Building a dashboard with the Google Analytics Spreadsheet Add-on

Google Analytics Dashboard with Google Sheets (Reporting API)

Google Analytics Dashboard with Google Sheets (Reporting API)

http://measureschool.com/dashboard Supermetrics - http://supermetrics.com/?aff=1014 Google Analytics Dashboard and custom Reporting functionality are not always flexible enough. That’s why Digital Analyst prefer to export the data out of GA (via the Reporting API) and manipulate the data in other Tools. In this video, we’ll take a look at how you can accomplish all these with Google Sheets and a Plugin called Supermetrics. #GoogleAnalyticsDashbaords #GoogleSheets #Measure Tools mentioned: Klipfolio - http://klipfolio.com/ Tableau - http://www.tableau.com/ R - https://www.r-project.org/ Google Sheets - https://www.google.com/sheets/about/ Supermetrics - http://supermetrics.com/?aff=1014 GA Reporting API - https://developers.google.com/analytics/devguides/reporting/ Query Explorer - https://ga-dev-tools.appspot.com/query-explorer/ ******* Free Email course: http://measureschool.com/emailcourse Free Resource Library: http://measureschool.com/resources More Measure Courses: http://measureschool.com/products πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ ******* . . RECOMMENDED MEASURE BOOKS: https://kit.com/Measureschool/recommended-measure-books GEAR WE USED TO PRODUCE THIS VIDEO: https://kit.com/Measureschool/measureschool-youtube-gear

Use Google Sheets for Tracking and Analytics πŸ“‰πŸ“ŠπŸ“ˆ

Use Google Sheets for Tracking and Analytics πŸ“‰πŸ“ŠπŸ“ˆ

Google Sheets is an awesome cloud-based Spreadsheet App that you can use to do analyse data. But it can also be use as a light-weight tracking solution. We can send data in and store it in a spreadsheet - In this video we are going to show you how MENTIONED LINKS Google Sheet Dashboard for GA https://www.youtube.com/watch?v=EujLlA7MM-c Pass dynamic data to Google Sheets using Google Tag Manager http://www.ganotes.com/pass-dynamic-data-to-google-sheets-using-google-tag-manager/ GTM Ressource Guide: http://measureschool.com/guide Free GTM Beginner course: https://measureschool.com/emailcourse Courses: http://measureschool.com/products πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ . . RECOMMENDED MEASURE BOOKS: https://kit.com/Measureschool/recommended-measure-books GEAR WE USED TO PRODUCE THIS VIDEO: https://kit.com/Measureschool/measureschool-youtube-gear

Introduction to the Google Analytics Spreadsheet Add-on

Introduction to the Google Analytics Spreadsheet Add-on

How to Create Custom Reports Using the Google Analytics API

How to Create Custom Reports Using the Google Analytics API

Recently, I tried to create a very specific Google Analytics Custom Report for ecommerce. Unfortunately, the Google Analytics interface couldn't handle our request. (Read full article - https://goo.gl/YxV9ro) Sign up for Free Google Analytics Course - https://goo.gl/9GnLyk Because of that lack of success, I had to go back to the drawing board. There was promise in the Google Analytics API explorer that I might be able to create this particular report using the GA API. But I wasn't going to build the report if you weren't interested in the subject matter. So, I offered to journey inside the Google Analytics API if you left enough comments. The votes were tallied, and here we are with the second part of our Google Analytics exploration! Here's we where started with our with custom report conundrum: We were trying to solve a reporting problem for one of our Analytics Course students, Helgi. Helgi needs a custom ecommerce report that includes quantity of product, revenue, the product purchased, and e-commerce conversion rate all in one report. Unfortunately, creating this custom report in the standard Google Analytics interface did not work. Google Analytics couldn't put all these metrics together in the custom report builder because these metrics and dimensions had different scopes. We used the Metric and Dimension Explorer to see if this report was even possible. The conclusion was, we might be able to use the Google Analytics API to build this report. Should we try this again in the Google Analytics API? At the end of our last tutorial, I asked you "Do you want to learn how to use the Google Analytic API." And you answered with a resounding "YES!" Because of your enthusiasm and support... Today we are going inside of the Google Analytics API to learn how to build custom reports! Building custom reports in the Google Analytics API The easiest way to build reports in the API is with the Google Sheets Add-on. Using the Google Sheets Add-on to work in the API You can navigate to the Google Analytics Spreadsheet Add-on here -https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on. Once you click through to install the Add-on, you'll get a blank spreadsheet. This spreadsheet is where we 'll build our custom report. In the Add-ons menu of your Google Sheet select "Create a new report." Building custom reports in the Google Sheets Add-on Creating a new report will bring up a menu on the left-hand side of your screen. In this menu, you can choose the property you want to work in. The Google Merchandise Store (GMS) is already populated with the product and sales data we need. We'll start by trying to build our report in the GMS account. The report menu is also where you select the metrics, dimensions, and segments you want in your report. The metrics we want in our report include quantity of product, revenue and conversion rate. We also need the dimension: product. Once your metrics and dimensions are set, you can select "Create Report." Configure your custom report Creating the report will add a configuration tab to your spreadsheet. This tab shows you the parameters of your report. It does not contain your data. Run your report To see our data, we need to select "Run reports" from the Google Sheets Add-ons menu. Permission levels for the Google Analytics API Unfortunately, attempting to run this report returned an error message. We don't have high enough permission to work in the GMS account using the API. To create this report I need to use an account where I have the right permission level. (To learn all about Google Analytics permission and access level see our Analytics Course permissions guide.) So we'll have to go back to square one. I'll switch over to an account that I have full access in and try to create our report again. Jumping from one property to another in the API is pretty quick and painless. Error messages and problem solving When I run our report from an account where I have full access in, I get shut down again. This time the error message says: "Selected dimensions and metrics cannot be queried together." Now, I could have edited our failed attempts to run this report out of this post and just said - "this isn't possible." But there's an important lesson here that I wanted to share with you. Sometimes you don't absolutely know what you can and can't do until you try. And... Just because you can dream it, doesn't mean Google Analytics can do it Not everything you can think up is something you can do in Google Analytics. In our previous post on custom reports, we used the dimensions and metrics explorer to see if this report was even possible. Google told us it was possible, so we moved to the next stage. Not all metrics and dimension work together, even in the API In this tutorial, we configured our report using the Google Analytics API. Read full article - https://goo.gl/YxV9ro

Quick Data Analysis with Google Sheets | Part 1

Quick Data Analysis with Google Sheets | Part 1

Spreadsheet software like Excel or Google Sheets are still a very widely used toolset for analyzing data. Sheets has some built-in Quick analysis features that can help you to get a overview on your data and very fast get to insights. #DataAnalysis #GoogleSheet #measure πŸ”— Links mentioned in the video: Supermetrics: http://supermetrics.com/?aff=1014 GA Demo account: https://support.google.com/analytics/answer/6367342?hl=en πŸŽ“ Learn more from Measureschool: http://measureschool.com/products GTM Copy Paste https://chrome.google.com/webstore/detail/gtm-copy-paste/mhhidgiahbopjapanmbflpkcecpciffa πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ πŸ“š Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books πŸ“· Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear Our tracking stack: Google Analytics: https://analytics.google.com/analytics/web/ Google Tag Manager: https://tagmanager.google.com/ Supermetrics: http://supermetrics.com/?aff=1014 ActiveCampaign: https://www.activecampaign.com/?_r=K93ZWF56 πŸ‘ FOLLOW US Facebook: http://www.facebook.com/measureschool Twitter: http://www.twitter.com/measureschool

Google Analytics API in Your Website

Google Analytics API in Your Website

In this video tutorial I'll show you, how you can integrate Google Analytics in your website dashboard. Google Analytics API V4 URL: https://developers.google.com/analytics/devguides/reporting/core/dimsmets Don't forget like and share this video & subscript to my channel! Created by Arthur Mann. http://arthur.systems/ Β© 2017

Report Like a Boss Using Google Data Studio

Report Like a Boss Using Google Data Studio

Join Data Studio Product Manager Nikhil Roy and Google Analytics Advocate Louis Gray live from Google HQ on August 17th to learn about how to design and deliver exceptional reports in Google Data Studio.

Combine Data Sources in Google Data Studio | Lesson 2

Combine Data Sources in Google Data Studio | Lesson 2

In this lesson we're going to setup our data sources in Google Sheets with the help of Supermetrics. We're going to pull data from Facebook Ads and Google Analytics and prepare it to later be used in Google Data Studio. Google Sheets combined with Supermetrics is a great way to control data that later goes into our data dashboards - it gives you the possibility to change data around, clean it up and even combine data sources (which is not possible in Google Data Studio itself). Previous video: http://bit.ly/2f4FgZl #GoogleDataStudio #DataSources #DataVizualisation πŸ”— Links mentioned in the video: Google Data Sheet: http://bit.ly/2tUX3EF Full Playlist: http://bit.ly/2hkwUx4 Coding is for Losers: http://codingisforlosers.com/ Ben Collins: http://benlcollins.com/ The Dashboard Plan: https://measureschool.com/dashboardplan Google Data Studio:http://bit.ly/2bcb7zt Google Sheets: http://bit.ly/1GAUvK5 Supermetrics: http://bit.ly/2hmxvOR πŸŽ“ Learn more from Measureschool: http://measureschool.com/products GTM Copy Paste https://chrome.google.com/webstore/detail/gtm-copy-paste/mhhidgiahbopjapanmbflpkcecpciffa πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ πŸ“š Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books πŸ“· Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear πŸ‘ FOLLOW US FACEBOOK: http://www.facebook.com/measureschool TWITTER: http://www.twitter.com/measureschool

Google Data Studio Tutorial 2017 πŸ“Š - How to build a Dashboard with GDS

Google Data Studio Tutorial 2017 πŸ“Š - How to build a Dashboard with GDS

Google Data Studio can help you import data from different sources and visualize them on a dashboard you can share with the world. In our tutorial, we are going to show you how to build such a dashboard including the visualizations you can use, how to import data and build in interactivity features. The Dashboard we built: https://goo.gl/A0wdVU GA Demo Account: https://support.google.com/analytics/answer/6367342?hl=en Google Data Studio Gallery: https://datastudiogallery.appspot.com/ Data Studio Video Tutorials (Google): https://support.google.com/360suite/datastudio/answer/6390659?hl=en&ref_topic=6267740 6 Advanced Techniques to master GDS: http://www.benlcollins.com/dashboard/google-data-studio-tips/ GTM Ressource Guide: http://measureschool.com/guide Free GTM Beginner course: https://measureschool.com/emailcourse Courses: http://measureschool.com/products πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ . . RECOMMENDED MEASURE BOOKS: https://kit.com/Measureschool/recommended-measure-books GEAR WE USED TO PRODUCE THIS VIDEO: https://kit.com/Measureschool/measureschool-youtube-gear

Top Videos -  loading... Change country
Load 10 more videos
 
Latest Searches
 
Sorry, You can't play this video
00:00/00:00
  •  
  •  
  •  
  •  
  •  
  •  
  •  
CLOSE
CLOSE
CLOSE