How to Turn CRM Data Into a Paid Media Plan and Audiences

Most paid media plans start from a persona doc and last quarter's channel mix. Your CRM holds a better brief: which accounts bought, what they paid, and how long they took to close. Here is how to turn that into segments, a budget split and live audiences in LinkedIn Ads, Google Ads and Meta Ads Manager, including the size and match rules that decide whether a segment can be targeted at all.

What to pull from Salesforce or HubSpot before you plan spend

Pull records, not dashboards. You want one row per opportunity with account attributes attached, so you can compare wins to losses. Five exports cover almost every planning decision:

• Closed-won opportunities, last 18 to 24 months: account name, website domain, industry, employee count, region, amount, create date, close date, lead source.
• Closed-lost opportunities, same window: same fields plus loss reason and stage reached. Losses at stage 1 tell you about targeting; losses at stage 4 tell you about product and price.
• Open pipeline: accounts with an active opportunity and their stage. These are your bottom-of-funnel and sales-support audiences.
• Buying committee contacts on won deals: titles and seniority from Salesforce opportunity contact roles, or contacts associated with a HubSpot deal. Real job title targeting comes from here.
• Customers and churned accounts: your suppression and expansion lists.

Two hygiene rules matter most. Make the account website domain a required, cleaned field, because domain is the join key between the CRM, LinkedIn company lists and your reporting. And export work email on contacts, since match rates depend on the identifier you hand over.

How to turn closed-won patterns into segments and a budget split

Aim for 3 to 5 segments you can name, size and fund, not a 12-cell matrix nobody runs.

1. Cluster the wins. Sort closed-won deals by industry, then employee band, then region. Keep every cluster with at least 5 wins.
2. Score each cluster on three numbers: win rate, average deal size and median days to close. Expected value per opportunity is win rate times deal size. A segment closing 25% at $60,000 is worth $15,000 per opportunity; one closing 12% at $30,000 is worth $3,600. Fund the first one first.
3. Check reachability. Count the matchable accounts and contacts per segment, then compare against the platform minimums below. A segment with 120 matchable accounts is a sales play, not a LinkedIn campaign.
4. Split budget by expected value. A defensible starting split across three segments is 60/30/10, with the smallest share on the unproven cluster.
5. Write the exclusions now: customers, late-stage opportunities, closed-lost-for-price accounts, competitors and your own employee domains.

How to push CRM lists into LinkedIn matched audiences

LinkedIn matched audiences accept two kinds of CRM export: a company list (names and domains) and a contact list (emails). Most failed uploads are size or header problems.

• Per LinkedIn's company targeting list requirements, an uploaded list needs at least 300 rows, must match a minimum of 300 members to be used in an active campaign, and caps at 20 MB or 300,000 companies. LinkedIn recommends 1,000 or more companies and suggests adding the LinkedIn Page URL plus fields like industry, city, state, country or zip to improve matching.
• For contacts, LinkedIn's contact targeting requirements set the same 300-row and 300-matched-member floor, and recommend uploading at least 10,000 personal or professional email addresses to help ensure the list matches at least 300 verified addresses on LinkedIn. Emails can be plain or SHA-256 hashed.
• Do not change the template headers. LinkedIn's matched audiences troubleshooting guide lists the supported company headers (companyname, companywebsite, companyemaildomain, linkedincompanypageurl, stocksymbol, industry, city, state, companycountry, zipcode) and contact headers (email, firstname, lastname, jobtitle, employeecompany, country).
• If a segment lands under 300 matched members, that guide notes you can select multiple lists in one campaign to clear the minimum. Location is a required targeting criterion and will cut the audience further.
• Check match quality with the Company Engagement Report, which LinkedIn documents as showing which companies from an uploaded list were and were not matched.

The practical read: expect only a fraction of a contact list to become targetable. Company lists built on clean domains hold up better than contact lists of personal Gmail addresses from gated content.

How to push the same segments into Google Customer Match

Google Customer Match turns a CRM list into audiences across Search, the Shopping tab, Gmail, YouTube and Display, per Google's Customer Match documentation. Four rules shape how you run it:

