--- title: "Data Activation historic event export" slug: "data-activation-historic-event-export" description: "Learn how to choose and run a historic event export, filter data, and understand file structure for efficient interaction and fact data management." updated: 2026-09-03T12:12:05Z published: 2026-09-03T12:12:05Z canonical: "docs.supermetrics.com/data-activation-historic-event-export" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Data Activation historic event export This article is a deep-dive companion to [How to use Data Activation exports](/v1/docs/how-to-use-data-activation-exports) and shows you how to choose and run a historic event export. With the **Historic event export** type, you can export all interaction data and fact data. Because this typically produces a large volume of information, we recommend specifying a query to fine-tune your filter. ## Understand the file structure The exported file follows this naming convention: **File name:** `fromdate-todate-uniqueID-trackingEventsStream.txt.gz` **Example:** `20210217-20210224-6970f9ac-459f-4592-9445-fc01751274c9-trackingEventsStream.txt.gz` - **Container**: `.gz` (a `.txt` file inside the `.gz` file). - **Structure**: JSON line format (each line is a valid JSON message). **Example data:** The following example contains all available event types. ```json {"siteNumber":1232,"trackId":"effa0827-f638-43b6-b16b-f2292ee386f4","timestamp":1613723775161,"eventId":"87587a90-728d-11eb-89a8-05da639d6de4","type":"FlightSearch","content":"","variables":{"date":"2021-06-01"},"interactionType":"engagement"} {"siteNumber":1232,"trackId":"effa0827-f638-43b6-b16b-f2292ee386f4","timestamp":1613723788543,"eventId":"8f5268f0-728d-11eb-aee0-771e4d64a934","type":"productView","content":"","variables":{"productId":"8"},"interactionType":"engagement"} {"siteNumber":1232,"trackId":"effa0827-f638-43b6-b16b-f2292ee386f4","timestamp":1613723825890,"eventId":"a5951c20-728d-11eb-b45e-b9671252bbcd","partnerNumber":2001,"partnerCookie":"ID123","mergeType":"SITE","interactionType":"sync"} {"siteNumber":1232,"trackId":"ef569ece-c6f6-484e-ad20-da2c0b734375","timestamp":1613723859236,"eventId":"b9754e40-728d-11eb-bc14-8de195883cd6","type":"Customer","ttl":600000,"forceInsert":false,"variables":{"country":"NL"},"operationType":"INSERT","interactionType":"externalFact"} {"siteNumber":1232,"trackId":"ef569ece-c6f6-484e-ad20-da2c0b734375","timestamp":1613723862969,"eventId":"bbaeea90-728d-11eb-b45e-b9671252bbcd","type":"Customer","ttl":600000,"forceInsert":false,"variables":{"country":"DE"},"operationType":"INSERT","interactionType":"externalFact"} {"siteNumber":1232,"trackId":"ef569ece-c6f6-484e-ad20-da2c0b734375","timestamp":1613723906319,"eventId":"d58599f0-728d-11eb-a108-27f6dea8c63d","transactionId":"123","value":0,"products":[],"variables":{},"interactionType":"conversion"} {"siteNumber":1232,"trackId":"ef569ece-c6f6-484e-ad20-da2c0b734375","timestamp":1613724120659,"eventId":"55474a30-728e-11eb-89a8-05da639d6de4","transactionId":"10212","value":500,"products":["product1","product2"],"variables":{"variant":"1"},"interactionType":"conversion"} {"siteNumber":1232,"trackId":"ef569ece-c6f6-484e-ad20-da2c0b734375","timestamp":1613724147728,"eventId":"6569b100-728e-11eb-89c8-7fac82f3b335","url":"https://demoshop64.relay42-demo.com/","source":"","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36","interactionType":"sessionStart"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724193994,"eventId":"80fd52a0-728e-11eb-aee0-771e4d64a934","url":"https://demoshop64.relay42-demo.com/","source":"","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36","interactionType":"sessionStart"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724243747,"eventId":"9ea50730-728e-11eb-89c8-7fac82f3b335","partnerNumber":7,"partnerCookie":"CAESEEpsQ1cNmeUTQRe4GRWyy4c","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724382000,"eventId":"f10cc300-728e-11eb-2515-f52f201da74b","identifier":"2","subIdentifier":null,"referral":null,"interactionType":"bannerView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724403000,"eventId":"fd911b80-728e-11eb-a62e-d868a54bc802","identifier":"2","subIdentifier":null,"referral":null,"interactionType":"bannerView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724436000,"eventId":"113c8200-728f-11eb-8bac-353e358bfb2d","identifier":"2","subIdentifier":null,"referral":null,"interactionType":"bannerView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724443000,"eventId":"15689f80-728f-11eb-9424-b5c852aa3e16","identifier":"2","subIdentifier":null,"referral":null,"interactionType":"bannerView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613724526000,"eventId":"46e16b00-728f-11eb-ec43-07665d8190e4","identifier":"2","subIdentifier":null,"referral":null,"interactionType":"bannerView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613725152817,"eventId":"bc7e1a10-7290-11eb-bc14-8de195883cd6","partnerNumber":12,"partnerCookie":"6912077124962412972","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1613730397403,"eventId":"f2826ab0-729c-11eb-bc14-8de195883cd6","partnerNumber":12,"partnerCookie":"6912077124962412972","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"035f9fa2-ec2b-4ff6-93cd-718d91dd3c0a","timestamp":1614123189797,"eventId":"7d054550-762f-11eb-bd2b-114198157ed5","partnerNumber":7,"partnerCookie":"CAESELzD3yne_qKTemlkHkmSztM","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"b313eda6-bbe1-433b-9cf3-879079586a3f","timestamp":1614165438222,"eventId":"db0b52e0-7691-11eb-b445-876cdba6ec7e","partnerNumber":0,"partnerCookie":"f90de690-2879-4ed4-aefd-ac77ef1a5b0d","mergeType":"SITE","thirdPartyCookie":"b313eda6-bbe1-433b-9cf3-879079586a3f","interactionType":"thirdPartySync"} {"siteNumber":1232,"trackId":"b313eda6-bbe1-433b-9cf3-879079586a3f","timestamp":1614165438243,"eventId":"db0e8730-7691-11eb-afba-b1ff9ddc9c50","partnerNumber":7,"partnerCookie":"CAESEEpsQ1cNmeUTQRe4GRWyy4c","mergeType":"SITE","thirdPartyCookie":"b313eda6-bbe1-433b-9cf3-879079586a3f","interactionType":"thirdPartySync"} {"siteNumber":1232,"trackId":"b313eda6-bbe1-433b-9cf3-879079586a3f","timestamp":1614165438293,"eventId":"db162850-7691-11eb-afba-b1ff9ddc9c50","partnerNumber":2,"partnerCookie":"dfbafcac-f7b7-47d8-af8a-4cd5b1403228","mergeType":"SITE","thirdPartyCookie":"b313eda6-bbe1-433b-9cf3-879079586a3f","interactionType":"thirdPartySync"} {"siteNumber":1232,"trackId":"8bc275c6-de2e-4adc-b93b-e85e59e66a0f","timestamp":1614165438295,"eventId":"db167670-7691-11eb-a85b-e14fc533460e","type":"bannerview","content":"","variables":{},"interactionType":"engagement"} {"siteNumber":1232,"trackId":"8bc275c6-de2e-4adc-b93b-e85e59e66a0f","timestamp":1614165732169,"eventId":"8a401390-7692-11eb-a85b-e14fc533460e","type":"bannerview","content":"","variables":{},"interactionType":"engagement"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614174174313,"eventId":"32290590-76a6-11eb-a51e-9bc5cda736fb","partnerNumber":12,"partnerCookie":"6912077124962412972","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614175061804,"eventId":"432566c0-76a8-11eb-91ec-a38b45b97fab","transactionId":"10212","value":500,"products":["product1","product2"],"variables":{"variant":"1"},"interactionType":"conversion"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178134045,"eventId":"6a582cd0-76af-11eb-b445-876cdba6ec7e","transactionId":"10212","value":500,"products":["product1","product2"],"variables":{"variant":"1"},"interactionType":"conversion"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178144872,"eventId":"70cc3e80-76af-11eb-a51e-9bc5cda736fb","url":"https://demoshop64.relay42-demo.com/","source":"","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36","interactionType":"sessionStart"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178166119,"eventId":"7d764770-76af-11eb-9e00-ed7479652290","type":"Customer","ttl":600000,"forceInsert":false,"variables":{"country":"test"},"operationType":"INSERT","interactionType":"externalFact"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178172829,"eventId":"817624d0-76af-11eb-91ec-a38b45b97fab","url":"https://demoshop64.relay42-demo.com/","source":"","userAgent":null,"interactionType":"pageView"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178187285,"eventId":"8a13f450-76af-11eb-9e00-ed7479652290","type":"productView","content":"","variables":{"productId":"8"},"interactionType":"engagement"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178197810,"eventId":"9059f120-76af-11eb-afba-b1ff9ddc9c50","partnerNumber":2,"partnerCookie":"dfbafcac-f7b7-47d8-af8a-4cd5b1403228","mergeType":"NO_MERGE","interactionType":"sync"} {"siteNumber":1232,"trackId":"fe09d818-5c21-43d2-a70b-049984862be7","timestamp":1614178234553,"eventId":"a6407a91-76af-11eb-91ec-a38b45b97fab","partnerNumber":2001,"partnerCookie":"ID123","mergeType":"SITE","interactionType":"sync"} ``` ## Filter export data By default, the historic event export includes all events, which can result in very large files even when compressed. To reduce the file size, you can use query filtering based on the JSON format of the data. ### Build a query You can query on any value within the JSON object. Every query starts with interaction, which represents the JSON line itself. Use dot notation to access nested fields. For example, given this JSON line: ```json {"interactionType":"engagement","type":"category","content":"","variables":{"categoryid":"251"},"siteNumber":1001,"timestamp":1436434343609,"trackId":"322add73-3348-4c51-839d-139156a14f4c"} ``` You can filter using any of the following queries: ```json interaction.interactionType=="engagement" ``` ```json interaction.type == "category" ``` ```json interaction.variables.categoryid == "251" ``` ```json interaction.interactionType=="engagement" && timestamp > 1436434343600 ``` > [!NOTE] > Note: > > When using the `&&` (and) operator, the query matches fields within the same JSON line. To get information from separate events, use the `||` (or) operator instead. ### Query examples #### **Search by trackId** Returns all events for a specific track ID. ```json interaction.trackId=="049fbeab-b561-4cc5-971a-e44012b96fa6" ``` #### **Search by interaction type** Returns all `sessionStart`, `engagement`, and `conversion` events. ```json interaction.interactionType=="sessionStart" || interaction.interactionType=="engagement" || interaction.interactionType=="conversion" ``` #### **Search engagements by properties** Returns all `productView` engagements where the `tripCode` property equals `br_GIG-AMS`. ```json interaction.interactionType=="engagement" && interaction.type=="Product View" && interaction.variables.tripCode=="br_GIG-AMS" ``` #### **Search session starts by partial URL** Returns all `sessionStart` events where the URL property matches a specific regex pattern. ```json interaction.interactionType=="sessionStart" && interaction.url =~ ".*demoshop92.relay42-demo.com.*" ``` #### **Search for mapping content** Returns all `sync` events where the partner number is `2001` and the merge type is `NO_MERGE`. ```json interaction.interactionType=="sync" && interaction.partnerNumber == "2001" && interaction.mergeType == "NO_MERGE" ```