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/

[luliu84]

Hi Jenn!

Are the mapping example you shared above is universal?  I assume yes.  I don't have a look up table as it is an adhoc pull of all the hits associated with an order.  I am trying to decipher the event_list.  

Based on what you shared above, can I say 166 instance of eVar67?

Thank you!

[Jennifer_Dungan]

Hi @luliu84,

The lookup file is standard, so the instance of eVar1 will always be "100", and event1 will always be "200"

Based on what you shared above, can I say 166 instance of eVar67?

---

I'm not sure if you mean that "Instance of eVar67", or that you can map "166" to "Instance of eVar67"

• If the first, then no, that doesn't mean 166 instances... you will have to count how many instances occurred.
• If you mean that you can set up a standard mapping, then yes... you shouldn't have to check the events.tsv every time.. that mapping should be the same for each run (unless Adobe adds some new events, but that shouldn't change your values... but as you can see, there are some gaps in the numbering, that allows Adobe to add some new values, and why Instances of eVar are all in the 100s (or 10000s), and why events are in the 200s (or 20000s).

To make sure this is clear (for you and anyone else who comes upon this post), I will show a simple flow:

• Page 1
  • eVar1="something"
  • events="event1,event2"  (what was set by your implementation)
    • You will also get an event for Instance of eVar1 on this call, since eVar1 was explicitly set
• Page 2
  • eVar1 not set, but retains value "something"
  • events="event1"   (what was set by your implementation)
    • You will not get Instance of eVar1 here, since the value is only retained
• Page 3
  • eVar1 set to "else"
  • no events
    • You will get an event for Instance of eVar1 on this call, since eVar1 was explicitly set

You will have three rows of data in your raw data export.

The first row (Page 1) will have an event_list of "100,200,201"

The second row (Page 2) will have an event_list of "200"

The third row (Page 3) will have an event_list of "100"

You will have to count these to get the events.

Overall, you will have:

• 2 - "Instance of eVar1"
• 2 - "Event1"
• 1 - "Event2"

I hope this helps.

[luliu84]

Hi Jenn!

I meant the standard mapping.  The example you provided is super helpful to further understand event list data.

Much appreciated!

Lu

[Jennifer_Dungan]

You're very welcome.. and yes, thankfully the mapping does not change on every pull... that would be a nightmare!

I believe the lookup table is provided each time, just in case something changes, you will have it (or you will get it on the first data pull)... for instance, let's pretend that Adobe adds 500 more Custom Events, so you have have up to 1500 (instead of the current 1000)... they would add the references for those new events into the mapping file... and while logically, that should mean starting at 21000, maybe it doesn't, and they have another gap that uses 200100 - 200500). You would have access to that new mapping immediately.