Play Button

Stop waiting on the data you need

Add industry data to account records in Salesforce, classify contacts by persona, or calculate custom discounts based on LTV. Census GPT columns can do it all in seconds—without a single line of code.

enrich and enhance

Stop waiting on the data you need

Add industry data to account records in Salesforce, classify contacts by persona, or calculate custom discounts based on LTV. Census GPT columns can do it all in seconds—without a single line of code.

Operationalize ai

Deeper insights.
Faster activation.

Automatically classify records by sentiment of interactions, sales territory, or business model. Pipe insights directly to your apps to power outbounding and reporting. 

clean and calculate

Never Regex again

Remove special characters or misaligned case formats from data with the click of a button. Create rollup calculations in seconds to ensure that the data you need is always ready to sync.

Enrich and Enhance
Operationalize AI
clean and calculate
Why leading companies trust Census for Data Transformation
Teams
for ops teams
Your favorite tools.
But better.

Census take the friction out of tools like Saleforce, Braze, Marketo and Hubspot by writing data transformations directly back to your source of truth.

Data
for marketing and sales teams
Data at the speed of your campaigns

Computed columns take your wait times from months to minutes so you can launch with the data you need—painlessly.

Marketing
for data teams
No more misalignment

 Computed columns bring transformation work under your oversight with no-code tools for writing data directly back to the warehouse.

pause

For the following company, return a single value
indicating whether the company is B2B, B2C, or BOTH
based on the company name.
COMPANY_NAME: {{ record[‘COMPANY_NAME’]}}.

The output is a single value and you will give no 
explanation.


Classify and Categorize

Label companies by business model

Copy this prompt

Your role is to determine the sentiment of a
response to a request for a demo.

1. Review the emails in {{record['RESPONSE']}}.
Based on the text, determine the sentiment of its 
author.

2. Based on the sentiment of the response, 
categorize the response as either:
Interested
Not interested
Enthusiastic
Snarky or Annoyed


Analyze and Summarize

Sort and prioritize reviews by sentiment

Copy this prompt

For the following name field, return the name with
special characters and numeric digits removed
Name Field: {{ record[‘CUSTOMER_NAME’]}}


Clean Records

Remove Special Characters Without Regex

Copy this prompt

You are tasked with determining the industry classification for a given company based on publicly available information. The industry classification should match the Securities and Exchange Commission's (SEC) list of official standard industrial classifications (SIC).
You will be given a company name: {{record['COMPANY']}}

Your task is to:
1. Research the company using publicly available information. This may include the company's official website, SEC filings, financial reports, and reputable business news sources.
2. Based on the information you find, determine the most appropriate industry classification for the company according to the SEC's standard industrial classification (SIC) system. The SIC is a four-digit code that categorizes companies based on their primary business activities.
3. Provide your answer in the following format:
[Insert the corresponding industry name here]([Insert the following SIC code here]


Enrich and Enhance

Add Industry data to account records

Copy this prompt
Marc Stone
Marc Stone VP of Data and Growth
ClickUp

Census is a big part of how we drive net new business and greatly reduce costs using data.

200+ integrations. And more added daily.

Acoustic Marketing Cloud
Acoustic Marketing Cloud
ADP
ADP
AdRoll
AdRoll
Amazon Ads
Amazon Ads
Amazon EventBridge
Amazon EventBridge
Amazon Kinesis
Amazon Kinesis
Amazon SQS
Amazon SQS
Amobee
Amobee

Automate. Enrich. Activate.

Your data is yours. Use it. Everywhere.