Data Sync is only available on request. Please get in touch to discuss your needs.
What is Data Sync?
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.Supported Destinations
Currently Trophy supports syncing data into Postgres databases.Connecting Your Destination
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.Supported Tables
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. |