supermetrics

euroflorist.com Guido Jansen


SuperMetrics for Google Drive: Add-on that turns Google Spreadsheet into a business reporting system for web analytics,

social media and online marketing.


Why use it?

• Calculate things that the web interface can’t do

• Combine different sources

• Automate reports


SourcesFree Pro SuperPro

Data Sources


SourcesFree (Super)Pro

Data Sources


Pro | Superpro• Scheduled refresh (daily | hourly)

• Scheduled e-mailing

• Max rows/query: 1M (instead of 100)

• Pricing: €43.85/month | €88.60/month


Supermetrics.comFor Google Drive: Chrome Add-on

(also available as Excel add-on)

Installation

http://supermetrics.com

https://chrome.google.com/webstore/detail/supermetrics/jmdiehkocgfclpcllfehohafdegbhdcc

http://supermetrics.com/product/supermetrics-data-grabber/


Launch Supermetrics


Sidebar


Data source


Select views


Select dates


Select metrics


Split by


Segment


Filter


Options


Exercise 1

• Combine data for multiple views

• Split by day

• Date range: July

• Compare revenue per user per country


Exercise 2

• Find the % of people that did a transaction on mobile that started on the home page.

• Compare the first 6 months of data of 2015 versus 2016

• Split by month

supermetrics

Internet