Skip to main content
Connect LinkedIn Ads to AstroBee to analyze your campaign performance, ad spend, and engagement metrics. Get queryable access to campaigns, creatives, conversions, and audience insights.
Experimental feature: LinkedIn Ads connector is currently in beta. We’re actively improving sync reliability and adding more features.

Prerequisites

  • A LinkedIn Ads account with active campaigns
  • Admin or Analyst access to the LinkedIn Campaign Manager account you want to sync
  • LinkedIn account must have campaigns with data

Connecting LinkedIn Ads

You can connect LinkedIn Ads 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 LinkedIn Ads

Click Connect next to LinkedIn Ads in the list of available connectors.
Available connectors including LinkedIn Ads
3

Start connection

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

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to LinkedIn Ads. 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 LinkedIn

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

Configure sync settings

After authentication succeeds, configure your sync settings:
Successful authentication with sync configuration
  • Accounts sync mode: Choose “Sync all accounts” or select specific accounts
  • Reports sync mode: Choose “Sync all reports” or select specific reports
  • Historical Sync Time Frame: Select how much historical data to sync (ALL_TIME syncs everything)
Click Save & Test to verify the connection.
7

Select tables to sync

Back in AstroBee, the “Configure Connector” modal shows your sync progress. Expand Sync Settings to select which tables to include.
Select LinkedIn Ads tables in AstroBee
Tables marked “(always synced)” are required. Common tables include:
  • account_history: Account information and settings
  • campaign_history: Campaign details and configurations
  • ad_analytics_by_campaign: Performance metrics by campaign
  • ad_analytics_by_creative: Performance metrics by creative
  • creative_history: Ad creative content and formats
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.
LinkedIn Ads 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 LinkedIn Ads connection now appears under MY SOURCES on the Sources page. You’ll see the sync status (e.g., “Backfilling history”) while historical data loads.
LinkedIn Ads connection completed

What happens next

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

Syncing data

LinkedIn Ads 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 advertising data:
  1. Navigate to the Sources page
  2. Find your LinkedIn Ads connection under MY SOURCES
  3. Click the sync button
AstroBee will pull the latest campaigns, ad performance, and conversion data from your LinkedIn Ad accounts.

Understanding LinkedIn Ads data

LinkedIn Ads syncs multiple related tables:
  • Campaign data: Campaign names, objectives, budgets, and status
  • Ad performance: Impressions, clicks, spend, and engagement metrics
  • Creative content: Ad formats, text, images, and targeting
  • Conversion tracking: Lead generation forms, website conversions, and attribution data
  • Audience insights: Demographic and professional targeting information
The exact tables available depend on your LinkedIn Ads configuration and which features you use in Campaign Manager.

Troubleshooting

For additional help, see Fivetran’s LinkedIn Ads troubleshooting guide.
Issue: Unable to authorize access to LinkedIn Ads.Solution:
  • Ensure you have Admin or Analyst access to the LinkedIn Campaign Manager account
  • Verify you’re signed in to the correct LinkedIn account
  • Check that your organization allows third-party access to LinkedIn Ads
  • Try re-authorizing from the beginning
  • Confirm your LinkedIn account is not locked or restricted
Issue: Connection succeeds but no data appears in tables.Solution:
  • Verify your LinkedIn Ad account has active or past campaigns
  • Check that you selected the correct ad account during setup
  • Ensure your campaigns have actually run and generated data
  • Wait for the initial sync to complete (can take 10+ minutes for accounts with extensive campaign history)
  • Trigger a manual sync to refresh data
Issue: Initial sync appears stuck or is taking longer than expected.Solution:
  • Accounts with extensive campaign history can take 30+ minutes to sync
  • Check your internet connection
  • Avoid making changes to the connection during sync
  • LinkedIn Ads API rate limits may slow down large syncs
  • If stuck for more than an hour, contact support at support@astrobee.ai
Issue: Some campaigns or ads don’t appear in synced data.Solution:
  • Verify you have access to those campaigns in LinkedIn Campaign Manager
  • Check that campaigns are not archived or deleted
  • Ensure your account sync mode includes the ad account containing those campaigns
  • Trigger a new sync to pull the latest data
  • Review your LinkedIn permissions - you need at least Analyst access
Issue: Conversion tracking data is not syncing.Solution:
  • Verify conversion tracking is properly configured in LinkedIn Campaign Manager
  • Check that conversions have actually occurred and been recorded
  • Ensure you have the necessary permissions to view conversion data
  • LinkedIn conversions may have a data delay of up to 48 hours
  • Trigger a new sync after conversions have had time to process
Issue: Cannot access specific LinkedIn Ad accounts.Solution:
  • Confirm you have Admin or Analyst role for those accounts
  • Check that the account owner hasn’t revoked your access
  • Verify the ad account is not suspended or closed
  • Re-authenticate to refresh your access permissions
  • Contact your LinkedIn Ads account administrator if access issues persist
Issue: Status shows “Backfilling history” for many hours.Solution:
  • Historical backfills for LinkedIn Ads can take 12+ hours for accounts with years of campaign 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 72 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 LinkedIn Ads
  • Contact support at support@astrobee.ai with the error message if the issue continues

Next steps