Offline Conversions Master - Multi-Platform Event Distribution

Import offline conversions from Google Sheets, CSV, CRM webhooks. Validate, normalize, hash PII, and distribute to Facebook, Google, LinkedIn, TikTok, and more via webhooks or direct API.

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

Quick Start

{
  "input": "your input here"
}

Demo Mode

Set demoMode: true to test with sample data (no charges). When you're ready for real results, set demoMode: false or omit it.

{
  "demoMode": true,
  ...
}

Input Parameters

Parameter	Type	Required	Description
See input schema

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

This actor uses pay-per-event billing: $0.01 per query (all tasks)

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

---

Common Problems & Solutions

"Invalid API key" error

Cause: Your API key is wrong, expired, or doesn't have the right permissions. Fix: Double-check your API key. Make sure you copied it exactly without extra spaces.

"Rate limit exceeded" error

Cause: You've hit the API's rate limits. Fix: Wait a few minutes, then try again. Consider reducing the number of concurrent requests.

Empty or incomplete results

Cause: The target may have anti-scraping protection or the data doesn't exist. Fix:

• Check if the URL/search query is correct
• Try with different parameters
• Some sites may block automated access

Demo data showing instead of real results

Cause: demoMode is still set to true. Fix: Set demoMode: false and provide your API key(s).

---

Built by John Rippy | Actor Arsenal