When to use this
- You have purchase, lead or other events that were not captured.
- You need to send historical events to Cometly with accurate timestamps.
- You exported data from another platform and need to push it into Cometly.
How to backfill missing events in Cometly
- Export your missing data into a Google Sheet with the required fields.
- Create a Zap that triggers on new rows added to the sheet.
- Map fields from your sheet to Cometly, including the historical Event Time.
- Add rows to the sheet to send each event to Cometly.
Step 1: Prepare your Google Sheet
Create a new Google Sheet with two tabs.Tab 1: “All Data”
This is your staging tab. Compile all of your missing event data here first. Do NOT connect this tab to Zapier. Export the missing transactions or events from your payment processor or platform:- Stripe: go to Payments > Export and filter by date range.
- ClickFunnels: go to Orders/Transactions and export.
- Other platforms: export from your CRM, payment provider or order management system.
Notes on Event Time:
- Use a consistent date and time format across all rows.
- This is the time the event actually happened, not the time you add it to the sheet.
Tab 2: “Send to Cometly”
This is your live tab, the one Zapier watches. Create it with the exact same column headers as your “All Data” tab. Do not paste any data into this tab yet. You do that after everything is configured and tested.Why two tabs?The “All Data” tab is your source of truth where you organize and review everything. The “Send to Cometly” tab is what Zapier monitors. Every time a new row appears in this tab, it triggers a Zap that sends the event to Cometly. Keeping them separate lets you control exactly when events get sent and avoids firing events before you are ready.
Step 2: Connect Cometly to Zapier (if not already connected)
- In Cometly, click Integrations in the sidebar.
- Find the Zapier card (category Webhooks & API) and open it.
- If Zapier is not active yet, click Activate Zapier.
- Under Manage API tokens, enter a Token Name, click Create Token and copy the token. You need it in Zapier.
Step 3: Create your Zap
Set up the trigger (Google Sheets)
- Go to zapier.com and click Create Zap.
- For the Trigger App, search for and select Google Sheets.
- For the trigger event, select New or Updated Spreadsheet Row.
- Connect your Google account and select:
- The Spreadsheet you created in step 1
- The Worksheet: select “Send to Cometly” (your live tab, NOT the “All Data” tab)
- Add one test row to the “Send to Cometly” tab so Zapier can detect your columns.
- Click Test Trigger to pull in the sample row.
Set up the action (Cometly)
- Click Add Step (the
+button). - Search for Cometly and select it.
- For the action event, select Send Event.
- Connect your Cometly account by pasting the API token you copied in step 2.
- Configure the action fields:
- Event Type: select the appropriate event (for example
Purchase,Leador your custom event name)
- Event Type: select the appropriate event (for example
Step 4: Map your fields
This is the most important step. You map each column from your Google Sheet to the corresponding Cometly field.Required fields
Recommended fields
Click + Add Field to map additional data:
Click Continue after mapping all fields.
Step 5: Test your Zap
- Click Test Step to send your sample row to Cometly.
- Verify that the event arrived in Cometly:
- Go to Events Manager and click the Events Log tab.
- Confirm the event shows the correct email, amount and event time.
- If everything looks correct, click Publish to activate the Zap.
Step 6: Backfill your data
Now that your Zap is live and verified, send the rest of your data.- Go to your “All Data” tab.
- Copy a batch of rows (50 to 100 at a time is recommended).
- Paste them into the “Send to Cometly” tab.
- Each new row triggers the Zap and sends the event to Cometly.
- Check the Events Log tab in Events Manager to confirm events are flowing in correctly.
- Repeat with the next batch until all data has been sent.
Tips
- Work in batches. Paste 50 to 100 rows at a time rather than all at once. This prevents rate limiting and makes it easy to catch issues early.
- Don’t re-paste rows. Rows that were already added to the “Send to Cometly” tab have already been processed. Adding them again creates duplicate events.
- Check as you go. After each batch, spot-check a few events in the Events Log to make sure everything looks right before continuing.
Troubleshooting
Confirm the backfill worked
Open Events Manager and click the Events Log tab. Each row you pasted into the “Send to Cometly” tab appears there as an event, with SUCCESS in the Details column. Open a few events and confirm the event time is the historical time from your sheet, not today’s date. The key is mapping the Event Time column from your sheet (not “the time we receive the event”) so that your reporting reflects when events actually occurred. If you need help identifying which events are missing, compare your platform’s transaction export against your Cometly Events Log.Frequently asked questions
Will backfilled events be attributed to the ads that produced them?
Cometly matches each backfilled event to a visitor by the email address you send, then ties it to the ad or channel that brought that visitor. It cannot attribute a conversion to an ad click that happened before the Cometly pixel (the tracking script on your site) was installed.How long do backfilled events take to show up in Cometly reports?
An event shows in the Events Log within 60 seconds of being sent. It can take up to 15 minutes to appear in the reporting areas, such as the Report Builder or Ads Manager.Can I backfill events into Cometly without Zapier?
Yes. The Cometly API accepts anevent_time on each event, in ISO 8601 format or as a Unix timestamp in seconds, so a developer can send historical events directly. See Create event.
Next steps
- Use the Events Log to verify each event
- Send events to Cometly with Zapier
- Edit or delete a conversion to fix a duplicate or a wrong amount
- Understand the data maturing period