Lookup Relations Tables

This page documents all lookup tables available in Content Reporting exports and how they relate to the Events table.

What you'll learn:

• All available lookup tables and their fields
• How to join tables using common identifiers
• Best practices for filtering and aggregating data
• How to handle timestamps, deleted records, and offline events

TL;DR

• Core tables: Events, Users, Assets, Shares, Devices
• Join using IDs: userId, assetId, shareId, deviceId, channelId
• Filter deleted: Check deletedAt field in lookup tables
• Timestamps: Use startedAt/endedAt for event time, loggedBefore/loggedAfter for sync time

Prerequisites

• Plan: Ultimate | Advanced or Expert
• Permissions: Administrator access to Showpad's Admin App
• Authentication: Valid OAuth 2.0 access token (learn more)

Quick Reference

Join Events with...	Using Field	Common Use Case
Users	userId	Get user names, roles, email addresses
Assets	assetId	Get asset names, types, Division info
Shares	shareId	Get share details, recipients, themes
Devices	deviceId	Get device type, app used, location
Channels	channelId	Get Experience names
Contacts	contactId	Get share recipient details
Sharedspaces	sharedSpaceId	Get Shared Space titles, participants

Important Considerations

See the Events API reference for all available parameters.

Lookup Tables

---

Next Steps

• Example Queries: SQL examples for common reporting scenarios