Intended Use
Automate Real Estate sales revenue and operations metrics out of NetSuite in the form dashboards and reports in Looker
People
Business Owner: Matt Smocovich
Lead Analyst: William Ritchings
Technical Lead: Abe Ahn
Tools and Technologies
NetSuite: Original data source
Fivetran: Data Sync tool (extracts and loads NetSuite data in to Snowflake)
Snowflake: Cloud data warehouse; Looker data source
Looker: Data modeling, visualization, dashboards
System Architecture
Data Model Designs
Production Objects
Dashboard | Tile | Explore | |
|---|---|---|---|
Real Estate Sales_Executives | Real Estate Revenue vs Budget (US) | RE Sales Revenue vs [Static] Budget | |
Real Estate Sales_Executives | Monthly Progress to Budget | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | Quarterly Progress to Budget | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | Yearly Progress to Budget | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | FY Performance by Individual | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | US Gross Pipeline | Sales Ops Opportunities | |
Real Estate Sales_Executives | US Weighted Pipeline | Sales Ops Opportunities | |
Real Estate Sales_Executives | Contracted Displays: Elevator vs. Multipurpose | Sales Ops Opportunities | |
Real Estate Sales_Executives | Active Forecasting Pipeline (Top 3 DMAs) | Sales Ops Opportunities | |
Real Estate Sales_Executives | Contracted Buildings by DMA | Sales Ops Opportunities | |
Real Estate Sales_Executives | Contracted Buildings by Lead Source | Sales Ops Opportunities | |
Real Estate Sales_Executives | Contracted Buildings by Tier | Sales Ops Opportunities | |
Real Estate Sales_Executives | Real Estate Revenue vs Budget (CANADA) | RE Sales Revenue vs [Static] Budget | |
Real Estate Sales_Executives | FY Performance by Individual (CANADA) | Sales Ops Contracted vs Budget Individual | |
Real Estate Sales_Executives | Active Forecasting Pipeline (By DMA) | Sales Ops Opportunities | |
Real Estate Sales_Executives | Monthly Progress to Budget (CANADA) | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | Quarterly Progress to Budget (CANADA) | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | Full Year Progress to Budget (CANADA) | Sales Ops Contracted vs Budget | |
Real Estate Sales_Executives | Contracted Displays by DMA | Sales Ops Opportunities | |
Real Estate Sales_Executives | Contracted Displays by Opp Type | Sales Ops Opportunities | |
US Real Estate Sales | Real Estate Revenue vs Budget | RE Sales Revenue vs [Static] Budget | |
US Real Estate Sales | Monthly Progress to Budget | Sales Ops Contracted vs Budget | |
US Real Estate Sales | Quarterly Progress to Budget | Sales Ops Contracted vs Budget | |
US Real Estate Sales | Full Year Progress to Budget | Sales Ops Contracted vs Budget | |
US Real Estate Sales | Attainment to Quota | Sales Ops Contracted vs Budget Individual | |
US Real Estate Sales | Closed Won by DMA | Sales Ops Opportunities | |
US Real Estate Sales | Contracted Buildings by Opportunity Type | Sales Ops Opportunities | |
US Real Estate Sales | Contracted Buildings by Source | Sales Ops Opportunities | |
US Real Estate Sales | Elevator vs. Lobby | Sales Ops Opportunities | |
US Real Estate Sales | US Gross Pipeline | Sales Ops Opportunities | |
US Real Estate Sales | US Weighted Pipeline | Sales Ops Opportunities | |
US Real Estate Sales | US All Time Pipeline (by Source) | Sales Ops Opportunities | |
US Real Estate Sales | Listed Active Pipeline | Sales Ops Opportunities | |
US Real Estate Sales | Leads Created this Month: Status | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Leads Created this Month | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Converted to Pipeline | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Conversion Ratio | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Leads Insight: Created YTD | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Leads Created YTD | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Converted to Pipeline | RE Sales Ops Customers / Entities | |
US Real Estate Sales | Conversion Ration YTD | RE Sales Ops Customers / Entities | |
CAN Real Estate Sales | Real Estate Revenue vs Budget | RE Sales Revenue vs [Static] Budget | |
CAN Real Estate Sales | Monthly Progress to Budget | Sales Ops Contracted vs Budget | |
CAN Real Estate Sales | Quarterly Progress to Budget | Sales Ops Contracted vs Budget | |
CAN Real Estate Sales | Full Year Progress to Budget | Sales Ops Contracted vs Budget | |
CAN Real Estate Sales | Attainment to Quota | Sales Ops Contracted vs Budget Individual | |
CAN Real Estate Sales | Closed Displays - Elevator vs. Lobby | Sales Ops Opportunities | |
CAN Real Estate Sales | Closed Displays by Opportunity Type | Sales Ops Opportunities | |
CAN Real Estate Sales | Closed Won by Property Manager | Sales Ops Opportunities | |
CAN Real Estate Sales | Closed Won Displays by DMA | Sales Ops Opportunities | |
CAN Real Estate Sales | Active Forecasting Pipeline (by DMA) | Sales Ops Opportunities | |
CAN Real Estate Sales | Gross Pipeline | Sales Ops Opportunities | |
CAN Real Estate Sales | Weighted Pipeline | Sales Ops Opportunities | |
CAN Real Estate Sales | CAN All Time Pipeline (by Source) | Sales Ops Opportunities | |
CAN Real Estate Sales | Listed Active Pipeline | Sales Ops Opportunities | |
Lead Gen Dashboard | Lead Gen Meetings by Week | Sales Ops Meetings | |
Lead Gen Dashboard | Team Monthly Meetings | Sales Ops Meetings | |
Lead Gen Dashboard | Team Monthly Meetings by Rep | Sales Ops Meetings | |
Lead Gen Dashboard | Team Quarterly Meetings | Sales Ops Meetings | |
Lead Gen Dashboard | LG Meetings Set by Rep (YTD) | Sales Ops Meetings | |
Lead Gen Dashboard | Weekly SQL's | NetSuite Contacts | |
Lead Gen Dashboard | Weekly SQL's by Rep | NetSuite Contacts | |
Lead Gen Dashboard | Monthly SQL's (YTD) | NetSuite Contacts | |
Lead Gen Dashboard | Quarterly SQL's (YTD) | NetSuite Contacts | |
Lead Gen Dashboard | Yearly SQL's by Rep | NetSuite Contacts | |
Lead Gen Dashboard | Sunny Tasks | Sales Ops Meetings | |
Lead Gen Dashboard | Ashley Tasks | Sales Ops Meetings | |
Lead Gen Dashboard | Maria Tasks | Sales Ops Meetings | |
Lead Gen Dashboard | Sunny Tasks by Rep | Sales Ops Meetings | |
Lead Gen Dashboard | Ashley Tasks by Rep | Sales Ops Meetings | |
Lead Gen Dashboard | Marya Tasks by Rep | Sales Ops Meetings | |
Lead Gen Dashboard | Sunny Tasks by Region | NetSuite Contacts | |
Lead Gen Dashboard | Maria Tasks by Region | NetSuite Contacts | |
Lead Gen Dashboard | Ashley Tasks by Region | NetSuite Contacts | |
Lead Gen Dashboard | Quarantined Buildings by Month | NetSuite Contacts | |
Lead Gen Dashboard | Active Opportunities by Source (U.S.) | NetSuite Contacts | |
Lead Gen Dashboard | Active Lead Gen Opportunities by Type | NetSuite Contacts | |
Lead Gen Dashboard | Lead Generation Pipeline | NetSuite Contacts | |
Lead Gen Dashboard | YTD Lead Generation Pipeline | NetSuite Contacts | |
Lead Gen Dashboard | Closed Lead Gen Opportunities by Type (YTD) | NetSuite Contacts | |
Lead Gen Dashboard | Closed Lead Gen Opportunities by Type (All-time) | NetSuite Contacts | |
Lead Gen Dashboard | Lead Gen Meetings to Win Funnel | Sales Ops Pipeline Funnel | |
Lead Gen Dashboard | Stage 5 Opps with SQL (NEGATIVE) | NetSuite Contacts | |
Lead Gen Dashboard | Craig Tasks | Sales Ops Meetings | |
Lead Gen Dashboard | Stage 1-4 Opps without an SQL Form (NEGATIVE) | NetSuite Contacts | |
Lead Gen Dashboard | SQL With No Sales Rep Name on Opp | NetSuite Contacts | |
Lead Gen Dashboard | Monthly SQL's by Rep | NetSuite Contacts | |
Lead Gen Dashboard | Closer Opps by Type - Closed YTD | NetSuite Contacts | |
Lead Gen Dashboard | Closed Lead Gen Opportunities by Type (YTD) | NetSuite Contacts | |
Operations Tiles | Projects Created YTD | Field Ops NetSuite Projects | |
Operations Tiles | Projects Started YTD | Field Ops NetSuite Projects | |
Operations Tiles | Projects Closed YTD | Field Ops NetSuite Projects | |
Operations Tiles | Backlog Revenue by Project Type | RE Sales Ops Customers / Entities | |
Operations Tiles | Project Type Created YTD | Field Ops NetSUite Projects | |
Operations Tiles | Backlog MMR by Category | RE Sales Ops Customers / Entities | |
Operations Tiles | Closed MRR by Category | RE Sales Ops Customers / Entities | |
Operations Tiles | Value Per Project - Ctrl vs UnCtrl | RE Sales Ops Customers / Entities | |
Operations Tiles | Project Revenue by PM | RE Sales Ops Customers / Entities | |
Operations Tiles | Avg Duration by Type | RE Sales Ops Customers / Entities | |
Operations Tiles | Revenue for Closed Projects | RE Sales Ops Customers / Entities | |
Operations Tiles | Avg. Duration by Type | RE Sales Ops Customers / Entities | |
Operations Tiles | Projects Completed / Month | RE Sales Ops Customers / Entities | |
Operations Tiles | Monthly New MRR | RE Sales Ops Customers / Entities | |
Operations Tiles | Square Ft. Added YTD | RE Sales Ops Customers / Entities | |
Operations Tiles | Closed Projects YTD by Type | RE Sales Ops Customers / Entities | |
Operations Tiles | Installed Displays / Month | RE Sales Ops Customers / Entities | |
Operations Tiles | Closed Projects YTD by PM | RE Sales Ops Customers / Entities | |
Operations Tiles | Market Upgrades | RE Sales Ops Customers / Entities | |
Operations Tiles | Market Expansion (Net-New Installs) | RE Sales Ops Customers / Entities | |
Operations Tiles | Backlog by DMA | RE Sales Ops Customers / Entities | |
Operations Tiles | Backlog by Type | RE Sales Ops Customers / Entities | |
Operations Dash - US | Completed Projects YTD | RE Sales Ops Customers / Entities | |
Operations Dash - US | Displays Installed YTD | RE Sales Ops Customers / Entities | |
Operations Dash - US | Net-New Sq Ft YTD | RE Sales Ops Customers / Entities | |
Operations Dash - US | Net-New Displays | RE Sales Ops Customers / Entities | |
Operations Dash - US | Displays Upgraded | RE Sales Ops Customers / Entities | |
Operations Dash - US | Display Type | RE Sales Ops Customers / Entities | |
Operations Dash - US | Completed Project Types | RE Sales Ops Customers / Entities | |
Operations Dash - US | Renewal Vs Growth | RE Sales Ops Customers / Entities | |
Operations Dash - US | Installed Displays / Month | RE Sales Ops Customers / Entities | |
Operations Dash - US | Avg Displays / Month | RE Sales Ops Customers / Entities | |
Operations Dash - US | Installations Year-to-Date | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backglog: Projects | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Total Displays | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Total Square Feet | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Display Upgrade | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Net-New Displays | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Display Type | RE Sales Ops Customers / Entities | |
Operations Dash - US | Display Backlog by Project Type | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog: Displays | RE Sales Ops Customers / Entities | |
Operations Dash - US | Backlog Additions YTD | RE Sales Ops Customers / Entities | |
Operations Dash - US | Avg. Backlog Add/ Mo | RE Sales Ops Customers / Entities | |
Operations Dash - US | Operations Backlog | RE Sales Ops Customers / Entities | |
Canada Backlog MRR | RE Sales Ops Customers / Entities | ||
US Backlog MRR | RE Sales Ops Customers / Entities |