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

Examples:
  • 20984_CenterForExcellence_Bio.txt
  • 20984_YWCAofWashington_Gifts.txt
 
If you have any questions, please contact
ftpsupport@blackbaud.com 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.
 
FIELD NAMECOMMENTS
Account IDUnique ID for each person or organization
Prefix 
First Name 
Middle Name 
Last Name 
OrgNameIf record is an Organization or Foundation
Suffix 
Date of Birthformat: 12/31/1999
Age 
Gender 
Marital Status 
No Valid Address 
Requests No Email 
Inactive 
Deceased 
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 
Email  
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
Campus  
Education Class of  
Major 
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.
FIELD NAMECOMMENTS
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 
Campaign Description 
FundDesignation of the Gift
Fund Description 
Fund Category 
Appeal 
Appeal Description 
Appeal Category 
Package ID 
Package 
Package Description 
Pay Method 
Anonymous 
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®