ROI by Campaign custom report

With this report, you can calculate your return on investment by campaign to see which marketing channels are the most cost-effective for your business using tracked deals in HubSpot.

Getting started

We pull deals from HubSpot as the revenue amount to match with attribution in CallRail for ROI calculations. In order to use this report, you'll need:

1. An active website pool.
2. An active HubSpot integration.
3. An active HubSpot subscription where you're tracking deals in HubSpot.
4. At least one active integration with an ad network (Google Ads, Facebook, Microsoft Advertising).

Need to print, export, or save a report? You can follow the instructions in this article to do so.

Important: Set up for lead Rrporting 

This report will automatically pull any campaign data available in CallRail via your ad network integrations. In order to get the most accurate data for this report, make sure to integrate CallRail with Google Ads, Facebook, or Microsoft Advertising and ensure the correct tracking templates are applied for Facebook and Microsoft Advertising using the articles below. Google Ads will automatically have tracking assigned via the integration.

How to integrate with Google Ads.
Set up Microsoft Advertising tracking templates for lead reporting.
Set up Facebook tracking templates for lead reporting.

Create an ROI by Campaign report 

1. Select Analytics on the left navigation bar.
   
   
2. Select Reports at the top of the page.
   
   
3. Click on Create Report from the Custom header on the left.
   
   
4. Select ROI by Campaign and click Create Report.
   
   
5. The report initially loads with a list of campaigns organized by ROI, with the total amounts for cost, revenue, and customer count for all selected campaigns bolded at the top. Each column displays an aggregated total of the different types of campaigns (organized by color), the source associated with the campaign, the cost per campaign, revenue, customer count, and ROI.
   
   
   
   
6. To add additional sources to your lead reporting, click on the Manage Spend button.
   
   Use this article to add or edit sources for lead reporting.
   
   
7. This report automatically saves once it's created. 

Filter your ROI report 

Filter your ROI report to drill down to specific data. 

1. Use the filter panel at the top of the report to change the data you're viewing.
   
   - Use the company drop-down to choose which companies should be on this report. You can select as many or as few as you'd like.
   
   - Use the date range drop-down to select the timeframe for the cost per qualified lead you'd like to see on this report.
   
   - Use the attribution drop-down to select the attribution model you'd like to see on this report. Your report initially loads with the 50/50 Model selected, but you can change models anytime.
   
   Read about attribution models and how to use them.
   
   - Use the keyword/ad ID drop-down to select whether you'd like to see your data down to the keyword or ad ID for your campaigns.

FAQ

Why don't I see revenue or ROI calculations in my report? 

If you're not seeing ROI or revenue it might be that you don't have any closed (won) deals for that timeframe. Our ROI report only matches contacts that have called one of your call tracking numbers at least once and matches it with closed deals in your HubSpot account. We don't pull in ROI data for deals that aren't in the close (won) state or contacts that have not interacted with any CallRail tracking numbers or form tracking submissions.

Read this HubSpot article for more information on deal stages.