Offline Conversions on Facebook: Tracking In-Store Sales

What Are Offline Conversions?

You're running Facebook ads to drive foot traffic to your retail stores. Customers see your ad, visit your location, and make purchases. But when you check Ads Manager, your conversion numbers look dismal because Facebook only tracks online actions.

This is where Offline Conversions come in.

Offline Conversions allow you to upload data about real-world sales, appointments, or events back to Facebook. The platform then matches those conversions to people who saw or clicked your ads, giving you a complete picture of your return on ad spend—both online and offline.

Key Insight: Up to 90% of retail purchases still happen in physical stores, yet most advertisers only measure online conversions. Offline Conversions bridge this gap.

How It Works (The 30-Second Version)

This closed-loop measurement transforms Facebook from a "top-of-funnel awareness tool" into a full-funnel revenue driver.

Real-World Use Cases

If your business has any offline component—and most do—you should be tracking offline conversions.

Why Track Offline Conversions?

Let me give you a real example. I worked with a furniture retailer spending $15,000/month on Facebook ads. Their Ads Manager showed a 1.8 ROAS (return on ad spend). Management wanted to cut the budget.

But when we implemented offline conversion tracking and uploaded in-store purchases, the real ROAS was 4.2x. The ads were driving massive foot traffic and sales—we just weren't measuring it.

The Business Case for Offline Tracking

Without offline tracking, you're flying blind. You might think a campaign is failing when it's actually your top revenue driver.

When Facebook knows which ads drive in-store sales, its algorithm optimizes for those conversions. Your campaigns get better over time because the AI has complete data.

Stop over-investing in campaigns that only look good online but don't drive real revenue. Allocate budget to campaigns that generate total value.

Facebook can build Lookalike Audiences from your offline buyers, not just website visitors. This unlocks higher-value customers who prefer in-person shopping.

Most advertisers don't track offline conversions. By doing so, you gain insights your competitors lack.

What You Can Measure

Facebook Offline Conversions can track:

• Purchase value – Revenue from in-store or phone sales
• Event timestamps – When the conversion happened
• Custom events – Appointments, test drives, demos, consultations
• Multiple touchpoints – Track the same customer across online and offline

You can even segment by store location, sales rep, or product category for granular reporting.

Setting Up Offline Conversions

Let's get your offline conversion tracking live. The setup has three phases: creating the dataset, preparing your data, and uploading.

Phase 1: Create an Offline Event Set

An Offline Event Set is a container for your offline conversion data. Think of it like a Facebook Pixel, but for offline events.

You now have an Offline Event Set with a unique ID. This ID is what you'll use when uploading data.

Phase 2: Prepare Your Data

Facebook needs specific customer information to match offline conversions to ad impressions. The more data you provide, the higher your match rate.

• Event Name – e.g., "Purchase", "Store Visit", "Appointment"
• Event Time – When the conversion happened (Unix timestamp or YYYY-MM-DD HH:MM:SS format)

• Email address
• Phone number (include country code)
• First name
• Last name
• City
• State
• ZIP code
• Country
• Date of birth
• Gender

• Purchase value – Revenue amount (e.g., 149.99)
• Currency – USD, EUR, GBP, etc.
• Custom data – Product name, store ID, sales rep, etc.

Privacy Note: All customer data must be hashed (SHA-256) before uploading to Facebook. Most upload tools do this automatically, but manual uploads require you to hash sensitive fields like email and phone.

Phase 3: Connect Your CRM or POS

You have three options for uploading offline conversion data:

• Export customer data from your POS or CRM
• Format as CSV with required columns
• Upload via Events Manager

• Use Facebook's Offline Conversions API
• Integrate with your CRM (Salesforce, HubSpot, Zoho)
• Automate daily or real-time uploads

• Use tools like Zapier, Segment, or AdsMAA
• Connect your data sources without code
• Schedule automatic syncs

I recommend Option B or C for ongoing campaigns. Manual uploads work for testing, but automation ensures you never miss a conversion.

How to Upload Offline Data

Let's walk through each upload method in detail.

Method 1: Manual CSV Upload

This is the fastest way to test offline conversions, but not scalable for ongoing use.

From your POS or CRM, export a CSV with these columns:

email, phone, fn, ln, ct, st, zip, country, event_name, event_time, value, currency

Example row:

[email protected], +14155551234, john, doe, san francisco, ca, 94103, us, Purchase, 2025-03-01 14:32:00, 89.99, USD

If your Events Manager requires pre-hashing, use a tool like this SHA-256 generator to hash emails and phone numbers.

Facebook will show you a match rate percentage—this is how many rows matched to Facebook users who saw your ads.

