Connectors

/

Google Analytics

Google Analytics

Marketing Analytics

Sync Google Analytics data anywhere.

Google Analytics is a web service that provides integrated analytical tools and essential statistics to aid companies in understanding data and performing search engine optimization (SEO) to improve marketing. Google Analytics provides a range of free marketing tools that help businesses track their website performance and gather insights from visitors. Analytics’ integration with other Google solutions like Google’s advertising and publishing products promotes a seamless workflow that saves time and increases efficiency and insights.

  • Certified
  • Generally available
  • 61 streams
  • 8 entities
Sync Google Analytics dataRead the docs
  • 61Streams
  • 8Entities
  • 2Actions
  • 50+Destinations
One connector

Everything Google Analytics can do in Airbyte

  • Sync to your warehouse

    Land 61 Google Analytics tables in 50+ destinations on a schedule you control.

  • Context store search

    Query synced Google Analytics data with filters, sorting and semantic search, without spending Google Analytics API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Google Analytics once. The same connection powers scheduled syncs and runtime actions.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version2.10.1

Set up in 12 steps

  1. Go to the Google Analytics website and log in to your account.
  2. Click on the Admin button in the bottom left corner of the screen.
  3. In the Admin section, click on the Account User Management option.
  4. Click on the + button to add a new user.
  5. Enter the email address associated with your Airbyte account and select the permissions you want to grant.
  6. Click on the Add button to save the new user.
  7. Go to the Airbyte website and navigate to the Sources page.
  8. Click on the Google Analytics source connector.
  9. Enter the credentials for your Google Analytics account, including the email address and password associated with the account.
  10. Click on the Test button to ensure that the connection is working properly.
  11. If the test is successful, click on the Save button to save the credentials and complete the setup process.
  12. You can now use the Google Analytics source connector to import data from your Google Analytics account into Airbyte.
61 streams

Every table you can sync from Google Analytics

  • Preconfigured streams:

  • daily_active_users

  • devices

  • four_weekly_active_users

  • locations

  • pages

  • traffic_sources

  • website_overview

  • weekly_active_users

  • user_acquisition_first_user_medium_report

  • user_acquisition_first_user_source_report

  • user_acquisition_first_user_source_medium_report

2 actions

Supported Google Analytics actions

  • List

    Read live records straight from the Google Analytics API.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

Full parameter-level details live in the Google Analytics entity reference.

Authentication

Authenticate Google Analytics once

  • Authenticate via Google (Oauth)

    Recommended

  • Service Account Key Authentication

Use cases

What teams build with Google Analytics

  • Show me the website overview report

  • List daily active users

  • Show weekly active user trends

  • Get the four-weekly active users report

  • List traffic sources

  • Show me page performance metrics

FAQ

Common questions

Do I need more than one Google Analytics connection?

No. One Google Analytics authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

Do Google Analytics entity actions need a sync to run first?

No. Entity actions read and write through the Google Analytics API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from Google Analytics?

Google Analytics API provides access to a wide range of data related to website traffic and user behavior. The following are the categories of data that can be accessed through the API:

1. Audience data: This includes information about the demographics, interests, and behavior of website visitors.

2. Acquisition data: This includes data related to how visitors are finding the website, such as through search engines, social media, or referral links.

3. Behavior data: This includes data related to how visitors are interacting with the website, such as which pages they are visiting, how long they are staying on the site, and which actions they are taking.

4. Conversion data: This includes data related to the goals and conversions on the website, such as the number of purchases, form submissions, or other desired actions.

5. E-commerce data: This includes data related to online sales, such as revenue, average order value, and product performance.

6. Real-time data: This includes data related to the current activity on the website, such as the number of active users and the pages they are currently viewing.

Overall, the Google Analytics API provides a wealth of data that can be used to gain insights into website performance and user behavior.

How do I transfer data from Google Analytics?

1. Go to the Google Analytics website and log in to your account.

2. Click on the Admin button in the bottom left corner of the screen.

3. In the Admin section, click on the Account User Management option.

4. Click on the + button to add a new user.

5. Enter the email address associated with your Airbyte account and select the permissions you want to grant.

6. Click on the Add button to save the new user.

7. Go to the Airbyte website and navigate to the Sources page.

8. Click on the Google Analytics source connector.

9. Enter the credentials for your Google Analytics account, including the email address and password associated with the account.

10. Click on the Test button to ensure that the connection is working properly.

11. If the test is successful, click on the Save button to save the credentials and complete the setup process.

12. You can now use the Google Analytics source connector to import data from your Google Analytics account into Airbyte.

What are top ETL tools to transfer data from Google Analytics?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Explore
All connectors

Start moving Google Analytics data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Google Analytics actions.

Try it freeTalk to sales