Start free

Common Room connector · Community signal reports

Read & reportRead-only source

Spot who just got active, and who has gone quiet.

Bring Common Room contacts and segments into your reports and AI assistants: each contact’s company, title, country, activity in the last 28 days and all time, and how many records each segment holds.

  • Find people whose activity jumped in the last 28 days
  • Track segment size from one refresh to the next
  • Ask ChatGPT or Claude which warm contacts to hand to sales
Common RoomSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

Common Room reportSample data
Full nameCompanyActivities, last 28 days
Maya ChenBrightwell23
Jonas WeberLarkspur2
Ama OwusuTallgrass11
Refreshes on your schedule in Google Sheets

Common Room reporting for one community

One Common Room community is the data source. Reports show contacts and segments as they are now.

Contacts

Read each contact’s name, primary email, job title, company, country and segments.

Activity

Compare activities in the last 28 days with all-time activities to see who is warming up or going quiet.

Segments

List segments with record type, how many records they hold and whether their automation is running.

Hand-offs

Filter warm contacts by segment, company and title, then join them to your CRM on email.

Report datasets and details

Reports you can build

2 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Segments
  • Contacts
What each dataset reports
  • Segments

    Every Common Room segment with its ID, name, the kind of records it holds, how many records are in it, and whether its rule-based updates are running or paused.

  • Contacts

    Every contact in your Common Room workspace with name, primary email, job title, company, country, activity counts for the last 28 days and all time, and the segments they belong to.

Metrics and dimensions

14 report fields across 2 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Common Room data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect Common Room to ChatGPT or Claude for community questions

Use Datapipe’s MCP access as your Common Room reporting tool. Ask about active contacts, quiet members and segments.

Example

Which contacts did more than half of their all-time activity in the last 28 days?

List contacts whose activities in the last 28 days are more than half their all-time activities, with company, title and segments, sorted by recent activity.

Start with Common Room

What you need

A Common Room API token created by an admin under Settings, API tokens.

What to know

Read-only. Reports show current contacts and segments; report dates don’t filter them. Up to 20,000 rows per report.

How it works

  1. Create your free account, then choose Common Room in Data sources.

  2. Paste your Common Room token.

  3. Choose contacts or segments and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with Common Room

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Contacts with company, title, country, segments and activity counts, and segments with record type, size and automation status.

No. It only reads contacts and segments.

Each contact shows activity for the last 28 days and all time. Refresh on a schedule to track change.

A Common Room admin, under Settings, API tokens.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each Common Room account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Turn community signals into conversations.

Start free, add Common Room and bring contacts and segments into the tools you already use.

Start free See setup requirements