Skip to content

Marketing and ads

Connect LinkedIn Ads to DataxLand

The LinkedIn Ads connector reads ad accounts, campaign groups, campaigns, creatives and daily performance reports from the LinkedIn Marketing API. Si maps the reports to marketing spend by day and campaign, so you get spend, impressions, clicks and CTR; add leads from forms or your CRM and you also get cost per lead and customer acquisition cost - exactly the questions a B2B business needs answered.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with LinkedIn Ads

  • Know the cost per lead of each LinkedIn campaign when leads live in HubSpot or Pipedrive.
  • Track monthly budget usage against campaign budgets.
  • Compare spend and CTR across LinkedIn, Google Ads and Facebook Ads in one marketing dashboard.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
accountsAd accounts you have read access to.
campaign_groupsCampaign groups and their budgets.
campaignsCampaigns with status, objective and budget.
creativesCreatives of each campaign.
ad_campaign_analyticsSpend, impressions, clicks and conversions by day and campaign; loaded incrementally.
ad_creative_analyticsThe same measures by creative.
lead_form_responsesLinkedIn lead gen form responses; personal data is hashed on load.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inStart Date
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Marketing spendTotal cost of marketing campaigns by spend date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)

Connect LinkedIn Ads in 4 steps

  1. 1

    Get an access token

    Create an app in the LinkedIn Developer Portal with ads read access and generate an access token (or a client ID, client secret and refresh token).

  2. 2

    Add the LinkedIn Ads source

    In the workspace choose Add source, find LinkedIn Ads, choose Access Token or OAuth2.0, paste your credentials, and set the Start Date and Account IDs if you only need some accounts.

  3. 3

    Choose streams

    Click Test connection, keep campaigns, campaign_groups and ad_campaign_analytics; add lead_form_responses if you use LinkedIn forms.

  4. 4

    Review and build

    Si proposes a mapping to daily marketing spend; you approve, then build the marketing dashboard.

Limits and caveats

  • DataxLand does not run the LinkedIn sign-in; you create the token in your own LinkedIn app. LinkedIn access tokens expire, so paste a new token when that happens or use a refresh token.
  • Cost per lead and CAC need a lead or customer source (CRM, forms) alongside.
  • Conversions reported by LinkedIn follow LinkedIn's attribution window; they are not real revenue.
  • Requires the Starter plan or above. An Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Can it read several ad accounts?

Yes. Leave Account IDs empty to read every account the token can access, or list the ones you need.

What currency is spend in?

The ad account currency, as LinkedIn returns it; DataxLand does not convert exchange rates.

When does yesterday's data show up?

After the next refresh on your schedule. LinkedIn may still update the last few days, so the connector re-reads a short window each time.

Dashboard templates that use this source

Ask Si about your LinkedIn Ads data →LinkedIn Ads + Salesforce →All data sources →

Connect LinkedIn Ads and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes