---
title: "Tables: asset interaction"
description: "Lists the Reporting API tables that hold the interactions sales reps, external recipients, and admins have with assets in Asset Hub, with their update frequency and download links."
contentType: "reference"
url: "https://developer.mindtickle.com/docs/reporting/tables-asset-interaction/"
---

## Prerequisites

1. [FAQ](/docs/reporting/faq/#how-do-i-enable-reporting-api-access-for-a-user): Your email address must be enabled for Reporting API access.

These tables provide data about any interactions that sales reps, external recipients, or admins have with assets in Asset Hub. Sample links request up to 10 results. Full-data links omit that sample limit but remain subject to [data limits and pagination requirements](/docs/reporting/best-practices/#data-limits). For the attributes in each table, see the [Reporting API metadata sheet](https://docs.google.com/spreadsheets/d/1mghEtkASz0OO9YUE2lJjjMfnZ4ilsGrmyFXqNpkM-Qo/edit#gid=0).

## Sales rep interactions

| Table name | Update frequency | Description | Downloads |
| --- | --- | --- | --- |
| `UserAssetDayWiseEngagement` \*\* | Every 6 hours | Contains daily sales rep engagement information for an asset in Asset Hub. Granularity: `UserId x AssetId x Date`. | [Sample data](https://admin.mindtickle.com/Odata.svc/UserAssetDayWiseEngagement?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/UserAssetDayWiseEngagement?$format=csv) |
| `UserAssetFeedback` \*\* | Every 6 hours | Contains data on asset feedback, comments and ratings, given by your users across assets. Granularity: `UserId x AssetId x CommentId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/UserAssetFeedback?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/UserAssetFeedback?$format=csv) |

## External recipient interactions

| Table name | Update frequency | Description | Downloads |
| --- | --- | --- | --- |
| `ExternalAssetInteraction` \*\* | Every 6 hours | Contains data about the interactions created for the external recipients for shared assets. Granularity: `InteractionId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/ExternalAssetInteraction?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/ExternalAssetInteraction?$format=csv) |
| `InteractionAssetMapping` \*\* | Every 6 hours | Contains data about all the externally shared assets linked to an interaction. Granularity: `InteractionId x AssetId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/InteractionAssetMapping?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/InteractionAssetMapping?$format=csv) |
| `ExternalContact` \*\* | Every 6 hours | Contains data about the external recipients for shared assets. Granularity: `ContactId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/ExternalContact?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/ExternalContact?$format=csv) |
| `SessionContactInfo` \*\* | Every 6 hours | Contains data about the sessions created against the interactions. Granularity: `SessionId x ContactId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/SessionContactInfo?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/SessionContactInfo?$format=csv) |
| `SessionAssetActivityInfo` \*\* | Every 6 hours | Contains data about all engagement garnered by the shared assets in terms of views, downloads, and time spent. Granularity: `InteractionId x SessionId x AssetId`. | [Sample data](https://admin.mindtickle.com/Odata.svc/SessionAssetActivityInfo?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/SessionAssetActivityInfo?$format=csv) |

## Admin interactions

| Table name | Update frequency | Description | Downloads |
| --- | --- | --- | --- |
| `AdminAssetEvents` \*\* | Every 6 hours | Contains information on updates made by admins to an asset in Asset Hub. Granularity: `AssetId x AssetVersion x UpdateType`. | [Sample data](https://admin.mindtickle.com/Odata.svc/AdminAssetEvents?$format=csv&$top=10), [full data](https://admin.mindtickle.com/Odata.svc/AdminAssetEvents?$format=csv) |

## Notes

- **Asterisk (\*):** For an update frequency marked with an asterisk, it may take up to 24 hours for data updates to appear.
- **Double asterisk (\*\*):** Tables marked with a double asterisk are not enabled by default. Contact [Mindtickle Support](mailto:support@mindtickle.com) to enable a particular table for your learning site. The rest of the tables are enabled by default.
- **Download links:** Sample links request up to 10 results. Full-data links remain subject to the table's data limits; use [pagination](/docs/reporting/pagination/) for larger exports.
- **Timestamps:** For fields with a timestamp (date and time) across the Reporting API tables, the value is in the GMT time zone.
- **Service root URL:** The Reporting API has two [service root URLs](/docs/reporting/use-odata/#url-components) to query and extract data. The download links on this page reference the default URL. Ensure that you are using the correct, applicable URL.

## Related

- [Use OData](/docs/reporting/use-odata/): How to build the query URL for these tables.
- [Tables: object metadata](/docs/reporting/tables-object-metadata/): Asset, hub, and attribute metadata these tables reference.
- [Best practices](/docs/reporting/best-practices/): Query URL guidelines and data limits.