ROI by Source Custom Report (Beta)

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

Use this article to learn how to:

  • Create an ROI by Source report
  • Export a report
  • Duplicate a report
  • Delete a report

Getting Started

In order to use this report, you'll need:

We pull deals from HubSpot as the revenue amount to match with attribution in CallRail for ROI calculations.

Set Up Tracking Templates for ROI Reporting

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

How to set up Bing Ads tracking templates for lead reporting.
How to set up Facebook tracking templates for lead reporting.

Create an ROI by Campaign Report 

  1. Select Reports at the top of the page.
  2. Click on Create Report from the Custom list of reports in the left menu.
  3. Select ROI by Source and click Create Report.

    Screen_Shot_2019-06-11_at_3.07.43_PM.png
  4. The report initially loads with a list of your sources in CallRail 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 that source (organized by color), cost of all tracked campaigns for that source, revenue, customer count, and ROI.

    roi_source.png
  5. To add additional sources to your lead reporting, click on the Manage Spend button.

    Screen_Shot_2019-05-09_at_10.31.46_AM.png

    Use this article to add or edit sources for lead reporting.
  6. 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.

    Screen_Shot_2019-06-11_at_3.19.37_PM.png

    • 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. 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.

Export Report

You can export your report to an Excel file. 

  1. Select Export at the top of the table.

    Screen_Shot_2019-02-06_at_11.33.34_AM.png
  2. Choose Excel to download an Excel file of your report. If you choose to export to Excel, your report will include a cover sheet that details the filters you used to create your report.

Duplicating a Custom Report

If you'd like to duplicate a custom report you've created, you can do so at any time.

  1. Select Reports at the top of the page.
  2. Find and click on the report you'd like to duplicate.
  3. Click Duplicate Report within the Report Options drop-down.

    Screen_Shot_2019-03-01_at_1.54.27_PM.png
  4. Confirm that you'd like to duplicate this report by clicking Duplicate.

    Screen_Shot_2019-03-01_at_1.55.55_PM.png

Deleting a Custom Report

If you'd like to delete a custom report you've created, you can remove it from your list at any time.

  1. Select Reports at the top of the page.
  2. Find and click on the report you'd like to delete.
  3. Click Delete Report within the Report Options drop-down.

    Screen_Shot_2019-03-01_at_1.49.01_PM.png
  4. Confirm that you'd like to delete this report by clicking Delete.

    screenshot_1532.png

FAQ

I'm not seeing 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.

Have more questions? Submit a request

Comments