)
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.”
External objects don’t consume Salesforce storage but require expensive Connect licensing ($2,000+ annually) and have query limitations. Custom objects provide full SOQL functionality but cost $20+ per GB annually in storage.
There’s a third option that combines the storage benefits of external objects with the functionality of custom objects at a fraction of the cost.
Get the best of both worlds using Coefficient
Coefficient imports external data directly into spreadsheets, giving you no Salesforce storage consumption, no Connect licensing costs, and full data manipulation capabilities without Governor Limits.
How to make it work
Step 1. Import external data without storage costs.
Connect Coefficient to your external databases or APIs and import large datasets directly into Google Sheets or Excel. This data doesn’t consume any Salesforce storage or require Connect licensing.
Step 2. Add your Salesforce CRM data.
Import relevant Salesforce objects, reports, or custom queries into the same spreadsheet. Now you have both external and CRM data in one place for comprehensive analysis.
Step 3. Perform complex analysis locally.
Use spreadsheet functions to create calculations, aggregations, and relationships that would be impossible with external objects or expensive with custom objects. Work with millions of records without API call overhead.
Step 4. Set up automated data refresh.
Schedule regular imports to keep your data current. Use instant refresh capabilities when you need the latest information, all without the performance limitations of external objects.
Stop paying for storage and licensing
Why choose between expensive storage and limited functionality when you can have both power and cost savings? Start with Coefficient and eliminate your external object dilemma.
