To access your charity area on the website, follow these steps after you log in:
1. Navigate to the "Analytics" tab in your charity area to view the segmentation of donations received by the charity. This segmentation includes details related to campaigns, external pages, and association pages, based on the dates you have specified.
2. To download the data in an Excel table, locate and click on the arrow button
situated on the right side of the screen above the table.
Note: Before downloading the report, you have the option to filter the information by currency, payment method, and specific dates.
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 displaying comprehensive data on donations and donors. While most tables share similarities, they may be arranged slightly differently. Below is a breakdown of some key columns in the most common type of table
Data | Explanation | עמודה |
id | Donation ID | A |
Transaction Date | Donation Transaction Date | B |
Amount | Donation Amount | C |
Releasable Amount | Donation Amount Minus Fees | D |
Currency | Donation Currency (USD, ILS, CAD, GBP) | E |
Target Name | Campaign Name | F |
Target ID | Campaign ID | G |
Main Event ID | Main Campaign ID (Relevant for Ambassador Campaign) | H |
Team ID | Ambassador Team ID (Relevant for Ambassador Campaign) | I |
Donor First Name | Donor First Name | J |
Donor Last Name | Donor Last Name | K |
Invoice Recipient Name | Name on the Receipt | L |
Donor Email | Donor Email | M |
Donor Phone Number | Donor Phone Number | N |
Donor Israeli ID | Donor Israeli ID | O |
Recurring | Recurring (Yes/No) | P |
Recurring Months | Recurring Months | Q |
Recurring Ends At | Recurring End Date | R |
Payment Provider | Funds Processed Through (JGive, Stripe, PayMe, Meshulam) | S |
Payment Method | Payment Method (CreditCard, DAF, Wire, JCF, BIT, Check, Wallet) | T |
Payment Redirected | Donations Redirected by JGive Fund (Consolidated on 20th of the month) | U |
Card Last 4 | Last 4 Digits of Credit Card | V |
Card Brand | Credit Card Company | W |
Processing Fee | Processing Fee | X |
Market Fee | Platform Fee | Y |
Transaction Fee | Fixed Fee of 30 Agorot | Z |
Release Status | Funds Transfer Status to the Organization's Bank Account | AA |
Released At | Funds Transfer Date | AB |
Comment | Donor Dedication/Comment on the Donation | AC |
Foreign Card | Is it a Foreign Credit Card? (Yes/No) | AD |
Share Donor Details | Did the Donor Choose to Share Their Details with the Organization? (Yes/No) | AE |
Receive Updates | Does the Donor Want to Receive Updates from the Organization? (Yes/No) | AF |
Share Donor Name | Did the Donor Choose to Share Their Name on the Site? (Yes/No) | AG |
Share Donation Amount | Did the Donor Choose to Share the Donation Amount on the Site? (Yes/No) | AH |
Invoice Number | Receipt Number | AJ |
Invoice Copy URL | URL to Receipt Copy | AI |
Transaction Voucher | Transaction Code from the Credit Card Company | AK |
Is Negative | Is it a Refund? (Yes/No) | AL |
Chargeback | Is it a Chargeback not Done by JGive (By the Customer/Credit Card Company)? | AM |
Refunded At | Donation Refund Date | AN |
Withdrawal Code | Withdrawal Code - a Unique Code Transferred to the Organization when it Receives Funds from the Credit Card Company | AO |
Withdrawal Date | Date of Funds Transfer by the Clearing Company | AP |
Provider Payment ID | Payment Provider ID | AQ |
Question 1 | Question 1 (In the Donation Process) | AR |
Answer 1 | Answer to Question 1 | AS |
Question 2 | Question 2 (In the Donation Process) | AT |
Answer 2 | Answer to Question 2 | AU |
Question 3 | Question 3 (In the Donation Process) | AV |
Answer 3 | Answer to Question 3 | AW |
Question 4 | Question 4 (In the Donation Process) | AX |
Answer 4 | Answer to Question 4 | AY |
Question 5 | Question 5 (In the Donation Process) | AZ |
Answer 5 | Answer to Question 5 | BA |
Question 6 | Question 6 (In the Donation Process) | BB |
Answer 6 | Answer to Question 6 | BC |
Purpose ID | Purpose ID Chosen in the Donation Process (If Any) | BD |
Purpose Title | Purpose Title Chosen in the Donation Process (If Any) | BE |
UTM Params | UTM Parameters (If Any) | BF |
Is Embedded | Is the Campaign Embedded? (Yes/No) | BG |
Donor Covered Fees | Did the Donor Cover the Fees Instead of the Organization? (Yes/No) | BH |
Match Request ID | Match Request ID by Employer/External Entity to the Organization | BI |
Match Request Status | Donation Matching Status (Pending, Matched, Failed, Cancelled) | BJ |
Sent By Check | Was the Donation Sent by Check? (Yes/No) | BK |