TS Events Data Source

TS Events functions as a primary audit data source. It contains data about the various events happening on your site, including sign-in, publishing and accessing views.

Create custom views

If you're a site admin or someone who has been granted access to the Admin Insights project, you can access the Admin Insights data sources directly from Tableau Cloud using Web Authoring or through Tableau Desktop to build custom views. For more information about connecting to Admin Insights data sources, see Use Admin Insights to Create Custom Views.

Use the following steps to create a view that displays the most popular views on the site.

  1. Connect to the TS Events data source.

  2. From the Data pane, drag Item Name to the Rows shelf and Number of Events to the Columns shelf.

  3. From the Data pane, drag Item Type to the Filters shelf, and tick the View box.

Do more with your data

Using Tableau Prep, you can join TS Events with other Admin Insights data sources on the following fields to get more visibility into your site. If you're analysing data from multiple Tableau Cloud sites, you must also join on "Site LUID = Site LUID".

  • Join TS Events to TS Users on "Actor User ID = User ID"

  • Join TS Events to Site Content on "Item ID = Item ID" and "Item Type = Item Type"

For more information, see Aggregate, Join or Union Data(Link opens in a new window) in Tableau Prep Help.

Data schema

The following table lists the fields included in the TS Events data source. Each row of data correlates with a single event that occurs on the Tableau Cloud site.

FolderField NameTypeDescription
Who ActedActor Licence RoleStringThe licence role for the user who initiated the event; one of Creator, Explorer or Viewer.
Actor Site RoleStringThe site role for the user who initiated the event
Actor User IDNumberThe user ID of the user who initiated the event.
Actor User NameStringThe email address of the user who initiated the event
Target User IDNumberThe user ID of the user who was the target of the event.
What Was Acted UponHistorical Item NameStringThe name of the Data Source or Workbook the event was performed against, at the time when the event was performed.
Historical Item Repository URLString

A unique, URL-style path to the Data Source, Workbook or View that the event was performed against.

This value preserves the historical path of an item during the time the event was performed.

Historical Project NameStringThe name of the project within which the event took place, as it was named at the time of the event.
Item IDNumberThe ID of the Data Source, Workbook or View the event was performed against.
Item LUIDStringThe LUID of the data source, workbook or view the event was performed against.
Item TypeStringIf the event was performed against content, the value is Data Source, Workbook or View. Item Type will be NULL if the event wasn’t performed against content.
Item NameString

Display name of the item included in the subscription.

The current name of the Data Source or Workbook the event was performed against.

Item Owner EmailString

Email address of the item owner.

The email of the user who currently owns the View, Datasource or Workbook the event was performed against.

Item Owner IDNumberThe ID of the user who currently owns the View, Datasource or Workbook the event was performed against.
Item Repository URLString

A unique, URL-style path to the Data Source, Workbook or View that the event was performed against.

This value describes the CURRENT path an item is available at. It will be NULL if the event was not performed against one of the three items listed above, or if the item has since been deleted.

Project NameStringThe current name of the Project the event took place in, if it was performed against content.
Site LUIDStringThe LUID of the site on which the event took place
Site NameStringThe name of the site on which the event took place
Workbook NameStringThe name of the Workbook the event was performed against, at the time when the event was performed.
What Action Was TakenEvent DateDate-timeThe date and time that the event in question took place, in UTC.
Event Date (local)Date-time

The date and time that the event in question took place, adjusted by the Timezone parameter you've set.

Note: For older data, a simple adjustment like this will not be accurate if your timezone uses Daylight Savings.

Event IDNumberUnique identifier for the event.
Event NameStringThe name of the specific event that occurred.
Event TypeStringEvents are grouped together into action types, such as Create, Access, Update and Delete.
-Admin Insights Published AtDate-timeDate and time the Admin Insights data source was last published in UTC
Count of Distinct ActorsCalculated fieldMeasure representing the count of unique actors (users initiating the events).
Number of EventsCalculated fieldMeasure representing the total number of events