Forums, Knowledge Base and FAQs/Knowledge Base/Widgets

Google Analytics

Gareth Wilson
posted this on June 28, 2012 11:39

About Google Analytics

http://www.google.com/analytics

Google Analytics not only lets you measure sales and conversions, but also gives you fresh insights into how visitors use your site, how they arrived on your site, and how you can keep them coming back.

google-analytics-logo.gif

About our Geckoboard integration with Google Analytics

Our Google Analytics integration allows you to:

  • Display visitor information including Visits, Pageviews, Pages/Visit, Bounce Rate, Avg. Time on Site, % New Visits and Unique visitors from the last 1 to 30 days, filtered by profile and filters, along with an optional secondary stat showing how that value has changed, either as a percentage or sparkline graph. 
  • Display campaign information including Ad Clicks, Ad Cost, CPC, CPM, CTR and Impressions from the last 1 to 30 days, filtered by profile, campaign and filters, along with an optional secondary stat showing how that value has changed, either as a percentage or sparkline graph.
  • Display ecommerce information including Total Item Revenue, Total Transaction Revenue, Number of Items Purchased and Number of Transactions from the last 1 to 30 days, filtered by profile, product and filters, along with an optional secondary stat showing how that value has changed, either as a percentage or sparkline graph.
  • Display goal information including starts, completions, completion rate, conversion rate and goal value from the last 1 to 30 days, filtered by profile, goal and filters, along with an optional secondary stat showing how that value has changed, either as a percentage or sparkline graph.
  • Display event information including total events, unique events, event value, avg. event value, visits with event and events per visit with event from the last 1 to 30 days, filtered by profile and filters, along with an optional secondary stat showing how that value has changed, either as a percentage or sparkline graph.
Screen_Shot_2012-09-10_at_15.10.011.png

Using Filters

Google Analytics filters allows you to see pageviews for specific URLs on your Geckoboard status board. You can use it to filter both dimensions and metrics from Google Analytics. You can find lots of in-depth information on Google's documentation pages about how to write Google Analytics filters, but here's a couple of practical examples.

To start, let's create a new Google Analytics widget: New widget >> Web Analytics >> Google Analytics. You'll notice an optional field called "Filters" on the widget configuration screen. Entering filter parameters in here allows you to filter by almost anything including multiple dimension and metric filters together.

Let's start by adding a filter to show only pageviews by Firefox users from the United States. Use the following settings in the widget configuration:

Metric Category: Visitors
Metric: Pageviews
Filters: ga:country==United States;ga:browser==Firefox

gaFilterConfig.png.scaled500.png

Breaking that down, we're using ga:country to restrict pageviews that came from the country "United States". We used the operator == here which ensures it's an exact match, but there are other operators we can use including =~ which matches based on a regular expression. An example of this might be to add a filter to restrict pageview numbers where the URL matched a regular expression.

If you want to restrict the pageview metric to only URL matching ^foo (i.e. your URL starts with foo), add the following filter:

ga:pagePath=~^foo

To match ^foo OR bar$ (url starts with foo OR ends with bar) you need to use a comma to separate terms:

ga:pagePath=~^foo,ga:pagePath=~bar$

To match ^foo AND bar$ (url starts with foo AND ends with bar) you use a semicolon to separate terms:

ga:pagePath=~^foo;ga:pagePath=~bar$

This doesn't scratch the surface of what's possible with Google Analytics filters but a look at their documentation and some experimentation can open up a ton of possibilities.

How to use the Geckoboard Google Analytics integration

Adding the Visitors widget to your dashboard

1. From the 'Add Widget' option, select the Web Analytics category and select the 'Google Analytics' widget.

2. Select the Analytics Profile you want to report data from.

3. Choose the 'Visitors' Metric Category

4. For visitors, the metrics options to choose to report on are: Visits, Pageviews, Pages/Visit, Bounce Rate, Avg. Time on Site, % New Visits and Unique visitors

5. The dimension value field will automatically be set to 'n/a' as this is only applicable for Campaign, Ecommerce and Goals metrics.

6. Optionally, you can enter some filters. These restrict the data returned e.g. to restrict data to only Firefox users from the United States you would use ga:country==United States;ga:browser==Firefox. For more information see the 'Using Filters' notes above, and full documentation can be found on Google's site.

7. Set the period to report on, either today, yesterday, past 7 days, past 28 days or past 30 days.

8. Optionally, you can display a secondary stat. This will show how the stat has changed over time and can be visualised with either a percentage number or sparkline graph.

9. Choose the period for the secondary output.

10. Set a label. This is the label that gets displayed at the top of the widget and has a 30 character maximum.

11. Select the widget size: either 1x1 or 2x2.

12. Click on 'Add to Dashboard' to finish.

Example 1x1 Visitors widget showing number of visits for past 30 days and the percentage change as secondary stat

Screen_Shot_2012-09-10_at_15.05.44.png

Example 2x2 Visitors widget showing number of visits for past 30 days and a sparkline as secondary stat

 Screen_Shot_2012-09-10_at_15.10.01.png

Adding the Campaigns widget to your dashboard

1. From the 'Add Widget' option, select the Web Analytics category and select the 'Google Analytics' widget.

2. Select the Analytics Profile you want to report data from.

3. Choose the 'Campaigns' Metric Category

