InnerWeb
Skip to main content

Preparing the People Sheet Before Entry to the System: Best Practices

The quality of account matching depends on the quality of the sheet. An external company coordinator who unifies phone numbers to E.164 format, completes e-mail addresses and corrects the spelling of names moves most matches to automatic mode and saves the administrator's time.

20 of 200
rows for manual resolution in the example calculation
Source: example calculation

Why tidy up the sheet

The system matches people by strong data: e-mail, phone number in E.164 format, employee ID or an external login identifier. Weak data, that is first and last name alone, requires a human decision. Every row of the sheet without strong data is therefore a future case to resolve.

The external company coordinator knows their people best, which is why they should prepare the sheet. A correction on their side costs a minute per person, while on the plant administrator's side it takes much more.

Phone number in E.164 format

E.164 format is a number with a country prefix, without spaces, hyphens or brackets, for example a plus sign, the country code and nine digits for a Polish number. A unified format lets you match a person to an account regardless of how the number was typed into a form or a previous sheet.

Remember that phone numbers are not verified. Matching by phone alone from a public form leads to waiting for administrator approval and changes nothing on the account. A phone number is therefore a good supplement, but does not replace the e-mail.

Sheet rows by type of data (example of 200 rows)

Sheet rows by type of data (example of 200 rows)Pie chart: 150 rows with e-mail, 30 with phone only, 20 with name only.Has e-mail: 150 rows (75%)Phone only: 30 rows (15%)Name only: 20 rows (10%)200rowsHas e-mail150 rows (75%)Phone only30 rows (15%)Name only20 rows (10%)
Source: Example calculation based on the assumed split of 150, 30 and 20 rows

E-mail, name and company

The e-mail address is the strongest data in the sheet. Enter the address of every person who has one, and avoid addresses shared by several people, because they lead to wrong links. If someone has no personal address, leave the field empty instead of entering the office address.

Enter first and last name in one convention: in separate columns, without titles and abbreviations. The system compares them regardless of letter case and diacritics, but typos and reversed order of first and last name still make matching harder. Write the company name the same way throughout the file, because the assignment of people to companies depends on it.

Errors most often found in sheets

The most common problems are phone numbers with spaces and without a country prefix, addresses with typos, the same person entered twice with a different spelling of the name, and the company name in three variants.

  • phone without a country prefix or with separators,
  • e-mail address shared by several people,
  • the same person in two rows,
  • company name written in several ways.

What the system does with rows that do not match

A strong match by e-mail to an active account without a password and without a login identifier links the registration to the existing account. Other strong matches, for example an account with a password, a pending invitation or a deleted account, end with response 409, and a deleted account is never restored. In weak matching the system shows at most 3 candidates with masked data and waits for a human decision for 780 seconds.

After the sheet is prepared, the number of such cases falls. In an example calculation for 200 rows: if 150 have an e-mail, 30 have only a phone, and 20 only a name, weak matching applies to only 20 rows, not to 200.

Procedure for the company coordinator

Below is a short sequence the coordinator can go through in an hour for a list of several dozen people. At the end, it is worth sending the sheet to the plant administrator together with the number of rows, so that the numbers can be compared after entry.

  • remove repeated people in the file,
  • unify phone numbers to E.164,
  • add personal e-mails where they exist,
  • split first and last name into separate columns,
  • unify the company name,
  • state the number of rows in the e-mail to the administrator.

Checklist

Video

Frequently asked questions

Is a phone number without an e-mail enough?

A phone number helps matching, but numbers are not verified. Matching by phone alone from a public form requires approval by the administrator.

What about people who do not have their own e-mail?

Leave the field empty. Entering the address of an office shared by several people leads to wrong matches.

Do letter case and diacritics in a name matter?

Weak matching ignores them, but typos and a reversed order of first and last name still make matching harder.

Sources

Prepare the sheet together with us

We will show a sheet template with columns and writing rules during the talk. Book a talk or a demo.

Let's talk