All our playbooks

How to filter Salesforce dashboard components from multiple objects using single business line field

Learn how to filter Salesforce dashboard components across multiple unrelated objects using a single business line field with dynamic filtering solutions.

How to filter Salesforce opportunities by specific product names while including opportunities without products

Learn how to create Salesforce opportunity reports that filter by specific product names while including opportunities without products in a single unified view.

How to filter Salesforce report by sum of timecard hours less than 40

Learn how to filter Salesforce timecard data by sum of hours under 40. Overcome native reporting limitations with automated solutions.

How to export HubSpot pipeline stages with deal values to Excel without losing custom properties

Export HubSpot pipeline data to Excel while preserving all custom properties. Learn how to maintain custom fields and automate data refreshes seamlessly.

How to export Salesforce timecard data to filter by weekly hour totals

Learn how to export and filter Salesforce timecard data by weekly hour totals with automated data extraction and real-time updates.

How to export multi-currency pipeline data from HubSpot to Excel with accurate conversions

Export HubSpot multi-currency pipeline data to Excel with accurate historical conversions. Handle complex currency analysis and regional performance tracking.

How to extract folder-level permissions matrix for Salesforce reports and dashboards

Create comprehensive folder-level permissions matrices for Salesforce reports and dashboards using automated data imports and dynamic analysis.

How to create Salesforce reports showing opportunities with specific products OR without products

Learn how to bypass Salesforce cross filter limitations and create unified opportunity reports showing both specific products and product-less opportunities.

How to exclude accounts with zero dollar opportunities from Salesforce net new account report

Learn how to clean up Salesforce net new account reports by excluding zero-dollar opportunities that represent test data or incomplete records.

How to export historical pipeline snapshots from HubSpot to Excel for trend analysis

Export historical HubSpot pipeline data to Excel for trend analysis. Automatically capture pipeline snapshots and track performance changes over time.

How to check effective permissions for Salesforce reports when users have multiple permission sets

Calculate effective Salesforce report permissions across multiple permission sets using automated permission aggregation and spreadsheet analysis.

How to create Salesforce report for accounts with no closed won opportunities since specific date

Learn how to identify Salesforce accounts without closed won opportunities since a specific date using advanced filtering and cross-object analysis techniques.