How to Map LinkedIn Ad Impressions to HubSpot Deals

You're spending $30K/month on LinkedIn Ads. Your sales team is closing deals. But can you prove the connection? For most B2B marketing teams, the answer is "sort of" — usually involving a spreadsheet, manual exports, and a lot of squinting at dates.

This guide walks through the exact process of connecting LinkedIn Ad impressions to HubSpot deal creation, using both manual methods and automated tools.

Step 1: Understanding the Data You Need

LinkedIn Ads provides company-level engagement data through its API — specifically through the MEMBER_COMPANY pivot in the Ad Analytics endpoint. This tells you which companies (not individuals) saw, clicked, or engaged with your ads.

HubSpot stores your deals, associated companies, and the company domain. The domain is your matching key — it's how you connect "Acme Corp saw your ad" to "Acme Corp has a $50K deal in pipeline."

Step 2: Export LinkedIn Company Engagement

In LinkedIn Campaign Manager, navigate to your campaign, click "Demographics", and select "Company" as the dimension. Export this as a CSV. You'll get company names and engagement metrics — but critically, not company domains.

This is where things get tricky manually. LinkedIn's Organization API can resolve company IDs to domains, but it requires API access. Without it, you're stuck doing manual company-to-domain matching.

Step 3: Pull HubSpot Deals with Company Data

In HubSpot, create a report or export that includes: Deal Name, Deal Amount, Deal Stage, Associated Company Name, and Company Domain. Filter for deals created in your attribution window (typically 90 days).

Step 4: Match Companies Across Systems

This is the critical step. You need to match LinkedIn company names to HubSpot company records. The most reliable approach uses a two-pass strategy:

• Domain matching (primary): Match the website domain from LinkedIn's org data to HubSpot's company domain field
• Fuzzy name matching (fallback): For companies without domain matches, use name similarity scoring with a high threshold (>85%) to avoid false positives

Step 5: Calculate Attribution

For each matched company, check: Did they engage with your ads before the deal was created? If yes, that deal is "influenced" by LinkedIn Ads. Sum up the deal values, and you have your influenced pipeline number.

The Automated Alternative

If this sounds like a lot of manual work — it is. The manual process takes 4-6 hours per week for most teams, and the data is stale by the time you finish. RevenueProven automates this entire pipeline: it connects to both LinkedIn and HubSpot via OAuth, syncs data daily, handles company matching automatically, and updates attribution as deals progress through your pipeline.