Overview

What are Export Views?

Export views are pre-joined, flat-table representations of your data. All related fields are denormalized into a single table — no JOINs required. Each row contains every relevant field for that record type.

Intended Use

• Ingest data into your own data warehouse (Snowflake, BigQuery, Redshift, etc.)

• Sync data to spreadsheets or flat-file pipelines

• Pull raw row-level data for custom analysis

How to Query

Get all fields:

SELECT * FROM export_lead;

Select specific columns:

SELECT id, source, first_name, last_name, created_at
FROM export_lead
WHERE created_at >= '2024-01-01'
ORDER BY created_at DESC
LIMIT 100;

Standard SQL WHERE, ORDER BY, and LIMIT clauses are supported.

Available Export Views

View	Description
export_lead	Leads with contact and lifecycle data
export_nps_response	NPS survey responses with entity names
export_nps_response_trend	NPS response-to-trend associations
export_user	Staff and provider user accounts

Tips

• Use LIMIT when exploring large datasets to keep query times fast.

• All timestamps are in UTC.

• Export views can be joined on shared columns when needed. For example, join export_nps_response_trend to export_nps_response on response_id.

• Use export_user to resolve owner_id values from other views.