No Code, AI powered Data Transformation.
Enrich, Enhance and Classify your data in seconds — no more regex, formula fields, or workarounds.
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.
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.
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.
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.
Why leading companies trust Census for Data Transformation
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.
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.
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.
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.
Label companies by business model
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
Sort and prioritize reviews by sentiment
For the following name field, return the name with
special characters and numeric digits removed
Name Field: {{ record[‘CUSTOMER_NAME’]}}
Remove Special Characters Without Regex
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]
Add Industry data to account records
Census is a big part of how we drive net new business and greatly reduce costs using data.
200+ integrations. And more added daily.
Automate. Enrich. Activate.
Your data is yours. Use it. Everywhere.