Connect CallRail to Power BI

Connect CallRail in Catchr using the account API key. In Catchr’s Power BI query builder, select call ID, start time, source, duration and lead status and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping individual call IDs and the distinction between calls and qualified leads clear in the model.

Catchr exposes call records with call IDs, timestamps, duration, direction, answer and voicemail information, marketing source, tracking number, campaign parameters, tags, and lead status where available. These fields let you compare sources by the calls they generate. Keep a unique call ID in detailed tables so repeated rows do not inflate totals.

No. A call record, a first-time caller, and a qualified lead are different measures. Use the first-call field to identify a caller’s first call to the company and the lead-status field to distinguish scored leads from other calls. An unanswered call or a long call is not automatically a qualified lead.

Yes. Use the call answer and voicemail fields, together with direction, to define the groups you want to compare. Keep inbound and outbound calls separate when evaluating response performance. Apply the same classification as your CallRail report instead of assuming every call without an answered flag belongs in the same category.

Those details depend on the tracking setup and the information available for the caller. Website session trackers can provide landing pages, campaign parameters, and click identifiers, while keywords are only available for supported paid sources. A blank keyword does not mean the call had no marketing source; inspect the tracker and attribution fields together.

Match the account or company, time zone, date range, call direction, tracker, and lead-status filters first. Count distinct call IDs when a join or tag breakdown can repeat records. Do not sum a caller’s total-calls field across individual call rows, because that repeats a caller-level count.

Yes. Add Google Ads spending and map the relevant campaigns to CallRail’s tracking data. Aggregate both sources to compatible dates and campaign keys before creating relationships. Divide spend by the lead measure you have defined, such as qualified inbound leads, and keep it distinct from cost per call or Google Ads’ own attributed conversions.