How BridgeBI builds this number

BridgeBI counts leads from the union of two Velocify exports, #1009 (Incoming Leads by Date Added) and #1008 (Incoming Leads by Inquiry), merged by Lead ID. The 1009 captures every NEW lead (Date Added inside the window). The 1008 captures RELEADS (leads created before the window that re-inquired inside it, with Date Added as far back as 2003). Together they cover the same New + Relead population PowerBI reports. Rows are deduped by Lead ID so one lead equals one count, and the window is applied on Inquiry Date to match PowerBI's filter. Campus-to-division follows the PowerBI-aligned rules (PR Campus, NU TEC, NU Online, CCU, Continuing Education).

Why the numbers differ

PowerBI's pipeline joins Velocify to additional sources (SIS and other report views), so it carries a small set of leads that appear in NEITHER the 1009 nor the 1008 export. That residual, typically 3% to 4%, is the entire gap. It is not a BridgeBI under-count; it is data PowerBI has that Velocify does not surface in these two exports.

Why BridgeBI is the more trustworthy source

• Auditable to the row. Every lead resolves to a Velocify Lead ID you can open and verify. PowerBI's number is a black box; you cannot drill to the row behind it.
• Built from exports you control. BridgeBI uses the exact Velocify 1009 + 1008 files you can re-pull any time. PowerBI's joins sit downstream and opaque.
• The gap is explainable. The residual is documented and bounded. PowerBI's inflation source is not; it just shows up bigger with no breakdown.
• Apples-to-apples on the overlap. BridgeBI applies PowerBI-aligned division rules, so the 96% to 97% that overlaps compares cleanly. Same definitions, same window, same Lead ID.
• Defensible in any meeting. When leadership asks why the number is different, BridgeBI has the answer down to the lead. PowerBI has "the pipeline did it."