Display Google Analytics metrics in Geckoboard

In this article, we'll show how to use our Google Analytics data source to display data from your Google Analytics account on your Geckoboard dashboard.

Presets for Google Analytics widgets

Metric

Timeframe

Visualization

Sessions

Sessions

Past 7 days

Line chart

Users

Users

Past 7 days

Line chart

Page views

Page views

Past 7 days

Line chart

Bounce rate

Bounce rate

Past 30 days

Number (percentage)

Session duration

Session duration (average)

Past 30 days

Number (time)

Pages per session

Page views per session (average)

Past 30 days

Number

New sessions

Percentage of new sessions

Past 30 days

Number (percentage)

Goal completions

Goal completions

Past 7 days

Line chart

Goal conversion rate

Goal conversion rate

Past 7 days

Number (percentage)

Revenue

Revenue (total)

Past 7 days

Number

Conversion rate

Ecommerce conversion rate

Past 7 days

Number (percentage)

It is possible to edit these presets to present the data in a way that works for your needs. You can also select the option to Build your own widget and display other metrics, timeframes or ways of grouping or splitting the data.

Tip

Aggregating data from more than one property (for example, web and mobile) is beyond the scope this this data source.

Is this is your first Google Analytics widget?

When adding your first Google Analytics widget, you'll be asked to create a connection and authenticate your Google Analytics account so that we're able to collect your data and display it on the dashboard.

Our Google Analytics integration uses oAuth to connect to Google Analytics, so if you're already logged into Google Analytics on your browser, you will jump straight to the widget configuration screen after a few seconds.

If you're not logged in to Google Analytics, a popup window will appear and allow you to log in for account authorization.

You're now ready to configure your first Google Analytics widget!

Creating multiple Google Analytics connections

You may need to create Google Analytics widgets using a different account to the one you used to create your first Google Analytics widget.

Example

If you need to see data on the websites of both mycompany and yourcompany, you would need to connect separately to these accounts within Geckoboard.

In these cases, you can follow the instructions below to connect a different account or select it for the widget you're creating:

Make sure that you are only logged in to the correct Google Analytics account elsewhere in the browser or logged out of Google Analytics completely.

Hover your cursor over the empty dashboard square you would like to position your widget and click the + button.

Alternatively, click Add widget, located in the top right of your dashboard.

Search for Google Analytics using the Search sources field.

Alternatively, you can also scroll down the alphabetical list of integrations until you reach the Google Analytics integration.

Click on the Google Analytics integration.

Choose an option from the list of preset visualizations or select the option to Build your own widget from the bottom left of the list.

You will jump straight to editing your new widget on your dashboard.

Click on the Account field.

Select the connection you need or click on the Add connection option to make a new connection

Click on the Connect button.

If you're already logged into Google Analytics on your browser, you will jump straight to the widget configuration screen after a few seconds.

If you're not logged in to Google Analytics, a popup window will appear and allow you to log in for account authorization.

Build your own Google Analytics widget

The widget configuration panel enables you to select the metrics you want to show, as well as choosing the visualization you'd like to use and adding any filters to the data.

Your widget will update on your dashboard as you create it. This will use real data from your Google Analytics account.

Each time you make a change you'll see a thin green progress bar at the top of the widget to indicate whether we're still collecting this data.

To configure your Google Analytics widget, follow these steps:

Click the downward arrow  in the Metric field to select the Metric you'd like to display.

If you're creating a line or column chart, you may wish to compare more than one metric within the same chart. You can choose Add second metric from the bottom of the dropdown Metric menu to select extra metrics to visualize.Once this has been done you can use the Add metric button below the dropdown menu to add more metrics.

Tip

It is possible to compare up to 9 different metrics with a line chart and up to 3 different metrics with a column chart. You can also delete any metrics that you do not wish to include by clicking on the cross  to the right of the metric name.

Note

It is only possible for us to compare metrics which are measuring the same type of value. It is not possible to compare a percentage with a duration on the same chart, for example.

Select the visualization you want to use from the options below the metrics. Not all visualizations are available for all metrics or all combinations of metrics and filters.

Tip

Using appropriate visualizations can make a world of difference while consuming your dashboards and can help inspire action. We’ve created this handy flowchart which makes it easy to identify the best visualization for the metric you're looking to display.

Select a Time value that you'd like to see data for.

You can choose to track the Past 7, 14, 28, 30, or 90 days. You can also show the calendar day (Today) and This Week, Month, Quarter, or Year in progress. It's also possible to use a Custom timeframe.

Note

We always count the week as beginning on a Monday in this Google Analytics integration.

You may need to Group your data by a particular value in order to create a chart, leaderboard or table so that we know which values to use for rows or labels or for the horizontal axis of a chart. For example, it's possible to see many of these metrics calculated for particular locations, browsers or channel groupings, as well as showing them over time .

This option is expressed in different ways for different visualizations:

If you're creating a line or column chart, and haven't chosen additional metrics to compare, you may want to split the data, for example to show performance for particular channel groupings by number of new users over a set time period .

Tip

It is only possible to use the Split by option when looking at a single metric.

Warning

As with additional metrics, the maximum number of columns available is 3 and the maximum number of line chart series is 9. If more than this is available, you will not see all of the available data.

Add any optional Filters to refine this data and click on the Apply button.

