Affinity connector

Use your Affinity data for reporting, automation and AI.

Data Panda brings your Affinity data together with the data from the rest of your firm. From one place, we turn it into dashboards, automations, AI workflows and custom apps your investment team uses every day.

Data Panda Reporting Automation AI Apps
Affinity logo
About Affinity

The CRM where the relationship graph is the deal flow.

Affinity is a San Francisco company founded in 2014 by Ray Zhou and Shubham Goel, two Stanford grads who built a CRM for the work that does not look like a B2B sales funnel: venture capital, private equity, investment banking, family offices and corporate development. Customers on its own site include Bain Capital, Bessemer Venture Partners, Kleiner Perkins, Lightspeed Venture Partners and BlackRock.

The pitch is relationship intelligence. Affinity reads the firm's email and calendar headers (not the message bodies) to auto-build the contact and organisation graph: who at the firm has met which founder, banker or operator, how recently, and how warm that thread looks. Lists, opportunities, custom fields and notes sit on top of that graph so partners can run a deal book, a coverage list or a portfolio tracker without retyping who introduced them to whom three months ago.

The point of pulling Affinity into a warehouse is that an investment firm's data lives in pieces a sales CRM never has to think about: the fund accounting system, the LP reporting tool, the portfolio company KPIs, the PitchBook or Crunchbase enrichment feed, the data room. Affinity knows the relationship side of every deal. It does not know the cap table, the IC memo or the quarterly mark. Those answers only appear when the relationship graph and opportunity stages sit next to fund admin, portfolio metrics and external market data on the same row.

What your Affinity data is for

What you get once Affinity is connected.

Deal flow on one record

Affinity opportunities, lists and relationship signals joined to fund admin and portfolio metrics.

  • Pipeline by partner, sector and stage, with median days at each stage flagged
  • Warm-intro coverage per target list, so dead lists get cut before the next quarter
  • Closed deals matched to fund accounting entries and committed capital

Deal-team automation

Let Affinity records drive the rest of the firm's stack instead of polling it by hand.

  • New opportunity in Affinity creates the data-room folder and IC checklist
  • Stage move to term sheet posts a scoped Slack alert to the deal team
  • PitchBook or Crunchbase signal on a watchlist company writes back as an Affinity note

AI workflows

Use the firm's own meeting and email graph to score deals and surface drift.

  • Warmth-decay scoring on coverage relationships that have not been touched in twelve weeks
  • Sourcing-channel attribution for deals that closed, not deals that took a meeting
  • Founder-fit scoring trained on the deals the firm invested in over five years

Custom apps on your data

Internal tools partners and IR ask for that Affinity's in-app lists do not quite cover.

  • IC packets pulling Affinity opportunity history, founder thread and portfolio overlap onto one page
  • LP reporting view tied to fund admin numbers, not screenshots
  • Portfolio company tracker mixing Affinity contacts, KPI uploads and follow-on deal stage
Use cases

Use cases we deliver with Affinity data.

A list of concrete reports, automations and AI features we have built on Affinity data. Pick the one that matches your situation.

Pipeline by partnerLive deal stage per partner, sector and check size over the trailing four quarters.
Warm-intro coverageWhich target list has a path through the firm's network and which is cold.
Relationship-warmth decayCoverage contacts not touched in twelve weeks, ranked by past deal value.
Sourcing attributionWhich channel produced the deals that closed, not the deals that took a first meeting.
Stage stagnationOpportunities sitting twice their stage median, surfaced before the IC review.
List playbook healthWhich Affinity lists drive deal flow, which quietly drift into a graveyard.
Founder-fit scoringTrained on the deals the firm invested in across five years, not on a wishlist.
IC packet assemblyAffinity history, portfolio overlap and PitchBook context on one packet page.
Portfolio follow-on viewExisting portfolio companies tracked through new rounds with Affinity stage and notes.
LP-friendly deal logClosed deals reconciled with fund accounting, ready for the LP update.
Coverage cleanupDuplicate organisations, contacts who left their fund or company, lapsed bankers.
Co-investor mapWho the firm syndicated with last and who keeps showing up on the same cap table.
Real business questions

