Offline Conversions CSV Builder for LinkedIn

How to build your LinkedIn offline conversions file

LinkedIn offline conversions connect deals that close in your CRM to the people who saw or clicked your LinkedIn ads. LinkedIn takes them as a CSV in a fixed template, described in its CSV conversions template requirements. This tool turns a normal CRM export into that LinkedIn conversions CSV template and checks every rule on the page before you upload.

1. Export your conversions. From HubSpot, Salesforce or your CRM, export won deals or qualified leads with the contact's email, first and last name, company, job title, country, date and amount.
2. Load the export. Drop the file in or paste rows. Click Try sample data to see a deals export with common problems.
3. Check the columns. The tool maps headers like Contact Email, Close Date and Amount to LinkedIn's names.
4. Set the event type and currency. Pick the event type you chose when you created the CSV conversion, and your ad account currency.
5. Download the CSV. It uses the template's exact column names. A second file lists rows that can't be uploaded and why.

What the builder fixes and checks

• Matching: an email, or a first and last name of up to 35 characters each. Using both raises the chance of a match.
• Dates: in the past and no more than 90 days old, written as epoch milliseconds or MM/DD/YYYY.
• Amounts: no currency symbols, no negatives, up to 2 decimals, and 1 when there is no revenue.
• Currency and event type: the ad account currency in every row and a valid eventtype code with its underscore.
• The @ sign: allowed only in the email column, so stray emails in name or title fields are removed.

Upload offline conversions to LinkedIn Ads

1. Create the CSV conversion. In Campaign Manager go to Measure › Conversion tracking, click Create conversion and choose CSV conversion. Set the name, event type, value, conversion windows and attribution, then click Next step.
2. Upload the file. Choose Upload a CSV list, give the source a name and select the downloaded file.
3. Attach ad sets. Click Next step, pick the ad sets to measure and click Create. Conversions only count for ad sets attached to the conversion.
4. Upload new rows regularly. Data can take up to 24 hours to appear. To add a new file, open Conversion tracking, filter by the CSV data source, open the conversion and upload again. Daily or weekly works best.

Want to automate it later? LinkedIn's Conversions API takes the same data from a CRM or partner tool. Keep CSV conversions separate from Insight Tag and Conversions API conversions, because LinkedIn does not deduplicate them against each other.

Common LinkedIn conversion CSV problems

Column names don't match the template

LinkedIn says the column names must be unedited from the template. A header like Email Address or Deal Amount is not recognized. The download from this tool uses the exact template names.

Rows older than 90 days are skipped

LinkedIn doesn't process them, and fewer valid rows can push the file under the 10% minimum. Upload new closed deals every week instead of a big export once a quarter.

Amount is 0 or blank

Lead and sign-up conversions often have no value. LinkedIn still needs a number, so it asks for 1 as a placeholder.

Wrong currency

A deal in EUR in a USD ad account breaks the rule that every row uses the account currency. Convert it in your CRM report before you export.

Event type doesn't match the conversion

The eventtype in the file must match the event type you picked when you created the conversion. If none fits, use other for both.

Conversions don't show up

Wait 24 hours, then check that the conversion is attached to the right ad sets. LinkedIn keeps uploaded rows for at most 180 days and then erases them, so keep your own copy of each file.