Power My Analytics
We have two methods for powering your data - both of which are optional.
You can download the data from a SQL data source.
You can build your own data source from scratch.
Downloading a Data Source
If you’d like to download the data for your dashboard, follow these steps.
First, you need to create a new data source in Google Analytics, such as a table you’ve already created in Google Sheet. This will be a custom table, which means it will store data not found in the usual Google Analytics table, such as data from AdWords or DoubleClick.
Next, you’ll create an API query in Google BigQuery. You’ll be setting some parameters to customize the report.
When you’re ready, hit the Export button on the API explorer, copy the credentials from the API explorer, and paste them into the BigQuery import query.
After it runs, your data is available for download in your Google Drive folder.
Using a Pre-made Data Source
If you want your data in Google Analytics right now, there’s a much easier way to do it.
We’ve made a way to pull from any table you’ve already made in Google Analytics and automatically generate it in BigQuery, so you don’t need to change anything about your data source.
Just click the button to start downloading.
If you’d like to see how it works in the video below:
Google Analytics Dashboard PowerUp
Google Analytics Dashboard PowerUp is a free extension for Google Analytics dashboards. You can customize which data you want to see in your charts and graphs, how your graphs and charts are powered, and how your report is segmented.
Configure Data Sources
By default, your data is pulled from a SQL data source. The data source is created for you in Google Analytics. You can customize the types of reports you want to see, what columns are available, and the filters for your data.
There are two types of data sources available for Google Analytics:
Data sources from Google CloudSQL. These are the classic data sources and work just like they did in the past.
Data sources from BigQuery. BigQuery is a Google Data store and has many of the same features that SQL Data sources have, but Google Analytics can take advantage of BigQuery’s real-time SQL processing and flexible query structures to speed up analysis. BigQuery provides a powerful and scalable solution for managing your analytical data.
Data Source Types
Data Sources from SQL - These data sources work like their classic SQL counterparts. There’s a unique name assigned to your data source, and the data can be filtered, ordered, and manipulated like a SQL table.
Data Sources from BigQuery - Data sources from BigQuery work like Google Analytics, but provide access to all the features of BigQuery instead of the old and not very useful features of SQL. There’s a unique name assigned to your data source, and the data can be filtered, ordered, and manipulated.
Customized reports
You can select all or just some of the columns available from your table. You can sort the table and choose how to display data in your charts and graphs.
You can also define what date or range your data applies to.
Configure the Chart Type
Google Analytics lets you choose which charts you’d like to show in your dashboard. You can choose between bar, line, or pie chart types.
Chart Filters
You can choose to see data that meets a specific set of criteria. For example, you could only see data from a particular country.
Chart Order
You can choose whether you want the rows of the table