Category: Excel

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

HubSpot’s native export strips custom properties or forces you to manually select fields every time you export pipeline data. This creates inconsistent reports and wastes time on repetitive tasks.

Here’s how to export your pipeline stages with deal values while keeping all custom properties intact, plus automate the whole process.

Export pipeline data with custom properties preserved using Coefficient

CoefficientHubSpotcreates a live connection betweenand Excel that preserves custom properties during every data refresh. Unlike HubSpot’s export function, you configure your custom fields once and they stay included automatically.

The key advantage: your custom deal properties maintain proper data types and field mapping consistency across all refreshes. No more lost data or manual field selection.

How to make it work

Step 1. Connect HubSpot to Excel through Coefficient’s sidebar.

Install Coefficient and open the sidebar in Excel. Select “Import from” and choose HubSpot from your connected sources. If it’s your first time, you’ll authenticate your HubSpot account.

Step 2. Select deals object and filter by pipeline stages.

Choose “Deals” as your object type. Use filters to select specific pipeline stages you want to analyze. You can filter by deal stage, close date, or any other criteria relevant to your reporting needs.

Step 3. Include all required custom properties in field selection.

In the field selection screen, check all custom deal properties you need for analysis. These might include custom scoring fields, territory assignments, or deal source tracking. Coefficient will remember these selections for future refreshes.

Step 4. Set up scheduled refreshes to keep data current.

Configure daily or weekly automatic refreshes so your Excel sheet updates with current pipeline data. This eliminates the need to manually re-export from HubSpot every time you need updated information.

Step 5. Use Formula Auto Fill Down for automatic calculations.

Add Excel formulas in columns next to your imported data. When new deals are added during refreshes, Coefficient automatically applies your formulas to the new rows, maintaining consistent calculations across your dataset.

Stop losing custom properties in your pipeline exports

Try CoefficientThis approach eliminates repetitive manual exports while ensuring your custom HubSpot properties are always available for Excel analysis.to maintain consistent pipeline reporting with all your custom fields intact.

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

Traditional Salesforce data exports become static immediately after download and require repeated manual effort, making weekly hour analysis inefficient and prone to outdated information.

Here’s how to streamline the export and filtering process with automated data extraction that maintains real-time connectivity to your timecard data.

Automate timecard exports with live data connectivity using Coefficient

SalesforceCoefficientSalesforceManual CSV exports fromhave no automated refresh capabilities and require complex setup for weekly aggregation analysis.streamlines this process by continuously syncingtimecard data to spreadsheets where you can perform advanced filtering on aggregated weekly totals using scheduled processing that eliminates manual intervention.

How to make it work

Step 1. Set up automated data export.

Connect to your Salesforce timecard objects or existing timecard reports using Coefficient. Configure filters to pull relevant date ranges like current or previous weeks, eliminating the need for repeated manual downloads.

Step 2. Create weekly hour calculations.

Build SUMIFS formulas to calculate weekly hour totals per employee:. This aggregates individual timecard entries into meaningful weekly totals for analysis.

Step 3. Apply filtering and formatting.

Use data filters to show employees with less than 40 hours and add conditional formatting for visual identification. Include related employee data like contact info and manager details for comprehensive reporting.

Step 4. Schedule automatic refreshes.

Set up hourly, daily, or weekly refresh schedules to maintain current data without manual intervention. This transforms one-time exports into a comprehensive, automated weekly hours tracking system.

Transform exports into automated tracking systems

Start automatingThis approach eliminates manual export cycles while providing historical trending and bulk data processing capabilities that static exports cannot deliver.your timecard data exports today.

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

HubSpot’s multi-currency exports lack proper conversion tracking and historical exchange rate handling. You can’t track deals using exchange rates from original deal dates or handle complex multi-currency calculations effectively.

Here’s how to export multi-currency pipeline data with all currency-related fields and enable sophisticated Excel-based currency conversion analysis that HubSpot cannot provide.

Handle complex multi-currency analysis using Coefficient

CoefficientHubSpothandles multi-currencypipeline data by importing all currency-related fields and enabling sophisticated Excel-based currency conversion analysis. You get both original currency amounts and converted values with conversion rate information preserved.

This enables historical exchange rate accuracy and regional performance analysis that HubSpot’s native multi-currency exports cannot deliver.

How to make it work

