Integration Guide

How to Build Referral Reports and Dashboards in Salesforce with GrowSurf

Name: GrowSurf
Rating: 4.74 (47 reviews)
Author: GrowSurf

Create Salesforce reports and dashboards that visualize your referral program's pipeline impact and ROI.

Data without visualization is just noise. Once your GrowSurf referral data flows into Salesforce, you need reports and dashboards that turn that data into actionable insights. The right dashboard helps you spot trends, identify top referrers, measure pipeline contribution, and prove ROI to executives.

This guide walks you through building a comprehensive referral program dashboard in Salesforce. You'll create reports covering lead volume, conversion funnel metrics, revenue attribution, top referrer leaderboards, and program ROI — all powered by the GrowSurf referral data synced to your Salesforce org.

Integration Steps

Step 1: Create the Core Referral Lead Report

Build the foundational report that tracks all referral-sourced leads and their progression through your pipeline.

Go to Reports > New Report and select "Leads" report type
Add filter: Referral_Source__c equals "GrowSurf"
Add columns: Name, Email, Referred_By__c, Lead Status, Created Date, Last Activity Date
Group by Lead Status to see the referral funnel
Add a row count summary to show total leads per status
Save as "Referral Leads by Status"

Step 2: Build a Referral Conversion Funnel Report

Track conversion rates at each stage of your referral funnel.

Create a report using "Leads with converted lead information" report type
Filter by Referral_Source__c = "GrowSurf"
Add columns: Total Leads, Qualified Leads, Converted Leads, Opportunities Created
Use summary formulas to calculate conversion rates between stages
Compare month-over-month to track program health trends

Step 3: Create a Top Referrers Leaderboard Report

Identify your most active and effective referrers to reward them and understand what makes them successful.

Create a report using "Leads" report type
Group by Referred_By__c (referrer email)
Add row count as summary to show referrals per referrer
Sort descending by referral count
Add a cross-filter to count how many of each referrer's leads converted
Save as "Top Referrers Leaderboard"

Step 4: Build the Revenue Attribution Report

Track actual revenue generated from referral-sourced opportunities.

Use "Opportunities with Campaign" report type filtered to your referral campaign
Add columns: Opportunity Name, Amount, Stage, Close Date, Campaign Source
Summarize Amount by Stage to see pipeline value at each stage
Add a summary formula for total won revenue from referrals
Compare referral revenue to total revenue for share-of-pipeline calculation

Step 5: Calculate and Display Program ROI

Build a report that calculates the return on investment of your referral program.

Create a custom report type joining Campaigns and Opportunities if needed
Calculate: Total Referral Revenue (sum of Closed Won amount from referral campaign)
Calculate: Total Program Cost (rewards paid + platform cost + development time)
ROI formula: ((Revenue - Cost) / Cost) * 100
Display this as a single KPI metric on your dashboard

Step 6: Assemble the Referral Program Dashboard

Combine all reports into a single dashboard that tells the complete referral program story.

Go to Dashboards > New Dashboard and name it "Referral Program Performance"
Add components:
- Funnel chart: Referral leads by status
- Table: Top 10 referrers with referral count and conversion count
- Metric: Total referral pipeline value
- Metric: Referral program ROI percentage
- Line chart: Monthly referral lead volume trend
- Donut chart: Referral leads vs. other lead sources
Set dashboard to auto-refresh daily
Share with marketing and sales leadership

Code Snippets

// Salesforce SOQL queries for referral reports

// 1. Referral leads by status
const leadsByStatus = `
  SELECT Status, COUNT(Id) leadCount
  FROM Lead
  WHERE Referral_Source__c = 'GrowSurf'
  GROUP BY Status
  ORDER BY COUNT(Id) DESC
`;

// 2. Top referrers leaderboard
const topReferrers = `
  SELECT Referred_By__c, COUNT(Id) referralCount,
    SUM(CASE WHEN IsConverted = true THEN 1 ELSE 0 END) convertedCount
  FROM Lead
  WHERE Referral_Source__c = 'GrowSurf'
    AND Referred_By__c != null
  GROUP BY Referred_By__c
  ORDER BY COUNT(Id) DESC
  LIMIT 20
`;

