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.
Example: What are the most popular views?
Use the following steps to create a view that displays the most popular views on the site.
-
Connect to the TS Events data source.
-
From the Data pane, drag Item Name to the Rows shelf and Number of Events to the Columns shelf.
-
From the Data pane, drag Item Type to the Filters shelf, and select the View checkbox.
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 analyzing 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.
Folder | Field Name | Type | Description |
---|---|---|---|
Who Acted | Actor License Role | String | The license role for the user who initiated the event; one of Creator, Explorer or Viewer. |
Actor Site Role | String | The site role for the user who initiated the event | |
Actor User Id | Number | The user id of the user who initiated the event. | |
Actor User Name | String | The email address of the user who initiated the event | |
Target User Id | Number | The user ID of the user who was the target of the event. | |
What Was Acted Upon | Historical Item Name | String | The name of the Data Source or Workbook the event was performed against, at the time that the event was performed. |
Historical Item Repository Url | String |
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 Name | String | The name of the Project within which the event took place, as it was named at the time of the event. | |
Item Id | Number | The Id of the Data Source, Workbook or View the event was performed against. | |
Item LUID | String | The LUID of the data source, workbook, or view the events was performed against. | |
Item Type | String | If 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 Name | String |
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 Email | String |
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 Id | Number | The Id of the user who currently owns the View, Datasource or Workbook the event was performed against. | |
Item Repository Url | String |
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 Name | String | The current name of the Project the event took place in, if it was performed against content. | |
Site Luid | String | The Luid of the Site on which the event took place | |
Site Name | String | The name of the Site on which the event took place | |
Workbook Name | String | The name of the Workbook the event was performed against, at the time that the event was performed. | |
What Action Was Taken | Event Date | Date-time | The 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 Id | Number | Unique identifier for the event. | |
Event Name | String | The name of the specific event that occurred. | |
Event Type | String | Events are grouped together into action types, such as Create, Access, Update and Delete. | |
- | Admin Insights Published At | Date-time | Date and time the Admin Insights data source was last published in UTC |
Count of Distinct Actors | Calculated field | Measure representing the count of unique actors (users initiating the events). | |
Number of Events | Calculated field | Measure representing the total number of events |