4. For campaigns, the metrics options to choose to report on are: Ad Clicks, Ad Cost, CPC, CPM, CTR and Impressions.

5. The dimension value field will be populated with the names of specific campaigns from which you can select from, or select 'all campaigns'.

6. Optionally, you can enter some filters. These restrict the data returned e.g. to restrict data to only Firefox users from the United States you would use ga:country==United States;ga:browser==Firefox. For more information see the 'Using Filters' notes above, and full documentation can be found on Google's site.

7. Set the period to report on, either today, yesterday, past 7 days, past 28 days or past 30 days.

8. Optionally, you can display a secondary stat. This will show how the stat has changed over time and can be visualised with either a percentage number or sparkline graph.

9. Choose the period for the secondary output.

10. Set a label. This is the label that gets displayed at the top of the widget and has a 30 character maximum.

11. Select the widget size: either 1x1 or 2x2.

12. Click on 'Add to Dashboard' to finish.

 

Adding the E-Commerce widget to your dashboard

1. From the 'Add Widget' option, select the Web Analytics category and select the 'Google Analytics' widget.

2. Select the Analytics Profile you want to report data from.

3. Choose the 'ECommerce' Metric Category

4. For E-Commerce, the metrics options to choose to report on are: Total Item Revenue, Total Transaction Revenue, Number of Items Purchased and Number of Transactions.

5. The dimension value field will be populated with the names of specific products from which you can select from, or select 'all products'.

6. Optionally, you can enter some filters. These restrict the data returned e.g. to restrict data to only Firefox users from the United States you would use ga:country==United States;ga:browser==Firefox. For more information see the 'Using Filters' notes above, and full documentation can be found on Google's site.

7. Set the period to report on, either today, yesterday, past 7 days, past 28 days or past 30 days.

8. Optionally, you can display a secondary stat. This will show how the stat has changed over time and can be visualised with either a percentage number or sparkline graph.

9. Choose the period for the secondary output.

10. Set a label. This is the label that gets displayed at the top of the widget and has a 30 character maximum.

11. Select the widget size: either 1x1 or 2x2.

12. Click on 'Add to Dashboard' to finish.

Example 1x1 E-Commerce widget showing number of transactions for past 30 days and a sparkline as secondary stat

Screen_Shot_2012-09-10_at_15.21.34.png

Adding the Goals widget to your dashboard

1. From the 'Add Widget' option, select the Web Analytics category and select the 'Google Analytics' widget.

2. Select the Analytics Profile you want to report data from.

3. Choose the 'Goals' Metric Category

4. For Goals, the metrics options to choose to report on are: Goal Starts, Goal Completions, Goal Completion Rate, Goal Conversion Rate and Goal Value.

5. The dimension value field will be populated with the names of specific goals from which you can select from, or select 'all goals'.

6. Optionally, you can enter some filters. These restrict the data returned e.g. to restrict data to only Firefox users from the United States you would use ga:country==United States;ga:browser==Firefox. For more information see the 'Using Filters' notes above, and full documentation can be found on Google's site.

7. Set the period to report on, either today, yesterday, past 7 days, past 28 days or past 30 days.

8. Optionally, you can display a secondary stat. This will show how the stat has changed over time and can be visualised with either a percentage number or sparkline graph.

9. Choose the period for the secondary output.

10. Set a label. This is the label that gets displayed at the top of the widget and has a 30 character maximum.

11. Select the widget size: either 1x1 or 2x2.

12. Click on 'Add to Dashboard' to finish.

Example 1x1 goals widget showing number of goal starts for past 30 days and a percentage as secondary stat

Screen_Shot_2012-09-10_at_15.26.15.png

Adding the Events widget to your dashboard

1. From the 'Add Widget' option, select the Web Analytics category and select the 'Google Analytics' widget.

2. Select the Analytics Profile you want to report data from.

3. Choose the 'Events' Metric Category

4. For events, the metrics options to choose to report on are: Total Events, Unique Events, Event Value, Avg Event Value, Visits with Event and Events per visit with Event.

5. The dimension value field will automatically be set to 'n/a' as this is only applicable for Campaign, Ecommerce and Goals metrics.

6. Optionally, you can enter some filters. These restrict the data returned e.g. to restrict data to only Firefox users from the United States you would use ga:country==United States;ga:browser==Firefox. For more information see the 'Using Filters' notes above, and full documentation can be found on Google's site.

7. Set the period to report on, either today, yesterday, past 7 days, past 28 days or past 30 days.

8. Optionally, you can display a secondary stat. This will show how the stat has changed over time and can be visualised with either a percentage number or sparkline graph.

9. Choose the period for the secondary output.

10. Set a label. This is the label that gets displayed at the top of the widget and has a 30 character maximum.

11. Select the widget size: either 1x1 or 2x2.

12. Click on 'Add to Dashboard' to finish.

Example 1x1 events widget showing total events for past 7 days with no secondary stat

Screen_Shot_2012-09-10_at_15.38.05.png

Example 1x1 events widget showing events per visit with event for past 7 days with no secondary stat

Screen_Shot_2012-09-10_at_15.39.37.png

Get help and provide feedback on the Google Analytics widget

If you encounter any problems, then please raise a support ticket. If there's an aspect you'd like to see added to this widget then please create a Feature Request.

 
Topic is closed for comments