Rockerbox
Send conversion data to Rockerbox for multi-touch attribution, marketing mix modeling, and incrementality testing. Zeotap delivers batch files of conversion events via SFTP, enabling Rockerbox to attribute conversions across your entire marketing mix.
Prerequisites
- A Rockerbox account with batch file delivery enabled
- SFTP credentials provided by your Rockerbox account manager
- The Rockerbox onsite Identify pixel deployed on your website (to match email and external ID formats)
- Conversion events or order data available in your data warehouse
Authentication
Rockerbox uses SFTP credentials for batch file delivery.
- Contact your Rockerbox account manager to request SFTP access
- You will receive a username and password for the Rockerbox SFTP server
- In Zeotap, enter your SFTP Username and SFTP Password when configuring the destination
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| SFTP Host | Text | Yes | The Rockerbox SFTP server hostname provided during onboarding |
| SFTP Port | Number | No | SFTP port number. Defaults to 22 |
| Remote Directory | Text | Yes | The remote directory path where batch files are uploaded |
| File Format | Select | No | File format for batch delivery. CSV is the officially supported format. |
Target Settings
| Field | Type | Required | Description |
|---|---|---|---|
| Conversion Type | Select | Yes | Type of conversion data: Purchase, Add to Cart, Email Signup, Create Account, or Custom |
Supported Operations
Sync Modes
| Mode | Supported |
|---|---|
| Insert | Yes |
| Upsert | — |
| Update | — |
| Mirror | — |
Rockerbox ingests conversion data as append-only batch files. Each sync produces a new file uploaded to the SFTP server. Historical data is not updated or deleted.
Audience Sync Modes
Not supported. Rockerbox does not have a list or audience membership API.
Features
- Field Mapping: Yes
- Schema Introspection: No
Required Mapping Fields
| Field | Description |
|---|---|
| Order ID | Unique order or transaction identifier. Must match your internal source of truth. |
| Customer email address. Must match the format collected by the Rockerbox onsite Identify pixel. |
Default Destination Fields
| Field | Type | Description |
|---|---|---|
order_id | string | Unique order or transaction identifier |
order_timestamp | timestamp | When the conversion occurred (MM/DD/YYYY HH:MM:SS, UTC preferred) |
revenue | number | Transaction revenue (decimal format, no currency symbols) |
email | string | Customer email matching the onsite Identify pixel format |
external_id | string | Customer ID matching the Rockerbox onsite pixel format |
coupon | string | Promotional or coupon code |
customer_type | string | new or returning |
currency | string | Currency code (e.g. USD, GBP) if not USD |
order_type | string | Purchase type: one-time, subscription_start, subscription_renewal, retail, or online |
products | json | Product details as a JSON array |
address_street_1 | string | Street address (for direct mail attribution) |
address_city | string | City (for direct mail attribution) |
address_state | string | State or region (for direct mail attribution) |
address_zip_code | string | Postal code (for direct mail attribution) |
How It Works
- Batch serialization — Zeotap transforms your model rows into CSV with the mapped field names
- SFTP upload — The batch file is uploaded to your designated Rockerbox SFTP directory, organized by date subdirectories (e.g.
/uploads/conversions/2026-04-12/batch_1712345678.csv) - Rockerbox processing — Rockerbox ingests the file and matches conversion events to marketing touchpoints using email and external ID, applying multi-touch attribution models
Each sync creates a new file. Files are organized into date-based subdirectories for easy tracking.
Rate Limits
Rockerbox SFTP delivery does not impose strict API rate limits. However:
- Files should be delivered daily, ideally by 00:30 UTC
- Rockerbox recommends keeping files under 25 MB. For large datasets, configure upstream model or sync batching so individual sync batches stay within this limit
Best Practices
- Match identifier formats — Ensure the email and external ID formats in your warehouse match those captured by the Rockerbox onsite Identify pixel. Mismatched formats prevent attribution matching.
- Use UTC timestamps — Rockerbox expects timestamps in UTC. If your data uses a different timezone, communicate this to your Rockerbox implementation team.
- Include revenue without symbols — Format revenue as plain decimal numbers (e.g.
2000.10), not$2,000.10. - Send a test file first — Before enabling production syncs, send a single day’s sample file and work with your Rockerbox account manager to validate the data format.
- Add address fields for direct mail — If you run direct mail campaigns, include
address_street_1,address_city,address_state, andaddress_zip_codeto enable direct mail attribution. - Set customer type — Including
customer_type(new/returning) enables Rockerbox to segment attribution reports by acquisition vs. retention.
Troubleshooting
SFTP connection failed
Verify that the SFTP host, port, username, and password are correct. Contact your Rockerbox account manager if you need new credentials. Ensure your network or firewall allows outbound connections on port 22 (or your configured port).
Files are not being processed by Rockerbox
Confirm that files are being uploaded to the correct remote directory. Rockerbox only processes files from the agreed-upon directory path configured during onboarding. Check with your account manager if the directory has changed.
Conversion data not appearing in attribution reports
Rockerbox matches conversions using email and external ID. Verify that these fields match the format collected by the Rockerbox onsite Identify pixel. Mismatched formats (e.g. uppercase vs. lowercase email) prevent attribution.
Revenue values showing incorrectly
Ensure revenue values are plain decimal numbers with a maximum of 2 decimal places. Do not include currency symbols ($), commas, or other formatting. If sending non-USD revenue, include the currency field.
Timestamp parsing errors
Rockerbox expects timestamps in MM/DD/YYYY HH:MM:SS format, preferably in UTC. If your timestamps use a different format or timezone, coordinate with your Rockerbox implementation team to configure the expected format.
Permission denied on SFTP upload
The SFTP user may not have write access to the configured remote directory. Contact your Rockerbox account manager to verify directory permissions. You can test permissions using the Test Connection button in Zeotap.