Datapipe
Linkedin Ads report
A daily table of the synced columns, ready for Sheets or a CSV.
Coming soon
Linkedin Ads for agencies and in-house teams
B2B marketers use Linkedin Ads in Datapipe to see sponsored spend, leads, and clicks once LinkedIn approves the app.
What connects
LinkedIn Marketing API access. It is not a Google sign-in. LinkedIn has to approve the app before ad reporting can be read. Until then the report is sample data.
What you can report on
- Campaign (dimension). Sponsored campaign name. The live pull is not available until LinkedIn approves the app.
- Impressions (metric). Impressions. Sample only until approval.
- Clicks (metric). Clicks. Sample only until approval.
- Spend (metric). Ad spend. Sample only until approval.
What you set up
- Do not paste a personal LinkedIn password. The Marketing API needs an approved app.
- Open Connections. LinkedIn stays on Coming soon.
- A sample report can be built so the Sheet is ready. It is not a live account.
Limitations
Needs LinkedIn Marketing API approval. There is no live campaign pull in this build. The field list is not a promise that those columns refresh.
Last reviewed 2026-10-29. Owner: Datapipe.
Connection
Coming soon
Coming soon. The LinkedIn Marketing API requires owner approval.
Fields
Fields from the LinkedIn Ads reporting analytics finder. This connector still needs LinkedIn Marketing API approval. Source: https://learn.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting. Read on 2026-10-27. 13 fields.
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Impressions | impressions | Times the ad was shown. | metric · integer | Advertising | Impressions |
| Clicks | clicks | Clicks on the ad. | metric · integer | Advertising | Clicks |
| Video views | videoViews | Video views. | metric · integer | Advertising | |
| Reach | approximateMemberReach | Approximate members reached. | metric · integer | Advertising |
Conversions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Conversions | externalWebsiteConversions | Website conversions. | metric · integer | Conversions | |
| Leads | oneClickLeads | Lead gen form submissions. | metric · integer | Conversions |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Pivot | pivotValues | The campaign, creative, or account the row is for. | dimension · string | Dimensions |
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Likes | likes | Likes on the sponsored update. | metric · integer | Metrics | |
| Comments | comments | Comments. | metric · integer | Metrics | |
| Shares | shares | Shares. | metric · integer | Metrics | |
| Follows | follows | Follows from the ad. | metric · integer | Metrics |
Technology
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Spend | costInLocalCurrency | Spend in the account currency. | metric · number | Technology | Spend |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Date | dateRange | The day or date range. | dimension · date | Time |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Linkedin Ads to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Linkedin Ads to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Linkedin Ads to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Linkedin Ads to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Linkedin Ads to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Linkedin Ads to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections. This source is marked Coming soon.
- You can still build a sample report so the destination and the schedule are ready.
- The owner turns the live connection on after the platform approves the app.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Linkedin Ads connection live?
Coming soon. The LinkedIn Marketing API requires owner approval.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The field list is the platform's published resource. A saved report uses the columns on that connector's card.