How RevPartners Created an Automation Process for The Real Deal

Hours of Manual Work per Week Saved

Source of Truth for the Sales Team

Spreadsheets

Customer Info

The Real Deal is the leading real estate news outlet in the US offering digital, print, social media and events. This media company operates through magazine subscriptions, marketing-related services and others to bring the real estate professionals prime information and data specific to the industry.

Full-cycle sales representatives focus on inbound leads, renewals and upsells.
Their 1-stage process focuses on inbound lead management.

Overview

Find out how RevPartners saved The Real Deal’s finance team over 40 hours of manual work each week.

The Challenge

Non-existent CRM where the database was spread out along multiple sheets

Needed to consolidate operations in a way that would free up the team’s time but remain accurate.

Management needed a reliable forecasting tool that would allow a view into sold amounts and revenue amounts.

Reporting by product was not enabled anywhere outside of spreadsheets and forecasting was tedious.

The biggest hurdle was implementing flight schedules into the HubSpot Instance

Flight schedules is the term used for the specific media service purchased by each client.
Each service is delineated by market and month it is running.
The flight schedules are, ultimately, how the company recognizes revenue and there is a need to know the amount closed versus the amount of revenue.

The Solution

Migration

Migrated the entire operation over to HubSpot, allowing management to decide the sales team’s ownership of portfolio, new lead distribution and deal customization based on specific sales cycles.

Flight Schedules

Automated the creation of flight schedules for each deal according to the detailed criteria added at the line item level.
Created a custom object for Flight Schedules in order to accurately and automatically track the services due to each client any given month.
Through Make.com created a formula-based integration that calculates the number of flight schedules for any combination of line item + month, resulting in the auto creation of a custom record to track delivery of the service.

Reporting

Year-over-year reporting trends on sold amounts versus revenue amounts.
Sales forecasting dashboard to track activity and sold amounts by product.

The Impact

Better Visibility & Team Performance

The management team has visibility into sales trends, activity and forecasting by product, which allows them to view gaps and properly strategize to meet goals.
Management is also able to better gauge team performance at a glance, without having to review multiple spreadsheets at a time.

Single Source of Truth

The sales team has a single source of truth where they can see their performance, amount sold, revenue and ultimately, understand goal attainment in real time.

Automation

Flight schedules used to be created manually - sometimes dozens per deal - and gave way to a lot of human error. Now the automatic creation of flight schedules has freed up the finance team’s time to focus on account payables and receivables.