Call Rail Leads in HubSpot

[DZoladz33]

Hello. I have a B2C client that a majority of their leads are from inbound phone calls from their campaigns. They use CallRail for there analytics. CallRail is integrated to their HubSpot instance but there is an issue in the ad campaigns. The ad campaigns' analytics do not show the CallRail phone-in leads, just the form fills. I'd like to calculate the cost per lead for the Call Rail telephone lead created in Contacts, down to the Ad Group level. It would be a simple process if HubSpot had the total ad spend in an object. Has anyone experienced this scenario? If so what work-around did you come up with? I'm not a Google Ads expert but I've read about creating ad conversion events but I don't know if that will solve the issue and show the phone-in leads. Thanks for the assistance.

[DZoladz33]

Hello @himanshurauthan  and thank you for the feedback. Yes CallRail and HubSpot are integrated so the leads data is showing in HubSpot. I had a feeling that was the method. I assume you have successfully implemented this, correct? Regarding the custom properties did you add those in the Contacts object? Or to a Custom Object? For the Google Ads API I assume these are the resources I will need to fetch in order to adequately present cost per lead down to the ad group level;

Account.id

Account.name

Campaign.id

Campaign.name
Campaign.status
ad_group.id

ad_group.name

segment.ad_network_type
metrics.clicks
metrics.ctr

metrics.average_cpe
metrics.average_cost

metrics.impressions
metrics.engagements

metrics.average_cpc
metrics.cost_micros (divide by 1,000,000 for Ad spend)

Thank you again Himanshu for you assistance.

[himanshurauthan · Accepted solution]

Hello @DZoladz33 
Make sure you have connected your Call Rail account to HubSpot and make sure that your Call Rail call data is being synced with HubSpot Contac. Then create custom properties in HubSpot to store the ad spend and cost per lead information. And use Google Ads API to fetch the ad spend data at the Ad Group level and push it to the corresponding custom property in HubSpot.  create a report or dashboard that shows the total ad spend, total number of leads (including phone-in leads from Call Rail), and the cost per lead.You can do this by dividing the total ad spend by the total number of leads. 

and do not forget to update the report or dashboard on a regular basis to reflect the latest ad spend and lead data.

Thanks & Regards 
Himanshu Rauthan

[DZoladz33]

Hello @himanshurauthan and thank you for the feedback. Yes CallRail and HubSpot are integrated so the leads data is showing in HubSpot. I had a feeling that was the method. I assume you have successfully implemented this, correct? Regarding the custom properties did you add those in the Contacts object? Or to a Custom Object? For the Google Ads API I assume these are the resources I will need to fetch in order to adequately present cost per lead down to the ad group level;

Account.id

Account.name

Campaign.id

Campaign.name
Campaign.status
ad_group.id

ad_group.name

segment.ad_network_type
metrics.clicks
metrics.ctr

metrics.average_cpe
metrics.average_cost

metrics.impressions
metrics.engagements

metrics.average_cpc
metrics.cost_micros (divide by 1,000,000 for Ad spend)

Thank you again Himanshu for you assistance.