)
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.”
Salesforce report type configuration rollbacks are complex and risky when lookup fields break reports. Rolling back can eliminate the new functionality you needed while potentially creating additional compatibility issues with other system components.
Here’s an alternative approach that eliminates the need for rollbacks by creating independent reporting infrastructure that preserves your new functionality while restoring report access.
Create parallel reporting infrastructure instead of rolling back using Coefficient
Coefficient provides an alternative to risky rollbacks by creating reports that access the same data through direct object imports. This approach keeps your Salesforce modifications in place while restoring reporting functionality.
How to make it work
Step 1. Maintain your current Salesforce configuration.
Keep your report type modifications in place to preserve the new lookup field functionality that prompted the original change. This maintains the schema improvements while addressing the reporting issues separately.
Step 2. Create independent reports using direct object access.
Build Coefficient imports that replicate your broken reports’ functionality using “From Objects & Fields” method. This accesses the same data without depending on report type configurations.
Step 3. Include the new lookup fields in your imports.
Select the lookup fields that caused the original modification need directly from the object field list. This preserves the new functionality while providing immediate report access.
Step 4. Implement version control with Snapshots.
Use Coefficient’s Snapshots feature to maintain historical versions of your data, providing rollback-like functionality for data analysis while maintaining forward compatibility with your evolving Salesforce configuration.
Step 5. Set up automated refresh schedules.
Configure hourly, daily, or weekly refresh schedules to keep your data current. This ensures your parallel reports provide real-time accuracy without manual maintenance.
Step 6. Gradually migrate stakeholders to the new reports.
Transition users to Coefficient-powered reports without disrupting current workflows. The enhanced capabilities often exceed the original Salesforce report functionality.
Preserve progress while restoring functionality
This approach eliminates rollback risks while maintaining your Salesforce improvements. You’ll establish a more resilient reporting infrastructure that adapts to schema changes without breaking, providing superior analytical capabilities. Start building rollback-free reporting solutions.
