source: .forge/discovery/source-schemas/pipedrive-organizations-export-schema.md Β· generated β€” edit the markdown, not this file

Pipedrive organisations export β€” schema (migration reference)

What this is: the column schema of the Pipedrive organisations export Empire shared, the source for accounts in the Pipedrive migration (F4-a reads it, F4-d writes it). Two exports arrived on 2026-09-28: organizations-15084451-95.xlsx in the morning, and organizations-15084451-99.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 company names and addresses 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, organization list β€” 4,235 organisations, 35 columns (the same columns in both exports), each with a unique Organization - ID (an integer).
  • Names are not unique: 4,029 distinct names, and 221 rows share a name with another row once case and spacing are ignored. People and leads refer to an organisation by name only β€” Pipedrive’s list-view export offers no linked organisation ID (see the people and leads schemas) β€” so a shared name cannot be linked on its own.
  • 267 organisations have no people.
  • Few addresses: 290 organisations have any address, 282 a country.
  • 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 (organizations-15084451-99.xlsx).

Export column Filled Migration note
Organization - ID 4,235 The migration identity: source = 'pipedrive', source_ref = the ID (F1-a FR-S8)
Organization - Name 4,235 β†’ account.name
Organization - Owner 4,235 (18 distinct) Not matched to a user β€” the account is owned by the import owner, and the name is kept (F4-a spec)
Organization - Country of Address 282 (63 spellings) β†’ account.country, normalised to ISO 3166-1 alpha-2
Organization - Address and its parts (street, city, state, region, postcode, full address) 4 to 290 account has no address columns
Organization - Labels 17 (3 distinct) Candidate account tags
Organization - People 4,235 Pipedrive-computed count β€” not stored
Organization - Organization created, Organization - Update time 4,235 Creation and last-change time in Pipedrive
Organization - Visible to 4,235 (1 value) Not migrated (sharing memo D-5)
Organization - Open deals, … Closed deals, … Won deals, … Lost deals, … Total activities, … Done activities, … Activities to do, … Email messages count 4,235 Pipedrive-computed counts β€” not stored
Organization - Next activity date, … Last activity date 1,088 / 119 Not stored (activities are not migrated β€” PRD Rev 44)
Organization - Website, … LinkedIn profile, … Industry, … Annual revenue, … Number of employees, … Profile picture 0 Empty in every row

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