Steps to Set Up Offline Conversion Import for Meta Ads
A technical, step-by-step guide for US brands to capture and attribute offline sales back to Meta campaigns with accurate matching and clean data pipelines.

Image via 123RF
In This Article
Step-by-step process
Data mapping essentials
Validate & scale
Why offline conversion import for Meta Ads matters
Offline conversion import for Meta Ads lets Shopify, WooCommerce and B2B teams close the loop between paid media and real-world revenue. By importing CRM or POS transactions to Meta, you improve attribution accuracy, reduce CAC uncertainty, and measure true campaign-driven revenue in $ for US marketplaces. This guide walks through the technical steps to set up offline conversion import for Meta Ads and integrates with common US stacks.
Who this is for
Founders, growth managers, and in-house performance teams using Meta (Facebook/Instagram) for lead gen or eCommerce who need reliable matching between customer records and ad clicks. If you manage offline receipts, phone orders, or enterprise contracts and use platforms like Shopify, Stripe, HubSpot or Salesforce, these steps apply.
If you want a broader digital growth approach that pairs attribution with CRO and paid media execution, see our Services Overview or learn about our team on the About page.
Prerequisites and quick architecture
Before starting, collect these items: a Business Manager account with Events Manager access, the Pixel or Conversions API installation guidance, a CRM or POS export that includes email/phone/transaction_id, and a secure server or ETL process to hash and transmit PII as required by Meta. The high-level architecture is: CRM/POS -> ETL (hashing & mapping) -> Events Manager (Offline Event Set or Conversions API) -> Meta attribution processing.
- Identify matching keys: email (preferred), phone, first_name+last_name+city, and transaction_id.
- Decide import method: CSV upload to an Offline Event Set or API-based imports for automated, frequent syncs.
- Confirm privacy and consent handling for United States customers (CCPA considerations) and store hashed values only in transit.
Hashing note: Meta requires SHA-256 hashed values for identifiers. Hash before transmission and avoid sending cleartext PII. This is a common cause of low match rates when skipped.
Mapping table: CRM fields to Meta parameters
| CRM field | Meta parameter | Notes |
|---|---|---|
| Lowercase, trimmed, SHA-256 hashed | ||
| phone | phone | Strip non-numeric characters, include country code |
| transaction_id | user_data.transaction_id or custom_event_id | Helps dedupe and attribute offline sale to click |
Funnel quick view (TOF → MOF → BOF)
- TOF: Impressions and reach measured by Meta - use to seed audiences.
- MOF: On-site engagement and lead capture (form fills, add-to-cart).
- BOF: Offline conversions such as in-store purchase, phone sale, or signed contract reconciled back to ads via offline conversion import.
Where to start in Meta
Create an Offline Event Set in Events Manager and connect it to the ad account(s) you want to attribute. For test imports use a small CSV with 10-50 hashed rows to validate match rates before scheduling large imports. If you need help aligning tracking with a larger growth plan, our team outlines structured frameworks on the Prebo Digital homepage.
Step-by-step: Set up offline conversion import for Meta Ads
Follow these technical steps to implement offline conversion import for Meta Ads. This covers CSV imports and API-based imports so you can choose a manual or automated approach depending on volume and cadence.
1. Export and clean your data
Export transactions from your CRM or POS (e.g., Shopify, Salesforce, HubSpot). Include: transaction_id, sale_amount (USD), purchase_time (ISO 8601), email, phone, first_name, last_name, city, state. Clean data to US formats-phone numbers with +1 country code and emails lowercased. For US-based B2B deals, include company and contract value in $ as an example field.
2. Hash and map identifiers
Apply SHA-256 to identifiers client-side in your ETL or server process. Example match keys: email, phone, and transaction_id. Hashing before transport reduces compliance risk and improves match integrity. If you use a third-party ETL, verify they support hashed outputs aligned to Meta specs.
3. Choose import method
- CSV upload to Offline Event Set - suitable for low-frequency imports.
- Offline Conversions API or Server-to-Server integration - recommended for daily automated syncs and higher volume.
4. Upload, validate, and reconcile
Upload your hashed CSV in Events Manager or push via API and monitor match-rate metrics. Expect match rates to vary; typical ranges are 20%-70% depending on the identifiers available and data quality. For example, a US retail chain with email and phone may see a 45% match rate initially (estimate).
5. Attribution, deduplication, and reporting
Meta deduplicates events by matching identifiers and event time. Use transaction_id to help prevent double counting between online conversions and offline imports. Set an appropriate attribution window (e.g., 7-28 days) and compare campaign spend to offline revenue to calculate adjusted CAC and MER. For practical help tying tracking into broader reporting systems like GA4 or a data warehouse, see our Services Overview.
Operational tips and common pitfalls
- Test with a small sample CSV and verify that Events Manager shows expected matches before running full imports.
- Keep timezones consistent (use UTC or ISO 8601) to avoid mismatches in event time.
- Avoid sending un-hashed PII; verify hashing logic and character encoding to prevent mismatches.
Example: attributing a $2,500 offline sale
A US B2B seller closes a $2,500 contract that originated from a Meta lead. After importing the hashed transaction with transaction_id and email, Meta matches the event to a prior ad click. If campaign spend was $500, and match-rate-adjusted attribution shows $2,000 of revenue attributable to the campaign (estimates), you can recalculate CAC and MER to inform scaling decisions. These figures are illustrative and depend on match rates and attribution settings.
Automation and long-term strategy
For frequent imports set up a daily ETL job or use the Offline Conversions API. A structured framework-strategy → build → test → scale → report-helps move from manual uploads to automated, reliable attribution that supports profitable scaling. If you want expert help mapping this into your stack and server-side tracking, talk to a tracking expert to explore implementation options.
Validation KPIs to monitor
- Match rate (hashed identifiers matched to Meta users)
- Deduplication rate vs online conversions
- Revenue attributed to Meta campaigns (USD) vs ad spend
Need a partner for complex setups?
Implementations that span multiple CRM systems or require server-side hashing and ETL pipelines often benefit from a structured partner. Learn how our technical-first approach pairs tracking and CRO to drive profitable growth on the About page.