Step 1. Import deal data including currency amounts and conversion rates.

Pull deal data with both original currency amounts and converted values. Include currency type fields, conversion rate information, and deal close dates to maintain historical accuracy for currency analysis.

Step 2. Create Excel lookup tables for historical exchange rates.

Build reference tables with historical exchange rates by date to ensure accurate conversions. Use VLOOKUP or INDEX/MATCH formulas to apply period-appropriate exchange rates to historical deals based on their close dates.

Step 3. Build formulas for currency normalization.

Create Excel formulas to convert all pipeline values to a single reporting currency. Use formulas like =Original_Amount*VLOOKUP(Close_Date,Exchange_Rate_Table,Currency_Column,TRUE) to apply accurate historical conversion rates.

Step 4. Set up regional performance analysis.

Use conditional formatting and pivot tables to analyze pipeline performance by currency and region. Calculate regional quota attainment and conversion rates while maintaining currency context for accurate performance measurement.

Step 5. Calculate exchange rate impact on pipeline values.

Build formulas to show how currency fluctuations affect pipeline values over time. Create variance calculations between original currency amounts and current conversion rates to understand exchange rate impact on revenue.

Master multi-currency pipeline analysis

Handle complex currenciesThis approach provides comprehensive multi-currency pipeline analysis with accurate historical conversions, capabilities that HubSpot’s standard reporting cannot effectively deliver.with the precision your global sales team needs.

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

Salesforce provides no native folder-level permissions matrix view, requiring administrators to manually check each folder’s sharing settings individually through Setup > Sharing Settings.

Here’s how to create comprehensive permission matrices directly in your spreadsheet using automated data imports.

Create dynamic folder permission matrices using Coefficient

Coefficientsolves this by creating comprehensive permission matrices with automated updates. You get consolidated matrix views, historical tracking of permission changes, and powerful export capabilities for permission data.

How to make it work

Step 1. Import folder data for reports and dashboards.

SalesforceConnect tousing SOQL:. This gives you the complete list of folders to analyze.

Step 2. Import permission data and user mappings.

Get permission details with:. Then import user/profile mappings:for complete visibility.

Step 3. Create dynamic permission matrices using pivot tables.

Use your spreadsheet’s PIVOT table functionality and Coefficient’s formula auto-fill to create dynamic permission matrices. Cross-reference folder IDs with permission data and user information.

Step 4. Apply conditional formatting to visualize access levels.

Use conditional formatting to highlight different access levels (Read, Edit, Manage). Create filterable, sortable views of all folder permissions with color coding for quick identification of permission patterns.

Eliminate manual permission auditing with automated matrices

Build yourThe resulting matrix provides filterable, sortable views of all folder permissions with automated updates through Coefficient’s scheduling features.automated permission matrix today.

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

SalesforceYou can’t create a singlereport showing opportunities with specific products OR opportunities without products because cross filters don’t support OR logic with standard filters.

This guide shows you how to bypass this limitation and create the unified opportunity report you need using advanced data integration.

Create unified opportunity reports using Coefficient

CoefficientSalesforce’seliminatescross filter restrictions by extracting your opportunity data directly and applying complex OR logic that the platform can’t handle natively. Instead of managing multiple separate reports, you get one comprehensive view.

How to make it work

Step 1. Import your opportunity data with product relationships.

Connect to Salesforce using Coefficient’s “From Objects & Fields” method. Select the Opportunity object and include all relevant fields like Name, Amount, Stage, and Close Date. Import related OpportunityLineItem data separately to capture product relationships, including Product2.Name and Quantity fields.

Step 2. Apply complex OR filtering logic.

Use Coefficient’s advanced filtering to identify both scenarios simultaneously. Create filters for opportunities with your target products:OR opportunities without any products:. This OR logic combination is impossible in Salesforce native reporting.

Step 3. Consolidate into a unified report.

Use spreadsheet functions to merge both datasets:. Add a categorization column withto distinguish opportunity types. Calculate unified metrics across both categories for comprehensive analysis.

Step 4. Set up automated refresh and alerts.

Schedule automatic data refresh to maintain current information without manual updates. Configure alerts for new opportunities appearing in either category. This keeps your unified report accurate while eliminating the need to manage multiple Salesforce reports.

Try Coefficient Now

Get the complete opportunity view you need

