Data sync

Learn how to sync Trophy data to your warehouse or database for analytics and reporting.

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.

We’re working on adding support for more destinations in the future. Please get in touch to discuss your needs.

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.

New and updated data is synced to the respective tables once per hour.

Get Support

Want to get in touch with the Trophy team? Reach out to us via email. We’re here to help!