The Donations Spreadsheet gives transactional data pertaining to your organisation’s donations collected via opt-in keywords on Donr’s Text Giving service.
Want to know a little more?
Where Do I Find the Donations Spreadsheet?
In the Donations section of your Donr Dashboard, you can find information on the donations that have been made to your organisation via Donr. For donations made via opt-in keywords, this data is sorted by campaign and by month and is downloadable as a ‘donations spreadsheet.’
The blue ‘CSV’ button allows you to download a spreadsheet of the information you’ve currently called up on your screen. For instance, if you have 25 active campaigns with Donr and want to see all of the donations they received for the calendar month of May 2019, simply click ‘Select all’ in the ‘Sort by Campaign’ drop-down menu, select ‘May 2019’ from the ‘Sort by Month’ drop-down menu and click ‘Filter.’
This will display the information you’re looking for on-screen then, when you click the blue ‘CSV’ button, the same information will be downloaded to your computer in the form of a CSV spreadsheet (you can export this into an MS Excel spreadsheet by clicking ‘save as’ and changing the file type).
What am I looking at?
The data in the spreadsheet will be sorted into various columns. Please see below to understand the information contained in the spreadsheet further:
Transaction ID: this is the individual reference number generated by each donation your organisation receives. This can be useful in helping you match up transactions from this spreadsheet with those listed on the Gift Aid data spreadsheet.
Campaign: this will show the Text Giving campaign that your supporter made the donation via.
MSISDN: this is the technical term for mobile phone number.
Email: if your organisation makes use of one of our Donr Appeal Pages (from 2019 or earlier) or completes their donation via credit/debit card if their Text Giving donation has failed, their email address may appear here.
Amount: this will show the amount that a supporter donated to your charity.
Method: this will let you know whether a supporter has donated via Text Giving or one of our Donr Appeal Pages (from 2019 or earlier).
Bill status: 100000 means the donation was successful, any code starting with 2 means the donation failed for some reason – this could be due to not having enough Pay-as-you-Go credit on their phone or having a block on their phone that prevents them from adding extra costs to their mobile bill.
Logged: the date and time the donation was made.
Name: if your organisation makes use of on our Donr Appeal Pages (from 2019 or earlier), and a supporter donates via credit/debit card, their name will appear here.