To prepare a gift file for Avid, export one row per gift. Avid needs four columns: Account ID, Transaction ID, Date and Amount. Column names do not have to match. A contacts file is optional for your first analysis.
Use this article when
- You are starting a free analysis and Avid asked you what to include in a transaction file.
- You are exporting gifts from your CRM to upload in Avid.
- You also need a contacts file, or you send files by SFTP.
What Avid needs in a gift file
A gift file is a spreadsheet of your donations with one row for each gift. Your CRM may call these gifts, donations, transactions or opportunities.
Avid needs four columns. The names in your file do not have to match Avid's names. After you upload, you review how each column matches Avid's fields.
Download the gift file template (CSV).
| In Avid | Names you may see | What it is |
|---|---|---|
| Account ID | Donor ID, Constituent ID or Contact ID | The donor's ID in your CRM. Example: A100013 |
| Transaction ID | Gift ID | The gift's own unique ID. Example: TXN-0000001 |
| Date | Gift date or Gift Date | The date of the gift. Example: 2021-11-01 |
| Amount | Gift amount or Gift Amount | The gift amount. Example: 30.00 |
The setup screen that links here labels these as Needed: Gift ID, Donor ID, Gift date and Gift amount.
For this gift file, a donor ID is enough. You can leave out names, emails, phone numbers and street addresses.
Helpful columns in a gift file
These columns are not required. They help Avid show how gifts arrived and which appeals they responded to. On the setup screen they are labeled Helpful.
| In Avid | Names you may see | What it is |
|---|---|---|
| Channel | Channel or Communication Channel | How the gift came in, such as online, direct mail, telemarketing or events. If you do not have a channel column, include another way to tell channels apart, such as gift codes. |
| Subchannel | Subchannel | A finer split of the channel. |
| Appeal Code | Appeal code or Segment Code | The code for the appeal, campaign or segment the gift responded to. |
| Appeal Description | Appeal name, Appeal Description or Segment | The name or description of that appeal, campaign or segment. |
| Is Recurring | Recurring flag or Recurrence Frequency | Whether the gift is part of a recurring or monthly gift. At a minimum, include a flag that marks monthly gifts. |
You can also include other gift details that matter to your organization. Examples are Payment Method, original currency code (if you use more than one currency), gift designation, and whether a premium or incentive was offered. If you use partial soft credits, include separate amount fields for hard or total credit and soft credit.
How far back to go
Include every gift you consider revenue, for the full life of your organization if you can. If you cannot include every year, include at least 7 full fiscal years plus the current fiscal year to date. If even that is not possible, include as many years as you can. Add the first, most recent and highest previous gift columns described with the contacts file.
When to add a contacts file
A contacts file is optional for your first analysis. Add one when you want Avid to use names and a way to reach each person. If you do not include names, emails or phone numbers, you will not be able to use Pathways effectively.
Include every donor account represented by the gifts in your gift file, generally at a household level, or at a contact level with household IDs preserved where you can. Match each person to the gift file with the same Account ID.
Download the contacts file template (CSV).
| Column | What to include |
|---|---|
| Account ID | The same donor ID used in the gift file. Avid needs this column to match contacts to gifts. |
| Contact ID and Household ID | Include these when your CRM has them. |
| First Name and Last Name | Needed if you want to use Pathways. |
| Email, phone and address fields | Include multiple or non-concurrent values when you can. You can also provide these in a separate file keyed to the Account ID. Use Email, Email Type, Phone, Phone Type, Address 1, Address 2, City, State, Postal Code, Country and Address Type when you have them. |
| Contactable flags | Flag: Contactable via Email, Flag: Contactable via Phone and Flag: Contactable via Postal. |
| Other useful fields | Date Added, Account Type, an ID in your email marketing system, inception source and channel, first-action information such as a form or appeal, and fields that identify donor segments or interests. |
If you cannot provide lifetime gift data, include as many years as you can. On the contacts file, also add first gift, most recent gift and highest previous gift columns. For each, include date, amount, channel and campaign or appeal.
How to upload the file
Avid accepts CSV, TXT, TSV, TAB, XLSX, XLS or ZIP files.
New Avid Starter users are sent to this article from the Connect step. Under How do you want to bring it in?, choose Upload an export. The guide What to include in your transaction file then links here. Drop your file on that same step.
If you already have an Avid account, go to Settings → Files → Upload a New File. You need edit access to Connections to upload files.
For step-by-step export instructions for your CRM, see Upload your gift history to Avid from your CRM.
To send files on a schedule by SFTP instead of a web upload, see How to connect SFTP. You can also send a file to Avid by email for an integration.
See the Avid Trust Center for SOC 2 information. If you have questions about a file you are preparing, contact LockStep Support. Include your organization name, whether the file is a gift file or a contacts file, and the column headers from your file. You do not need to send donor rows.