Skip to main content
Connect Google Analytics 4 to AstroBee to analyze your website traffic, user behavior, and engagement metrics. Get queryable access to events, conversions, and user properties.
Experimental feature: Google Analytics connector is currently in beta. We’re actively improving sync reliability and adding more features.

​
Prerequisites

  • A Google Analytics 4 property (Universal Analytics is not supported)
  • Google account with read access to the GA4 property you want to sync
  • GA4 property must be actively collecting data
You must use a Google Analytics 4 property. Universal Analytics properties are not supported by this connector.

​
Connecting Google Analytics

You can connect Google Analytics in two ways: from the Sources page if you’re already using AstroBee, or during the onboarding process if you’re a new user.
1

Choose Connect Sources

On the Import Data screen, click the Connect Sources card.
Onboarding screen with Connect Sources option
2

Select Google Analytics

Click Connect next to Google Analytics in the list of available connectors.
Available connectors including Google Analytics
3

Start connection

A “Configure Connector” modal appears showing “Google Analytics Not Connected”. Click the orange Connect button to begin setup.
Configure Google Analytics modal
4

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to Google Analytics 4. Review the security information and click Continue.
Fivetran authorization screen
Fivetran ensures:
  • Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
  • Private: Your data passes through without permanent storage
5

Authenticate with Google

On the Fivetran setup page, click Authorize with Google to log in through OAuth. You’ll be redirected to Google to grant access.
Google Analytics authentication configuration
Follow the Fivetran Google Analytics 4 setup guide for detailed instructions.
6

Configure sync settings

After authentication succeeds, configure your sync settings:
Google Analytics sync configuration
  • Historical Sync Time Frame: Select how many months of historical data to sync (e.g., 12 months)
  • Accounts sync mode: Choose “Sync all accounts” or select specific GA4 properties
Click Save & Test to verify the connection.
7

Select tables to sync

Back in AstroBee, the “Configure Connector” modal shows your connection as “Scheduled to start”. Expand Sync Settings to select which tables to include.
Select Google Analytics tables in AstroBee
Common GA4 tables include:
  • accounts: Your GA4 account and property information
  • conversion_events: Configured conversion events and their metrics
  • audiences_report: Audience segment data
  • demographic_age_report: User demographics by age
  • custom_dimensions: Custom dimensions you’ve configured
Click Save Table Selection, then Continue.
8

Data layer building

A modal appears showing “Your data layer is building”. AstroBee is unifying, deduplicating, and resolving entities across your data.
Data layer building modal
This may take 10 minutes to a couple of hours. Feel free to close this and come back later.
9

Data syncing

The Sources page shows your sync progress. Your data source is syncing and the data layer will be generated automatically once syncing completes.
Google Analytics syncing progress
It’s safe to close this window and continue working. You can connect other data sources while you wait.
10

Connection complete

Your Google Analytics connection now appears under MY SOURCES on the Sources page. You’ll see the sync status (e.g., “Backfilling history”) while historical data loads.
Google Analytics connection completed

​
What happens next

After connecting Google Analytics, AstroBee automatically generates a data layer from your synced tables. Once complete, you can start querying your analytics data using natural language.
You can also edit your data layer to customize entities, add properties, or create relationships.

​
Syncing data

Google Analytics connections sync automatically when first connected and during historical backfill. After the initial sync completes, you can trigger manual syncs to refresh your data. To sync your latest analytics data:
  1. Navigate to the Sources page
  2. Find your Google Analytics connection under MY SOURCES
  3. Click the sync button
AstroBee will pull the latest events, conversions, and user data from your GA4 property.

​
Understanding GA4 data

Google Analytics 4 syncs multiple related tables:
  • Events data: User interactions tracked on your website or app
  • Conversion events: Events marked as conversions in your GA4 property
  • User properties: Custom dimensions and user attributes
  • Demographic reports: Age, city, and country breakdowns
  • Account/Property metadata: Configuration and settings information
The exact tables available depend on your GA4 configuration and which custom reports you’ve set up.

​
Troubleshooting

For additional help, see Fivetran’s Google Analytics 4 troubleshooting guide.
Issue: Unable to authorize access to Google Analytics.Solution:
  • Ensure you’re using a Google Analytics 4 property (not Universal Analytics)
  • Verify your Google account has read access to the GA4 property
  • Check that you’re signed in to the correct Google account
  • Try re-authorizing from the beginning
  • Confirm your organization allows third-party access to Google Analytics
Issue: Connection succeeds but no data appears in tables.Solution:
  • Verify your GA4 property is actively collecting data
  • Check that your property has been active long enough to have data
  • Ensure you selected the correct property during setup
  • Try increasing the historical sync time frame
  • Wait for the initial sync to complete (can take 10+ minutes for large datasets)
Issue: Initial sync appears stuck or is taking longer than expected.Solution:
  • Historical syncs with many months of data can take 30+ minutes
  • Reduce the historical sync time frame if you don’t need all historical data
  • Check your internet connection
  • Avoid making changes to the connection during sync
  • If stuck for more than an hour, contact support at support@astrobee.ai
Issue: Some events or conversions don’t appear in synced data.Solution:
  • Verify the events are properly configured in your GA4 property
  • Check that events have actually fired and been recorded in GA4
  • Ensure conversion events are marked as conversions in GA4 settings
  • Trigger a new sync to pull the latest data
  • Review your account sync mode (all accounts vs specific accounts)
Issue: Cannot connect a Universal Analytics property.Solution:
  • This connector only supports Google Analytics 4 properties
  • Migrate your tracking to GA4 if you haven’t already
  • Universal Analytics properties are not supported by Fivetran
  • Contact support@astrobee.ai if you need help with migration strategies
Issue: Status shows “Backfilling history” for many hours.Solution:
  • Historical backfills can take several hours for properties with many months of data
  • This is normal behavior, not a stuck sync
  • You can safely close the browser and return later
  • The sync continues in the background and your data layer will generate automatically when complete
  • If backfill exceeds 24 hours with no progress, contact support at support@astrobee.ai
Issue: Sync completed but data layer shows an error or never finishes building.Solution:
  • Check that at least one table was selected during setup
  • Verify your synced tables contain actual data (not empty)
  • Try refreshing the page to see updated status
  • If the error persists, try disconnecting and reconnecting Google Analytics
  • Contact support at support@astrobee.ai with the error message if the issue continues

​
Next steps

Create a Data Layer

Transform your GA4 data into a queryable business model

Ask Questions

Start analyzing your website traffic and user behavior with natural language