AI Columns

No Code, AI powered Data Transformation.

Enrich, Enhance and Classify your data in seconds. Without 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.

Actionable Enrichment

Campaign Personalization

Deeper Segmentation

Actionable Enrichment

Customer insights delivered directly to your reps

Calculate a fit score, provide next best action recommendations, and share key talking points based on a user's engagement history. Sync it all directly to Salesforce to support your reps where they work.

Copy our engagement scoring prompt

Campaign Personalization

Deeper insights.
Faster activation.

Draft personalized email content, classify outbound responses with sentiment analysis tools, and calculate the most engaging follow up content for prospects. Sync it all directly to your outbounding and nurture platforms.

Enrich and classify customer profiles

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.

Get more segmentation prompts

play_arrow

Why leading companies trust Census for Data Transformation

for ops teams

Your favorite tools.
But better.

Take the friction out of tools like Saleforce, Braze, and Hubspot by prompting any data point you need and syncing it in real time.

Get more Braze prompts

for marketing and sales teams

Data at the speed of your campaigns

AI 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

Cut turnaround times for key data

Automatically analyze, summarize and surface the data your business users need --in the places where they work.

Try it on product data

pause


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


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


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