All our playbooks

Why Salesforce dashboard filters show only lookup fields, not formula fields on Activities

Salesforce Activity dashboard filters are limited to lookup relationships and can't show formula fields. Here's how to make all fields filterable.

Workarounds for Excel table structured references not working in Google Sheets

Find effective workarounds for Excel table structured references that don't work in Google Sheets. Create cross-platform compatible formulas.

Workaround for NetSuite Row Layout Assignment export when no suitable Analytics dataset exists

Export NetSuite Row Layout Assignment data when Analytics datasets don't exist. Use direct table access and multi-method workarounds for complete data extraction.

Expediting sales pipeline dashboard creation in Google Sheets using pre-configured templates

Speed up sales pipeline dashboard creation with Coefficient's pre-built templates. Reduce setup time from hours to minutes with automated data connections.

How to automate daily Salesforce sales pipeline data refresh directly into Google Sheets

Automate daily Salesforce pipeline data refresh in Google Sheets with Coefficient. Set up once and get fresh sales data every morning without manual work.

How to automate real-time operational dashboards in Notion by connecting Google Sheets to live business systems

Automate real-time operational dashboards in Notion using Google Sheets connected to CRMs, data warehouses, and business systems for live data visualization.

How to build a historical snapshot report for Salesforce sales pipeline data

Sales Ops managers and RevOps teams can build a complete historical pipeline reporting system capturing weekly or daily pipeline snapshots automatically by using Coefficient's Salesforce connector with the Snapshots feature in Google Sheets or Excel. Salesforce reporting shows your pipeline as it stands right now. It cannot show you what your pipeline looked like at end of last month, how much pipeline has been added or lost since the start of the quarter, or whether your forecast accuracy is improving over time. Without historical snapshots, every QBR starts with someone manually reconstructing data that should have been saved automatically.

How to create sophisticated data pipelines for BI tools using spreadsheets without a data engineer

Build enterprise-grade data pipelines for Looker Studio and Power BI using spreadsheets. No coding, SQL, or data engineering expertise required.

How to customize dynamic sales pipeline data visualizations for automated weekly email reports

Create customized dynamic pipeline visualizations for automated weekly email reports. Personalize charts and metrics for different recipients with Coefficient.

How to embed interactive, auto-refreshing Google Sheets data charts on websites and internal wikis

Embed interactive, auto-refreshing Google Sheets charts on websites, Confluence, SharePoint, and internal wikis using automated data connections.

How to ensure HubSpot sales pipeline data in Google Sheets updates automatically

Keep HubSpot pipeline data in Google Sheets automatically updated with real-time changes. Set up hourly refreshes and eliminate stale sales data forever.

How to embed live-updating Google Sheets charts in Notion for real-time business intelligence

Learn how to create live-updating Google Sheets charts in Notion for real-time business intelligence using automated data connections and dynamic visualizations.