# 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

{% tabs %}
{% tab title="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
  {% endtab %}

{% tab title="CRM / Sales ops" %}

* Export Contacts and Company contacts to analyze your contact database and company relationships
* Join Companies with Company contacts and Contacts to build a full account-level view
* Send data to BigQuery for longer-term CRM trend analysis across quarters
  {% endtab %}

{% tab title="Operations" %}

* Use Teams data to understand organizational structure and align event ownership
* Pull custom field definitions (Event fields, Contact fields, Company fields) to audit your data model before migrations or audits
* Append data from multiple Circa accounts into a single destination using Coupler.io's Append transformation
  {% endtab %}
  {% endtabs %}

## 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