All our playbooks

Why Salesforce joined reports only export 20,000 records from the first block

Salesforce joined reports hit a 20,000 record export limit per block. Learn why this happens and how to bypass it to access your complete dataset.

Accessing virtual fields from Opportunity History reports in Salesforce CRM Analytics

Learn why CRM Analytics can't access virtual fields from Opportunity History reports and discover the direct solution for complete field access.

Alternative methods to add lookup fields without using Salesforce new report type configuration

Access Salesforce lookup field data without modifying report type configurations using direct object access that eliminates breaking change risks.

Alternative methods to track opportunity stage changes in Salesforce CRM Analytics dashboards

Discover effective alternatives to CRMA's limited stage tracking capabilities with automated Salesforce report imports and advanced spreadsheet analytics.

Alternative methods to track Salesforce opportunity stage duration when field history reports fail

When Salesforce field history reports fail, use these alternative methods to track opportunity stage duration with comprehensive data and unlimited historical tracking.

Alternative to Salesforce report subscription for external email recipients

Find a comprehensive alternative to Salesforce report subscriptions that works for external email recipients without licensing restrictions or formatting limitations.

Automate dashboard refresh when underlying data changes using workflow actions

HubSpot workflows can't monitor data changes or trigger dashboard refreshes. Here's how to automate refreshes that respond to underlying data changes.

Automating user field sync when Salesforce and HubSpot have different user identifiers

Automate user field sync between Salesforce and HubSpot with different identifiers using dynamic matching systems and scheduled data flows.

Build sales performance report with quota attainment and open deals by stage in HubSpot

Create comprehensive sales performance reports combining quota attainment metrics with detailed pipeline stage analysis from HubSpot data.

Building a staging table to reconcile Excel company data with existing HubSpot records

Create dynamic staging environments that sync live with HubSpot data for complex company data reconciliation instead of static snapshots.

Building stage duration calculations in Salesforce CRMA without standard history fields

Skip CRMA's complex dataflow transformations and build accurate stage duration calculations using simple spreadsheet formulas and automated data imports.

Calculating month-over-month differences between two years of closed won data in Salesforce

Calculate month-over-month differences between two years of Salesforce closed won data with automated calculations and live data connectivity.