How to Credit In-Person Sales to Facebook Ads Using Shopify and Zapier
Most businesses completely lose track of sales that happen at pop-up shops, markets, or through direct conversations. This Shopify-Zapier integration automatically sends every purchase to Facebook Ads - giving you accurate conversion data and better ad performance.
The Offline Conversion Problem
If you sell products at pop-up shops, markets, or through direct sales conversations, you're likely missing a critical piece of your marketing puzzle. Facebook can't automatically track these offline purchases like it does with website conversions, leaving you blind to which ads actually drove those sales.
This creates a dangerous gap in your advertising data. You might be turning off high-performing ads because they appear ineffective, while continuing to fund ads that look good in reports but don't drive real business results.
The impact: Businesses that implement offline conversion tracking typically see a 20-35% improvement in ad performance within 60 days, simply from having complete data.
How Facebook Tracks Offline Sales
Facebook's offline conversions system works by matching customer information from your sales (like email or phone number) with people who interacted with your ads. When a match is found, Facebook attributes the sale to your ad campaign while maintaining customer privacy through data hashing.
The process requires four key pieces of information from each Shopify order:
- Customer identifier (email or phone number)
- Purchase amount and currency
- Event timestamp (when the sale occurred)
- Event name (like "Purchase" or "Lead")
This integration ensures Facebook's algorithm receives the same conversion signals from offline sales as it does from online purchases, allowing for accurate optimization.
Step 1: Shopify Trigger Setup
Begin by creating a new Zap in Zapier and selecting Shopify as your trigger app. Choose the "New Order" trigger event - this tells Zapier to watch for every completed sale in your Shopify store.
You'll need to connect your Shopify account to Zapier by:
- Clicking "Sign in to Shopify"
- Entering your store's URL (yourstore.myshopify.com)
- Granting the necessary permissions
Pro tip: Test your trigger with a recent Shopify order to confirm Zapier can access your order data before proceeding to the next step.
Step 2: Facebook Action Configuration
For the action step, search for and select "Facebook Offline Conversions". Choose the "Send Offline Conversion Event" action - this creates the bridge between Shopify and Facebook's ad system.
Connect your Facebook Ads account by:
- Selecting the correct Facebook Business Manager account
- Choosing the ad account that runs your campaigns
- Granting Zapier the necessary permissions
At 1:15 in the video tutorial, you'll see the critical mapping step where we match Shopify order fields to Facebook's required data points.
Data Mapping Best Practices
Accurate data mapping is crucial for successful offline conversion tracking. These field mappings ensure maximum match rates and clean data in Facebook Ads Manager:
| Facebook Field | Shopify Data Source | Notes |
|---|---|---|
| Email/Phone | Customer email or phone | Use both if available for better matching |
| Event Time | Created at timestamp | Must be within 28 days of ad exposure |
| Event Value | Total price | Include currency mapping |
| Event Name | Custom value "Purchase" | Can use order tags for different events |
Critical note: Facebook's matching system works best when the customer used the same email/phone on Shopify that they used when interacting with your ads. Encourage customers to provide this information at checkout.
Testing Your Integration
Before turning your Zap live, thoroughly test each component:
- Trigger test: Confirm Zapier can pull recent Shopify orders
- Action test: Send a sample conversion to Facebook
- Facebook verification: Check Offline Events Manager for the test event
At 2:30 in the video, you'll see how to verify the test event appears in Facebook's system before going live with the integration.
Analyzing The Results
Once live, monitor these key metrics in Facebook Ads Manager to gauge the integration's impact:
- Match rate: Percentage of offline events matched to ad viewers (aim for 60%+)
- Cost per conversion: Should decrease as Facebook gains more complete data
- Conversion value: Total attributed revenue from both online and offline sales
Expect to see more accurate reporting within 7 days, with improved ad performance becoming noticeable after 14-21 days as Facebook's algorithm adjusts to the new data.
Watch the Full Tutorial
For a visual walkthrough of each step, including the exact field mappings and testing process, watch the complete video tutorial below. At 1:45, you'll see the critical moment where we verify the Facebook connection is working properly.
Key Takeaways
Tracking offline conversions completes your advertising picture, ensuring Facebook optimizes for your true business results rather than just online metrics.
In summary: This Shopify-Zapier-Facebook integration gives you accurate conversion data from all sales channels, leading to better ad decisions and improved ROI. The setup takes less than 30 minutes but provides ongoing benefits for your advertising strategy.
Frequently Asked Questions
Common questions about offline conversion tracking
Tracking offline conversions helps attribute sales that happen outside your online store (like at pop-up shops or events) back to your Facebook ad campaigns. This gives you a complete picture of ad performance and allows Facebook's algorithm to optimize for your true business outcomes.
Without offline conversion tracking, you're likely undervaluing your best-performing ads because their full impact isn't being measured. Many businesses discover that ads they thought were underperforming are actually their top drivers when offline sales are included.
- 20-35% improvement in ad performance is typical after implementation
- Enables optimization for true revenue, not just online metrics
- Provides complete ROI calculation across all sales channels
The integration sends customer email or phone number (for matching), order value, currency, purchase timestamp, and event name (like 'purchase'). Facebook uses this data to match conversions with people who saw your ads while respecting privacy standards.
Only the data necessary for conversion tracking is shared - no full customer records or sensitive information is transmitted. Facebook hashes all personal data before processing to maintain privacy.
- Customer email and/or phone number
- Order total and currency
- Purchase date and time
While this specific tutorial uses Shopify, the same principles apply to other ecommerce platforms. The key requirements are being able to trigger on new orders and access the necessary customer and order data.
Most major platforms have Zapier integrations that can be similarly configured. The exact field names might vary slightly, but the core concept remains the same - triggering on new sales and sending the relevant data to Facebook's offline events API.
- Works with Square, Clover, and other POS systems
- Requires access to customer email/phone and order details
- May need custom field mapping for some platforms
Offline conversions typically appear in Facebook Ads Manager within 24 hours. The delay allows for matching and processing time. For accurate reporting, Facebook looks back up to 28 days from the conversion date to determine which ads influenced the sale.
Initial matches may take longer as Facebook builds its matching models. After the first week, you should see consistent daily updates to your conversion data.
- 24-hour processing time typically
- 28-day attribution window
- Matching improves over time
Yes, Facebook's offline events API supports tracking various event types beyond purchases, including leads, registrations, and custom events. You can configure different Zaps for different event types based on your Shopify order tags or other triggers.
Common additional events include lead generation at trade shows, appointment bookings, or custom conversion points specific to your business model. Each can be tracked separately in Facebook's system.
- Purchase events (most common)
- Lead events for potential customers
- Custom events for unique business needs
Online conversions are tracked automatically via the Facebook pixel when purchases happen on your website. Offline conversions require manual or automated upload of sales data for transactions that occur outside your digital properties. Both contribute to your overall conversion reporting.
The key difference is in how the data is collected - automatic vs. manual - not in how Facebook values or optimizes for the conversions. Both types are equally valuable for campaign optimization.
- Online: Automatic via pixel
- Offline: Manual/automated upload
- Same optimization value
Facebook reports that offline event matching typically achieves 60-80% match rates when using email addresses. Adding phone numbers can improve matching. The system uses hashed customer data to maintain privacy while still providing accurate attribution.
Match rates depend on several factors including whether customers use the same email/phone across platforms, and whether they're logged into Facebook when seeing your ads. Providing multiple identifiers improves accuracy.
- 60-80% match rate with email alone
- Higher with phone numbers added
- Hashing maintains privacy
GrowwStacks specializes in building custom automation workflows that connect your ecommerce platform with advertising and CRM systems. Our team can implement this Shopify-Facebook integration, troubleshoot matching issues, and create additional automations to streamline your marketing operations.
We'll handle the technical setup while you focus on your business. Our experts ensure maximum match rates and accurate data flow between systems, giving you reliable conversion tracking across all sales channels.
- Complete Shopify-Facebook integration setup
- Customized for your specific business needs
- Ongoing optimization and support
Ready to See Your True Ad Performance?
Missing offline conversions means you're making advertising decisions with incomplete data. Let GrowwStacks implement this Shopify-Facebook integration for you - typically completed in under 2 business days.