Answers you will finally get.

Which warm intros closed a round?

Affinity opportunities tagged with the introducing contact and source list, joined to the deals that reached funded close in the fund administration system. The firm sees which referral path produces investments and which produces nothing but coffee meetings, ranked per partner and per fund vintage.

Which coverage relationships went cold this quarter?

People and organisations on coverage lists with no email, meeting or note from anyone at the firm in the last twelve weeks, ranked by past deal value and by relationship warmth at peak. Partners get a short list of relationships worth re-warming before the next deal, instead of a full address book.

Which deals are stuck in the same Affinity stage past their own median?

Opportunities sitting twice as long as the median time the firm spends in that stage for that sector and check size, surfaced before the IC review. Stage stagnation gets flagged on the deal team, not discovered when the partner pulls the pipeline export the night before the meeting.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Closed Affinity deals reconciled against committed and called capital in the fund administration tool, with vintage, fund and partner visible on the same line. LP updates and IC packets pull from the same number, so the closed-deal narrative does not change between the deal team and the back office.

For sales leaders

Pipeline coverage, warm-intro reach and stage velocity per partner, alongside the deals that closed and the relationships that went cold. Partner reviews move from list anecdotes to a concrete view of who is sourcing, who is closing and which coverage threads need attention this month.

For operations

List hygiene, duplicate organisations, contacts who changed jobs and Affinity custom-field fill rate on one dashboard. Data work gets prioritised on the lists the partners run a deal book against, not on whichever field is blank.

Ideas

What you can automate with Affinity.

Pair with PitchBook

Layer PitchBook market signals onto Affinity opportunities

PitchBook valuations, round history and competitor moves are matched onto the Affinity opportunity and parent organisation. Partners see the latest priced round, the cap table and similar-stage benchmarks next to the firm's own thread with the founder, so the IC conversation starts from a current market picture instead of last quarter's note.

Pair with Slack

Fire scoped Slack alerts on Affinity stage changes

Stage moves, term-sheet signs and stalled opportunities in Affinity push a targeted Slack message to the deal owner, the sector channel or the IC channel. Partners stop relying on a Monday pipeline export and the team sees the deal that needs attention this afternoon, not next week.

Pair with Salesforce

Sync Affinity deal flow with a parallel Salesforce instance

For firms that run Affinity for the partner deal book and Salesforce for an adjacent business unit (advisory, fund administration, banking coverage), the two systems stay aligned on contacts, organisations and deal stage. Records that get touched in either place reconcile on the warehouse side, so reporting does not have to pick a winner and account ownership stays clean.

Pair with Notion

Push Affinity opportunities into the Notion deal-room workspace

When an Affinity opportunity moves to active diligence, a structured Notion page is created with the founder thread, list context and IC checklist. Diligence notes and decisions in Notion flow back as Affinity notes on the same opportunity, so the partner who looks up the deal six months later sees both sides instead of a half-empty CRM record.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Affinity data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Affinity to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Affinity connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Do you pull the Affinity relationship graph and interactions, or only the standard objects?

Both. Persons, Organizations, Opportunities, Lists, Notes and custom fields land as first-class tables. The interaction history that powers Affinity's relationship intelligence (who at the firm met which contact, when, and via which channel) lands as a separate table that can be joined back to any organisation or opportunity. Email and calendar bodies are not synced; only the metadata Affinity itself reads.

What about the custom fields a partner adds to a deal list?

Custom fields on Affinity lists, organisations and opportunities are read through the same API and land as columns alongside the standard schema. Renames and new fields appear on the next sync, so a coverage tracker the firm reshapes mid-quarter does not lose history when the warehouse refreshes.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Affinity setup and the systems around it. Together we pick the first thing worth building.