Google Analytics data into your data warehouse in minutes

Automate Google Analytics from a single space with no code

Meltano Tap Google Analytics is a Singer tap for extracting Google Analytics 4 (GA4) data into Meltano Cloud for reporting, modelling, and downstream analysis.

It helps you collect website and app performance data from Google Analytics in a repeatable pipeline so you can analyse traffic, engagement, locations, devices, pages, and revenue-related activity alongside data from your other business systems.

Use this connector when you want to:

• centralise Google Analytics data in your warehouse
• build dashboards and reports on website performance
• track traffic sources, user behaviour, and engagement trends over time
• combine analytics data with advertising, CRM, sales, or product data
• customise the extracted reports using your own stream definitions

Setup

In Google Analytics:

1. Select the property you want to extract data for
2. Go to "Admin" -> "Property" -> "Property details"
3. Copy the "PROPERTY ID"

In Meltano Cloud:

1. Login and connect with your Google account
2. Enter the property ID
3. Choose a start date for extraction

Streams

The tap provides the following default streams:

website_overview

Overview of the website performance.

Properties

traffic_sources

Where website traffic originates from.

Properties

locations

Website activity by country, region, and city.

Properties

four_weekly_active_users

Active users measured over a rolling 28 day period.

Properties

weekly_active_users

Active users measured over a rolling 7 day period.

Properties

daily_active_users

Active users measured over a rolling 1 day period.

Properties

devices

Website activity by device, operating system, and browser.

Properties

transactions

Revenue and transaction performance overview.

Properties

pages

Page-level traffic and engagement performance.

Properties

Custom Streams

The tap also supports custom streams. When custom stream definitions are specified, they override all default streams.

Settings

Property ID

Google Analytics Property ID.

To find this in Google Analytics:

1. Log in to the Analytics dashboard
2. Select the property
3. Go to "Admin"
4. Under "Property", open "Property details"
5. Copy the "Property ID"

Start Date

The earliest record date to sync

Report definitions file

Google Analytics Reports Definition. The tap uses the default reports definition if this field is not provided. A project-relative path to JSON file with the definition of the reports to be generated.

See https://ga-dev-tools.google/ga4/dimensions-metrics-explorer/ for valid dimensions and metrics.

The JSON structure expected is as follows:

[
  { "name" : "name of stream to be used",
    "dimensions" :
    [
      "Google Analytics Dimension",
      "Another Google Analytics Dimension",
      // ... up to 7 dimensions per stream ...
    ],
    "metrics" :
    [
      "Google Analytics Metric",
      "Another Google Analytics Metric",
      // ... up to 10 metrics per stream ...
    ]
  },
  // ... as many streams / reports as the user wants ...
]

For example, if you want to extract user stats per day in a users_per_day stream and session stats per day and country in a sessions_per_country_day stream:

[
  { "name" : "users_per_day",
    "dimensions" :
    [
      "date"
    ],
    "metrics" :
    [
      "newUsers",
      "active1DayUsers"
    ]
  },
  { "name" : "sessions_per_country_day",
    "dimensions" :
    [
      "date",
      "country"
    ],
    "metrics" :
    [
      "sessions",
      "sessionsPerUser",
      "avgSessionDuration"
    ]
  }
]

Report definitions list

A list of report definitions to be generated directly in the config. Each object in the list defines a report/stream to extract, including the stream name, the Google Analytics dimensions, and the metrics to request.

The JSON structure expected is as follows:

[
  {
    "name": "name of stream to be used",
    "dimensions": [
      "Google Analytics Dimension",
      "Another Google Analytics Dimension"
      // ... up to 7 dimensions per stream ...
    ],
    "metrics": [
      "Google Analytics Metric",
      "Another Google Analytics Metric"
      // ... up to 10 metrics per stream ...
    ]
  }
  // ... as many streams / reports as the user wants ...
]

For example, you can define multiple reports inline like this:

[
  {
    "name": "traffic_overview",
    "dimensions": ["date", "country"],
    "metrics": ["activeUsers", "sessions"]
  },
  {
    "name": "device_analysis",
    "dimensions": ["date", "deviceCategory"],
    "metrics": ["activeUsers", "engagedSessions", "engagementRate"]
  },
  {
    "name": "traffic_source_analysis",
    "dimensions": ["date", "sessionSource", "sessionMedium"],
    "metrics": ["activeUsers", "sessions", "eventCount"]
  },
  {
    "name": "top_pages",
    "dimensions": ["date", "pagePath"],
    "metrics": ["screenPageViews", "activeUsers"]
  },
  {
    "name": "engagement_report",
    "dimensions": ["date"],
    "metrics": ["engagedSessions", "engagementRate", "userEngagementDuration"]
  }
]

End Date

The last record date to sync

Flattening Enabled

'True' to enable schema flattening and automatically expand nested properties.

Flattening Max Depth

The max depth to flatten schemas.

Stream Map Config

User-defined config values to be used within map expressions.

Stream Maps

Config object for stream maps capability. For more information check out Stream Maps.