Data Extensions - Public

	A	B	C	D	E
1	Data Source	WinRed Field Name	Data Extension Field	Data Type	Example

2	New		record_type	Text	donation
3	Both	revv_uid	record_id	Text	rv_ccc_01ffpc554t10zzjhrw6vk63w3m
4	Both	created_at	created_at	Date	9/15/21 23:59
5	Donation	product_name	product_name	Text	Double Upsell Donation
6	Donation	profile_revv_uid	profile_id	Text	rv_prof_01ffpbn17137589kcnp1e8to8b
7	Both	email	email	EmailAddress	demo@revv.com
8	Both	first_name	first_name	Text	John
9	Both	last_name	last_name	Text	Doe
10	Both	address	address	Text	1234 Main Street
11	Both	city	city	Text	Houston
12	Both	state	state	Text	TX
13	Both	zip	zip	Text	77002
14	Both	mobile	mobile	Phone	6615554697
15	Donation	phone	phone	Phone	6615554697
16	Both	sms_opt_in	sms_opt_in	Boolean	FALSE
17	Both	sms_accepted_at	sms_opt_in_at	Date	9/15/21 23:59
18	Donation	occupation	occupation	Text	Retired
19	Donation	employer	employer	Text	Retired
20	Donation	employer_address	employer_address	Text	1776 Wilson Blvd Suite 530
21	Donation	employer_city	employer_city	Text	Arlington
22	Donation	employer_state	employer_state	Text	VA
23	Donation	employer_zip	employer_zip	Text	22209
24	Both	source_url	source_url	Text	https://secure.winred.com/lincoln-for-illinois/june-donate?utm_medium=email_hf&utm_source=sfmc&utm_campaign=june-deadline&utm_content=button-red-donate-now&utm_term=click_now
25	Both	referer	referer	Text	https://secure.winred.com/lincoln-for-illinois/sign-up-now
26	Both	utm_medium	utm_medium	Text	email_hf
27	Both	utm_source	utm_source	Text	sfmc
28	Both	utm_campaign	utm_campaign	Text	june-deadline
29	Both	utm_content	utm_content	Text	button-red-donate-now
30	Both	utm_term	utm_term	Text	click_now
31	Both	initiative_name	campaign_name	Text	End of Quarter Goal
32	Both	initiative_campaign_revv_uid	campaign_id	Text	rv_ig_01ffp743t511mmd0d95j2qjr5q
33	Donation	initiative_type	campaign_type	Text	merchandise_campaign
34	Lead	source	lead_type	Text	abandoned_cart
35	Both	user_agent	user_agent	Text	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36
36	Donation	interval	interval	Text	month
37	Donation	recurrence_ordinal	recurrence_ordinal	Number	1
38	Donation	recurring	part_of_subscription	Boolean	TRUE
39	Donation	user_type	one_click_eligible	Boolean	TRUE
40	Donation	one_click	one_click_donated	Boolean	FALSE
41	Donation	money_bomb_opt_in	money_pledge_opt_in	Boolean	TRUE
42	Both	source_revv_uid	origin_organization_id	Text	rv_acct_KAc7JCrR2zqrYbmN4AJEd7xy
43	Both	source_name	origin_organization_name	Text	WinRed Demo
44	Donation		recipient_organization_id	Text	rv_acct_KAc7JCrR2zqrYbmN4AJEd7xy
45	Donation		recipient_organization_name	Text	WinRed Demo
46	Donation	upsell_page_type	upsell_page_type	Text	Conduitpanelupsell
47	Donation	first_subscribed	subscription_start	Boolean	TRUE
48	Donation	amount	donation_amount	Decimal	999999.99
49	Both	page_name	page_name	Text	June Deadline
50	Both	page_revv_uid	page_uid	Text	rv_page_01fg4qx8a13mc2q7jeex3g5491
51	Donation	money_bomb_opt_in_revv_uid	money_pledge_opt_in_uid	Text	rv_ig_01ezmgrgjea7f2gcfcbvf9cvcv
52	Donation	money_bomb_processed_revv_uid	money_pledge_processed_uid	Text	rv_ig_01ezmgrgjea7f2gcfcbvf9cvcv
53	Donation	money_bomb_processed_name	money_pledge_processed_name	Text	MB 9/30
54	Donation	merch_order_revv_uid	merchandise_order_uid	Text	ord_01fg51sd4g5mccshdearwq81nn
55	Both		language	Locale
56	Both	source_code	source_code	Text	etext
57	Lead		petition_number_of_fields	Number	15
58	Donation	contributor_type	contributor_type	Text	personal
59	Donation	business_name	business_name	Text
60	Donation	type_of_business	type_of_business	Text
61	Donation	pac_name	pac_name	Text