Menus and Metrics - Using Google Analytics as a data source
The Google Analytics data connector is one of the most important features to be added to Klipfolio Dashboard in some time. This feature makes it easy to create a data source using Google Analytics data -- just select items from a menu to query your Analytics account. The best part is that the data source you retrieve is automatically updated, so that when you use it to create a data visualization in your Google Analytics dashboard, the data shown in that report will always be shown in real-time.
Creating a data source using Google Analytics
Here's a brief overview of the steps required to create a data source using Google Analytics:
- Start the data source creation process
- Retrieve your Profile ID
- Craft the query
Step 1: Start the process
Klipfolio Dashboard walks you through a basic step-by-step each time you create a data source. If your data source is web accessible (like Google Analytics), you'll likely need some form of authentication. In the case of Google Analytics, you need to create an OAuth Token. Here's the basic steps you need to follow:
1. On your dashboard, click the Library link.
2. Select the Data Sources tab.
3. Click the Set Up a New Data Source button.
4. Select the Google Analytics option.
Now you need to select valid credentials. If you don't have any, follow the next 3 steps.
5. Click the Sign in to your Google Account button.
6. Sign in to your Google Analytics account.
7. Grant Klipfolio Dashboard access to your Google Analytics account (on your behalf).
Step 2: Retrieve your Profile ID
This step requires you to access your Google Analytics account to retrieve the profile ID of the web property (website) from which you want to retrieve data. You can find the profile ID at the end of the URL in the Google Analytics reporter. It is the last 8-digits after the "p" in the URL. You will need to copy this ID to your clipboard and paste it in the appropriate field back in Klipfolio Dashboard.
Step 3: Craft the query
This is the fun part. Let's start with the difference between a dimension and a metric. A dimension "describes" the data while a metric provides a raw value. For instance, if you select the dimension ga: month and the metric ga: visits, your data source will show the number of visits for each month within the time period specified.
Once you have this figured out, you can start to experiment with the extensive list of metrics and dimensions provided in the drop-down menus. However, we do recommend that you limit the amount of items you include in your query since this may create an overly complicated data set that is difficult to visualize effectively.
Subscribe to Happy Dashboarding
Learn the art and science of building world-class dashboards