Start buildingThis approach transforms what requires multiple disconnected Salesforce reports into a single comprehensive analysis tool. You’ll have real-time insights across all opportunity types that cross filter limitations prevent.your unified opportunity reports today.

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

SalesforceExcluding zero-dollar opportunities from net new account analysis is particularly challenging inbecause these records often represent placeholder opportunities, test data, or incomplete records that skew reporting accuracy. Native filtering struggles with this nuanced data cleanup requirement.

Here’s how to build cleaner net new account reports by filtering out zero-dollar opportunities at the source and creating quality control measures.

Clean up your data with Coefficient

CoefficientSalesforceprovides superior data handling for this common net new accountsreporting challenge by letting you filter out problematic data before analysis.

How to make it work

Step 1. Import clean data at the source.

Use Coefficient’s filtering capabilities to exclude Amount = 0 or null values during import. Use “From Objects & Fields” with Amount > 0 filter, or custom SOQL:

Step 2. Set up dynamic amount criteria.

Create dynamic filtering by pointing to a cell containing your minimum amount threshold. This allows easy adjustment without re-importing data when your qualification criteria change.

Step 3. Identify accounts with only zero-dollar opportunities.

Use formulas to flag accounts that only have zero-dollar opportunities for data quality review:

Step 4. Build refined net new calculation.

Create comprehensive logic that considers both amount and stage criteria:

Step 5. Create quality control dashboard.

Build a secondary analysis showing excluded accounts for data quality review, so you can identify patterns in your zero-dollar opportunity creation.

Get more accurate net new account identification

Start cleaningThis approach ensures more accurate net new account identification by eliminating data quality issues that commonly affect Salesforce opportunity amount criteria reporting.up your account reports today.

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

HubSpot lacks native functionality to export pipeline data as it existed at specific past dates. You can’t easily track how your pipeline looked last month or compare pipeline states over time for trend analysis.

Here’s how to automatically capture historical pipeline snapshots and export them to Excel for comprehensive trend analysis that HubSpot’s standard reporting cannot provide.

Capture automated historical pipeline data using Coefficient

Coefficient’sHubSpot’sSnapshots feature specifically addresses this challenge by automatically capturing historical pipeline data copies for Excel trend analysis. Unlikelimited historical reporting, you get complete pipeline state preservation at any frequency you need.

Each snapshot maintains complete deal data with all custom properties as they existed at capture time, creating a comprehensive historical dataset impossible to build with HubSpot’s native tools.

How to make it work

Step 1. Set up live pipeline data import with required properties.

Create a live import of your pipeline deals including all relevant properties like deal amount, stage, probability, close date, and custom fields. This becomes your current pipeline view that updates automatically with fresh data.

Step 2. Configure monthly snapshots for historical capture.

Enable scheduled snapshots to automatically preserve pipeline state data on specific dates like month-end. Choose monthly frequency for quarterly trend analysis, or weekly snapshots if you need more granular historical tracking.

Step 3. Create Excel analysis comparing pipeline periods.

Build formulas to compare pipeline values, stage distribution, and deal velocity across different snapshot periods. Use SUMIFS to calculate pipeline totals by month and create percentage change calculations between periods.

Step 4. Build trend charts for pipeline growth visualization.

Create Excel charts showing pipeline growth, conversion rates, and forecasting accuracy over time using your historical snapshot data. Include trend lines to identify seasonal patterns and performance trajectories.

Step 5. Use Excel’s data analysis tools for pattern identification.

Apply Excel’s statistical functions to identify seasonal patterns, calculate moving averages, and spot performance trends that would be impossible to detect without historical pipeline data preservation.

Finally track how your pipeline actually changes over time

Start capturingThis automated approach creates a comprehensive historical pipeline dataset in Excel that enables sophisticated trend analysis impossible with HubSpot’s standard reporting capabilities.your pipeline history automatically today.

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

Calculating effective permissions across multiple permission sets is extremely complex in Salesforce, as permissions can be additive across profiles, permission sets, sharing rules, and role hierarchies with no native calculator available.

Here’s how to simplify this through automated permission aggregation and spreadsheet analysis capabilities.

Calculate effective permissions automatically using Coefficient

Coefficientsimplifies effective permission calculation through automated permission aggregation. You can import all permission sources using comprehensive SOQL queries and create effective permission matrices with permission source attribution.

How to make it work

