Reading the Analytics Export
How to download your event's raw analytics as a CSV file, what each column means, and how to turn it into reports in Excel or Google Sheets.
The Analytics dashboard answers the common questions for you. When you need something it does not show, such as a custom report for a sponsor, activity per hour of a specific day, or a comparison between two events, download the analytics export: every interaction recorded for your event, one row per action, as a single CSV file.
Downloading the Export
- Open your event in the Management Console.
- In the menu, choose Export, just below Analytics.
- Next to ANALYTICS DATA, click EXPORT and confirm.
The console collects every recorded action and shows its progress while it builds the file. Large events can take a minute. The file downloads as AnalyticsExport-Everything_<date>_<time>.csv.
The export always contains the whole event, from the first recorded action to now. The date range you pick on the dashboard does not apply to it; filter by date in your spreadsheet instead (see Working with time).
Opening the File
The file is UTF-8 with commas between columns. Names with accents or non-Latin characters come through intact.
- Google Sheets: File > Import > Upload, and keep the default separator detection.
- Excel: use Data > From Text/CSV rather than double-clicking the file. On computers set to a European region (Dutch, German, French and others), Excel expects semicolons, and a double-clicked file lands entirely in column A. The import dialog lets you pick Comma as the delimiter.
- Numbers, LibreOffice and data tools (Power BI, Tableau, Python, R) read it directly.
Turn the first row into a header and turn on filters before you start: almost every question below begins with filtering two columns.
What a Row Means
Each row is one thing one person did once: opened a session, tapped a sponsor, sent a chat message, voted on a question. Nothing is pre-counted. Ten views of the same session by the same person are ten rows, which is why you will usually count rows and count distinct users separately (see Totals versus unique people).
Rows come from the attendee app and from the guest portal. Everyone signed in is recorded, including your own staff and moderators, so expect your team’s testing and floor work in the numbers. If you need attendee-only figures, filter out your team’s User IDs (the easiest way to find them is to open a few pages yourself just before exporting and look for your own rows at the bottom of the time range).
The Columns
| Column | Example | What it means |
|---|---|---|
| User ID | pX3k9QmL2v... |
An anonymous account identifier for the person who did it. The same person has the same User ID throughout the event, and in every other event in the same app. It is not their email and no other export contains it, so it identifies a person without telling you who. |
| Action | view |
What they did. See Actions below. |
| Target ID | kV8sF0aQ... |
The internal id of the thing acted on: a session, speaker, sponsor, chat room and so on. Stable even if the item is renamed later. Empty for page views and for a few portal actions. |
| Target Type | session |
What kind of thing was acted on. See Target types below. |
| Target Name | Opening Keynote |
A readable name for the target as it was at the time of the action. If you renamed a session mid-event, its earlier rows carry the old name. For pages, this is the page name (Schedule, Speakers, Portal Home…). |
| Timestamp | 1789203600 |
When it happened, as a Unix time in seconds. Handy for calculations. |
| Time (UTC) | 2026-09-12T08:20:00.000Z |
The same moment as readable date and time, in UTC, not your event’s local time. |
| Impression Count | 14 |
Only used on impression rows: how many times that sponsor’s banner was shown. 0 on every other row. |
| Parent ID | kV8sF0aQ... |
For an action on something that lives inside something else, the id of that container: the session a Q&A question belongs to, or the chat a message was sent in. Empty otherwise. |
| Parent Type | session |
What kind of thing the Parent ID is (session, chatRoom, …). Empty when there is no parent. |
Target Types
| Target Type | What it is |
|---|---|
page |
A screen in the app or portal. Target Name is the screen (Schedule, Speakers, Sponsors, Feed, Guests, Map, Event Home, Portal Home, …). |
session |
A session in your programme. |
speaker |
A speaker profile. |
sponsor |
A sponsor: logo, banner or sponsor page. |
question |
A Q&A question inside a session. |
chatRoom |
A chat conversation, direct or support. |
message |
A chat message being sent. |
meeting |
A meeting request between attendees. |
contact |
Another guest, from the guest list. |
lead |
A lead scanned with the lead scanner. |
vcard |
The person’s own digital business card. |
map |
A venue map. |
abstract |
A scientific abstract or e-poster. |
post |
A feed post (only reports are recorded here; likes and comments are counted on the post itself). |
Actions
The same action word means slightly different things depending on the target. The combinations you will use most:
| Action | On | Means |
|---|---|---|
view |
page |
Opened a screen. Your best measure of which features people use. |
view |
session, speaker, sponsor, abstract |
Opened that item’s detail page. |
subscribe / unsubscribe |
session |
Added the session to, or removed it from, their personal schedule. |
handout |
session |
Tapped a session’s Handout, Q&A or Poll button (Target Name tells you which). |
handout |
abstract |
Downloaded an e-poster. |
click |
sponsor |
Tapped a sponsor logo or banner, or a sponsor’s link. The number sponsors usually ask for. |
click |
page, session, speaker |
Tapped a specific button. Target Name is the button (Show Yourself, LinkedIn, Speaker On Site, E-Poster Fullscreen…). |
vote / unvote |
question |
Upvoted a Q&A question, or took the upvote back. |
answer, approve, reject (and their un... reversals) |
question |
Moderation of Q&A by your staff. |
create |
message |
Sent a chat message. |
create |
meeting, vcard |
Sent a meeting request, or created a digital business card. |
accept / decline / tentative / suggest |
meeting |
Responded to a meeting request, or proposed another time. |
scan |
lead |
Scanned a lead. |
edit / remove |
lead, meeting, vcard |
Changed or deleted one. |
block / unblock / report |
chatRoom |
Blocked or reported someone in a chat. On a report, Target Name is the reason they picked. |
report |
post |
Flagged a feed post. Target Name is the reason they picked. |
impression |
sponsor |
The sponsor’s banner was shown on screen. Impression Count says how many times (see below). |
impression row can stand for many displays: add up Impression Count for the number of times a banner was seen, and count distinct User IDs for how many people saw it. The time on the row is when the batch was sent, up to five minutes after the displays it covers.
Totals versus Unique People
Most questions have two answers, and it is worth reporting both:
- Total actions: count the rows. “The keynote was opened 1,240 times.”
- Unique people: count the distinct User IDs. “412 people opened the keynote.”
A big gap between the two means a smaller group came back again and again, which is often a good sign for a session or sponsor.
In Google Sheets, =COUNTUNIQUE(...) over the User ID column of a filtered range gives you unique people. In Excel, insert a PivotTable and tick Add this data to the Data Model in the dialog; the value field can then be set to Distinct Count.
Working with Time
The Time (UTC) column is in UTC. To get your event’s local time, convert the Timestamp column instead, which every spreadsheet can do arithmetic on. Put this in an empty column (row 2 shown, Timestamp in column F):
=F2/86400 + DATE(1970,1,1) + 2/24
Format the column as date and time. The + 2/24 adds two hours: use your own offset from UTC on the event days (+ 1/24 for Amsterdam in winter, + 2/24 in summer, - 4/24 for New York in summer). Add =INT(G2) for just the date, or =HOUR(G2) for the hour of the day, and you can pivot by either.
Recipes
Each of these is a filter on two columns plus a PivotTable (Excel) or pivot table (Google Sheets).
Most popular sessions
Filter Target Type session and Action view. Pivot with Target Name as rows and both a count of rows and a distinct count of User ID as values. Sort descending.
Sessions people planned to attend
Same, with Action subscribe. Subtract the unsubscribe rows per session for the net number. Compare with the view counts: a session many people looked at but few added may have had a confusing title or clashed with something bigger.
A sponsor report
Filter Target Type sponsor, then Target Name your sponsor. Sum Impression Count on the impression rows (banner displays), count the click rows (and distinct users who clicked) and count the view rows (opened the sponsor’s page). Clicks divided by impressions is the click-through rate. Delete the User ID column before you send anything to a sponsor.
Q&A participation per session
Filter Target Type question and Action vote. The Target Name is the question; the Parent ID is the session it was asked in. Pivot by Parent ID with a distinct count of User ID to see how many people took part in each session’s Q&A, then match the ids to session names from the session rows, which carry both.
When people were active Add the local time and hour columns from above. Pivot with the date as rows, the hour as columns, and a distinct count of User ID as values. Colour the table with conditional formatting for an instant heat map of the event days. Quiet hours during the programme are worth a look.
Which features people used
Filter Target Type page and Action view. Pivot by Target Name with a distinct count of User ID. This shows how many attendees ever opened the Feed, Map, Guests list or Speakers page, which helps you decide what to promote, rename or drop from the menu next time (see Menu customization).
Speaker reach for a speaker’s own report
Filter Target Type speaker, Action view, Target Name the speaker. Add the views of their sessions from the sessions recipe.
Networking activity
Count create rows on message (messages sent), create rows on meeting (meeting requests), and scan rows on lead (leads scanned), per day.
Comparing events Export each event, add a column with the event name to each, and paste them below one another. Every recipe above then works with the event name as an extra pivot column.
Other Exports on the Same Page
The Export page also offers Review Data (session and speaker feedback), Attendance Data (who registered for and attended each session), Ticket Data (tickets with check-in status), User Data (your guest list) and Feed Images. These hold names and email addresses; the analytics export deliberately does not, and none of them contains a User ID, so the analytics stay unlinked from your guest list.