Attendee Enrichment & CRM Pipeline
A conversational / social-engagement platform
Overview
A data-enrichment pipeline that turns a raw event guest list into a rich, CRM-ready dataset. It researches each attendee across web and social sources, scrapes their public LinkedIn presence, downloads profile photos, and outputs an enriched CSV, feeding the recognition and personalization needs of the wider social-engagement platform.
Why It Exists
To make in-person event engagement personal, the platform needs more than a name and email: it needs each guest’s professional context and photo. This repository automates the otherwise manual, time-consuming research of looking each person up and consolidating what’s found.
What We Built
A scripted enrichment workflow (scripts/enrich_linkedin_data.py, scripts/fetch_linkedin_posts.py) plus a documented enrichment-playbook.md capturing hard-won lessons. The search strategy layers Serper (Google) as the primary lookup, You.com as secondary, and Tavily for deeper research, with Apify scrapers (e.g. the Facebook Pages Scraper and LinkedIn actors) pulling structured social data. The pipeline downloads LinkedIn profile photos to a local photo store, replaces stub records with full author profiles and recent posts, and produces enriched guest CSVs (e.g. a Beta Nights networking edition) and a consolidated crm_data.csv. Per-person JSON records under betanights_people hold the intermediate enriched data.
Technologies & Approach
Python automation orchestrating multiple third-party intelligence APIs, Serper, You.com, Tavily for search, and Apify actors for social scraping, with a prioritized, documented playbook to minimize wasted calls. Output is normalized into JSON per person and flattened into CRM-ready CSVs.
Outcome / Impact
Produced enriched, photo-backed attendee datasets that directly power the platform’s facial recognition and personalized conversation generation, turning a plain RSVP list into actionable engagement data while codifying a repeatable enrichment process.
Capabilities Demonstrated
- Multi-source person enrichment with a prioritized search strategy
- Orchestrating Apify social-scraping actors at scale
- Photo and profile harvesting into a structured local store
- Turning raw guest lists into CRM-ready datasets
- Documenting an operational playbook to make the process repeatable