Pairgap / Data operations + reporting
The need
Operational decisions depended on understanding users, tracking activity, and keeping records reliable across systems.
Mercy’s contribution
- Applied profile-completion criteria across Airtable bases and tables.
- Identified test accounts, organized completed-profile lists, and combined cleaned exports.
- Worked with registration, attendance, profile, assessment, and funnel reporting.
- Collated meeting-contact records and grouped repeat emails while retaining meeting dates and context.
- Used website and product analytics to support reporting and follow-up discussions.
What the work delivered
Structured exports and clearer operational reporting, with definitions and data checks that help prevent misleading totals.
Tools and methods: Airtable, Google Sheets, GA4, PostHog, Mixpanel.
