Workstream #2: Moving Event Properties to User Properties

1 Table 1: Event properties to move to User Properties
2 Table 2: User Properties to Deprecate

Table 1: Event properties to move to User Properties

#	Event Property	Action	New Name	Keeping as event property	rbiberia Comment
1	appBuild	User property	App Build	No
2	browserType	User property	Browser Type	No
3	browserVersion	User property	Browser Version	No
4	isMobileWeb	User property	Mobile Web	No
5	Locale	User property		No
6	Pickup Mode	User property		Yes
7	Service Mode	User property		Yes
8	loyaltyId	User property	Loyalty ID	No
9	Restaurant Address	User property		Yes
10	Restaurant ID	User property		Yes	Q: How to get all stores?
11	Restaurant Name	User property		Yes
12	Restaurant Number	User property		Yes
13	StoreId	User property	Sanity Restaurant ID	Yes

Table 2: User Properties to Deprecate

#	Event Property	Action	rbi Comment	rbiberia Comment
1	$Age	Deprecate	Use Age instead
2	Adjust Enabled	Deprecate
3	Amplitude Enabled	Deprecate
4	Basic Consent Enabled	Deprecate
5	Birthday Date	Deprecate	Use dob instead ('Birthday' in Braze)
6	bkLegacyUserId	Deprecate
7	bkLegacyUserType	Deprecate
8	Branch Enabled	Deprecate
9	Braze Enabled	Deprecate
10	Camera Access	Deprecate
11	Comfort Consent Enabled	Deprecate
12	customer_name	Deprecate
13	dob	Do not deprecate	Use Date of Birth instead	Don’t deprecate, needed for Braze native attribute ‘Birthday’
14	Email Opt In	Deprecate	Use email_subscribe instead
15	Facebook Enabled	Deprecate
16	fdCustomerId	Deprecate
17	Firebase Enabled	Deprecate
18	firstName	Deprecate	Use FirstName instead
19	Frequency last 30 days	Deprecate	Not used/available
20	Language	Deprecate	Use language instead
21	Last App Visit	Deprecate	Not used/available
22	Last Order Date	Deprecate	Keep Date Last Order
23	Last Order Value	Deprecate	Not used/available
24	lastName	Deprecate	Use LastName instead
25	Location Services	Deprecate
26	loyalty	Deprecate	Not working as expected, can filter where loyalty id is not null
27	migratedTimestamp	Deprecate
28	Name	Deprecate	Split between FirstName and LastName
29	New Coupons Opt In	Deprecate
30	New Products Opt In	Deprecate
31	notifications	Deprecate
32	Number of Activated Coupons	Deprecate	Not used/available
33	Offers Consent Enabled	Deprecate
34	Orders Count	Deprecate	Not used/available
35	Orders Value	Deprecate?	Not used/available
36	orderStatus	Deprecate
37	promotionalEmails	Deprecate
38	Push Notifications	Deprecate	Use push_subscribe instead
39	rewardsEmail	Deprecate	Use email_subscribe instead
40	rewardsPush	Deprecate
41	secondaryIdentifier	Deprecate
42	secondaryIdentifierCreatedDate	Deprecate
43	secondaryIdentifierType	Deprecate
44	source	Deprecate
45	Store Cities List	Deprecate	Not used/available
46	Store Ids List	Deprecate	Not used/available
47	thLegacyCognitoId	Deprecate
48	Tier	Deprecate
49	updatedAt	Deprecate
50	userId	Deprecate	We have user_id for rbi cognito id
51	userPreferences	Deprecate
52	userSortKey	Deprecate
53	web_os_name	Deprecate	We keep OS and Platform
54	web_os_version	Deprecate
55	zipcode	Deprecate	Use Zip instead
56	marketingEmail	Deprecate	Use email_subscribe instead
57	marketingPush	Deprecate	Use push_subscribe instead
58	DISCOUNT_TYPE	Deprecate?		Don't Deprecate - Used for (RFM) segmentation