Pull LinkedIn Ads data into Microsoft Excel
Keep LinkedIn Ads out of the export-and-paste loop: load it into your data warehouse, tie it to website touch points and deals, then let account managers pull the finished Data Mart into Excel whenever they need it.
LinkedIn AdsConnectedAd AccountsAd AnalyticsAd Analytics by…Ad Analytics by…
Microsoft ExcelDateCostClicksDaily 09:00Account managers rebuild the LinkedIn Ads workbook from CSV exports before every pipeline meeting, and it still shows cost, not deals.
Paste this into your AI assistant. It loads LinkedIn Ads into your data warehouse, ties campaigns to website sessions and leads, and pulls that Data Mart into Microsoft Excel through the add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/linkedin-ads-connector-to-microsoft-excel.md. The task: give me a Microsoft Excel workbook of LinkedIn Ads spend, clicks and leads by campaign that I refresh before the pipeline meeting, without exporting a CSV. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
LinkedIn Ads Endpoints
8 LinkedIn Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Accounts
Your ad account settings, billing details, currency, and account status.
14 fieldsAd Analytics
Daily performance metrics for your campaigns — impressions, clicks, spend, and conversions.
104 fieldsTime seriesAd Analytics by Country
Daily campaign performance by the country of the members who saw your ads — impressions, clicks, spend, and conversions per country.
100 fieldsTime seriesAd Analytics by County
Daily campaign performance by the county of the members who saw your ads — impressions, clicks, spend, and conversions per county.
100 fieldsTime seriesAd Analytics by Region
Daily campaign performance by the region of the members who saw your ads — impressions, clicks, spend, and conversions per region.
100 fieldsTime seriesCampaign Groups
Top-level containers that group campaigns with shared objectives, budgets, and scheduling.
14 fieldsCampaigns
Individual campaigns defining your targeting, ad format, bid strategy, and budget.
29 fieldsCreatives
The visual and copy elements of your ads shown to members across LinkedIn.
14 fields
Why LinkedIn Ads does not go straight to Excel
LinkedIn Ads reaches Excel through a CSV export or a connector, but not reliably, at scale or business-ready. A B2B deal closes months after the click, and a workbook of ad costs does not show it. The data warehouse holds the join first.
- LinkedIn Ads reports cost per lead form, not the pipeline that lead became
- The data analyst links campaigns to CRM deals by SQL keys, then publishes the result
- Sales and finance review one workbook instead of three exports
LinkedIn AdsAd spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load LinkedIn Ads into your data warehouse first
LinkedIn AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databrickslinkedin_ads.ad_analyticsStep 2: Link LinkedIn Ads to web analytics and deals
In your data warehouse the model puts LinkedIn Ads next to Facebook Ads and Google Ads, then connects sessions and leads by a campaign key. Pick an industry to see the shape of its model.
- B2B spend and consumer spend share one table
- Leads, sessions and subscriptions join by SQL keys, not by an email match in a cell
- cost_per_lead and pipeline_per_dollar are defined once
LinkedIn AdsAd Analytics
Facebook AdsAd spend
Google AdsAd spendStep 3: Pull LinkedIn Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published LinkedIn Ads Data Mart (Ad Analytics), tick the columns you want and press Create & Run.
- Pull costInUsd, clicks and the website conversions next to the date
- The add-in reads the data warehouse, so a LinkedIn token never sits in the workbook
Microsoft ExcelYour columns staydateRangeStartcostInUsdclicksStep 4: Refresh the LinkedIn Ads workbook when you need it
Refresh the workbook before the pipeline meeting. Imported columns update; the notes, formulas and pivots you added stay where they are.
- Refresh rewrites only the columns the add-in created
- No refresh job to babysit: you press it when you need current numbers
Microsoft ExcelYour column staysdateRange…costInUsdclicksYoursStep 5: Reuse LinkedIn Ads inside OWOX MCP
Your LinkedIn Ads Data Mart carries over to OWOX MCP, your assistant for data. Ask for any report, chat with the numbers, then open the result in Google Sheets or Excel in one click.
- Ask about leads or revenue in plain words
- Workbook and chat read one definition of every measure
Google SheetsOpenExcelOpen
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
Why OWOX for LinkedIn Ads in Excel
A one-off export or a connector add-in moves LinkedIn Ads cost into Excel. OWOX adds the long B2B view: the same campaign tracked to the deal.
- The long sales cycle fits. Cost stays joined to leads and deals that close months later, so Excel shows more than clicks.
- Ad Analytics columns you choose. Pick the Ad Analytics columns the workbook needs, from 175 fields across five endpoints.
- Pull when you need it. The add-in refreshes imported columns on demand and keeps your own.
- Maintained for you. No export macro to repair when LinkedIn changes its API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.