Challenges
This is a CSiDonate CROWDFUNDING edition feature.
Overview
Challenge Mode is an optional Template mode in CSiDonate that allows a CSiDonate staff user to set a predefined goal for a particular template. The template will display a progress tracker at the top of the form indicating the overall progress towards the goal.
The goal can be one of two distinct types: amount raised in dollars, or number of unique donors.
Setup
To activate Challenge Mode, edit a template and under the General tab, change the Template Mode to Challenge.
Select one of the goal types via the radio buttons, and enter the target goal amount.
The amount raised can be a decimal number, however the number of donors must be a whole number.
![](../__attachments/19923033/image2019-8-18_15-50-34.png?inst-v=0ab34592-5aae-43f9-847f-2cf7c07b1354)
Time Constrained Challenges
To create an automatic time-limited challenge campaign, combine Challenge Mode with the Active From/Thru options in the template settings.
Tracking Progress
Progress Tracker on the Donation Form
Once the challenge has been enabled, a progress tracker will appear on the donation form.
![](../__attachments/19923033/image2019-8-18_15-53-5.png?inst-v=0ab34592-5aae-43f9-847f-2cf7c07b1354)
This progress tracker is visible to the public.
When the goal is reached, the progress bar simply reaches 100%, and the challenge statistics continue to count up.
![](../__attachments/19923033/image2019-8-18_15-54-38.png?inst-v=0ab34592-5aae-43f9-847f-2cf7c07b1354)
External Progress Tracking
Using the vcsi_iDonate_Gift_Metadata_Combined view, you can write a query or report to calculate the same challenge progress as the donation form, and display the tracking information on another website such as a RiSE website.
-- For Amount-Based Goals
SELECT SUM(GiftAmount)
FROM vcsi_iDonate_Gift_Metadata_Combined
WHERE ChallengeTemplate = '<ENTER TEMPLATE UID>'
-- For Donor Count-Based Goals
SELECT COUNT(DISTINCT ID)
FROM vcsi_iDonate_Gift_Metadata_Combined
WHERE ChallengeTemplate = '<ENTER TEMPLATE UID>'
Notes on Challenge Donation Statistics
CSiDonate only records challenge statistics if the template mode is currently set to Challenge.
A template can exist prior to it becoming a "Challenge Template", and if donations are entered against that template, they will not affect the challenge statistics.
Similarly, if a template is set to Challenge, and then sometime later is changed back to Standard, CSiDonate does NOT delete the previous challenge statistics for that template - they are still available in the gift metadata for historical purposes.
Therefore, if a template was previously in Challenge mode, reset to Standard mode, and then changed back to Challenge mode, it will retain its previous statistics from the first time that it was set to Challenge.
To start a new challenge campaign with different donation statistics, use the Save Template As... feature to create a new copy of the template.
If you need to delete challenge statistics for a template, please contact CSI and we would be happy to assist with updating that data for you!