How To Use Analytics Tables on Grip as an Event Organiser

Analytics tables can be used in a variety of ways, in this article we'll cover the most common actions that you can take with them.

Please note: Analytics tables are distinct from our new insights reports, Grip Pulse.

Analytics tables are extremely powerful and can be used to:

• Take an in-depth look at data within your event
• Create custom views in order to look at specific data
• Download custom data exports 
• Use tools to drill down into a specific data set
• Create graphs directly from the dashboard that can be downloaded

In this article we will cover:

Adding And Removing Columns
Re-ordering Columns
Sorting Columns
Filtering
Creating Pivot Tables
Exporting data

Analytics Data tables

Adding And Removing Columns

The new feature allows you add or remove columns to allow you to see the exact data you want to see without needing to download it and manually reorder and delete columns.

On the right hand side of the table is a popout menu that shows a list of all available columns. To see this you must have the 'Columns' tab selected and open, if you cannot see the area in the green rectangle on the image above, simply click the 'columns' tab again. 

All of the columns that are currently displayed will have the boxes beside their name ticked, to add an additional column simply find the name of the column you would like to add, either by scrolling through the list or using the search function in this section. 

Once a column has been added it will be added to the group in which it exists, for instance in the above example if I were to add 'Meeting Comment' this would be added in the 'Meeting Info' section of the table. 

You can remove columns from the table by simply unticking them from the box on the right. You can also remove entire sections by unselecting them in this box too. 

Re-ordering Columns

You can reorder columns within the table to either display data in a way that is most logical for you, order it in a specific way ahead of export, or to help with analysis. 

To reorder a column hover over a column header until you see this reorder icon:

From here you can simply click and hold the header and drag it to where you want it to sit on the table.

If you move the column to a different section, it will create a label of the section it is part of above it, to avoid confusion:

In the example above, I have moved Meeting ID into the 'Meeting Times' section; it still has the 'Meeting Info' label above it. 

Sorting Columns

In order to sort the table based on a column, simply click on the column header. 

On first click, the column header will display the up arrow and sort the column from smallest to largest for numbers, A-Z for words, and earliest to latest for dates. 

On second click, the column header will display the down arrow and sort the column from largest to smallest for numbers, Z-A for works, and latest to earliest for dates. 

Filtering

There are two ways of filtering on the table: 

Using the column headers

Simply hover over a column header until you see this icon:

Simply click the icon and the the filtering menu will appear:

From here just choose from the options in the dropdown that best describes what you want to filter against: 

• Contains - The data contains the value entered
• Not Contains - The data does not contain the value entered
• Equals - The data exactly matches the value entered
• Not Equal - The data does not match the value entered
• Starts With - The data begins with the value entered
• Ends With - The data ends with the value entered

You can choose two filters per column which can be added as either: 

• AND - The data shown will match both filter values simultaneously
• OR - The data displayed will match one or both filter values

Using The Filters Tab

In addition to filtering using the column headers within the table, you can filter using the filters tab on the right hand side of the table. 

This offers the same functionality as using the column header to filter, but also allows you to create filters for the table against columns that are not in the table. 

Copy and paste data directly from the data view

You can copy and paste data directly from the data table and insert this into a spreadsheet. Simply, drag over the data you want to copy, click copy (ctrl c) and paste into a spreadsheet (ctrl v).

Creating Pivot Tables

In order to create a pivot table, you must select the 'pivot mode' in the right hand box.

From there select the values you want to display in your pivot table from the columns list. 

Select the row groups by dragging the desired columns to the 'Row Groups' section and choose the values that you want to add to the pivot table by dragging the values you want to display to the 'Values' section.

Exporting data

The key thing to remember about exporting data from the Analytics Library is that it will export the current view you have set within the table - so whatever columns, filters, ordering etc you have set in the table is how the export will appear.

You can also click 'Export all Columns' where you can choose to download as a CSV, or Excel file with all available data.

Analytics Data tables

Stream Views

At Grip, we measure and track the engagement of users that engage with embedded sessions on Grip.

Stream views key definitions:

The three sources:

• Main Stage.
• Session Page.
• Home Page (when a session is promoted).

Registered Sessions

Registered Sessions export will showcase the event participants who have added sessions to their schedule along with the additional information about the participant such as data type, custom profile values.

Event Program

Event Program export will include all data relating to the sessions that have been configured for an event. This will include but not be limited to Session Name, Session Description, Start Time, End Time, Is Session Mandatory, Session Time Blocking and much more.