Step 1. Import all permission sources with comprehensive queries.

SalesforceConnect toand import profile permissions:. Then get permission set assignments:

Step 2. Get folder sharing permissions.

Import folder-level access:. This captures sharing rule permissions that might grant access beyond profile and permission set settings.

Step 3. Create additive permission calculations using spreadsheet formulas.

Use Coefficient’s formula auto-fill to create IF/OR formulas that determine the highest permission level across sources. Build VLOOKUP combinations to cross-reference user assignments and conditional logic for permission inheritance rules.

Step 4. Build effective permission matrices.

Create user-specific effective permissions across all reports with permission source attribution (Profile vs Permission Set vs Sharing). Calculate access level results showing Read/Edit/Manage effective rights for each user-report combination.

Step 5. Apply dynamic filtering and schedule updates.

Use dynamic filtering to analyze specific users or permission combinations. Schedule automated updates to maintain current effective permission calculations as permission assignments change.

Get comprehensive effective permission visibility

Salesforce’sStart calculatingThis provides comprehensive effective permission visibility that’s impossible throughnative interface, eliminating hours of manual permission checking.your effective permissions today.

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

SalesforceFinding accounts that haven’t closed any deals since a specific date is trickier than it sounds.native reporting struggles with this “accounts WITHOUT something” scenario because it requires complex cross-object analysis between accounts and opportunities.

SalesforceHere’s how to build this report using spreadsheet formulas that can handle the negative filtering logic thatcan’t manage effectively.

Build the report using Coefficient

Coefficientlets you import both account and opportunity data into your spreadsheet, then use formulas to identify accounts with opportunities but no closed won deals since your target date. This approach bypasses Salesforce’s cross-filter limitations entirely.

How to make it work

Step 1. Import your account data.

Use Coefficient’s “From Objects & Fields” to pull all accounts with key fields like Account ID, Name, Created Date, and Industry. This gives you the base list to analyze against.

Step 2. Import opportunity data with date filtering.

Create a second import for opportunities, including Account ID, Stage, Close Date, Amount, and Created Date. Use dynamic filtering to only include opportunities created since your target date (like 2018 or whenever you want to start tracking).

Step 3. Create your analysis formula.

Use a COUNTIFS formula to identify accounts that have opportunities but no “Closed Won” stage since your specified date:

Step 4. Set up automated refresh.

Schedule hourly or daily refreshes to keep your report current without manual work. This ensures you’re always working with the latest opportunity data.

Get better account insights with real-time data

Start buildingThis approach gives you the flexible date handling and cross-object analysis that Salesforce’s standard reports can’t provide.more sophisticated account reports today.

How to create employee list with less than 40 hours from Salesforce timecards

Creating employee lists based on aggregated timecard hours requires working around Salesforce’s inability to filter on calculated totals, since native reports and list views cannot reference timecard aggregations.

Here’s the most efficient method for generating and maintaining dynamic employee lists that update automatically with current timecard data.

Generate dynamic employee lists with automated timecard analysis using Coefficient

SalesforceCoefficientSalesforcecannot create reports that filter employees based on sum of their timecard hours, and list views on Employee objects cannot reference timecard aggregations.provides the most efficient method by integrating both employee data and timecard records from, then using spreadsheet functions to calculate totals and generate filtered lists that maintain current employee status with scheduled data refreshes.

How to make it work

Step 1. Import employee and timecard data.

Connect to both Salesforce User/Employee and Timecard objects using Coefficient. Join data on Employee ID to link timecards with employee information like name, department, manager, and contact details.

Step 2. Calculate weekly hours per employee.

Create weekly hour calculations using SUMIFS formulas:. This aggregates individual timecard entries into meaningful weekly totals for each employee.

Step 3. Filter and format the employee list.

Apply filters where calculated hours are less than 40 and add color-coding for different hour ranges (0-20, 20-30, 30-39 hours). Group by manager for targeted follow-up and include all relevant employee details for HR workflows.

Step 4. Automate list maintenance.

Schedule weekly refresh to update employee status automatically. Set up alerts when specific employees consistently fall below thresholds and integrate with email notifications for proactive management.

Build actionable employee tracking systems

Start creatingThis approach creates a dynamic, actionable employee list that updates automatically and provides comprehensive insights beyond what Salesforce native reporting can deliver.your automated employee tracking lists today.