Anonymousprnt::Y
Find:

|


 
 
Click on images to see them in full screen

UA Reports

Once the Door Tablet Add-in starts to post hits to Google Universal Analytics (UA), reports can be generated in a variety of ways, using a variety of tools.

Built-in UA Reporting
The built-in reporting is both rich in functionality and easy to use.

Please note the following...

  1. Meeting starts and ends are posted as "events" hits. Starts and Ends would be identical in number (please ignore the discrepancy below as we started with ends only).
  2. End of Day (EOD) reports are posted as "pageviews" hits.

Sample events report...


When picking Custom Dimensions, use the letters "dt" to access the ones you defined


Reserved from report

Check how many meetings failed... (remember that every meeting has two events, so in the report below 11 meeting were aborted)

View where meetings take place (1 session = 1 meeting)


Report using other tools
Google UA offers additional rich tools at your disposal. Some of these tool will be embedded in the Door Tablet Web UI in order to provide instant access which will require no effort for end users.
You can access these tools from here https://ga-dev-tools.appspot.com/embed-api/

Example
The following demonstrates how you get the Resource Utilisation report in a matter of minutes.
This is what we are after... showing how much each resource is actually used, based on its time availability.

Follow the steps:
During the process of accessing the tools you will be asked to authenticate to Google and approve access to your Analytics Account and properties.
Open the above URL and click on Spreadsheet Add-on


Then...


The spreadsheet will appear, click on "New Report"

Fill in this form as follows:


You will now need to make a small addition to the report parameters. Add the two metrics exactly as shown below, using a comma to separate them...


You are now ready to run the report:


You are now able to manipulate the results, for example calculating the ratio between the used minutes and available minutes. Add a column between the resource names and the total available time, and insert the formula as shown:

Copy the formula for all the resources and you will now have a column that is ready to plot in a chart: