Google Sheets Export Report Schemas

	A	B	C
1	Buckets Breakdown
2	Column Name	Description	Data Type

3	TIER_1	Marketing channel categorization level 1 (most broad), as defined in your mapping rules. For example, a link where referrer url = Google and utm_campaign = cpc may be mapped as tier_1 = Paid Search and tier_2 = Google	string
4	TIER_2	Marketing channel categorization level 2	string
5	TIER_3	Marketing channel categorization level 3	string
6	TIER_4	Marketing channel categorization level 4	string
7	TIER_5	Marketing channel categorization level 5	string
8	SPEND_KEY	The ID used to pull spend from an advertising platform. This is typically the Ad ID, but may differ based on your account setup.	string
9	DATE	Date when the action occurred	date
10	FIRST_TOUCH	Sum of first touch conversions (if marketing touchpoint is the first touchpoint, then it will get full credit for the conversion; otherwise, it will get no credit)	float
11	NTF_FIRST_TOUCH	Sum of first touch conversions, filtered by new to file users	float
12	REVENUE_FIRST_TOUCH	If the marketing touchpoint is the first interaction, it will get full revenue credit. Otherwise will be 0.	float
13	NTF_REVENUE_FIRST_TOUCH	First touch revenue, filtered by new to file users	float
14	LAST_TOUCH	Sum of last touch conversions (if marketing touchpoint is the last touchpoint, then it will get full credit for the conversion; otherwise, it will get no credit)	float
15	NTF_LAST_TOUCH	Sum of last touch conversions, filtered by new to file users	float
16	REVENUE_LAST_TOUCH	Last touch revenue	float
17	NTF_REVENUE_LAST_TOUCH	Last touch revenue, filtered to new to file users	float
18	EVEN	Fractional credit a marketing touchpoint receives if each touchpoint gets equal weight	float
19	NTF_EVEN	Even weight conversions, filtered by new to file users	float
20	REVENUE_EVEN	Using the even weight, the portion of conversion revenue that is attributed to this marketing touchpoint	float
21	NTF_REVENUE_EVEN	Even weight revenue, filtered by new to file users	float
22	NORMALIZED	Weight given to this marketing touchpoint, as determined by the multi-touch attribution model	float
23	NTF_NORMALIZED	Modeled weight conversions, filtered by new to file users	float
24	REVENUE_NORMALIZED	Using the normalized weight, the portion of conversion revenue that is attributed to this marketing touchpoint	float
25	NTF_REVENUE_NORMALIZED	Modeled weight revenue, filtered by new to file users	float
26	SPEND	Total spend in the advertiser's reporting currency	float
27	PLATFORM	The name of the platform (e.g., Facebook) associated with the marketing touchpoint	string
28	CACHE_ID	Identifier used by Rockerbox to sync dataset to your google sheet	string
29	CURRENCY_CODE	The advertiser reporting currency for both revenue and spend	string
30	ADVERTISER	Rockerbox Account ID	string
31	TYPE	The report type (e.g., platform_data)	string
32	REPORT	The name of the report	string
33	IDENTIFIER	conversion segment id	string
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