When adding filters, you'll be taken to a new menu and can choose a filter from the dropdown options and a value that you'd like this filter to match.Most filters allow you to select that it is or is not a specific value or that the filtered option contains or does not contain a specific value.

Time based filters, such as Created at allow you to select a timeframe of the Past7, 14, 28, 30, or 90 days. Additionally, you can filter by Today and This week, Month, Quarter, or Year.

Example

If you'd like to see only pageviews from Europe, you could apply the filter Continent is and the option Europe, or you could apply the filter Continent is not and the options Americas, Asia, Oceania and Africa and (not set).

If necessary, enable the option to set a Goal and fill in your goal value. You can also specify whether it's a Less than or More than goal.

You can use the Fine-tune Menu to change the number of decimal places used or add additional information about the values being displayed. Instructions for this are available here.

And you're done! Click anywhere outside the menu to exit.

Which metrics are available in this integration?

User metrics

Users

New users

Percentage of new sessions

Number of sessions per user

1 day active users

7 day active users

14 day active users

28 day active users

30 day active users

Session metrics

Sessions

Bounce rate

Average session duration

Bounces

Unique dimension combinations

Hits

Page metrics

Pageviews

Unique pageviews

Average time on page

Pageviews per session

Page value

Entrances

Entrance rate

Exits

Exit rate

Events metrics

Events

Unique events

Average event value

Event value

Events per session

Sessions with event

Goal metrics

Goal starts

Goal completions

Goal conversion rate

Goal abandons

Goal abandonment rate

Goal value

Goal value per session

Product revenue metrics

Transactions

Number of items purchased

Number of unique products purchased

Ecommerce conversion rate

Average order value

Average number of items per purchase

Average revenue per user

Average revenue per session

Average revenue per item

Average product revenue per purchase

Average transactions per user

Total value

Tax

Shipping

Refund amount

Refund amount (by product)

Number of refunds

Number of refunds (by unit)

Number of refunds (by product)

Buy to detail rate

Cart to detail rate

Product page views (by product)

Added to cart (by product)

Added to cart (by unit)

Removed from cart (by product)

Removed from cart (by unit)

Checked out (by product)

Checked out (by unit)

Product list - Click through rate

Product list - Clicks

Product list - Views

Internal promotion - Click through rate

Internal promotion - Clicks

Internal Promotion - Views

App tracking metrics

Screen views

Unique screen views

Average screen views per session

Average time on screen

Social interaction metrics

Social interactions

Social interactions per session

Unique social interactions

Site speed metrics

Average page load time

Average domain lookup time

Average page download time

Average redirection time

Average server connection time

Average server response time

Average document interactive time

Average document content loaded time

User timing metrics

Average user timing

Exceptions metrics

Exceptions

Exceptions per screen

Crashes

Crashes per screen

Site search metrics

Searches

Sessions with search

Percentage of sessions with search

Search result views

Search result views per search

Average search depth

Average time after search

Search exits

Search exit rate

Search refinements

Search refinement rate

Average goal value per search

Site search goal conversion rate

AdWords metrics

Impressions

Clicks

Cost

Cost per click

Click through rate

Cost per conversion

Cost per goal conversion

Cost per thousand impressions

Cost per transition

Return on ad spend

Revenue per click

AdSense metrics

AdSense - Revenue

AdSense - Ad units viewed

AdSense - Ad viewed

AdSense - Ads clicked

AdSense - Page impressions

AdSense - Click through rate

AdSense - Effective cost per thousand page impressions

AdSense - Exits

AdSense - Viewable impression rate

AdSense - Coverage

Ad Exchange metrics

AdX - Impressions

AdX - Impressions per session

AdX - Coverage

AdX - Monetized Pageviews

AdX - Clicks

AdX - Click through rate

AdX - Effective cost per thousand page impressions

AdX - Revenue

AdX - Revenue per thousand sessions

AdX - Viewable impression rate

DoubleClick Campaign Manager metrics

DCM - Impressions

DCM - Clicks

DCM - Cost

DCM - Cost per click

DCM - Click through rate

DCM - Conversions

DCM - Revenue

DCM - Return on ad spend

DCM - Revenue per click

DoubleClick for Publishers metrics

DFP - Impressions

DFP - Impressions per session

DFP - Clicks

DFP - Click through rate

DFP - Coverage

DFP - Monetized pageviews

DFP - Effective cost per thousand page impressions

DFP - Revenue

DFP - Revenue per thousand sessions

DFP - Viewable impression rate

DFP Backfill - Impressions

DFP Backfill - Impressions per session

DFP Backfill - Clicks

DFP Backfill - Click through rate

DFP Backfill - Coverage

DFP Backfill - Monetized Pageviews

DFP Backfill - Effective cost per thousand page impressions

DFP Backfill - Revenue

DFP Backfill - Revenue per thousand sessions

DFP Backfill - Viewable impression rate

DoubleClick Bid Manager metrics

DBM - Effective cost per action

DBM - Effective cost per click

DBM - Effective cost per thousand page impressions

DBM - Click through rate

DBM - Clicks

DBM - Conversions

DBM - Cost

DBM - Impressions

DBM - Return on ad spend

DoubleClick Search metrics

DS - Impressions

DS - Clicks

DS - Click through rate

DS - Cost per click

DS - Revenue per click

DS - Cost

DS - Profit

DS - Return on ad spend

Tip

If you're not sure which metrics to track, you might be interested in our SaaS Metrics Generator, which can help you find the right metrics and learn more about them.