| A | B | C | D | E | |
|---|---|---|---|---|---|
1 |  | ||||
2 | New Column Name | (Grey = no change) Previous Column Name | Field Type | Max Length | Definition |
3 | First Name | Text | 255 | First name of individual | |
4 | Last Name | Text | 255 | Last name of individual | |
5 | email_id / Email | 255 | Email address of individual | ||
6 | Middle Name | Text | 255 | Middle name of individual | |
7 | Suffix of individual | Text | 255 | Suffix of individual | |
8 | Full Name | Name | Text | 255 | Full Name of individual |
9 | Product | Product | Text | 45 | Name of Product (Direct / Challenge) |
10 | % Goal | % Goal | Float | 5 | This is how far a fundraiser is to achieving the financial goal at 100% (Donors = % to goal, the fundraiser they donated to. Participants = % to goal of the fundraiser they participated in |
11 | Updated Date | Date: YYYY/MM/DD | 10 | Date the record was updated in the DB | |
12 | Zip Code | Zip Code | Text | 7 | Zip Code of address of individual |
13 | Postal Consent Date | Date: YYYY/MM/DD | Date individual provided consent to receive postal mail from nonprofit | ||
14 | Address City | Text | 255 | City of address of individual | |
15 | Address Line 1 | Home Address | Text | 255 | Address of individual |
16 | Address Line 2 | Text | 255 | Address of individual | |
17 | Address Postal Code | Text | 255 | Postal Code of Individual | |
18 | Address State | Text | 255 | Address of individual | |
19 | Messenger Opt-in | Messenger Opt-in | True/False | 5 | Designates whether the fundraiser opted-in to receive messages through Messenger |
20 | Messenger Opt in Date | Date: YYYY/MM/DD | 10 | Date individual provided consent to receive messages via Messenger from nonprofit | |
21 | Email Consent Date | Date: YYYY/MM/DD | 10 | Date individual provided consent to receive emails from nonprofit | |
22 | Phone Number | Phone | Text | 40 | Phone number of individual |
23 | Phone Number Consent Date | Date: YYYY/MM/DD | 10 | Date individual provided consent for phone contact | |
24 | SMS Consent | True/False | 5 | Consent to recieve SMS messeges | |
25 | SMS - Consent Date | Date: YYYY/MM/DD | 10 | Date individual provided consent for SMS messeges | |
26 | Gender | Text | 6 | Gender of individual as provided by FB | |
27 | Unique Record Identifier | Text | 20 | ||
28 | Messenger Identifier | Numeric | 19 | Unique identifier for Messenger ID provided by Facebook | |
29 | Birthday | Date: YYYY/MM/DD | 10 | How would you like to contribute in the future? - Monthly Giver - Donate Birthday - Share Story | |
30 | Focus Area | Focus Area | Text | 4000 | Individuals connection to the nonprofit |
31 | Mission Story | Mission Story / Fundraiser Story | Text | 4000 | Story of why individual raised money for nonprofit |
32 | Mission Story Share Consent | True/False | Consent to publically share Mission Story | ||
33 | Mission Story Consent Date | Date: YYYY/MM/DD | 10 | Date the individual provided consent to share story | |
34 | Dedication Name | Text | 100 | Who they are doing the fundraiser/challenge in memory of | |
35 | Retention Score | Retention Score | Numeric | 1 | Fundraiser response as to the likelihood of creating a future campaign (1-5 scale, 5 highest) |
36 | Campaign ID | Campaign ID | Numeric | 19 | Unique ID assigned to campaign by Facebook. This is the primary key for the Fundraiser API |
37 | Campaign URL | Campaign URL | Hyperlink | 100 | Link to campaign on Facebook |
38 | Campaign Goal | Goal | Float | 15 | The goal amount the fundraiser set for the campaign |
39 | Campaign Start Date | Start Date | Date: YYYY/MM/DD | 10 | Date the campaign started |
40 | Campaign End Date | End Date | Date: YYYY/MM/DD | 10 | Date the campaign is ending / ended |
41 | Event Identifier | Text | 10 | Unique identifier for event | |
42 | Event Series | Series | Text | Name of event series. For example: - 35 Mile Challenge - 25 Burpee Challenge | |
43 | Fundraiser Title | Text | 255 | Name of campaign designated by fundraiser | |
44 | Broken Link | Broken Link | True/False | Designates whether the Thank You message was able to be delivered | |
45 | Total Donations | Donations | Numeric | 10 | Total number of donations received via fundraiser |
46 | Total Raised | Raised | Float | 15 | Total revenue received via fundraiser |
47 | Self Donate | True/False | 5 | Identifies if they fundraiser made a donation to their own campaign | |
48 | Fundraiser Goal | Numeric | 10 | The goal amount the fundraiser set for the campaign | |
49 | Fundraiser Type | Fundraiser Type | Text | 100 | The type of fundraiser on Facebook. May be any of the following:- API Integrated Fundraiser- Birthday Fundraiser- Generic Fundraiser- Instagram Profile Donate Button- Instagram Stories Sticker- Page Donate Button- Post Donate Button |
50 | Thank You Message 1 | Thank You Message 1 | True/False | Designates whether a personal thank you message was delivered on Facebook fundraiser wall | |
51 | Thank You Message 2 | Thank You Message 2 | True/False | Designates whether an additional personal thank you message was delivered on Facebook fundraiser wall | |
52 | Campaign Goal | Float | 15 | The goal amount the fundraiser set for the campaign | |
53 | Sum Total Income | Float | 255 | (Total Raised + Gift aid) | |
54 | US Based Fundraiser | True/False | 5 | Designates if the fundraiser was run within the united states | |
55 | P2P 7 Day Opt In | True/False | -The tag was used for the P2P Integrated product. -It's sent to P2P Integrated users who start fundraisers via NGO webpage, opt-in to messenger, and sign up for the "7-day Challenge" in messenger | ||
56 | Event Series Name | Text | 255 | Name of event series. For example: - 35 Mile Challenge - 25 Burpee Challenge | |
57 | FB Fee | Float | 15 | Fee taken by Facebook to process transaction | |
58 | Charge Time PT | Charge Time PT | DateTime | 10 | The time and date of donation in Pacific Time. |
59 | Net Payout | Numeric | 255 | Amount paid to nonprofit | |
60 | Donation Amount | Donation | Float | 15 | The amount donated in USD. Note that the donation amount is positive for donations and chargeback reversals and negative for refunds and chargebacks. |
61 | Donation Date | Date | Date: YYYY/MM/DD | 10 | Charge date of transaction |
62 | Payment ID | Payment ID | Numeric | 19 | The transaction or payment ID (provided by Facebook) |
63 | Retention Score | Numeric | 1 | Fundraiser response as to the likelihood of creating a future campaign (1-5 scale, 5 highest) | |
64 | Payment Processor | Designates who processed payment (typically Facebook or Blackbaud if using TeamRaiser integration) | |||
65 | Charge Action Type (Chargeback) | Text | 255 | The type of charge made: C - Chargeback D - Out of Window Chargebacks J - Out of Window Chargeback Reversal K - Chargeback Reversal N - Decline R - Refund S - Normal Charge | |
66 | Matching Donation | Text | 3 | Donations in this field may come from matches by a fundraiser creator or matches by Facebook for birthday gifts but do not include Giving Tuesday matching. | |
67 | Sender Currency | Text | 5 | Currency the donation was made in. | |
68 | Payout Currency | Text | 5 | Currency the donation will be paid out in. | |
69 | Tax Amount | Float | 15 | Amount of tax withheld from donation | |
70 | Total Activity Recorded | Numeric | 10 | Total count of activity recorded in messenger for challenges. Example: - 110 (miles) | |
71 | Tax USD Amount | Float | 15 | Amount of tax in USD withheld from donation | |
72 | FB Giving Source | Text | 255 | Source Name: The location on Facebook where the donation was made. - donate_button_charity_page : Donations raised through clicking donate button on the charity's Facebook Page header. - donate_button_charity_posts: Donations raised through a donate button added to a post on the charity's Facebook Page. - donate_button_user_posts: Donations raised through a user adding the donate button to their own post. - fundraisers: Donations raised from all other sources (example: fundraisers made by a user or a profile frame). - ig_donation_sticker : Donations raised through a sticker on an Instagram Story. - ig_profile_donate_button : Donations raised through donate buttons on an Instagram business profile. - video_fundraiser: Donations raised from a user adding a donate button to their live video. | |
73 | Event Acquisition Source | Text | 45 | Source of event registration: - Group, Referral, Lead Forms | |
74 | Activity Type | Text | 45 | Type of challenge activity. For example: - Burpees - Miles | |
75 | Attribution Source | Attribution Source | Text | 50 | Designates if e-mail address came from Transaction Report or Donor Module |
76 | Date of Acquisition | Date: YYYY/MM/DD | 10 | Date of acquisition for challenge sign up | |
77 | Event Location | Text | 255 | Location of event | |
78 | Event Title | Text | 255 | Name of individual events. For example: - Chicagoland 35 Mile Challenge - Detroit 25 Burpee Challenge | |
79 | Is Fundraiser | Designates if someone registered for a challenge and is a fundraiser | |||
80 | Is Lead | Designates if someone registered for a challenge | |||
81 | Is Participant | Designates if someone registered for a challenge and recorded an activity | |||
82 | Activity Recorded | Total count of activity recorded in messenger for challenges. Example: - 110 (miles) | |||
83 | Survey Question 1 | Text | 4000 | Before this challenge, have you participated in an event, race or fundraising activity benefiting a nonprofit? | |
84 | Survey Question 2 | Text | 4000 | How does the virtual experience compare to the physical event? | |
85 | Survey Question 3 | Text | 4000 | Describe how the virtual experience compares to a physical event | |
86 | Survey Question 4 | Text | 30 | How likely are you to participate in the event next year? | |
87 | Survey Question 5 | Text | 30 | Please rate your experience with the Messenger companion app | |
88 | Survey Question 6 | Text | 4000 | What would you change? | |
89 | Survey Question 7 | Text | 4000 | We loved having you as a member of our Facebook Group. What would you like to get out of this community between events? | |
90 | Survey Question 8 | Text | 4000 | How would you like to contribute in the future? - Monthly Giver - Donate Birthday - Share Story | |
91 | Gift Aid UK Only | Binary (1/0) | Designates if donation qualifies for Gift Aid in the UK | ||
92 | Gift Aid - Donation Country | Text | 255 | Designates country where donation was made to qualify for Gift Aid | |
93 | Gift Aid - Donor Email for Sending Receipt | Text | 255 | Email provided by donor to qualify for Gift Aid | |
94 | Gift Aid - Donor Full Name | Text | 255 | Full name that donor provides to qualify for Gift Aid | |
95 | Gift Aid - Donor Physical Address City | Text | 255 | Address that donor provides to qualify for Gift Aid | |
96 | Gift Aid - Donor Physical Address Country | Text | 255 | Address that donor provides to qualify for Gift Aid | |
97 | Gift Aid - Donor Physical Address Line 1 | Text | 255 | Address that donor provides to qualify for Gift Aid | |
98 | Gift Aid - Donor Physical Address Line 2 | Text | 255 | Address that donor provides to qualify for Gift Aid | |
99 | Gift Aid - Donor Physical Address Postal Code | Text | 255 | Address that donor provides to qualify for Gift Aid | |
100 | Gift Aid - Donor Physical Address State | Text | 255 | Address that donor provides to qualify for Gift Aid | |