Accessing fundraising reports

If you have Fundraising enabled on your mCommons account, you can view your fundraising performance reports.

For fundraising reports:

• Open the fundraising programs reports

• Open a performance report

• Open a donation report for a user

Opening the fundraising programs reports

To open a fundraising report:

• Select Fundraising in the left pane, and then select Fundraising.

  

  The Fundraising page contains Active and Inactive Fundraising Programs report tables.

  The Active Fundraising Programs report table lists fundraising programs that are currently in use, along with the donation information:

  

  If the table is longer than one page, use the page-navigation options on the right to navigate to the next or previous page.

  The Inactive Fundraising Programs table lists the same information for programs that have not yet been activated or that have been deactivated.

Opening a performance report

To open a performance report:

1. Select Fundraising in the left pane, and then select Fundraising.

2. Locate the campaign in the Active Fundraising Programs report, and then select the campaign name link.

   The report also includes the following information for programs that have successfully raised donations:

   Row	Description
   Total amount raised	Total U.S. dollar amount raised by the campaign.
   Accepted	Number of donations confirmed by the user.
   Pending	Number of donations pending confirmation, plus the total dollar amount.
   Declined	Number of donations declined, because the user responded NO or did not respond.
   Rejected	Number of donations rejected by the service carrier, usually because the user's mobile phone or mobile carrier service has blocked donations.
   Total	Total number of donations.

Opening a donation report for a user

To open a donation report for a user:

1. Select Fundraising in the left pane, and then select Fundraising.

2. Locate the campaign in the Active Fundraising Programs report, and then select the campaign name link.

   The performance report for the donation campaign opens.

3. Select the Total donations link.

   The donation report lists donations by each donor's mobile phone number.

   The Donations report contains the following information about each donation:

   Column	Description
   Profile	Mobile phone number identifying the user profile. Tip: To open the user profile, select the profile number.
   Status	The status of the donation: Accepted Pending/Incomplete Declined Rejected Failed
   Amount	The U.S. dollar value of the donation.
   Source	The channel used to make the donation, for example SMS or MMS text message to the donation campaign keyword.
   Description	Further information about the source of the donation.
   Processed at	Date and time when the donation was processed by mCommons.

From the Donations table:

• Filter donations

• Export donation data

Filtering donations

To filter the donation records in the Donations table:

1. Select Fundraising in the left pane, and then select Fundraising.

2. Locate the campaign in the Active Fundraising Programs report, and then select the campaign name link.

3. Select the Total donations link.

   The Donations report opens.

4. To filter the Donations table, select one of the following options above the table:

   • All: All donations.

   • Accepted: Donations confirmed by the user.

   • Pending/Incomplete: Donations not yet confirmed, because the user texted in the keyword but has not replied YES to confirm the donation.

   • Declined: Donations declined, because the user responded NO or did not respond.

   • Rejected: Donations rejected by the service carrier, usually because the user's mobile phone or mobile carrier service has blocked donations

   • Failed: Donation messages failed, because of a block on premium messaging on this phone (for example, a parental lock or the user is not an authorized account holder).

   The Donations table displays only those records that match the selected filter.

Exporting donation data

You can export the full set or a subset of donation records to a CSV (comma-separated values) file.

To export donation records:

1. Select Fundraising in the left pane, and then select Fundraising.

2. Locate the campaign in the Active Fundraising Programs report, and then select the campaign name link.

3. Select the Total donations link.

4. (Optional) Arrange the Donations table to display the records to export. For more information, see Filtering donations.

5. Above the Donations page, on the right, select Save as CSV.

   The contents of the Donations table, filtered or all data, plus the donor's s profile data, are saved in a CSV file containing the following columns:

   Column	Description
   phone	The mobile phone number identifying the user profile.
   amount	The U.S. dollar value of the donation.
   created_at	The date and time when the donation was processed by mCommons.
   donation_status	The status of the donation: Accepted Pending/Incomplete Declined Rejected Failed
   source	The channel used to make the donation, for example, SMS or MMS text message to the donation campaign keyword.
   description	Further information about the source of the donation.
   donation_log	Error messages generated when the donation was processed.
   carrier	The messaging service provider for the user's mobile device.

   For more information on the profile fields, see Exporting profile records.

6. To download the CSV file, select Home in the left pane, and then select Reports.

7. Locate the CSV file in the Exports table, select the link in the Name column, and then open the downloaded file.