| title | Data sync |
|---|---|
| description | Learn how to sync Trophy data to your warehouse or database for analytics and reporting. |
| og:description | Learn how to sync Trophy data to your warehouse or database for analytics and reporting. |
| icon | database |
Data sync allows you to connect Trophy to your data warehouse or database and set up an ongoing sync of Trophy data for analytics and reporting purposes. This enables teams to build custom queries across internal data in combination with data from Trophy.
Currently Trophy supports syncing data into Postgres databases.
We're working on adding support for more destinations in the future. Please [get in touch](mailto:support@trophy.so) to discuss your needs.Please contact the support team to connect your destination. We'll understand the specifics of your set up, help you create the necessary tables and create a secure connection.
Once connected, Trophy will backfill historical data for you and then continue to sync data once per hour.
Trophy supports syncing data into the following tables:
| Name | Destination Table Name | Description |
|---|---|---|
| Metric totals | trophy_metric_totals |
Total value of all metric events per day for each user. |
| Point totals | trophy_points_totals |
Total value of all point awards per day for each user. |
| Streak periods | trophy_streak_periods |
Streak history for each user. |
| Streak freezes | trophy_streak_freezes |
Streak freezes for each user. |
| Leaderboard rankings | trophy_leaderboard_rankings |
Leaderboard positions per run. |
| Achievement completions | trophy_achievement_completions |
Completed achievements for all users. |
New and updated data is synced to the respective tables once per hour.
Want to get in touch with the Trophy team? Reach out to us via email. We're here to help!