Skip to main content

9 docs tagged with "Account model"

Configuring the Account model and its queries.

View all tags

Account Model Field Reference

This page documents every recognized account property in FunnelStory, its expected data type, and what it's used for. When mapping your query columns to account properties, use this as your reference.

Advanced Account Model Configuration

This page covers advanced scenarios for the Account model. Each section explains a specific configuration goal, how it works in FunnelStory, and provides query examples for multiple data source types.

Getting Started: Configuring the Account Model

Welcome to FunnelStory. This guide walks you through configuring the Account data model -- the foundational model that everything else in FunnelStory depends on. Whether you're pulling data from a CRM like Salesforce or HubSpot, a data warehouse like Snowflake or BigQuery, or a combination of both, this guide covers what you need to get it right.

Prerequisites: Setting Up Data Connections

Before configuring the Account model, you need at least one data connection in FunnelStory. A data connection is a link between FunnelStory and an external system that holds your account data.

Real-World Examples

This page provides complete, end-to-end Account model configurations for common setups. Each example includes the full query, the property mapping table, and an explanation of what's being configured.

Shared teams

Shared teams are groups of workspace users you define in FunnelStory. When an account’s data includes a matching team identifier, every member of that team can be auto-assigned to the account after an Account model refresh—useful when portfolios are owned by pods or regions rather than a single CSM.

Writing Queries for the Account Model

The query you write determines what data FunnelStory pulls into the Account model. The format depends on your data source type. This page covers the query syntax for every supported connection type.