Tracksuit Private Preview
Tracksuit is a brand tracking dashboard for measuring the value of brand-building activities. This connector allows you to sync funnel metrics for your tracked brands.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | ||
| Re-sync | check | |
| API configurable | ||
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Setup guide
Follow our step-by-step Tracksuit setup guide to connect Tracksuit with your destination using Fivetran connectors.
Sync overview
Once Fivetran connects to your Tracksuit database, the Tracksuit connector fetches an initial snapshot of all of your funnel metrics. Once the connector completes the initial sync, it updates the data with new funnel metrics as surveys are conducted.
IMPORTANT: Survey results are updated monthly. Hence, we strongly recommend setting the sync frequency for your Tracksuit connector to 24 hours. See our sync frequency documentation for more details.
Schema information
Fivetran replicates the funnel metric database with one exception, we add a unique ID to ensure data does not get replicated.
Fivetran-generated columns
Fivetran adds the following columns to tables in your destination:
_fivetran_deleted(BOOLEAN) marks deleted rows in the source database._fivetran_synced(UTC TIMESTAMP) indicates when Fivetran last successfully synced the row._fivetran_index(INTEGER) shows the order of updates for tables that do not have a primary key._fivetran_id(STRING) is the hash of the non-Fivetran values of each row. It is a unique ID that Fivetran uses to avoid duplicate rows in tables that do not have a primary key.