Follow

Format of the monthly report

Each month we send you details on all donations given to you in the previous month. This article explains the format of this report, and what each column covers.

All those marked with * may have a null value in the report, either because the field is optional for the donor to fill out, or because the donation isn't associated with any object of that type (e.g. a team or event)

Column Name Format Content
Donation ID Number A unique ID for each donation set by BetterNow.
Donation Date Date (UTC) The date on which the donations was made
Amount Number The donation amount
Currency Text The currency of the donation
Donor Type Text Private or corporate donor.
Tax ID* Text Donor Tax ID
Full Name Text Full name of the donor
First Name Text First name of the donor
Last Name Text Last name of the donor
Company Name* Text Awaiting update on BetterNow - stay tuned!
Email Case insensitive text Email fo the donor
Phone* Text  Phone number as collected on donation from or user profile. This is reported in the international standard for phone numbers: e164
Address 1* Text Street line 
Address 2* Text  Street line 2
Postal Code* Text The postal code
City* Text  City 
Province* Text Province
Country* Text (max 2 characters) Country code of the donor
Birthdate* Date (UTC) The donor birthday if available
Name as shown Text The name shown with the donation, not necessarily the actual name of the donor
Comment* Text Comment with the donation
Given Anonymously True/false TRUE = name is hidden on the public donation
Allow organisation contact True/false TRUE = donor accepted to be contacted
Allow site contact True/false TRUE = donor accepted to be contacted by site owner (only relevant on platform sites) 
Project Name Text Name of project, donation is connected with
Project Reference Number Unique project ID
Fundraiser Title Text Title of the fundraiser donated to
Fundraiser URL Text URL of the fundraiser donated to
Fundraiser ID Text Unique ID of the fundraiser
Fundraiser Type Text Awaiting new feature on BetterNow - stay tuned!
Fundraiser Full Name Text Full name of fundraiser donated to
Fundraiser First Name Text First name of fundraiser donated to
Fundraiser Last Name Text  Last name of fundraiser donated to
Event Name* Text Name of event, fundraiser is connected with
Event ID* Number Unique event ID
Team ID* Number Unique team ID
Team Name* Text Name of team, fundraiser is member of 
Charity Reference Number Unique charity ID
Charity Name Text Name of charity, fundraiser is fundraising for
Site Text  URL of the site, the donation was given through
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk