Salesforce has long been a leader in CRM, helping businesses manage customer relationships and streamline operations. But the real magic happens when Salesforce becomes a hub for enriched, actionable data. By connecting your data warehouse to Salesforce with Census, you can supercharge your CRM workflows with AI-powered insights. With GPT Columns, you can go a step further, using AI to create dynamic, context-aware outputs directly within Salesforce.
Below are some use cases and GPT column prompts designed to make Salesforce an even more powerful tool for your teams. The field names are represented in Census’s Liquid Template format for ease of use, and the prompts should be customized to fit your specific data model. Census allows you to easily model your customer data as Datasets, ready for activation.
1. AI for RevOps: How to Automate Fit Scoring in Salesforce
Building an Ideal Customer Profile (ICP) analysis and account scoring system can be a daunting task for RevOps teams, often involving extensive data analysis and consensus-building among sales leaders. However, with Census's GPT Columns feature, this process can be streamlined significantly.
Step 1: Set Up Your ICP Analysis
Begin by creating an ICP analysis in Census that consolidates customer traits, success metrics, and account data. This analysis will help identify attributes that predict high-value outcomes for your business.
- Define Key Attributes: Determine characteristics meaningful for your ICP, such as high lifetime value (LTV), short sales cycles, industry fit, or specific investor backing.
- Create a JSON Array: Aggregate this data into a JSON format, capturing all relevant information in a single field per customer.
This ICP analysis serves as the benchmark against which new accounts will be scored.
Step 2: Write Your Fit Score or ICP Analysis GPT Prompt
With your ICP analysis ready, craft a GPT prompt to evaluate each account's fit score based on your criteria.
- Customize Success Indicators: Include attributes that align with your ICP, like revenue thresholds, employee count, or specific technologies, and assign weights based on their correlation with success.
- Generate a Fit Score: Establish a scoring system (e.g., 0-10) with explanations for each score to ensure transparency for the sales team.
Using { {record['CUSTOMER_TRAITS'] } }, perform an Ideal Customer Profile (ICP) analysis using regression. List positive and negative traits with their correlation strengths (strong, moderate, weak), noting data gaps without assuming negatives. Identify valuable traits exclusively based on regression analysis, with category weights summing to 100% for LLM scoring.
Success Metrics
Use these metrics to assess success, loyalty, and conversion:
- ARR: Annual recurring revenue, indicating customer value.
- ever_customer: If the account has been a customer.
- is_customer: Current active customer status.
- LTV: Expected revenue per customer.
- months_as_customer: Duration as an active customer.
- weeks_to_convert: Time from first interaction to conversion.
Categories (with weights)
- Technology (30%):
- Identify high/medium confidence tech with success correlations.
- Industry (15%):
- Highlight industries with positive/negative success correlations.
- Annual Revenue Range (10%):
- List revenue ranges correlating with success.
- Employee Size Range (15%):
- Specify employee count ranges with success alignment.
- Geographic Fit (10%):
- Identify country or regional correlations.
- Investors (10%):
- Highlight investor partnerships with positive or negative impacts.
- Hiring Trends (10%):
- Analyze relevant job titles and hiring volume; exclude negative indicators.
Final Output: Structure findings with headings, correlation strengths, and category weights. Note data gaps and additional traits from regression analysis for scoring and lead comparison.
Utilizing GPT Columns, you'll receive an ICP analysis output that ranks each account against these success indicators, creating a tailored ideal customer profile.
Step 3: Test the Account Fit Score with Familiar Accounts
Testing validates the accuracy of your scoring.
- Select a Sample Set: Choose a handful of known accounts to evaluate, allowing you to quickly assess if the scores align with expectations.
- Fine-Tune as Needed: Adjust the prompt based on test results until the fit scores consistently match your ICP benchmarks.
Step 4: Score New Accounts and Customize the Prompt for Sales
After testing, you're ready to score new accounts.
- Run Your Prompt: The prompt will evaluate each new account, comparing it to your ICP benchmark.
- Provide Clear Explanations: Use a "stoplight" system (e.g., green for good fit, yellow for moderate, red for low) to help the sales team interpret scores at a glance.
- Add Sample Summaries: Include example summaries to demonstrate how the fit score output should look, enabling the sales team to quickly grasp key insights.
By following these steps, you can build an automated ICP analysis and account scoring system in a single afternoon, transforming weeks of work into actionable sales insights.
2. How we built an AI product usage summary with GPT columns
Understanding and utilizing product usage trends is critical for empowering GTM teams with actionable insights. Census allows you to integrate product event data and build comprehensive summaries to enhance decision-making in Salesforce.
Step 1: Build the Activity Schema in Census
To get started, consolidate your product event data into a single schema for analysis.
- Define the Scope: Identify key product usage events to track, such as login frequency, feature adoption, or concerning inactivity signals.
- Create a JSON Array: Use Census to build an activity schema where events for each account are aggregated into a JSON array. This allows you to store all activity data compactly in Salesforce for seamless access.
SELECT
account_id,
JSON_AGG(
JSON_BUILD_OBJECT(
'event_type', event_type,
'event_time', event_time,
'event_value', event_value
)
) AS activity_summary
FROM product_events
GROUP BY account_id;
Step 2: Write a GPT Prompt to Summarize Usage Trends
Once your activity data is organized, use GPT to analyze and summarize product usage trends for GTM teams.
Key Insights to Include:
- Compare current 30-day trends to the previous 30 days.
- Highlight positive, negative, and exploratory behaviors.
- Suggest actionable next steps based on event patterns.
Sample GPT Prompt:
Analyze the following product event data for account : .
- Summarize product usage trends over the past 30 days compared to the prior 30 days.
- Identify key patterns: positive trends (e.g., increased feature adoption), negative trends (e.g., reduced usage), and exploratory behaviors (e.g., testing new features).
- Suggest 3 actionable next steps for the sales team.
- Present findings in this structure:
- **Key Usage Trends:** Summary of major trends.
- **Concerning Events:** Highlights of potential risks.
- **Actionable Next Steps:** Tailored recommendations for GTM teams.
Step 3: Structure Data for Salesforce
With your analysis complete, ensure that the insights are formatted for easy consumption by the sales team in Salesforce.
- Organize Outputs: Align the output structure with your Salesforce fields, such as “Key Events,” “Concerning Trends,” and “Next Steps.”
- Include Suggested Sales Talking Points: Provide GTM teams with ready-made talking points based on product usage insights to personalize their outreach.
Step 4: Validate and Iterate
- Test Outputs: Review sample accounts to ensure insights align with expectations.
- Fine-Tune Prompts and Data: Adjust the activity schema and prompt logic as needed to maximize relevance and usability.
By centralizing and summarizing product usage data, you can empower your GTM teams with actionable insights directly in Salesforce. This approach ensures that key product events are not just tracked but actively leveraged to drive impactful sales conversations and customer engagement strategies.
Leveraging AI and GPT Columns to Empower Salesforce Teams
Incorporating GPT Columns into your go-to-market strategy empowers sales and marketing teams with actionable, AI-driven insights tailored to their unique needs. By enriching Salesforce with data from your warehouse, you can guide account executives toward high-value opportunities with personalized recommendations, prevent churn with proactive customer retention alerts, and craft hyper-personalized marketing campaigns that drive engagement. Whether it's helping sales reps identify the next best action, providing account managers with re-engagement strategies, or delivering marketing teams tailored content suggestions, these AI-powered prompts unlock new levels of efficiency and effectiveness. Start leveraging these strategies today to drive revenue, retain customers, and create impactful campaigns that resonate with your audience.
Ready to take Salesforce to the next level? Start Your Free Trial or Book a Demo today to see how Census can transform your data into a powerful asset for growth.