GPT Columns

No Code, AI powered Data Transformation.

Enrich, Enhance and Classify your data in seconds — no more regex, formula fields, or workarounds.

Try now

Get a demo

4.8 on G2.com

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

Improve Operations

Clean and Calculate

enrich and enhance

Stop waiting on the data you need

See it in action

Improve Operations

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.

See our prompt library

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.

Get started for free

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.

Get started for free

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.

Get started for free

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