ABCDEFGHIJKLMNOPQR
1
mParticle Data Plan Builder | Media
2
This sheet helps you understand how to use an mParticle Data Plan in this Data Plan Builder.
Read the docs for Data Plans here.
3
To get started, follow these steps:To use an EXISTING data plan, follow these steps:
4
1. Clone this template
1. Clone this template
5
To clone this Google Sheets template, select File > Make a copy.
Note: It can take up to 30 seconds for the mParticle add-on to load after cloning a sheet -- this is normal.

To clone this Google Sheet template, select File > Make a copy.
Note: It can take up to 30 seconds for the mParticle add-on to load after cloning a sheet -- this is normal.

6
2. Define your data model2. Download your existing Data Plan as JSON
7
Edit the Users and Events tabs to match the user and event data you plan to collect. Download your plan in the UI or use the Data Planning API.
8
9
3. Generate the data plan3. Import your existing data plan into the Builder
10
In the Google Sheets menu, select mParticle > Generate Data Plan to create your data plan. The script takes you to the Export tab after it's completed.
In the Import tab below, paste the JSON from Step 2 into the specified area. In the Google Sheets menu, select mParticle > Populate Builder From Data Plan to populate the Builder with your data plan. The script takes you to the Events tab after it's completed.
11
Note: You'll only see the mParticle menu option in your cloned sheet.
Note: You'll only see the mParticle menu option in your cloned sheet.
12
13
4. Upload to mParticle4. Edit your data model
14
To upload the plan JSON to mParticle in the UI or use the Data Planning API.Edit the Users, Events, and Products tabs below to match the user and event data you plan to collect.
15
16
5. [Optional] Generate code snippets5. Generate an updated data plan
17
Generate code snippets that you can use to implement your data plan with mParticle Snippets.In the Google Sheets menu, select mParticle > Generate Data Plan to generated an updated data plan. The script takes you to the Export tab after it's completed.
18
19
Note: You'll only see the mParticle menu option in your cloned sheet.
20
21
6. Upload to mParticle
22
Upload the updated plan JSON to mParticle in the UI or use the Data Planning API.
23
24
7. [Optional] Update code snippets
25
Generate updated code snippets that you can use to implement your data plan with mParticle Snippets.
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