Method 2: API Upload (Automated)

For ongoing tracking, use the Offline Conversions API. This requires developer resources but enables real-time tracking.

POST https://graph.facebook.com/v18.0/{offline_event_set_id}/events

{
  "data": [
    {
      "event_name": "Purchase",
      "event_time": 1709308320,
      "user_data": {
        "em": "7d8c3c0f5c9e3f4a2b1d6e8f9a0b1c2d3e4f5a6b7c8d9e0f1a2b3c4d5e6f7a8b",
        "ph": "4c7e9a2f1d3b5e6f8a0c2d4e6f8a0b2c4d6e8f0a2b4c6d8e0f2a4b6c8d0e2f4a"
      },
      "custom_data": {
        "value": 89.99,
        "currency": "USD"
      }
    }
  ]
}

• Salesforce – Use Salesforce Marketing Cloud or a custom integration
• HubSpot – Native Facebook Offline Conversions integration
• Zapier – Connect CRM to Facebook without code
• Custom API – Build your own integration using Facebook's SDK

Method 3: Partner Integrations

If you use popular CRM or analytics platforms, they often have built-in Facebook Offline Conversions support:

• Shopify POS – Sync in-store sales automatically
• Square – Connect point-of-sale data directly
• Salesforce – Native Offline Conversions connector
• HubSpot – Map deals and contacts to Facebook
• Segment – Route offline events to Facebook as a destination

Check your platform's integration marketplace for pre-built connectors.

Improving Match Rates

Your match rate determines how many offline conversions Facebook can attribute to your ads. A 30% match rate means Facebook matched 30% of your uploaded conversions to ad impressions.

Industry benchmarks:

• Poor: 20-40% match rate
• Good: 50-70% match rate
• Excellent: 75%+ match rate

How to Boost Match Rates

The more fields you include, the better. Email + phone + name significantly outperforms email alone.

• Lowercase all emails: [email protected], not [email protected]
• Include country codes for phones: +14155551234, not (415) 555-1234
• Remove spaces and special characters from phone numbers

Facebook's attribution window is 28 days by default (configurable to 7, 14, or 28 days). Upload conversions within a few days of the event to maximize matching.

Use SHA-256 hashing for emails and phones. Incorrect hashing breaks matching entirely.

In Ads Manager, you can extend the attribution window to 7-day click, 1-day view, or 28-day click. Longer windows increase match rates but may reduce accuracy.

Train staff to ask for email or phone during checkout. Incentivize with discounts or loyalty programs.

Pro Tip: Offer a 10% discount for joining your email list at checkout. This boosts data collection and match rates while building your CRM.

Analyzing Offline Conversion Data

Once your data is flowing, it's time to optimize based on insights.

Where to Find Offline Conversion Reports

Key Metrics to Track

Optimization Strategies

Compare online-only ROAS to blended (online + offline) ROAS. Campaigns with high offline conversion rates might look weak online but are actually your best performers.

Create audiences from offline buyers:

• People who made in-store purchases
• High-value offline customers (e.g., >$500 purchases)
• Customers who bought specific product categories

Use these for retargeting and Lookalike Audiences.

If offline conversions dominate your revenue, optimize campaigns for offline events instead of online conversions. This tells Facebook's algorithm what truly matters.

If you have multiple store locations, create separate Offline Event Sets for each. This lets you measure which locations benefit most from ads.

Look at how long between ad exposure and in-store purchase. If most conversions happen within 3 days, shorten your attribution window for cleaner data.

Common Pitfalls to Avoid

• Not hashing data – Leads to zero match rate
• Uploading too late – Conversions outside attribution window are lost
• Incomplete customer data – Low match rates reduce insights
• Ignoring match rate trends – Declining match rate signals data quality issues
• Not testing campaigns – Run a holdout test to prove ad incrementality

Ready to automate offline conversion tracking? Sign up for AdsMAA and connect your CRM, POS, and ad accounts for unified reporting across online and offline channels.

Bringing It All Together

Offline Conversions turn Facebook from an online-only platform into a true omnichannel measurement tool. For businesses with physical locations, phone sales, or in-person services, it's the difference between guessing and knowing what drives revenue.

The setup takes an afternoon, but the insights last forever. You'll finally see the full impact of your ads—not just clicks and website conversions, but real-world sales that drive your bottom line.

Once you see the complete picture, you'll wonder how you ever optimized ads without it.

• Learn how to optimize Facebook campaign budgets using both online and offline data
• Explore advanced attribution models to credit multi-touch journeys
• Discover privacy-compliant tracking strategies for offline data

Your customers don't live in a purely digital world—your measurement shouldn't either.