)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Your most sophisticated targeting criteria often exists in Excel spreadsheets but Salesforce Campaign Builder cannot access external data for segmentation. This creates a frustrating gap between your best targeting intelligence and email execution capabilities, forcing you to choose between advanced targeting and professional email delivery.
You’ll discover how to bridge Excel-based targeting criteria with Salesforce email infrastructure, enabling sophisticated campaigns while maintaining deliverability and compliance features.
Execute campaigns with Excel targeting criteria using Coefficient
Coefficient solves this challenge by automatically pushing external targeting data into Salesforce custom fields, enabling native email functionality while preserving your Excel-based intelligence. This approach combines analytical power with professional email infrastructure.
How to make it work
Step 1. Create custom fields in Salesforce for Excel-based criteria.
Set up dedicated custom fields in Contact and Lead objects for your Excel targeting data. For example, create “Excel_Purchase_Score__c” for transaction analysis or “External_Segment__c” for demographic targeting that doesn’t exist in CRM fields.
Step 2. Import and process Excel targeting data in Google Sheets.
Bring your Excel targeting criteria into Google Sheets and apply sophisticated business logic using advanced formulas. Handle complex calculations like purchase behavior scores, predictive analytics, or multi-variable demographic segments that Salesforce formula fields cannot process.
Step 3. Set up automated field population using scheduled exports.
Configure scheduled exports to UPDATE Contact and Lead records with processed targeting criteria. Use conditional updates to only modify records where targeting criteria changes, maintaining data efficiency and API usage optimization.
Step 4. Execute mass emails using native Salesforce tools.
Leverage Salesforce Campaign Builder, Marketing Cloud, or email automation using newly populated custom fields. This maintains native deliverability features, bounce handling, unsubscribe management, and compliance capabilities that direct Excel-based sending cannot provide.
Step 5. Maintain dynamic targeting with ongoing synchronization.
Set up daily or weekly export schedules to keep targeting criteria current as Excel data evolves. This enables responsive campaigns that adapt to external analytics, survey results, or predictive model updates automatically.
Launch your first Excel-powered campaign
This solution combines Excel’s analytical flexibility with Salesforce’s robust email infrastructure, solving the limitation where external targeting intelligence cannot be utilized through native CRM tools. Start building your Excel-powered email campaigns today.
