Adobe event.tsv Event List Mapping

[ADLSSt143]

In our SDR we use adobe events 251,252,253,254 for google search. We want to check whether these events are available in event.tsv file. But our confusion is which number we need to check in tsv for these events. Could you help us?

[Jennifer_Dungan · Accepted solution]

Hi,

when you say "events 251,252,253,254", I assume you mean "event251", "event252", "event253" and "event254'". The raw data "event id" is different from the "named event id", and your events.tsv will provide that mapping... that file includes all events, not just the ones you are using, and they are listed as pairs.

The files should start off like:

1 Purchase
2 Product View
10 Cart Open
11 Checkout
12 Cart Add
13 Cart Remove
14 Cart View
20 Campaign View
100 Instance of eVar1
101 Instance of eVar2
102 Instance of eVar3
103 Instance of eVar4
104 Instance of eVar5
105 Instance of eVar6
106 Instance of eVar7
107 Instance of eVar8
108 Instance of eVar9
109 Instance of eVar10

---

The actual events will start much later in the file:

200 Custom Event 1
201 Custom Event 2
202 Custom Event 3
203 Custom Event 4
204 Custom Event 5
205 Custom Event 6
206 Custom Event 7
207 Custom Event 8
208 Custom Event 9
209 Custom Event 10

---

The numbering conventions change a bit after event 100.. The events in question that you are looking for should be:

20250 Custom Event 251
20251 Custom Event 252
20252 Custom Event 253
20253 Custom Event 254

---

So in your Raw Data events list, you will look for 20250, 20251, 20252 and 20253

1, 2, 10, 11, 12, 13, 14 and 20 are all standard.

The 100s (and 10000s) are your eVar Instances

The 200s (and 20000s) are your custom events

The 500s, 600s and 700s are a mix of click map and mobile app events

The 1700s are campaign items

[ADLSSt143]

Thanks Jennifer, where we can see these information in Adobe documentation ?

[Jennifer_Dungan]

The only documentation I know of is this:

https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d... 

And it really doesn't go into much depth... just that the event mappings are provided via the events.tsv file....

[leocwlau]

@ADLSSt143,  A bit of self-promotion . I wrote a blog before with Python examples on how to break and map event_list and post_event_list, https://leocwlau.com/2022/converting-event_list-and-post_event_list-in-adobe-analytics-data-feed/