// 3. Referral revenue attribution
const referralRevenue = `
  SELECT SUM(Amount) totalRevenue, COUNT(Id) dealCount,
    AVG(Amount) avgDealSize
  FROM Opportunity
  WHERE Campaign.Name LIKE '%GrowSurf%'
    AND StageName = 'Closed Won'
`;

// 4. Monthly referral trend
const monthlyTrend = `
  SELECT CALENDAR_MONTH(CreatedDate) month,
    CALENDAR_YEAR(CreatedDate) year,
    COUNT(Id) leadCount
  FROM Lead
  WHERE Referral_Source__c = 'GrowSurf'
    AND CreatedDate = LAST_N_MONTHS:12
  GROUP BY CALENDAR_MONTH(CreatedDate), CALENDAR_YEAR(CreatedDate)
  ORDER BY CALENDAR_YEAR(CreatedDate), CALENDAR_MONTH(CreatedDate)
`;

Tips

Schedule Weekly Report Emails to Stakeholders

Set up scheduled report subscriptions in Salesforce to automatically email the referral program dashboard to marketing and sales leadership every Monday morning. This keeps the program top-of-mind and ensures stakeholders see results without having to log in.

Add Comparison Benchmarks to Your Dashboard

Don't show referral metrics in isolation — always compare against other lead sources. Show referral conversion rate next to your average conversion rate, referral deal size vs. overall average, and referral time-to-close vs. other channels. This context makes the data actionable.

Use Dashboard Filters for Dynamic Analysis

Add dashboard filters for date range, referral campaign, and referrer so users can slice the data without creating new reports. This makes one dashboard serve multiple use cases and reduces report maintenance.

FAQ

Can I embed Salesforce referral reports in other tools like Slack or email?

Yes. Salesforce supports scheduled report exports via email and integrations with Slack through Salesforce for Slack. You can also use Salesforce's Analytics API to pull report data into external dashboards or BI tools.

How often should I review referral program metrics in Salesforce?

Review the dashboard weekly for operational metrics (lead volume, conversion rates, top referrers) and monthly for strategic metrics (ROI, revenue attribution, program trends). Quarterly reviews should include cohort analysis and comparison against program targets.

What if I need to report on referral data that spans multiple Salesforce objects?

Create custom report types that join Leads, Contacts, Opportunities, and Campaign Members. Go to Setup > Report Types > New Custom Report Type and define relationships between objects. This lets you build cross-object reports that trace the full referral journey from lead to revenue.

GrowSurf for Startups Program

Startups get a 50% discount

GrowSurf Deals

Get $234k+ In Software Savings

LoyaltySurf

Reward Your Customers For Their Loyalty

Startup Growth Tactics Quiz

How to Build Referral Reports and Dashboards in Salesforce with GrowSurf

Integration Steps

Step 1: Create the Core Referral Lead Report

Step 2: Build a Referral Conversion Funnel Report

Step 3: Create a Top Referrers Leaderboard Report

Step 4: Build the Revenue Attribution Report

Step 5: Calculate and Display Program ROI

Step 6: Assemble the Referral Program Dashboard

Code Snippets

Tips

Schedule Weekly Report Emails to Stakeholders

Add Comparison Benchmarks to Your Dashboard

Use Dashboard Filters for Dynamic Analysis

FAQ

Can I embed Salesforce referral reports in other tools like Slack or email?

How often should I review referral program metrics in Salesforce?

What if I need to report on referral data that spans multiple Salesforce objects?

Unlock the power of word-of-mouth marketing anddeepen your bond with customers

Set up your refer a friend program with customer referral and affiliate program software that lowers your acquisition costs, increases customer loyalty, and saves you gobs of time.

Built for startups,scaled for unicorns

View GrowSurfCustomer Examples

Unlock the power of word-of-mouth marketing and
deepen your bond with customers

Built for startups,
scaled for unicorns

View GrowSurf
Customer Examples