First, log in to your charity area on the charity login page:
1. In the side menu, click Analytics. Here you can view the donations your charity received, based on the filters and period you choose.
2. To download the data to a file, click the Download button
above the data cards, on the right side of the screen (next to the Compare button).
Note: The file includes only the donations that match the filters you chose. Before downloading, you can filter by period and payment method, and with Add filter also by campaigns, currency, donors, campaign type, recurring donations and more.
3. Please be patient as the file downloads; for large files, this process may take a few minutes.
4. Once the download is complete, the file will be saved to your computer, and ready for your use.
5. We recommend using Google Sheets to view the file (click here for a guide on importing to Google Sheets), but you can also use any other software you have available, such as Microsoft Excel or Open Office Calc.
Inside the file, you will find a table with the data on donations and donors. Below are the main columns in the file, in column order:
Data | Explanation | Column |
Donation Type | Donation type | A |
id | Donation ID | B |
Transaction Date | Donation Transaction Date | C |
Amount | Donation Amount | D |
Releasable Amount | Donation amount minus fees | E |
Currency | Donation Currency (USD, ILS, CAD, GBP) | F |
Amount (ILS) | Donation amount in ILS (converted) | G |
Target Name | Campaign Name | H |
Target ID | Campaign ID | I |
Main Event ID | Main Campaign ID (Relevant for Ambassador Campaign) | J |
Team ID | Ambassador Team ID (Relevant for Ambassador Campaign) | K |
Donor First Name | Donor First Name | L |
Donor Last Name | Donor Last Name | M |
Invoice Recipient Name | Name on the Receipt | N |
Donor Email | Donor Email | O |
Donor Phone Number | Donor Phone Number | P |
Donor Israeli ID | Donor Israeli ID | Q |
Recurring | Recurring (Yes/No) | R |
Recurring Months | Recurring Months | S |
Recurring Ends At | Recurring End Date | T |
Payment Provider | Funds Processed Through (Jgive, Stripe, PayMe, Meshulam) | U |
Payment Method | Payment Method (CreditCard, DAF, Wire, JCF, BIT, Check, Wallet) | V |
Payment Redirected | Donations Redirected by Jgive Fund (Consolidated on 20th of the month) | W |
Card Last 4 | Last 4 Digits of Credit Card | X |
Card Brand | Credit Card Company | Y |
Wallet Type | Digital wallet type (Apple Pay / Google Pay), if a wallet was used | Z |
Processing Fee | Processing Fee | AA |
Market Fee | Platform Fee | AB |
Transaction Fee | Fixed Fee of 30 Agorot | AC |
Release Status | Status of the funds transfer to the charity's bank account | AD |
Released At | Funds Transfer Date | AE |
Release Date Conversion Rate | Currency conversion rate on the funds transfer date (foreign-currency donations) | AF |
Comment | Donor Dedication/Comment on the Donation | AG |
Foreign Card | Is it a Foreign Credit Card? (Yes/No) | AH |
Share Donor Details | Did the Donor Choose to Share Their Details with the Organization? (Yes/No) | AI |
Donor Foundation Name | Donor foundation name (if entered) | AJ |
Receive Updates | Does the Donor Want to Receive Updates from the Organization? (Yes/No) | AK |
Share Donor Name | Did the Donor Choose to Share Their Name on the Site? (Yes/No) | AL |
Share Donation Amount | Did the Donor Choose to Share the Donation Amount on the Site? (Yes/No) | AM |
Hidden (For Offline) | Is the donation hidden from public display (offline donations)? (Yes/No) | AN |
Invoice Issued | Was a receipt issued for the donation? (Yes/No) | AO |
Invoice Number | Receipt number | AP |
Invoice Copy URL | Link to the receipt copy | AQ |
Tax Authority Confirmation Number | Tax Authority confirmation number for the receipt | AR |
Transaction Voucher | Transaction Code from the Credit Card Company | AS |
Is Negative | Is it a Refund? (Yes/No) | AT |
Chargeback | Is it a Chargeback not Done by Jgive (By the Customer/Credit Card Company)? | AU |
Refunded At | Donation Refund Date | AV |
Withdrawal Code | Withdrawal Code - a Unique Code Transferred to the Organization when it Receives Funds from the Credit Card Company | AW |
Withdrawal Date | Date of Funds Transfer by the Clearing Company | AX |
Provider Payment ID | Payment Provider ID | AY |
Question 1 | Question 1 (In the Donation Process) | AZ |
Answer 1 | Answer to Question 1 | BA |
Question 2 | Question 2 (In the Donation Process) | BB |
Answer 2 | Answer to Question 2 | BC |
Question 3 | Question 3 (In the Donation Process) | BD |
Answer 3 | Answer to Question 3 | BE |
Question 4 | Question 4 (In the Donation Process) | BF |
Answer 4 | Answer to Question 4 | BG |
Question 5 | Question 5 (In the Donation Process) | BH |
Answer 5 | Answer to Question 5 | BI |
Question 6 | Question 6 (In the Donation Process) | BJ |
Answer 6 | Answer to Question 6 | BK |
Purpose ID | Purpose ID Chosen in the Donation Process (If Any) | BL |
Purpose Title | Purpose Title Chosen in the Donation Process (If Any) | BM |
UTM Parameters | UTM Parameters (If Any) | BN |
Is Embedded | Is the Campaign Embedded? (Yes/No) | BO |
Donor Covered Fees | Did the Donor Cover the Fees Instead of the Organization? (Yes/No) | BP |
Donor Covered Fees Amount | Fee amount covered by the donor | BQ |
Igul Letova | Did the donor choose Igul Letova (rounding up the donation)? (Yes/No) | BR |
Igul Letova Card Brand | Card company used for the Igul Letova charge | BS |
Match Request ID | Match Request ID by Employer/External Entity to the Organization | BT |
Match Request Status | Donation Matching Status (Pending, Matched, Failed, Cancelled) | BU |
Sent By Check | Was the Donation Sent by Check? (Yes/No) | BV |
Donation ID | Additional internal donation ID | BW |
Matching Index | Donation matching index | BX |
Matched Amount | Matched amount approved for the donation | BY |