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 |
|---|---|
| accounts | Ad accounts you have read access to. |
| campaign_groups | Campaign groups and their budgets. |
| campaigns | Campaigns with status, objective and budget. |
| creatives | Creatives of each campaign. |
| ad_campaign_analytics | Spend, impressions, clicks and conversions by day and campaign; loaded incrementally. |
| ad_creative_analytics | The same measures by creative. |
| lead_form_responses | LinkedIn lead gen form responses; personal data is hashed on load. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Start Date |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector 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.
| Metric | Definition | Unit |
|---|---|---|
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
| Customer acquisition cost (CAC) | Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketing | Currency |
| Budget utilization | Marketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budget | Ratio (%) |
Connect LinkedIn Ads in 4 steps
- 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
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
Choose streams
Click Test connection, keep campaigns, campaign_groups and ad_campaign_analytics; add lead_form_responses if you use LinkedIn forms.
- 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
Connect LinkedIn Ads and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes