Send a flat file that is either fixed-length or comma-separated (.txt or .csv files).
Use a 4-digit year format for all data fields (11/29/1999).
Files should be named as follows:  <SiteID>_<Sitename>_<FileType>.txt

  • 20984_CenterForExcellence_Bio.txt
  • 20984_YWCAofWashington_Gifts.txt
If you have any questions, please contact and include the following information:
  • Your SiteID or Organization Name
  • Your Name
  • Your Telephone Number
  • The Name of the Target Analytics Product you are exporting for
  • Reference KB Article Number 88888 in your message

File 1: Account-Related Data
The account-related file should contain ALL donors on your system. You may also choose to include prospects and other non-donor populations.  Transfer all account-related information in ONE CSV file, with as many of the following fields for which you have data.
Account IDUnique ID for each person or organization
First Name 
Middle Name 
Last Name 
OrgNameIf record is an Organization or Foundation
Date of Birthformat: 12/31/1999
Marital Status 
No Valid Address 
Requests No Email 
Deceased Date 
Household Record IDFor systems that have household records
Household Full NameFor systems that have household records
Spouse Record ID 
Spouse Prefix 
Spouse First Name 
Spouse Middle Name 
Spouse Last Name 
Spouse Suffix 
Spouse has No Valid Address 
Spouse Requests No Email 
Spouse is Inactive 
Spouse is Deceased 
Spouse Is Constituent 
Home Address Line 1Mailing address
Home Address Line 2 
Home City 
Home State 
Home Zip Code 
Home Country 
Home Address IDUnique ID for address
Home Address Type 
Home Phone 
Individual/Organization Indicator 
Date Added to DatabaseFormat: 12/31/1999
Gives Anonymously 
Solicit CodesNo Phone, No Email, No Exchange, No Solicit
Constituency Code  (1-10)Up to 10 codes per record
Constituency Code Date From 
Constituency Code Date To 
Solicitor Type    
Solicitor Date From 
Solicitor Date To 
Solicitor Last Name 
Solicitor First Name 
Education School NameUp to 4 schools per record
Education Class of  
Education Degree  
Maiden Name 
If you are exporting from The Raiser's Edge please see How to submit data to Target Analytics from The Raiser’s Edge®

File 2: Transaction-Related Data
Transfer all payment transactions in one CSV file. Select all records on the database as of today’s date. Include all fields below that your organization tracks.
IMPORTANT: one record per individual gift transaction.
Gift IDUnique ID for each gift
Pledge IDIf Pledge
Account IDIndividual record of the donor
Household Record IDHousehold record (if applicable)
Source Code 
Gift Amount 
Gift Date 
Gift Type 
Gift Code 
Gift Code Description 
Gift Constituent Code 
Gift Constituent Description 
Campaign Description 
FundDesignation of the Gift
Fund Description 
Fund Category 
Appeal Description 
Appeal Category 
Package ID 
Package Description 
Pay Method 
Gift Sub Type 
Gift Sub Type Description 
Expires On 
Gift Vehicle 
Receipt Amount 
Membership Type 
Gift Proposal Type 
Gift Proposal Type Description 
Tribute Type 
Tribute Type Description 
Gift Recognition ID (Soft Credit)ID of record that is being soft credited
If you are exporting from The Raiser's Edge please see How to submit data to Target Analytics from The Raiser’s Edge®