🔁Send historical data to any destination with Time Machine

Once installed, Freshpaint automatically collects every user action on your site. Even if you only realize a specific user action is important six months after installing, Freshpaint will already have collected that user action for you. After creating a new event definition, you can get access to the historical instances of that event through the time machine feature. When you use the time machine, Freshpaint will send all events that match the given event definition to a specified destination.

To use the time machine feature, after creating an event definition, go to the events schema page and select the new event.

Then scroll down to the event destinations view and click Backfill for the given destination.

This will forward all historical instances for the given event in Freshpaint to the destination.

Backfill Specific Data Ranges

You also have the ability to isolate backfills to a date range you can define. Freshpaint customers have shared that the value of a backfill can often be realized within a much shorter, specific time period. Shorter backfills mean less data clutter, and greater separation of signal from noise.

To do this simply toggle on the "Limit the backfill period" option, then enter a start and end date for the backfill. You cannot backfill data prior to when Freshpaint was installed on your site.

If you are already sending an event to a destination before you backfill the event, we recommend deleting the event out of the destination before you use the Time Machine.

Supported Destinations

The Time Machine is supported for the following destinations:

  • Amplitude

  • Azure Synapse Analytics

  • BigQuery

  • Customer.io

  • Iterable

  • Klaviyo

  • Mixpanel

  • MySQL

  • Panolpy

  • Postgres

  • Redshift

  • S3

  • Snowflake

  • Stonly

Time machine for warehouses is enabled automatically. When you send an event to a warehouse, Freshpaint will send every instance of the event to your warehouse, even the instances that occurred before you created the event definition.

Last updated