A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DonorPerfect object | ActiveCampaign object | ActiveCampaign field group | Sync with ActiveCampaign | Create custom field in ActiveCampaign | ActiveCampaign field title | ActiveCampaign field type | ActiveCampaign field description | DonorPerfect field name | DonorPerfect prompt | DonorPerfect field type | DonorPerfect standard or custom field |
2 | Donor | Contact | DonorPerfect | Yes | No | ActiveCampaign native | The Email in DonorPerfect | Textbox | Standard | |||
3 | Donor | Contact | DonorPerfect | Yes | No | First Name | ActiveCampaign native | The First Name in DonorPerfect | first_name | First Name | Textbox | Standard |
4 | Donor | Contact | DonorPerfect | Yes | No | Last Name | ActiveCampaign native | The Last Name in DonorPerfect | last_name | Last Name | Textbox | Standard |
5 | Donor | Contact | DonorPerfect | Yes | No | Phone Number | ActiveCampaign native | The phone number in ActiveCampaign | mobile_phone | Mobile Phone | Textbox | Standard |
6 | Donor | Contact | DonorPerfect | Yes | Yes | Created Date | Date | The Created Date in DonorPerfect | created_date | Created Date | Textbox | Standard |
7 | Donor | Contact | DonorPerfect | Yes | Yes | Email Status Date | Date | The Email Status Date in DonorPerfect | email_status_date | Email Status Date | Textbox | Standard |
8 | Donor | Contact | DonorPerfect | Yes | Yes | Initial Gift Date | Date | The Initial Gift Date in DonorPerfect | initial_gift_date | Initial Gift Date | Textbox | Standard |
9 | Donor | Contact | DonorPerfect | Yes | Yes | Last Gift Date | Date | The Last Gift Date in DonorPerfect | last_contrib_date | Last Contribution Date | Textbox | Standard |
10 | Donor | Contact | DonorPerfect | Yes | Yes | Maximum Gift Date | Date | The Maximum Gift Date in DonorPerfect | max_date | Maximum Gift Date | Textbox | Standard |
11 | Donor | Contact | DonorPerfect | Yes | Yes | Donor Last Modified Date | Datetime | The Donor Last Modified Date in DonorPerfect | modified_date | Donor Last Modified Date | Textbox | Standard |
12 | Donor | Contact | DonorPerfect | Yes | Yes | Address Type | Dropdown | The Address Type in DonorPerfect | address_type | Address Type | Drop-Down | Standard |
13 | Donor | Contact | DonorPerfect | Yes | Yes | Created by | Dropdown | The Created by in DonorPerfect | created_by | Created By | Textbox | Standard |
14 | Donor | Contact | DonorPerfect | Yes | Yes | Record Type | Dropdown | The Record Type in DonorPerfect | dp_record_type | Record Type | Textbox | Standard |
15 | Donor | Contact | DonorPerfect | Yes | Yes | Donor Type | Dropdown | The Donor Type in DonorPerfect | donor_type | Donor Type | Drop-Down | Standard |
16 | Donor | Contact | DonorPerfect | Yes | Yes | Email Status | Dropdown | The Email Status in DonorPerfect | email_status | Email Status | Drop-Down | Standard |
17 | Donor | Contact | DonorPerfect | Yes | Yes | Email Type | Dropdown | The Email Type in DonorPerfect | email_type | Email Type | Drop-Down | Standard |
18 | Donor | Contact | DonorPerfect | Yes | Yes | Modified by | Dropdown | The Modified by in DonorPerfect | modified_by | Modified By | Textbox | Standard |
19 | Donor | Contact | DonorPerfect | Yes | Yes | No Email Reason | Dropdown | The No Email Reason in DonorPerfect | no_email_reason | No Email Reason | Drop-Down | Standard |
20 | Donor | Contact | DonorPerfect | Yes | Yes | No Mail Reason | Dropdown | The No Mail Reason in DonorPerfect | nomail_reason | No Mail Reason | Drop-Down | Standard |
21 | Donor | Contact | DonorPerfect | Yes | Yes | Opt-Out Source | Dropdown | The Opt-Out Source in DonorPerfect | opt_out_source | Opt-Out Source | Drop-Down | Standard |
22 | Donor | Contact | DonorPerfect | Yes | Yes | Receipt Delivery | Dropdown | The Receipt Delivery in DonorPerfect | receipt_delivery | Receipt Delivery | Drop-Down | Standard |
23 | Donor | Contact | DonorPerfect | Yes | Yes | Receipting Preference | Dropdown | The Receipting Preference in DonorPerfect | donor_rcpt_type | Receipting Preference | Drop-Down | Standard |
24 | Donor | Contact | DonorPerfect | Yes | Yes | Title | Dropdown | The Title in DonorPerfect | title | Title (Mr./Mrs) | Textbox | Standard |
25 | Donor | Contact | DonorPerfect | Yes | Yes | UK County | Dropdown | The UK County in DonorPerfect | ukcounty | UK County | Drop-Down | Standard |
26 | Donor | Contact | DonorPerfect | Yes | Yes | 2 Years Ago CYTD | Text | The 2 Years Ago CYTD in DonorPerfect | ly2_cytd | 2 Years Ago CYTD | Textbox | Standard |
27 | Donor | Contact | DonorPerfect | Yes | Yes | 2 Years Ago YTD | Text | The 2 Years Ago YTD in DonorPerfect | ly2_ytd | 2 Years Ago YTD | Textbox | Standard |
28 | Donor | Contact | DonorPerfect | Yes | Yes | 3 Years Ago CYTD | Text | The 3 Years Ago CYTD in DonorPerfect | ly3_cytd | 3 Years Ago CYTD | Textbox | Standard |
29 | Donor | Contact | DonorPerfect | Yes | Yes | 3 Years Ago YTD | Text | The 3 Years Ago YTD in DonorPerfect | ly3_ytd | 3 Years Ago YTD | Textbox | Standard |
30 | Donor | Contact | DonorPerfect | Yes | Yes | 4 Years Ago CYTD | Text | The 4 Years Ago CYTD in DonorPerfect | ly4_cytd | 4 Years Ago CYTD | Textbox | Standard |
31 | Donor | Contact | DonorPerfect | Yes | Yes | 4 Years Ago YTD | Text | The 4 Years Ago YTD in DonorPerfect | ly4_ytd | 4 Years Ago YTD | Textbox | Standard |
32 | Donor | Contact | DonorPerfect | Yes | Yes | 5 Years Ago CYTD | Text | The 5 Years Ago CYTD in DonorPerfect | ly5_cytd | 5 Years Ago CYTD | Textbox | Standard |
33 | Donor | Contact | DonorPerfect | Yes | Yes | 5 Years Ago YTD | Text | The 5 Years Ago YTD in DonorPerfect | ly5_ytd | 5 Years Ago YTD | Textbox | Standard |
34 | Donor | Contact | DonorPerfect | Yes | Yes | 6 Years Ago CYTD | Text | The 6 Years Ago CYTD in DonorPerfect | ly6_cytd | 6 Years Ago CYTD | Textbox | Standard |
35 | Donor | Contact | DonorPerfect | Yes | Yes | 6 Years Ago YTD | Text | The 6 Years Ago YTD in DonorPerfect | ly6_ytd | 6 Years Ago YTD | Textbox | Standard |
36 | Donor | Contact | DonorPerfect | Yes | Yes | Average Gift Amount | Text | The Average Gift Amount in DonorPerfect | avg_amt | Average Gift Amount | Textbox | Standard |
37 | Donor | Contact | DonorPerfect | Yes | Yes | Gift Total | Text | The Gift Total in DonorPerfect | gift_total | Gift Total | Currency | Standard |
38 | Donor | Contact | DonorPerfect | Yes | Yes | Last Contribution Amount | Text | The Last Contribution Amount in DonorPerfect | last_contrib_amt | Last Contribution Amount | Currency | Standard |
39 | Donor | Contact | DonorPerfect | Yes | Yes | Last Year CYTD | Text | The Last Year CYTD in DonorPerfect | ly_cytd | Last Year CYTD | Textbox | Standard |
40 | Donor | Contact | DonorPerfect | Yes | Yes | Last Year YTD | Text | The Last Year YTD in DonorPerfect | ly_ytd | Last Year YTD | Textbox | Standard |
41 | Donor | Contact | DonorPerfect | Yes | Yes | Maximum Gift Amount | Text | The Maximum Gift amount in dollars in DonorPerfect | max_amt | Maximum Gift Amount | Textbox | Standard |
42 | Donor | Contact | DonorPerfect | Yes | Yes | Do Not Send Mail | Radio | The Do Not Send Mail option in DonorPerfect | nomail | Do Not Send Mail | Yes/No | Standard |
43 | Donor | Contact | DonorPerfect | Yes | Yes | Gift Aid Eligible (Donor Level) | Radio | The Gift Aid Eligible (Donor Level) in DonorPerfect | gift_aid_eligible | Gift Aid Eligible (Donor Level) | Textbox | Standard |
44 | Donor | Contact | DonorPerfect | Yes | Yes | No Email | Radio | The No Email option in DonorPerfect | no_email | No Email | Yes/No | Standard |
45 | Donor | Contact | DonorPerfect | Yes | Yes | Organization | Radio | The Organization in DonorPerfect | org_rec | Organization | Yes/No | Standard |
46 | Donor | Contact | DonorPerfect | Yes | Yes | Optional Line | Text | The Optional Line in DonorPerfect | opt_line | Optional Line | Textbox | Standard |
47 | Donor | Contact | DonorPerfect | Yes | Yes | Address 2 | Text | The Address 2 in DonorPerfect | address2 | Address 2 | Textbox | Standard |
48 | Donor | Contact | DonorPerfect | Yes | Yes | Address 3 | Text | The Address 3 in DonorPerfect | address3 | Address 3 | Textbox | Standard |
49 | Donor | Contact | DonorPerfect | Yes | Yes | Address 4 | Text | The Address 4 in DonorPerfect | address4 | Address 4 | Textbox | Standard |
50 | Donor | Contact | DonorPerfect | Yes | Yes | Business Phone | Text | The Business Phone in DonorPerfect | business_phone | Business Phone | Textbox | Standard |
51 | Donor | Contact | DonorPerfect | Yes | Yes | Calendar Year-to-Date | Text | The Calendar Year-to-Date in DonorPerfect | cytd | Calendar Year-to-Date | Textbox | Standard |
52 | Donor | Contact | DonorPerfect | Yes | Yes | City | Text | The City in DonorPerfect | city | City | Textbox | Standard |
53 | Donor | Contact | DonorPerfect | Yes | Yes | Country | Text | The Country in DonorPerfect | country | Country | Drop-Down | Standard |
54 | Donor | Contact | DonorPerfect | Yes | Yes | Donor ID | Text | The Donor Id in DonorPerfect | donor_id | Donor ID | Textbox | Standard |
55 | Donor | Contact | DonorPerfect | Yes | Yes | Fax Phone | Text | The Fax Phone in DonorPerfect | fax_phone | Fax Phone | Textbox | Standard |
56 | Donor | Contact | DonorPerfect | Yes | Yes | Home Phone Number | Text | The Home Phone Number in DonorPerfect | home_phone | Home Phone | Textbox | Standard |
57 | Donor | Contact | DonorPerfect | Yes | Yes | Job Title | Text | The Job Title in DonorPerfect | prof_title | Professional Title | Textbox | Standard |
58 | Donor | Contact | DonorPerfect | Yes | Yes | Middle Name | Text | The Middle Name in DonorPerfect | middle_name | Middle Name | Textbox | Standard |
59 | Donor | Contact | DonorPerfect | Yes | Yes | Number of Gifts | Text | The Number of Gifts in DonorPerfect | gifts | Number of Gifts | Textbox | Standard |
60 | Donor | Contact | DonorPerfect | Yes | Yes | Number of Years Donated | Text | The Number of Years Donated in DonorPerfect | yrs_donated | Number of Years Donated | Textbox | Standard |
61 | Donor | Contact | DonorPerfect | Yes | Yes | Opt-Out Reason | Text | The Opt-Out Reason in DonorPerfect | opt_out_reason | Opt-Out Reason | Textbox | Standard |
62 | Donor | Contact | DonorPerfect | Yes | Yes | Postal Code | Text | The Postal Code in DonorPerfect | zip | Zip | Textbox | Standard |
63 | Donor | Contact | DonorPerfect | Yes | Yes | Salutation | Text | The Salutation in DonorPerfect | salutation | Salutation | Textbox | Standard |
64 | Donor | Contact | DonorPerfect | Yes | Yes | State | Text | The State in DonorPerfect | state | State | Drop-Down | Standard |
65 | Donor | Contact | DonorPerfect | Yes | Yes | Street Address | Text | The Street Address in DonorPerfect | address | Address | Textbox | Standard |
66 | Donor | Contact | DonorPerfect | Yes | Yes | Suffix | Text | The Suffix in DonorPerfect | suffix | Suffix | Textbox | Standard |
67 | Donor | Contact | DonorPerfect | Yes | Yes | Year-to-date | Text | Fiscal Year-to-date donations in DonorPerfect | ytd | Fiscal Year-to-date | Currency | Standard |
68 | Donor | Contact | DonorPerfect | Yes | Yes | Narrative | Text Area | The Narrative in DonorPerfect | narrative | Narrative | Memo | Standard |
69 | Gift | Deal | DonorPerfect | Yes | No | Gift Amount | ActiveCampaign native | The gift amount which will result in the deal amount in ActiveCampaign | amount | Gift Amount | Textbox | Standard |
70 | Gift | Deal | DonorPerfect | Yes | Yes | Created Date | Date | The Created Date in DonorPerfect | created_date | Created Date | Textbox | Standard |
71 | Gift | Deal | DonorPerfect | Yes | Yes | Gift Aid Date | Date | The Gift Aid Date in DonorPerfect | gift_aid_date | Gift Aid Date | Textbox | Standard |
72 | Gift | Deal | DonorPerfect | Yes | Yes | Gift Date | Date | The Gift Date in DonorPerfect | gift_date | Date | Textbox | Standard |
73 | Gift | Deal | DonorPerfect | Yes | Yes | Last Bill Date | Date | The Last Bill Date in DonorPerfect | last_bill_date | Last Bill Date | Textbox | Standard |
74 | Gift | Deal | DonorPerfect | Yes | Yes | Last Paid Date | Date | The Last Paid Date in DonorPerfect | last_paid_date | Last Paid Date | Textbox | Standard |
75 | Gift | Deal | DonorPerfect | Yes | Yes | Modified Date | Date | The Modified Date in DonorPerfect | modified_date | Modified Date | Textbox | Standard |
76 | Gift | Deal | DonorPerfect | Yes | Yes | Receipt Date | Date | The Receipt Date in DonorPerfect | rcpt_date | Receipt Date | Textbox | Standard |
77 | Gift | Deal | DonorPerfect | Yes | Yes | Start Date | Date | The Start Date in DonorPerfect | start_date | Start Date | Textbox | Standard |
78 | Gift | Deal | DonorPerfect | Yes | Yes | Thank you date | Date | The Thank you date in DonorPerfect | ty_date | Thank you date | Textbox | Standard |
79 | Gift | Deal | DonorPerfect | Yes | Yes | Thank You Email Letter Date sent | Date | The Thank You Email Letter Date sent in DonorPerfect | emailsentty_date | Thank You Email Letter Date sent | Textbox | Standard |
80 | Gift | Deal | DonorPerfect | Yes | Yes | Thank You Letter Letter Date sent | Date | The Thank You Letter Letter Date sent in DonorPerfect | lettersentty_date | Thank You Letter Letter Date sent | Textbox | Standard |
81 | Gift | Deal | DonorPerfect | Yes | Yes | Tribute End Date | Date | The Tribute End Date in DonorPerfect | tribute_end_date | Tribute End Date | Textbox | Standard |
82 | Gift | Deal | DonorPerfect | Yes | Yes | Tribute Start Date | Date | The Tribute Start Date in DonorPerfect | tribute_start_date | Tribute Start Date | Textbox | Standard |
83 | Gift | Deal | DonorPerfect | Yes | Yes | Write-off Date | Date | The Write-off Date in DonorPerfect | writeoff_date | Write-off Date | Textbox | Standard |
84 | Gift | Deal | DonorPerfect | Yes | Yes | Acknowledgement Preference | Dropdown | The Acknowledgement Preference in DonorPerfect | acknowledgepref | Acknowledgement Preference | Dropdown | Standard |
85 | Gift | Deal | DonorPerfect | Yes | Yes | Auction Category | Dropdown | The Auction Category in DonorPerfect | auction_category | Auction Category | Drop-Down | Standard |
86 | Gift | Deal | DonorPerfect | Yes | Yes | Campaign | Dropdown | The Campaign in DonorPerfect | campaign | Campaign | Drop-Down | Standard |
87 | Gift | Deal | DonorPerfect | Yes | Yes | Created By | Dropdown | The Created By in DonorPerfect | created_by | Created By | Textbox | Standard |
88 | Gift | Deal | DonorPerfect | Yes | Yes | DPForms Form Name | Dropdown | The DPForms Form Name in DonorPerfect | dpforms_formname | DPForms Form Name | Textbox | Standard |
89 | Gift | Deal | DonorPerfect | Yes | Yes | Frequency | Dropdown | The Frequency in DonorPerfect | frequency | Frequency | Drop-Down | Standard |
90 | Gift | Deal | DonorPerfect | Yes | Yes | General Ledger | Dropdown | The General Ledger type in DonorPerfect | gl_code | General Ledger | Drop-Down | Standard |
91 | Gift | Deal | DonorPerfect | Yes | Yes | Memorial or Honorarium | Dropdown | The Memorial or Honorarium in DonorPerfect | memory_honor | Memorial or Honorarium | Drop-Down | Standard |
92 | Gift | Deal | DonorPerfect | Yes | Yes | Modified By | Dropdown | The Modified By in DonorPerfect | modified_by | Modified By | Textbox | Standard |
93 | Gift | Deal | DonorPerfect | Yes | Yes | Payment Type | Dropdown | The Payment Type in DonorPerfect | payment_type | Payment Type | Textbox | Standard |
94 | Gift | Deal | DonorPerfect | Yes | Yes | Processing Method | Dropdown | The Processing Method in DonorPerfect | processing_method | Processing Method | Textbox | Standard |
95 | Gift | Deal | DonorPerfect | Yes | Yes | Receipt Delivery Pref | Dropdown | The Receipt Delivery Pref in DonorPerfect | receipt_delivery_g | Receipt Delivery Pref | Drop-Down | Standard |
96 | Gift | Deal | DonorPerfect | Yes | Yes | Receipt Status | Dropdown | The Receipt Status in DonorPerfect | rcpt_status | Receipt Status | Drop-Down | Standard |
97 | Gift | Deal | DonorPerfect | Yes | Yes | Receipting Preference | Dropdown | The Receipting Preference in DonorPerfect | rcpt_type | Receipting Preference | Drop-Down | Standard |
98 | Gift | Deal | DonorPerfect | Yes | Yes | Record Type | Dropdown | The Record Type in DonorPerfect | record_type | Record Type | Drop-Down | Standard |
99 | Gift | Deal | DonorPerfect | Yes | Yes | Solicitation | Dropdown | The Solicitation type in DonorPerfect | solicit_code | Solicitation | Drop-Down | Standard |
100 | Gift | Deal | DonorPerfect | Yes | Yes | Sub Solicitation | Dropdown | The Sub Solicitation type in DonorPerfect | sub_solicit_code | Sub Solicitation | Drop-Down | Standard |