HubSpot Data Migration Property Matching Template (Partners)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	MAKE A COPY if you want to use this template
2	[Company Name] Hubspot Integration
3	Property Field Matching Database
4
5	[Client System] Property Label
6	[Client System] Property Internal Name
7	Hubspot Property Label	First Name	Last Name	Company name	Contact ID	Contact Owner	Email	Phone Number	Mobile phone number	Fax Number	Street Address	City	Postal Code	Country/Region	Lead Status	Lifecycle stage	Create date	Lead Source	Original Source
8	Hubspot Property Internal Name	firstname	lastname	company	hs_object_ID	hubspot_owner_id	email	phone	mobilephone	fax	address	city	zip	country	hs_lead_status	lifecyclestage	createdate	lead_source	hs_analytics_source

9	Description	A contact's first name	A contact's last name	The name of the contact's company. This is separate from the Name property of the contact's associated company and can be set independently.	The unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed.	The owner of a contact. This can be any HubSpot user or integration user, and can be set manually or via Workflows.	A contact's email address	A contact's primary phone number	A contact's mobile phone number	A contact's primary fax number	A contact's street address, including apartment or unit #	A contact's city of residence	The contact's zip code. This might be set via import, form, or integration.	The contact's country/region of residence. This might be set via import, form, or integration.	The contact's sales, prospecting or outreach status	The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.	The date that a contact entered the system	The known source through which a contact found your company	The first known source through which a contact found your website. Source is automatically set by HubSpot, but may be updated manually.
10	Group	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Contact information	Web analytics history	Custom group #1
11	Field Type	Single-line text	Single-line text	Single-line text	Number field	HubSpot user	Single-line text	Single-line text	Single-line text	Single-line text	Single-line text	Single-line text	Single-line text	Single-line text	Radio select	Radio select	Date picker	Single-line text	Dropdown select
12	Property Status inHubspot	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	Existing	To be created
13	Options					Hubspot User List									New	Subscriber			Organic Search
14															Open	Lead			Paid Search
15															In Progress	Marketing Qualified Lead			Email marketing
16															Open Deal	Sales Qualified Lead			Social media
17															Unqualified	Opportunity			Referrals
18															Attempted to contact	Customer			Other campaigns
19															Connected	Evangalist			Direct traffic
20															Bad Timing	Other			Offline Sources
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100