---
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-03-19T08:11:30Z
published: 2026-03-19T08:11:30Z
---

> ## 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 `&amp;&amp;` (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"
```
