| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Field | Example | Format on Charges | Format on Conduit Candidate Charges (CCC) | Description | |||||||||||||||||||
2 | address | 123 Main Street (address1) | string | string | Donor's address | |||||||||||||||||||
3 | address_2 | Apt 128-S | string | string | Donor's address line 2 | |||||||||||||||||||
4 | amount | 33.33 | decimal | decimal | Donation amount (or conduited amount for CCCs) | |||||||||||||||||||
5 | amount_refunded | 23 | decimal | decimal | Refunded amount | |||||||||||||||||||
6 | amount_reversed | 10 | decimal | decimal | Alias of amount_refunded | |||||||||||||||||||
7 | application_fee | 18.3 | decimal | decimal | The total fee amount charged, including merchandise and partner fees | |||||||||||||||||||
8 | arrival_date | 2019-03-06 03:58:11 UTC | n/a | datetime | The payout estimated arrival date | |||||||||||||||||||
9 | bundler_id | bundler-id-example | string | string | Bundler ID | |||||||||||||||||||
10 | candidate_state | VA | n/a | string | The US State the candidate is from | |||||||||||||||||||
11 | card_brand | visa | string | string | Card issuer | |||||||||||||||||||
12 | charge_amount | 500 | n/a | decimal | The total donation amount of the CCC | |||||||||||||||||||
13 | charge_revv_uid | rv_ch_123hex | n/a | string (example: rv_ch_hex) | This links the conduit candidate charge back to the top-level charge | |||||||||||||||||||
14 | charge_type | conduit_page | string | string | The type of charge, correlates to the Page the charge occurred on | |||||||||||||||||||
15 | chargeback_status | lost | string | string | The status of the dispute | |||||||||||||||||||
16 | city | Arlington | string | string | Donor's city | |||||||||||||||||||
17 | code | C123456789 | n/a | string | Alias of FEC Registration ID | |||||||||||||||||||
18 | conduit_candidate_revv_uid | rv_conduit_candidate_123hex | n/a | string | The candidate receiving the CCC | |||||||||||||||||||
19 | created_at | 2019-03-06 03:58:11 UTC | datetime | datetime | The datetime of the donation | |||||||||||||||||||
20 | default_percentage | 0.3 | n/a | decimal | The default percentage of the candidate in the conduit | |||||||||||||||||||
21 | description | Smith for Congress | n/a | string | Description of the candidate | |||||||||||||||||||
22 | district | VA-7 | n/a | string | The candidate's district | |||||||||||||||||||
23 | donor_covered_fees | boolean | boolean | True or false, if the donor covered processing fees or not | ||||||||||||||||||||
24 | bob@example.com | string | string | Donor's email | ||||||||||||||||||||
25 | employer | string | string | Donor's employer | ||||||||||||||||||||
26 | employer_address | address1 | string | string | Donor's employer address | |||||||||||||||||||
27 | employer_city | string | string | Donor's employer city | ||||||||||||||||||||
28 | employer_state | string | string | Donor's employer state | ||||||||||||||||||||
29 | employer_zip | string | string | Donor's employer postal code | ||||||||||||||||||||
30 | fec_registration_id | C123456789 | n/a | string | FEC Registration ID | |||||||||||||||||||
31 | fee | n/a | decimal | Alias to application_fee for CCCs | ||||||||||||||||||||
32 | first_name | string | string | Donor's first name | ||||||||||||||||||||
33 | first_subscribed | boolean | boolean | True, if this is the first donation on a subscription. I.e. when the donor donates and subscribes, that first donation will have 'true' in this field | ||||||||||||||||||||
34 | from_payment_request_button | boolean | boolean | True or false, if the donor used Apple Pay or Google Pay | ||||||||||||||||||||
35 | highest_personal_contribution | decimal | decimal | Highest personal contribution for this donor. For anonymous donors, we do NOT match on email or anything | ||||||||||||||||||||
36 | initiative_campaign_revv_uid | rv_ig_123hex | string | string | The initiative attached to the page | |||||||||||||||||||
37 | initiative_name | Trump 45 Pint Glass - Gold | string | string | Name of the initiative | |||||||||||||||||||
38 | initiative_type | merchandise_campaign | string | string | Type of the initiative | |||||||||||||||||||
39 | interval | monthly | string | string | Recurring interval, how often the subscription recurs | |||||||||||||||||||
40 | last_name | string | string | Donor's last name | ||||||||||||||||||||
41 | maximum_contribution_cents | n/a | integer | The maximum personal donation for the donor | ||||||||||||||||||||
42 | merchandise_fee | decimal | decimal | The merchandise fees | ||||||||||||||||||||
43 | mobile | 15555555555 | integer | integer | Donor's mobile number | |||||||||||||||||||
44 | most_recent_contribution | decimal | decimal | The donor's most recent donation value | ||||||||||||||||||||
45 | name | n/a | string | The name of the Candidate, not the donor | ||||||||||||||||||||
46 | net | 15 | n/a | decimal | Gross amount less fees | |||||||||||||||||||
47 | occupation | string | string | Donor's occupation | ||||||||||||||||||||
48 | office | president | n/a | string | The office of the Candidate | |||||||||||||||||||
49 | one_click | boolean | boolean | True, if this is a one click donation | ||||||||||||||||||||
50 | order_details | [{}, {}] | array of hashes | n/a | The details of the conduit candidate charges for a particular charge | |||||||||||||||||||
51 | organization_name | WinRed | string | string | Name of the organization hosting the page | |||||||||||||||||||
52 | organization_revv_uid | string | string | UID of the organization hosting the page | ||||||||||||||||||||
53 | page_revv_uid | rv_page_123hex | string | string | UID of the page | |||||||||||||||||||
54 | page_name | Trump | string | string | The name of the page | |||||||||||||||||||
55 | party_affiliation | other | n/a | string | Party of the Candidate | |||||||||||||||||||
56 | phone | 15555555555 | integer | integer | Donor's phone number | |||||||||||||||||||
57 | price | 33.33 | n/a | decimal | Alias to amount | |||||||||||||||||||
58 | processing_fees | decimal | decimal | Revv processing fee. Credit card processing fees, plus merchandise fees that Revv takes on the charges | ||||||||||||||||||||
59 | profile_revv_uid | rv_prof_123hex | string | string | UID of the donor's profile | |||||||||||||||||||
60 | recurrence_ordinal | 3 | integer | integer | The number represents how many times the subscription has recurred. For example, 3 represents that this is the third donation on this subscription | |||||||||||||||||||
61 | recurring | boolean | boolean | True/false if its part of a subscription | ||||||||||||||||||||
62 | referer | https://l.facebook.com | string | string | The URL where the donor came from | |||||||||||||||||||
63 | revv_subscription_id | rv_sub_123hex | string | string | UID of the subscription | |||||||||||||||||||
64 | revv_uid | rv_ch_123hex | rv_ccc_123hex | UID of the Charge or CCC | ||||||||||||||||||||
65 | share_data | n/a | boolean | True/false if data is being shared to the Candidate | ||||||||||||||||||||
66 | shipping_city | string | string | Donor's shipping city | ||||||||||||||||||||
67 | shipping_first_name | string | string | Donor's shipping first name | ||||||||||||||||||||
68 | shipping_last_name | string | string | Donor's shipping last name | ||||||||||||||||||||
69 | shipping_state | string | string | Donor's shipping state | ||||||||||||||||||||
70 | shipping_street | string | string | Donor's shipping street | ||||||||||||||||||||
71 | shipping_street_2 | Apt 128-S | string | string | Donor's shipping street 2 | |||||||||||||||||||
72 | shipping_zip | string | string | Donor's shipping postal code | ||||||||||||||||||||
73 | sms_accepted | boolean | boolean | True/false if the donor opted-in to SMS | ||||||||||||||||||||
74 | sms_accepted_at | datetime | datetime | Datetime of the donor opted-in to SMS | ||||||||||||||||||||
75 | source_code | string | string | Source code | ||||||||||||||||||||
76 | source_name | n/a | string | Name of the source candidate. The candidate who setup the page and conduited to your candidate | ||||||||||||||||||||
77 | source_type | card | string | string | Type of funding source: card or bank account | |||||||||||||||||||
78 | source_url | https://secure.winred.com/donate | string | string | The landing page URL the donor donated at | |||||||||||||||||||
79 | state | VA | string | string | Donor's state | |||||||||||||||||||
80 | status | succeeded | string | string | Status of the charge | |||||||||||||||||||
81 | subscription_current_period_end_at | datetime | datetime | The subscription's next processing datetime | ||||||||||||||||||||
82 | subscription_current_period_start_at | datetime | datetime | The susbcription's previous processing datetime | ||||||||||||||||||||
83 | subscription_origin_charge_revv_uid | string | string | UID of the origin charge of a subscription | ||||||||||||||||||||
84 | subscription_status | active | string | string | Status of the subscription | |||||||||||||||||||
85 | upsell_page_revv_uid | rv_up_123hex | string | string | UID of the upsell page the donation came from | |||||||||||||||||||
86 | upsell_page_type | Doubleupsell | string | string | Type of the upsell page the donation came from | |||||||||||||||||||
87 | upsell_parent_id | string | string | UID of the origin charge that started the Upsell flow | ||||||||||||||||||||
88 | user_agent | Mozilla/5.0 | string | string | The browser and device the donor was using when they donated | |||||||||||||||||||
89 | user_type | boolean | boolean | True, if the donor is a logged-in donor | ||||||||||||||||||||
90 | utm_campaign | string | string | UTM Campaign | ||||||||||||||||||||
91 | utm_content | string | string | UTM Content | ||||||||||||||||||||
92 | utm_medium | string | string | UTM Medium | ||||||||||||||||||||
93 | utm_source | string | string | UTM Source | ||||||||||||||||||||
94 | utm_term | string | string | UTM Term | ||||||||||||||||||||
95 | zip | 20005 | string | string | Donor's postal code | |||||||||||||||||||
96 | ||||||||||||||||||||||||
97 | ||||||||||||||||||||||||
98 | ||||||||||||||||||||||||
99 | ||||||||||||||||||||||||
100 |