source: .forge/discovery/source-schemas/pipedrive-people-export-schema.md · generated — edit the markdown, not this file

Pipedrive people export — schema (migration reference)

What this is: the column schema of the Pipedrive people export Empire shared, the source for contacts in the Pipedrive migration (F4-a reads it, F4-d writes it). Two exports arrived on 2026-09-28: Contacts.xlsx in the morning, and people-15084451-98.xlsx in the afternoon, re-exported with every hidden column ticked. The counts below are from the second. Only the structure and counts are recorded here. The file holds real names, email addresses and phone numbers and lives outside the repo (client data) — it is never committed. The counts are one snapshot: re-count against the export actually used for each migration run.

Shape

  • One sheet, person list — 4,977 people, 47 columns (the same columns in both exports), each with a unique Person - ID (an integer).
  • The organisation is named, not identified: Person - Organization holds the organisation’s name. Pipedrive’s list-view export offers no linked organisation ID — the re-export with every hidden column ticked has none. 390 of the 4,633 people with an organisation name point at a name that several organisations share, so the name alone cannot link them.
  • 344 people have no organisation.
  • Duplicates: 1,018 rows share a name with another row, and 653 work email addresses appear on more than one person.
  • Several values in one cell: 246 Email - Work cells and 551 Phone - Work cells hold more than one value, separated by commas.
  • 37 people have no email and no phone.
  • Timestamps are written YYYY-MM-DD HH:MM:SS with no time zone.

Columns (export field → migration note)

Fill counts are from the second 2026-09-28 export (people-15084451-98.xlsx).

Export column Filled Migration note
Person - ID 4,977 The migration identity: source = 'pipedrive', source_ref = the ID (F1-a FR-S8)
Person - Name 4,977 → contact.name
Person - First name, Person - Last name 4,966 / 3,702 Parts of the name — contact stores the full name only
Person - Organization 4,633 The organisation’s name — links the contact to its account (see Shape)
Person - Email - Work 4,745 The first value → contact.email (the main address); every other value → the contact’s other addresses (F20-l, decided 2026-10-26; design/architecture.md § Mailbox integration, Rev 74)
Person - Email - Home, … Other 0 / 7 Email - Other → the main address when there is no work address, otherwise the contact’s other addresses (F20-l)
Person - Phone - Work 3,189 → contact.phone (one value; see Shape)
Person - Phone - Mobile, … Home, … Other 393 / 4 / 1
Person - Job title 26 → contact.job_title
Person - Country 3,501 (327 spellings) No country column on contact; a candidate for its account’s country — needs normalising to ISO 3166-1 alpha-2
Person - Owner 4,977 (17 distinct) Not matched to a user; a contact has no owner in the CRM (it follows its account)
Person - Trade Fairs 4,317 A Pipedrive custom field — fills a lead’s source (F4-a spec); custom fields are not otherwise migrated (PRD Rev 44)
Person - Labels 2,322 (6 distinct) Candidate contact tags
Person - Notes 569 A text field on the person, not a Pipedrive note record; one value repeats in 263 rows
Person - Person created, Person - Update time 4,977 Creation and last-change time in Pipedrive
Person - Visible to 4,977 (1 value) Not migrated (sharing memo D-5)
Person - Open deals, … Closed deals, … Won deals, … Lost deals, … Total activities, … Done activities, … Activities to do, … Email messages count 4,977 Pipedrive-computed counts — not stored
Person - Next activity date, … Last activity date, … Last email received, … Last email sent 123 to 3,767 Not stored
Person - Postal address and its parts, Person - Birthday, Person - Instant messenger, Person - Profile picture 0 to 135 Not stored

Generated from .forge/discovery/source-schemas/pipedrive-people-export-schema.md by .claude/lib/render-docs-html.js. Markdown is canonical.