• Minimum size. Google's Customer Match troubleshooting guide states that all submitted files must have a minimum of 100 user records, and recommends audience list sizes of at least 100 users to prevent ads from not serving.
• Freshness. Lists have a maximum membership duration of 540 days, and a list must have at least 100 members added or updated within the last 540 days to stay eligible. Schedule a refresh; do not upload once.
• Formatting. Files must be CSV using only the approved headers (Email, Phone, First Name, Last Name, Country, Zip, Mobile Device ID). If you pre-hash, use hex SHA-256 on lowercased, trimmed values; Google Ads can also hash raw data locally at upload. Processing can take up to 48 hours.
• Auto-inclusion. Campaigns using Smart Bidding and optimized targeting automatically include all Customer Match lists in the account unless you opt out. If your closed-won list is quietly shaping a prospecting campaign's bidding, that is why. Google also now recommends Data Manager or the Data Manager API over the Google Ads API for new Customer Match integrations.

Mirror the same segments into Meta as customer list custom audiences, and keep segment names identical across platforms so reporting lines up later.

Which ad platforms integrate natively with HubSpot and Salesforce

HubSpot is the most hands-off option if your CRM is HubSpot. Its ads audiences documentation covers Facebook, Google and LinkedIn ad accounts, audiences built from website visitors, HubSpot contacts or existing audiences, and a sync that runs in both directions as contacts enter or leave a segment. HubSpot also warns that synced audience size will be significantly lower than the number of contacts you selected, because each network matches on cookies or contact information. It publishes the per-network minimums, which are the numbers to plan against:

Salesforce is different. There is no one-click audience push inside Sales Cloud, so segments reach ad platforms one of three ways: a manual report export and upload, activation through Salesforce Data Cloud, or a sync layer such as a reverse ETL tool. That is the main reason Salesforce-based teams end up with stale lists.

Which tools do which step

Tofu publishes this article and makes Tofu Ads Agent. Here is an honest map of where each category stops.

Tofu Ads Agent reads closed-won and closed-lost deals, pipeline, sales velocity and deal size to produce the ICP and segments, plans top, mid and bottom of funnel plays, sizes audiences before any spend, and stages campaigns into your own ad account switched off until someone turns them on. Pricing is a flat $2,500 per month, not a percentage of spend. The honest limits: it is newer than Metadata.io, 6sense or Demandbase, it needs CRM and ad-account connections first, and it recommends rather than auto-spends.

How to write campaign data back to the CRM

A segment plan with no write-back is a guess with a spreadsheet. Three steps make pipeline attributable by segment:

1. Standardize UTMs before launch. Encode segment, funnel stage and channel in utm_campaign and utm_content, and use the same naming in LinkedIn Campaign Manager, Google Ads and Meta Ads Manager.
2. Capture them on the form and store them on the record. Hidden fields for first-touch and last-touch campaign on the contact, stamped onto the account and opportunity so revenue groups by segment.
3. Turn on native tracking if you use HubSpot. Per HubSpot's ad tracking documentation, HubSpot attributes contacts to specific ads by appending tracking parameters to your ad URLs, and only attributes clicks that happen after auto-tracking is enabled. Mind the gaps: LinkedIn Message ads, Thought Leader Ads and Document ads cannot be tracked due to API limitations, though Lead Gen Form submissions still sync, and renaming an ad campaign does not update the utm_campaign value in the tracking template.

Mistakes that break CRM-to-ads workflows

• Confusing record count with audience size. Google explains that file counts and reported list size differ because of inactive users, ad personalization opt-outs and formatting problems. Plan around matched size.
• Launching segments that cannot clear the floor. Under 300 matched members, a LinkedIn campaign will not serve. Combine lists or switch that segment to firmographic targeting.
• Uploading once. A Customer Match list with no members added or updated in 540 days becomes ineligible, and a static export goes stale the week sales adds new accounts.
• Dirty domain data. Blank or misspelled website fields break company matching and show up as misses in the Company Engagement Report.
• No suppression. Customers, late-stage opportunities and internal domains eat budget if you never build the exclusion lists.

With the plan, segments and write-back in place, the bottleneck moves to execution: enough creative per segment to test, campaigns built per funnel stage, and weekly bid and budget tuning. That is the work lean B2B SaaS teams run out of time for, and what Tofu Ads Agent produces while a person still approves every launch.

Frequently asked questions

Sources

1. Requirements for company targeting lists in Campaign Manager · LinkedIn Help
2. Requirements for contact targeting lists in Campaign Manager · LinkedIn Help
3. Troubleshooting Tips for LinkedIn Matched Audiences · LinkedIn Help
4. About Customer Match · Google Ads Help
5. Fix Customer Match issues with list upload, small list size, or low volume · Google Ads Help
6. Create ads audiences in HubSpot · HubSpot Knowledge Base
7. Ad tracking in HubSpot · HubSpot Knowledge Base