Overview:

Unity Analytics events contain a payload of parameters that describe the player's gameplay. They are used by Analysts to build reports and gather insights that can be used in LiveOps campaigns, to improve the game's engagement, monetization etc.

It is important to therefore understand what events and parameters are being recorded. 

Contents:

This article contains guidance on three distinct methods for viewing a glossary of Unity Analytics parameters recorded by a game.  

1. The Event Manager contains a list of standard and custom events that can be viewed to see what parameters are assigned.
2. The Parameter Manager contains a list of all defined parameters regardless of whether they are assigned to an event.
3. The SQL Data Explorer can be used to view the names and values of individual parameters or to run a query to view all parameters sent during a specific period.

Procedure:

Event Manager 

The event manager contains the definition of each analytics event that is configured for the game environment.

1. Navigate to the Unity Analytics dashboard and select the Event Manager tool to view a list of all standard and custom events that have been defined. 
2. Click on one of the events displayed in the 'Events' section of the page to view the list of parameters that have been assigned to the event. You can see the name, description and type of each parameter as well as whether it is required or optional to include it, to pass event validation. Additional parameters can be assigned to the event on this page. 
   

Parameter Manager

The parameter manager contains the definition of each parameter that is configured for the game.

1. Navigate to the Unity Analytics dashboard and select the Event Manager tool to view a list of all standard and custom events that have been defined. 
2. Click on the 'Parameters' tab to view a list of all the parameters that have been defined for the game.
   
3. Click on one of the individual parameters to see the name, description, type and any formatting rules for the parameter. 
   

SQL Data Explorer

The main purpose of the SQL Data Explorer is to build reports and analyse data collected from the game. But it can also be used to view a glossary or aggregated summary of the parameters recorded during a specified period.

1. Navigate to the Unity Analytics dashboard and select the SQL Data Explorer tool. It will show a default SQL Query.
   
   
2. Click on the 'Glossary' button above the SQL query panel to reveal a list of the data tables that can be queried, then click on the 'Events' table entry to reveal the columns in the events table.
   Note, that some additional parameters are injected into events to enrich them, during the ingestion and validation phase. These parameters are not visible in the glossary.
   
   
   
3. Enter the following SQL Query and Run it, to view the name, type and aggregated contents of parameters sent in events within the last 7 days.

   SELECT REGEXP_REPLACE(f.path, '\\[[0-9]+\\]', '[]') AS "Paramater",
     TYPEOF(f.value) AS "Type",
     COUNT(*) AS "Count",
     MIN(f.value) as "Min Value",
     MAX(f.value) as "Max Value",
     COUNT(DISTINCT f.value) as "Distinct Values"
   FROM events,
     LATERAL FLATTEN(event_json, RECURSIVE=>true) f
   WHERE event_date >= CURRENT_DATE - 7
   GROUP BY 1, 2 
   ORDER BY 1, 2;