Google Analytics is the worlds most used Web Analytics platform and offers its users detailed insights into website traffic, conversions, sales and other customisable dimensions and metrics. It is available in 40 languages and has a market share of 82%.
Connect Google Analytics to Google Sheets with Windsor.ai
Finally, all your website and analytics data from Google Analytics available in Google Sheets
About Google Sheets
Google Sheets is a web based spreadsheet tool. It allows end users to create spreadsheets, pivot tables, charts and run Google App Script code to automate various functions.
Connecting data from Google Analytics to Google Sheets
Step 1 – Open a fresh tab in your browser, login to Google Sheets
Step 2 – Go to Add-ons > Get Add-ons > Install Windsor.ai
The second option is to install Windsor.ai directly from the Google Workplace Marketplace. Search for Windsor.ai and install
Once the installation is over, you can search for Windsor.ai under the ADD-ONS menu in your Google sheet
Getting your Google Analytics data to Google Sheets
Add-ons → Windsor.ai→ Launch
Set up queries
Pick corresponding values from drop-down menus.
Data source: Google Analytics
Select view: Windsor.ai blog
Select date: Year to date
Select metrics: Pageviews
Split by dimensions: Page path vs. Year & month
Filter: Switzerland, let’s say total page views
Setting up automatic refreshes
You can also set up triggers (an automatic refresh) if you are running the same query.
On the windsor.ai sidebar
Click > Schedule > Add triggers
In trigger view, you can pick the frequency of updates.
Windsor.ai: Connecting all marketing data
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.
Start a free trial today.
Integrate all your data and measure what matters.