Case studies · Web App Development3 min read
Advanced search for CVCA Intelligence, Canada’s venture capital and private equity data portal
intelligence.cvca.caCVCA Intelligence is where Canada’s venture capital and private equity community looks up deals, funds, exits, companies and investors. Its search only handled simple lookups. We designed and built an advanced search that answers the questions subscribers actually ask, without ever showing data its contributors asked to keep private.
At a glance
- A visual query builder: any number of conditions, AND/OR logic, nested groups and exclusions.
- One search across five types of data: companies, investors, deals, funds and exits.
- Results in under 1.5 seconds, with columns, sorting and paging the subscriber controls.
- Searches shared by link and exported to CSV, within monthly limits.
- Confidential deals and undisclosed values kept out of results, exports and shared links.
- Works on phones as well as desktops.
The client
The Canadian Venture Capital & Private Equity Association (CVCA) is the voice of Canada’s private capital industry. CVCA Intelligence is its subscription data portal: tens of thousands of records on Canadian venture capital and private equity deals, funds, exits, companies and investors, used by investors, analysts and advisors.
The challenge
Subscribers come with precise questions. Something like: “Ontario SaaS companies that raised a Series A over $10M in the last two years from a foreign investor.” The original search couldn’t answer that. It handled simple lookups, one type of record at a time.
- No way to combine several conditions in one search.
- No way to search across companies, investors, deals, funds and exits from one place.
- No way to save, share or export a specific search.
- And whatever replaced it had to keep confidential and partly disclosed data protected, because CVCA’s data contributors depend on it.
What we built
A new advanced search, modelled on the way leading data platforms like Crunchbase work, and built to CVCA’s rules.
A visual query builder
Subscribers build a search by adding conditions, combining them with AND or OR, grouping them, and excluding what they don’t want. The question above becomes a few clicks instead of an email to the CVCA team.
One search, five types of data
Pick companies, investors, deals, funds or exits, and the available fields change to match. No more hunting for the right search page.
Results the way you want them
Choose and reorder the columns, sort by any of them, and page through up to 1,000 results, returned in under 1.5 seconds.
Share it, export it
Every search has a link that reopens it exactly, for any subscriber. Results export to CSV, within monthly limits that protect the data.
Privacy rules, everywhere
Confidential deals and undisclosed values never appear in results, in exports or behind a shared link. The rules contributors rely on apply to every path out of the system.
On a phone, too
The whole experience works on small screens, not just at a desk.
No downtime when the data changes
The search index rebuilds in the background, so data refreshes never interrupt anyone mid-search.
How we worked
The search was scoped and delivered as a defined project, against a written requirements document. That kept a complex tool (interface design, performance, data privacy, mobile and infrastructure) on one agreed plan from the first conversation to launch.
Has your data outgrown its search?
Membership portals and data products tend to start with a search box and grow into something people need to question properly. We design and build the tools that let them, and keep the rules around the data intact.
See our web app development, or tell us about your product.
