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
1
Navigate to Sources
From the Sources page, click on “Google Analytics” in the Available Sources section
2
Start connection
Click “Connect” to begin the setup process
3
Authorize with Fivetran
AstroBee uses Fivetran to securely connect to Google Analytics 4. Click “Continue” to proceed
- Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
- Private: Your data passes through without permanent storage
4
Configure authentication and sync settings
Follow the setup guide on the right for detailed configuration instructions from Fivetran.
- Sync all accounts: Automatically sync all GA4 properties you have access to
- Sync specific accounts: Select only specific properties to sync
- How to select GA4 properties
- Historical sync recommendations
- Custom report configuration
5
Test and save connection
Once configured, click “Save & Test” to verify the connection
6
Select tables to sync
Back in AstroBee, your data is being synced from Google Analytics. This typically takes 10 seconds to 10 minutes depending on your data volume and historical sync settings.Once synced, select which tables to include in your analysis. Common GA4 tables include:
- accounts: Your GA4 account and property information
- conversion_events: Configured conversion events and their metrics
- properties: GA4 property settings and metadata
7
Connection complete
Your Google Analytics connection is now active and appears in “My Sources”
What happens next
After connecting Google Analytics, you can create an ontology to start querying your analytics data. Click “Create Ontology” to let AstroBee analyze your GA4 tables and generate a business model for natural language queries.Syncing data
Google Analytics connections use manual sync - you control when data is refreshed. To sync your latest analytics data:- Navigate to the Sources page
- Find your Google Analytics connection
- Click the sync button
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
- Account/Property metadata: Configuration and settings information
Managing connections
Syncing multiple properties
Google Analytics is a one-to-many connector - one connection can sync multiple GA4 properties if you choose “Sync all accounts” mode. To add more properties to an existing connection:- Edit your connection settings
- Ensure “Sync all accounts” is selected, or add specific accounts to your sync list
- Trigger a new sync
Deleting a connection
To remove a Google Analytics connection:- Navigate to the connection settings
- Click the “Remove connection” button
Deleting a connection removes all synced GA4 data from your warehouse. Any ontologies using this data will no longer work.
Troubleshooting
For additional help, see Fivetran’s Google Analytics 4 troubleshooting guide.Authentication failed
Authentication failed
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
No data syncing
No data syncing
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)
Sync taking too long
Sync taking too long
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
Missing expected events or conversions
Missing expected events or conversions
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)
Universal Analytics property not working
Universal Analytics property not working
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