Exporting data with S3 logoExporting data with S3

Last updated Sep 17th, 2024

Overview

You can export contact, organization and activity data from Common Room into your data warehouse via our S3 integration. Once you've set up the S3 bucket using the instructions here, our team will work with you to finalize the data contract and set up a regular export.

Sample data contract

Activity Data

Field nameData typeDescription
activity_timestamp
datetime | null
Timestamp of the activity
service_name
string | null
Signal associated with the activity
activity_type
string | null 
Type of activity (e.g. slack_post_added)
emails
string | null
Comma separated list of emails for activity contact
first_seen_date
datetime | null
Date the contact
primary_email
string | null
Primary email for activity contact
profiles
string | null
Comma separated list of social profiles for activity contact
full_name
string | null
Full name for activity contact
city
string | null
City for activity contact
member_token
string | null
Contact identifier associated with activity

Contact Data

Field nameData typeDescription
full_name
string | null
Full name of contact
primary_email
string | null
Primary email of contact
profiles
string | null
Comma separated list of social profiles for contact
emails
string | null
Comma separated list of emails for contact
first_seen_date
datetime | null
Date contact was first seen in Common Room
last_seen_date
datetime | null
Date contact was last seen in Common Room
location
string | null
Location of contact (City, State, Country)
organizationName
string | null
Name of contact's organization
organizationDomain
string | null
Domain of contact's organization
job_title
string | null
Job title of contact
sentiment_all_time
float | null
All-time sentiment score for contact (0-100)
tags
string | null
Comma separated list of tags for contact
segment_names
string | null
Comma separated list of segments contact is a part of
first_seen_source
string | null
Signal that contact was first seen in
impact_points_all_time
int | null
All-time impact points for contact
impact_points
int | null
Impact points for contact (over agreed upon time range)
sentiment
float | null
Sentiment for contact (0-100 value over agreed upon time range)
stat_<source>_<source_name>_<type>
float | null
An entry for each of the statistics. 
source - Channel source e.g. Slack, Discourse, Github, …
source_name - Name of the source
type - type of activity statistic - e.g. replies
member_tokens
string | null
Comma separated list of tokens representing the Contact
<custom_fields>
Dependent on custom field type
An entry for each of the custom fields on the community Contact

Organization Data

Field nameData typeDescription
organization_name
string | null
Name of organization
domain
string | null
Domain of organization
location
string | null
Location of organization (City, State, Country)
member_count
int | null
Total number of Common Room contacts associated with organization
employee_count
int | null
Estimated employee count of organization
approx_capital_raised
float | null
Estimated capital raised by organization
approx_revenue_min
float | null
Estimated minimum revenue for organization
approx_revenue_max
float | null
Estimated maximum revenue for organization
first_seen_date
datetime | null
First date the organization was seen in Common Room
last_seen_date
datetime | null
First date the organization was seen in Common Room
first_seen_source
string | null
First signal the organization was seen in Common Room
impact_points_all_time
int | null
All-time impact points for organization
sentiment_all_time
float | null
All-time sentiment score for organization (0-100)
impact_points
int | null
Impact points for organization (over agreed upon time range)
sentiment
float | null
Sentiment for organization (over agreed upon time range)
<custom fields>
Dependent on custom field type
An entry for each of the custom fields on the Organization

Details

  • The folder name will be in the following format: data-export/Activity/YYYY/MM/DD/
  • File formats will be in JSONL
  • Marker file name is: _completionmarker_
  • Common Room custom fields map to the following data types, each of which can be nullable.
    • Yes/No - boolean
    • Date - datetime
    • Number - int
    • Single-select - string
    • Multi-select - string
    • Text - string
    • URL - string
  • For customer-provided data (e.g. data that is coming in via your CRM, Census, etc.), we will preserve the formatting of the original data signal so please ensure that you have the proper handling on your end when mapping the data.
  • If you choose to receive data as a CSV instead of a JSONL format, null values will be transmitted as empty strings.

Didn't find your answer?Get in touch· Visit ourhelp center