Data Overview

Circa gives you access to event management and CRM data including events, contacts, companies, teams, and the relationships that connect them. You can also pull custom field definitions to understand how your data is structured.

Available entities

Entity	What it contains
Events	Event records with details like name, dates, status, and type
Contacts	Individual people with contact info and profile data
Teams	Organizational team records
Companies	Company records with organizational details
Company contacts	Junction data linking contacts to companies
Event contacts	Junction data linking contacts to specific events
Event fields	Custom field schema for the Events entity
Contact fields	Custom field schema for the Contacts entity
Company fields	Custom field schema for the Companies entity

Metrics and dimensions

Events

Field	Type	Description
id	Dimension	Unique event identifier
name	Dimension	Event name
status	Dimension	Current event status (e.g., planned, completed)
start_date	Dimension	Event start date
end_date	Dimension	Event end date
type	Dimension	Category or type of event
created_at	Dimension	When the event record was created
updated_at	Dimension	When the event record was last updated

Contacts

Field	Type	Description
id	Dimension	Unique contact identifier
first_name	Dimension	Contact's first name
last_name	Dimension	Contact's last name
email	Dimension	Contact's email address
phone	Dimension	Contact's phone number
created_at	Dimension	When the contact was created
updated_at	Dimension	When the contact record was last updated

Companies

Field	Type	Description
id	Dimension	Unique company identifier
name	Dimension	Company name
created_at	Dimension	When the company record was created
updated_at	Dimension	When the company record was last updated

Teams

Field	Type	Description
id	Dimension	Unique team identifier
name	Dimension	Team name
created_at	Dimension	When the team was created

Relationship entities (Company contacts, Event contacts)

Field	Type	Description
id	Dimension	Relationship record ID
contact_id	Dimension	ID of the linked contact
company_id / event_id	Dimension	ID of the linked company or event
created_at	Dimension	When the relationship was created

Custom field definitions (Event fields, Contact fields, Company fields)

Field	Type	Description
id	Dimension	Field identifier
name	Dimension	Field name/label
field_type	Dimension	Data type of the custom field
required	Dimension	Whether the field is required

Common metric combinations

• Events + Event contacts + Contacts — Join all three to see a full attendee list per event with contact details

• Companies + Company contacts + Contacts — Build a company-level contact directory with relationship context

• Events + Event fields — Understand which custom data points are being tracked across events

• Contacts + Contact fields — Audit your contact data model and field usage

Use cases by role

Event managers

• Pull Events and Event contacts to track attendance and participation across all events

• Join Events with Contacts to build per-event attendee reports in Google Sheets or Looker Studio

• Use the Aggregate transformation to count contacts per event and identify your highest-attended events

CRM / Sales ops

Operations

Platform-specific notes

• Custom fields defined in Circa appear in the Event fields, Contact fields, and Company fields entities — the actual values for those fields will appear in the Events, Contacts, and Companies entities respectively

• The start_date parameter controls how far back historical data is pulled — set this carefully to avoid pulling more data than needed

• Relationship entities (Event contacts, Company contacts) only contain IDs — you'll need to join them with the Contacts, Events, or Companies entities to get human-readable data

• Circa is built for event-centric CRM workflows, so Events is typically the anchor entity for most reporting use cases