)
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.”
CRMA fundamentally cannot access computed fields that only exist in Salesforce reports because it operates at the object level rather than the reporting layer where these fields are computed. This architectural limitation affects all virtual fields including From Stage, To Stage, and calculated metrics.
Here’s how to access all computed fields that CRMA cannot reach, without complex workarounds or manual recreations.
Import computed fields directly from Salesforce reports using Coefficient
Coefficient specifically addresses this gap by importing directly from Salesforce reports rather than objects. This provides complete access to virtual fields that CRMA cannot reach, leveraging Salesforce’s native reporting engine to access pre-calculated fields while offering superior analytical flexibility through Salesforce spreadsheet functionality.
How to make it work
Step 1. Select your Salesforce report containing computed fields.
Choose any Opportunity History report or other report that contains the virtual fields you need. Coefficient accesses the report-level data where computed fields like From Stage, To Stage, calculated percentages, and cross-object references are already processed by Salesforce’s reporting engine.
Step 2. Import all report columns including virtual fields.
Coefficient automatically imports all visible report columns, including computed fields, formulas, and calculated metrics that don’t exist in the underlying object structure. Set up automated refreshes to maintain current virtual field values without manual intervention.
Step 3. Enhance analysis with spreadsheet capabilities.
Perform additional calculations on the computed data using familiar spreadsheet functions. Create stage transition analysis, sales performance metrics with computed ratios, time-based calculations, and custom formulas that build on the virtual field data.
Step 4. Schedule regular data updates.
Set up automated imports from hourly to monthly to maintain current virtual field values. This ensures your analysis always reflects the latest computed data without the performance overhead of recreating virtual field logic manually.
Access the data CRMA can’t provide
Stop struggling with CRMA’s object-level limitations and get immediate access to all computed fields from your Salesforce reports. Start using Coefficient to unlock the virtual field data your analysis needs.
