Offline Conversions Master

Built by John Rippy | johnrippy.link

🏆 2025 Zapier Automation Hero of the Year — Project Phoenix: A 95-step AI sales pipeline cutting development time by 50%. Read more →

Multi-Platform Offline Conversions - Import, Validate, Hash & Distribute to Any Ad Platform

Import offline conversions from multiple sources, validate, normalize, hash PII for compliance, and distribute to any ad platform via webhooks. Perfect for tracking in-store purchases, phone orders, and CRM conversions.

Features

Conversion Import

• import_from_sheet - Import conversions from Google Sheets
• import_from_csv - Import conversions from CSV URL
• process_webhook_payload - Process incoming CRM/POS webhooks

Conversion Processing

• validate_conversions - Validate required fields and formats
• normalize_conversions - Standardize timestamps, currencies, values
• hash_pii - SHA256 hash email, phone, and other PII
• deduplicate_conversions - Remove duplicates by order ID

Output & Distribution

• filter_conversions - Filter by value, date, event type
• format_for_platform - Format for specific platform requirements
• export_to_webhook - Send to Zapier, Make, n8n, or platform APIs
• get_processing_stats - Get statistics on processed conversions
• preview_data - Preview processed data before export

Use Cases

Track In-Store Purchases

1. Export POS transactions to Google Sheet
2. Import with customer email/phone
3. Hash PII and format for Facebook CAPI
4. Send via webhook to Facebook

CRM Lead Attribution

1. Receive webhook from CRM (closed deal)
2. Match gclid/fbclid from original lead
3. Send conversion to Google/Facebook
4. Attribute revenue to ad campaigns

Multi-Platform Distribution

1. Import conversions once
2. Format for each platform (FB, Google, LinkedIn)
3. Send to multiple webhooks
4. Track across all ad accounts

Input Formats

Google Sheets / CSV

Required columns:

• email or phone - Customer identifier
• value - Conversion value/revenue
• timestamp - When conversion occurred
• order_id - Unique transaction ID

Optional columns:

• currency - ISO 4217 code (default: USD)
• click_id - gclid, fbclid, ttclid, etc.
• event_type - Purchase, Lead, etc.
• first_name, last_name - Customer name

Webhook Payload

[
  {
    "email": "john@example.com",
    "phone": "+15551234567",
    "value": 99.99,
    "currency": "USD",
    "timestamp": "2024-01-20T14:30:00Z",
    "order_id": "ORD-12345",
    "gclid": "EAIaIQobChMI..."
  }
]

Platform-Specific Formatting

Platform	Click ID	Required Fields	Hashing
Facebook	fbclid, fbc	email or phone	SHA256
Google	gclid, gbraid	gclid or email	SHA256
LinkedIn	li_fat_id	email	SHA256
TikTok	ttclid	email or phone	SHA256
Microsoft	msclkid	msclkid or email	SHA256
Pinterest	epik	email	SHA256
Snapchat	ScCid	email or phone	SHA256

Output Format

Generic Format

{
  "conversions": [
    {
      "email_hash": "abc123...",
      "phone_hash": "def456...",
      "value": 99.99,
      "currency": "USD",
      "event_time": 1705761000,
      "order_id": "ORD-12345",
      "event_type": "Purchase"
    }
  ],
  "stats": {
    "total_input": 100,
    "valid": 95,
    "invalid": 5,
    "duplicates_removed": 3,
    "total_value": 9500.00
  }
}

Pricing

$0.01 per query (all tasks)

Compliance Notes

• Always obtain consent before tracking conversions
• PII is hashed before transmission
• Include order IDs for deduplication
• Match attribution windows (typically 7-28 days)