--- title: "LinkedIn Ads to Databricks Connector | OWOX" canonical: "https://www.owox.com/connectors/free-linkedin-ads-connector-to-databricks" updated: "2026-10-28" --- # Land LinkedIn Ads data in Databricks LinkedIn Ads to Databricks with OWOX Data Marts: one table per endpoint in your own catalog and schema, readable field descriptions, a scheduled refresh. Then join ad spend to your web analytics and CRM data to see which ads became deals. ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)LinkedIn Ads · Connected · Ad Accounts · Ad Analytics · Ad Analytics by… · Ad Analytics by… Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Date · Cost · ClicksDaily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## LinkedIn Ads Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/linked-in-ads/readme/) 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 fields](/data-sources/linkedin-ads#schema-ad-accounts) * [Ad Analytics Daily performance metrics for your campaigns — impressions, clicks, spend, and conversions. 104 fields · Time series](/data-sources/linkedin-ads#schema-ad-analytics) * [Ad Analytics by Country Daily campaign performance by the country of the members who saw your ads — impressions, clicks, spend, and conversions per country. 100 fields · Time series](/data-sources/linkedin-ads#schema-ad-analytics-by-country) * [Ad Analytics by County Daily campaign performance by the county of the members who saw your ads — impressions, clicks, spend, and conversions per county. 100 fields · Time series](/data-sources/linkedin-ads#schema-ad-analytics-by-county) * [Ad Analytics by Region Daily campaign performance by the region of the members who saw your ads — impressions, clicks, spend, and conversions per region. 100 fields · Time series](/data-sources/linkedin-ads#schema-ad-analytics-by-region) * [Campaign Groups Top-level containers that group campaigns with shared objectives, budgets, and scheduling. 14 fields](/data-sources/linkedin-ads#schema-campaign-groups) * [Campaigns Individual campaigns defining your targeting, ad format, bid strategy, and budget. 29 fields](/data-sources/linkedin-ads#schema-campaigns) * [Creatives The visual and copy elements of your ads shown to members across LinkedIn. 14 fields](/data-sources/linkedin-ads#schema-creatives) ## S00 · Why ## Why bring LinkedIn Ads into Databricks with your CRM data Run an ad today and the deal may close a year from now, and the ad account will not connect the two. Ad spend, website touch points and CRM deals need to be tables in one [data warehouse](/data-storages) so a single query can follow the path. * Put LinkedIn spend next to Facebook, Google and Microsoft Ads costs in Databricks * Tie a click and a form submit to the CRM deal that followed * Keep the data in your own Databricks tables, ready for a data model ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)LinkedIn Ads · Ad spend Web analytics · Clicks, form fills CRM · Deals ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · Ad · Touch point · DealJoined by id · Ad clicked · Deal months laterOne query links the ad to the deal. ## S01 · Step 1 ## Step 1: Connect LinkedIn Ads and pick the fields Create a Data Mart on your Databricks [data storage](/data-storages), choose LinkedIn Ads as the [data source](/data-sources) and authorize once. Open an endpoint and select the fields to load. * Five endpoints and 175 fields to choose from * Ad Analytics alone has 104 fields: spend, impressions, clicks, conversions, leads New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)LinkedIn Ads · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%3E%3Cpath%20fill%3D%22%23FF4500%22%20d%3D%22M24%2048c13.2548%200%2024-10.7452%2024-24S37.2548%200%2024%200%200%2010.7452%200%2024s10.7452%2024%2024%2024Z%22%2F%3E%3Cpath%20fill%3D%22%23fff%22%20d%3D%22M40.0082%2024.0013c-.0247-.6756-.2443-1.3296-.6323-1.8831-.388-.5536-.9278-.9831-1.5544-1.2368-.6266-.2537-1.3132-.3207-1.9771-.193-.6638.1277-1.2765.4448-1.7642.9129-2.7302-1.8559-5.9395-2.8812-9.24-2.952l1.56-7.488%205.136%201.08c.0611.5675.3224%201.0947.7371%201.487.4148.3922.9557.6238%201.5258.6531.5701.0293%201.132-.1455%201.5848-.4931.4528-.3476.7668-.8452.8858-1.4035s.0351-1.1407-.2366-1.6427c-.2718-.502-.7135-.89074-1.2461-1.09639-.5325-.20564-1.1208-.21475-1.6594-.0257-.5387.18906-.9922.56389-1.2794%201.05729l-5.88-1.17603c-.0962-.0211-.1956-.0229-.2924-.0053-.0969.0176-.1893.05425-.2719.10783-.0826.05357-.1537.12301-.2093.20429-.0556.08127-.0945.17281-.1144.26921l-1.776%208.328c-3.3411.0503-6.5945%201.0764-9.36%202.952-.37-.3481-.8112-.6117-1.2932-.7723-.4819-.1606-.993-.2145-1.4979-.158-.5048.0565-.9913.2222-1.42582.4854-.43447.2633-.80651.6178-1.09033%201.0392-.28383.4213-.47264.8993-.55337%201.4008-.08072.5016-.05142%201.0147.08587%201.5038.13729.4891.37928.9425.70922%201.3288.32993.3863.73991.6962%201.20153.9083-.027.3514-.027.7045%200%201.056%200%205.376%206.264%209.744%2013.992%209.744%207.728%200%2013.992-4.368%2013.992-9.744.027-.3515.027-.7046%200-1.056.5922-.2944%201.0891-.7504%201.4331-1.3152.344-.5649.5211-1.2155.5109-1.8768Zm-24%202.4c0-.4747.1408-.9387.4045-1.3334.2637-.3947.6385-.7023%201.0771-.8839.4385-.1817.9211-.2292%201.3866-.1366.4656.0926.8932.3212%201.2289.6568.3356.3357.5642.7633.6568%201.2289.0926.4655.0451.9481-.1366%201.3866-.1816.4386-.4893.8134-.8839%201.0771-.3947.2637-.8587.4045-1.3334.4045-.3152%200-.6273-.0621-.9184-.1827-.2912-.1206-.5558-.2974-.7787-.5203-.2228-.2228-.3996-.4874-.5202-.7786-.1206-.2912-.1827-.6033-.1827-.9184Zm13.944%206.696c-1.7027%201.2831-3.7977%201.8402-5.928%201.752-2.1303.0882-4.2253-.5649-5.928-1.848-.1021-.1244-.1542-.2822-.1463-.4429.0079-.1607.0752-.3127.189-.4264.1137-.1138.2657-.1812.4264-.1891.1607-.0078.3186.0443.4429.1464%201.443%201.0584%203.2043%201.5918%204.992%201.512%201.7899.0973%203.5595-.4192%205.016-1.464.1273-.1242.2987-.1926.4765-.1904.088.0011.175.0196.2559.0543.0809.0347.1541.085.2156.1481.0615.063.1099.1375.1426.2193.0326.0817.0489.1691.0477.2572-.0011.088-.0195.1749-.0542.2558-.0348.0809-.0851.1542-.1481.2157ZM29.5%2029.0005c-.4747%200-.9185-.244-1.3132-.5077-.3946-.2637-.7023-.6385-.8839-1.0771-.1817-.4385-.2292-.9211-.1366-1.3866.0926-.4656.3212-.8932.6568-1.2289.3357-.3356.7633-.5642%201.2289-.6568.4655-.0926.9481-.0451%201.3866.1366.4386.1816.8134.4892%201.0771.8839.2637.3947.4045.8587.4045%201.3334.013.3252-.0402.6496-.1565.9536-.1162.3039-.2931.5811-.5199.8145-.2267.2335-.4986.4184-.799.5436-.3004.1251-.6194.195-.9448.1915Z%22%2F%3E%3C%2Fsvg%3E)Reddit Ads · AuthorizeConnected · Endpoint · Ad Analytics · Ad Accounts · Ad Analytics by C… · Ad Analytics by C… ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)Ad Analytics · 104 fields · dateRangeStartcostInUsdcostInLocalCurrencyclicksexternalWebsiteConversionsqualifiedLeads ## S02 · Step 2 ## Step 2: Load LinkedIn Ads into a Databricks table Choose the catalog, schema and table. They are pre-filled, starting from the main catalog, and you can change them. Run it and the first load lands in your own Databricks workspace. * Each endpoint gets its own table, not one wide table of every field * Every run is logged in Run History ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · linkedin\_ads · Table · ad\_analytics · Run Run History · Pending · Running · SuccessIncremental load ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.linkedin\_ads.ad\_analytics ## S03 · Step 3 ## Step 3: Open the output schema in plain words The first run gives you the output schema: every field with an alias and a business-friendly description. Your [data quality](/product/data-quality) checks can read it too. * Descriptions follow the LinkedIn Ads documentation * Teammates can read the table without the API reference ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.linkedin\_ads.ad\_analytics · Output schema · Field · DescriptiondateRangeStart · Start date of the report data… · costInUsd · Cost in USD based on the pivot… · costInLocalCurrency · Cost in the account's local… · clicks · The count of chargeable clicks… · externalWebsiteConversions · Total number of times users… · qualifiedLeads · The count of qualified leads… ## S04 · Step 4 ## Step 4: Keep the LinkedIn Ads tables linked in Databricks Campaign groups, campaigns, creatives and ad analytics stay separate tables, joined by ids. In SQL they become one LinkedIn Ads [data model](/product/data-modeling). * LinkedIn stores links as URNs such as urn:li:sponsoredAccount:{id}; extract the id to join * Join the model to web analytics and CRM tables ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)Campaign Groups · name · account · id ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)Campaigns · id · name · campaignGroup ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)Creatives · id · campaign · isServing ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)Ad Analytics · costInUsd · pivotValues ## S05 · Step 5 ## Step 5: Run on a schedule and backfill the history Set it once. A daily scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice. * Incremental load for the current day * Backfill a custom period for history * No pipeline to maintain Schedule · Run on a schedule · Daily 09:00 Backfill · Run backfill Run History · Daily schedule · Manual backfill · Daily schedule ## S06 · Step 6 ## Step 6: Reuse the Databricks tables in every tool One set of tables feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) like Claude and ChatGPT and AI insights in Slack or email. * Define the numbers once * Every report reads the same tables ![](https://cdn.owox.com/www/webflow/679a0196297e59cd87da67aa_13.svg/public)LinkedIn Ads · Data Mart · Published Your data model ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets ![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards ![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT ![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email ## Related connectors [LinkedIn Ads to Claude](/connectors/linkedin-ads-connector-to-claude)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[LinkedIn Ads to ChatGPT](/connectors/linkedin-ads-connector-to-chatgpt)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks)[LinkedIn Pages to Databricks](/connectors/free-linkedin-pages-connector-to-databricks) · Show 6 more · Show fewer ## Recent updates * [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430) * [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430) * [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430) * [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410) * [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410) ## Why OWOX ## Why OWOX for LinkedIn Ads in Databricks Notebooks with API calls and generic ETL tools get the data in. OWOX also keeps it in your tables, readable and ready to model. * **You own the data.** It lands in your own Databricks workspace, in tables you control. * **A business-friendly schema.** Aliases and plain descriptions instead of API identifiers. * **Ready for a data model.** Separate tables per endpoint, joined by ids, built to meet web analytics and CRM. * **Maintained for you.** No jobs to repair when LinkedIn changes its API. * **Free to self-host.** The open-source OWOX Data Marts runs in your own infrastructure. [Book a call](/book-a-call) [Get Started Free](https://www.owox.com/app-signup) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/linked-in-ads/readme) - [Ad AccountsYour ad account settings, billing details, currency, and account status.14 fields](https://www.owox.com/data-sources/linkedin-ads) — /data-sources/linkedin-ads.md - [data warehouse](https://www.owox.com/data-storages) — /data-storages.md - [data source](https://www.owox.com/data-sources) — /data-sources.md - [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md - [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md - [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md - [LinkedIn Ads to Claude](https://www.owox.com/connectors/linkedin-ads-connector-to-claude) — /connectors/linkedin-ads-connector-to-claude.md - [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md - [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md - [LinkedIn Ads to ChatGPT](https://www.owox.com/connectors/linkedin-ads-connector-to-chatgpt) — /connectors/linkedin-ads-connector-to-chatgpt.md - [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md - [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md - [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md - [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md - [LinkedIn Pages to Databricks](https://www.owox.com/connectors/free-linkedin-pages-connector-to-databricks) — /connectors/free-linkedin-pages-connector-to-databricks.md - [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog) - [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md