Airtable Google Analytics Integration

What This Article Covers

  • Sync your Google Analytics data to Airtable with no code
  • Contact our support for fast help if you run into any issues
Follow along to get your Google Analytics data into Airtable:

Connecting to the Google Analytics to Airtable

In this reference we’ll look at how to pull and keep our Google Analytics data synced to Airtable. Do do this we’ll use the SyncWith extension available in the Airtable marketplace

Don’t Have SyncWith?

  • SyncWith is a Google Sheets Add On
  • SyncWith allows you to move data from any API into Google Sheets
  • Learn more about why Marketers love SyncWith
  • ⭐️⭐️⭐️⭐️⭐️ Reviewed by hundreds of businesses
  • Check out our Airtable API Extension in the Airtable marketplace to install today, and see why 100,000s of users are using us to setup their data connections easily.

How Does SyncWith Work on Airtable?

notion image

Connecting Google Analytics to Airtable

  1. Install Syncwith if you haven’t
notion image
  1. Open the SyncWith extension
  1. Click New report or click Google Analytics
notion image
  1. A new tab will open in your browser to configure your connector
  1. If you selected Google AAnalytics you’ll jump right into the configuration screen
  1. If you selected New report you’ll see a list of many api services as well as the ability to search
  1. Search for google analytics
notion image
  1. Select Google Analytics v4
  1. You’ll now see the configuration screen

Connecting the Google Analytics API to Airtable

You’ll see a configuration screen like the following:
notion image

Authentication

  1. Click Connect an account
  1. You’ll run through an OAuth flow with Google to give SyncWith access to your Google Analytics account
notion image
  1. Select the web property you want to report on in the Property drop down

Choose a Reporting Time Frame

You can choose from a wide range of default reporting time frames as well as dynamic ones. Some marketers and agencies might report on the last 21 weeks of data. You may or may not want to see the current day in the reporting period.
All are possible with the date range picker. Popular options include:
  • Last 30 days
  • Last 90 days
  • Last Month, Last 3 Months
  • Month to Date
You may create multiple connections with different date ranges, for instance if you’re building a dashboard you might want to know your total ad spend in the last month, 3 months and year. You can create 3 reports to pull each of these numbers, or pull daily and do the aggregation in airtable
notion image

Choosing Your Dimensions

Dimensions are important if you want to pivot your data to see how different groups of users perform, for example:
  • I want to see analyze landing pages by source of traffic
  • I want to understand organic trends for landing pages over time
  • I want to see google search console keyword data by landing page
  • I want to understand which countries and content are driving conversions
  • Popular options will include
    • Session source / medium
    • Date
    • Landing page
    • Country
    • Device category
 
notion image

Choosing Your Metrics

Now that you’ve selected the dimensions you want to report along - eg the things you’re interested in. Now you need to choose what you want to know about them.
For traffic, web and seo analysis that could be Sessions, Engaged sessions, Views per session, Average session duration and 7-day active users
notion image

Creating a Table

  1. Click the Save button
notion image
  1. SyncWith will begin creating the connection, creating a new table in the base and importing the requested data, you see the Save button grey out and change to Saving
notion image
  1. Once complete the configuration tab will close and your Airtable will be updated
notion image
  1. The extension will also add the new report to a list of existing reports, each report has a context menu allowing you to Edit or Delete the report
notion image

Refreshing the Google Analytics Airtable Connection

In order to refresh your google analytics data and sync it to airtable click the Refresh button
notion image