All our playbooks

How to automatically sync Excel data to HubSpot contacts without manual CSV uploads

Learn how to automatically sync Excel data to HubSpot contacts without manual CSV uploads using scheduled exports and direct API integration.

How to build a Salesforce stage duration report with historical data beyond 18 months

Build Salesforce stage duration reports with unlimited historical data beyond the 18-month field history limitation using automated snapshots and preservation strategies.

How to bulk create call log activities for multiple contacts in Salesforce without data loader

Learn how to bulk create call log activities for multiple Salesforce contacts without Data Loader using spreadsheets and direct CRM integration.

How to bypass Salesforce Data Connector refresh rate limitations in Google Sheets

Stop manually refreshing Salesforce data in Google Sheets. Learn how to set up automated hourly, daily, and weekly refresh schedules that actually work.

How to calculate time spent in each Salesforce opportunity stage for all users

Calculate time spent in each Salesforce opportunity stage across all users with advanced formulas and automated tracking that native reports can't provide.

How to calculate win rate by deal amount instead of deal count in HubSpot

Learn how to calculate HubSpot win rates by deal amount instead of deal count using automated formulas and live data imports for revenue-based analysis.

How to copy multiple Salesforce IDs from one report filter to another report

Discover how to efficiently copy multiple Salesforce IDs between report filters using automated cross-referencing and dynamic filtering capabilities.

How to create a comma-separated list of IDs from Salesforce report results

Learn how to automatically generate comma-separated ID lists from Salesforce reports using spreadsheet formulas and automated data imports.

How to create audit trail of merged account IDs in Salesforce custom fields

Build comprehensive audit trails for merged Salesforce account IDs using automated tracking systems and custom field documentation for complete merge history.

How to create dual date filters for period comparison in Salesforce charts

Learn how to build dual date filters for period comparison charts in Salesforce using data preparation techniques and visualization tools.

How to create master renewal calendar from Salesforce assets without duplicate dates

Build a clean, deduplicated master renewal calendar from Salesforce assets that provides strategic visibility without information overload or duplicate dates.

How to create month-over-month comparison reports with filtered date ranges in HubSpot

Learn how to create month-over-month comparison reports with specific date range filters using Coefficient when HubSpot blocks duplicate date fields.