BKY Data Consulting
Live demo
Built for your HubSpot setup

Advocacy Outreach Performance

See how your outreach efforts are performing and where new partnerships are forming. Live demo on synthetic data.

Hi Leapcure team — here's a working demo I built for your advocacy outreach process; click anything, every number is live from the sample data below.

Organizations Contacted
20
▲ last 30 days
Response Rate
55%
▲ last 30 days
New Partnerships Started
11
▲ last 30 days
Avg. Response Time
3.8 days
▼ for responded

What I can do for you

Exactly what I'd take off your plate on this project — in plain English.

Build targeted outreach lists
Research and compile precise lists of patient advocacy groups, community organizations, and key leaders by condition and location. (My skill: Data cleaning / dedup / migration, Python (pandas))
Manage and track all outreach
Set up and maintain your system for sending and tracking emails, social media messages, and contact form submissions, ensuring clean response tracking. (My skill: CRMs: HubSpot setup, custom fields, pipelines)
Automate follow-ups and notifications
Set up automatic reminders for follow-ups and instantly notify your team when a key organization responds. (My skill: Automation & APIs: HubSpot API + webhooks, n8n / Make / Zapier, Slack/email notifications)
Keep your contact data clean
Find and fix duplicate entries, standardize names and addresses, and ensure all your contact information is accurate and complete. (My skill: Data cleaning / dedup / migration, Python (pandas))
Create compelling outreach materials
Assemble and format presentation decks, case studies, and one-pagers using your existing templates to clearly communicate your message. (My skill: Generalist support)

How the data flows

Define Outreach Goals
Discovery Call
Understand your specific needs for advocacy outreach, target conditions, and desired partnership outcomes.
HubSpot Setup & Customization
HubSpot CRM
Configure HubSpot with custom fields and pipelines to accurately track advocacy organizations, contacts, and outreach stages.
List Building & Data Import
Python (pandas) · HubSpot API
Research and compile targeted lists of organizations, then import and clean this data directly into HubSpot.
Outreach Automation & Tracking
HubSpot API · n8n / Make / Zapier
Set up automated email sequences, social media tracking, and response monitoring through your CRM and automation tools.
Reporting & Ongoing Support
HubSpot Reporting · Google Sheets
Create custom dashboards and reports to monitor outreach performance and provide ongoing support for your advocacy efforts.

Outreach Status by Condition

This chart shows how many organizations for each medical condition have been contacted, responded, or are in active discussion. It helps you see which areas need more focus or are performing well.

Overall Response Status

This chart shows the percentage of organizations that have responded versus those that haven't yet. It gives a quick overview of how effective your initial outreach is.

Outreach Activity Over Time

This chart tracks the number of new organizations contacted each day. It helps you monitor your team's activity and see trends in your outreach volume.

Workflows I can automate for you

Repetitive work I can put on autopilot using your tools' APIs plus n8n, Zapier & Google Apps Script — so it just happens, hands-off.

Auto-create new advocacy leads
When you find a new advocacy organization, automatically create a new contact and company record in HubSpot from a simple form or spreadsheet. (Tools: Google Sheets API · Google Apps Script · HubSpot API)
Automate cold outreach sequences
Set up automated email sequences to advocacy organizations, personalized with their details, and track opens and clicks directly in HubSpot. (Tools: HubSpot API · HubSpot CRM)
Instant notifications for responses
When an advocacy organization replies to your outreach, instantly notify your team in Slack or via email so you can follow up quickly. (Tools: HubSpot API · n8n / Make / Zapier · Slack/email notifications)
Clean up duplicate contacts automatically
Regularly scan your HubSpot contacts for duplicates and merge them automatically or flag them for review, keeping your lists tidy. (Tools: Python (pandas) · HubSpot API · scheduled jobs (cron))

Recent Advocacy Outreach Details

Org NameConditionGeographyContact EmailOutreach DateResponse StatusPartnership Stage
Diabetes Action NetworkDiabetesNationalsarah.c@dan.org2023-10-01RespondedInitial Discussion
Rare Disease AllianceRare DiseasesUS - Eastmark.j@rda.org2023-10-02No ResponseContacted
Cancer Support Group CAOncologyUS - Westemily.w@csgc.org2023-10-03RespondedFollow-up Scheduled
Heart Health FoundationCardiologyNationaldavid.l@hhf.org2023-10-04RespondedInitial Discussion
Autoimmune Connect UKAutoimmuneUKjessica.b@acu.org2023-10-05No ResponseContacted
Neuro Wellness NetworkNeurologyNationalmichael.g@nwn.org2023-10-06RespondedInitial Discussion
Kidney Care PartnersNephrologyUS - Midwestsophia.d@kcp.org2023-10-07No ResponseContacted
Mental Health AdvocatesMental HealthNationalchris.m@mha.org2023-10-08RespondedFollow-up Scheduled
Digestive Health OrgGastroenterologyUS - Southolivia.w@dho.org2023-10-09No ResponseContacted
Pain Management SupportChronic PainNationalethan.m@pms.org2023-10-10RespondedInitial Discussion

Raw source data

dataset.csv — showing 12 of 20 rows. The dashboard above is computed from this file, untouched.

Org NameConditionGeographyContact NameContact EmailOutreach DateResponse StatusResponse DatePartnership Stage
Diabetes Action NetworkDiabetesNationalSarah Chensarah.c@dan.org2023-10-01Responded2023-10-05Initial Discussion
Rare Disease AllianceRare DiseasesUS - EastMark Johnsonmark.j@rda.org2023-10-02No ResponseContacted
Cancer Support Group CAOncologyUS - WestEmily Whiteemily.w@csgc.org2023-10-03Responded2023-10-06Follow-up Scheduled
Heart Health FoundationCardiologyNationalDavid Leedavid.l@hhf.org2023-10-04Responded2023-10-08Initial Discussion
Autoimmune Connect UKAutoimmuneUKJessica Brownjessica.b@acu.org2023-10-05No ResponseContacted
Neuro Wellness NetworkNeurologyNationalMichael Greenmichael.g@nwn.org2023-10-06Responded2023-10-10Initial Discussion
Kidney Care PartnersNephrologyUS - MidwestSophia Davissophia.d@kcp.org2023-10-07No ResponseContacted
Mental Health AdvocatesMental HealthNationalChris Millerchris.m@mha.org2023-10-08Responded2023-10-11Follow-up Scheduled
Digestive Health OrgGastroenterologyUS - SouthOlivia Wilsonolivia.w@dho.org2023-10-09No ResponseContacted
Pain Management SupportChronic PainNationalEthan Mooreethan.m@pms.org2023-10-10Responded2023-10-12Initial Discussion
Lupus Foundation CAAutoimmuneCanadaAva Taylorava.t@lfc.org2023-10-11No ResponseContacted
Allergy & Asthma NetworkAllergy/AsthmaNationalNoah Clarknoah.c@aan.org2023-10-12Responded2023-10-15Initial Discussion

How this works in production

How I'd set this up on your live system:

Source
HubSpot CRM
Your live advocacy organizations, contacts, and outreach history
Automation
HubSpot API · n8n / Make / Zapier · Google Apps Script
Automating list building, outreach sequences, response tracking, and notifications
Output
HubSpot Dashboards · Slack/Email Notifications · Google Sheets
Real-time insights on outreach performance and instant team alerts

This demo runs on synthetic data.

Ready to streamline your advocacy outreach?

I can set up these systems for your team in just a few weeks.

bing@bkydataconsulting.com