Challenge Member Progress

Each member's progress towards each challenge, exported daily as a delta file.

The Challenge Member Progress file contains each member's progress towards each challenge. It is the challenge equivalent of Achievement Usage.

Delta export. Each daily file contains the member–challenge progress entries whose progress changed during that day. An entry reappears whenever the member makes further progress. Upsert on campaignId + customerId and keep the row with the latest updatedAt.

This report is not available by default. To enable it for your environment, contact the Open Loyalty support team.

File: analytics/Challenges/challenges_member_progress_YYYY_MM_DD.csv Primary key: campaignId + customerId

Available data (in column order):

Column	Type	Empty value	Description
campaignId	uuid	No	ID of the challenge
campaignName	string	No	Name of the challenge
campaignDescription	string	Yes	Description of the challenge
customerId	uuid	No	ID of the member
limitReached	boolean	False	Whether the member reached the completion limit
completedCount	integer	No	Number of completed challenges
memberProgressRules	json array	No	Progress on each challenge rule
createdAt	datetime	No	Date when the progress entry was created
completedAt	datetime	Yes	Date when the member last completed the challenge
tenantId	uuid	No	ID of the tenant where the challenge was created
updatedAt	datetime	No	Date of the most recent progress update

limitReached, completedCount, and memberProgressRules are calculated when the file is produced, not at the end of the day the file covers.

Achievements that were migrated to challenges can appear both here and in the Achievement Usage file.