Mandatory fields on imports

It would be great if we could choose which fields are mandatory for importing contacts (initially), in addition to those that are already pre-defined in Hubspot.

Agree! Even if its first/last name, email and type - it’s killing me that people can upload thousands of garbage contacts.

I think it is critical that required fields are respected too during an import. Otherwise, this can be a potential cause of dirty data.

I totally agree! Please this should be basics in HubSpot. It really does not make sense to upload contacts without an email address.. but some people still do this, regardless how often you tell them not to do.

For an enterprise-level organisation, this is mandatory, because it would allow us to ensure nobody ever imports data that cannot be immediately attributed to a specific team.

Upvoting this as it would make it easier to ensure quality leads are uploaded and emails are important to deduplicate contacts

Agree! It makes completely no sense to have mandatory fields for creating contacts directly in Hubspot but its possible to import contacts without any information through a 3rd party tool like Lusha!

It is a MUST with the BU solution

User: Any HubSpot user with import permissions

Problem. Many large/global companies using HubSpot have required property fields, that need to be completed at a contact or company level. These required property fields are used to improve segmentation over multiple countries/product types/contact types etc. An example of these required fields would look like this.
- Country (of contact)

- Contact type (Patient, Doctor or Pharmaceutical)

- Product Line (ProdA, ProdB or ProdC)

These companies rely on having this information completed for each contact, so they can accurately see any patterns or trends, as well as track product division KPIs. Integrations automatically allocate the correct fields to contacts based on IP country, name of form/page etc, but any manually imported contacts rely on the user remembering to add country, contact type and product line to each spreadsheet.

HubSpot imports already have the functionality to check for a unique identifier (like Contact ID) and prompt you to ensure first name, last name and email are all existing columns, in order for the import to take place.

Request

It would be great if this could be expanded upon, so the company can pre-define any additional property fields, outside of the First name, Last name and Email, so any data entered into their CRM meet their business requirements.

Use Case

As a Marketing manager

I want to ensure all manually imported data includes our three ‘required properties’ (Country, Contact type, Product)

So I can confidently segment our contact data and supply our contact with the right content and the right time.
Acceptance criteria

Given a HubSpot user has imported a contact datasheet

When they are directed to the mapping page

Then an error message will display if they have not included the business’s pre-defined required fields.

Thank you.

With so many updates to permissions and partitioning, this seems like a great next step, giving us the ability to keep data clean.

Fully support this idea! I think it´s essential for business units as well!

Hi all, Alex from the HubSpot product team here.

We’re currently in the planning stages of building what we’re calling “saved import templates.” This would allow an admin to create an import template that requires specific properties, and permission them out so specific users in their portal can only do a contact import if it has a specific set of properties, for example.

We’ll update this community post once we have more information.

Hi @agirard

This is fantastic! I’m excited to see how this pans out. Thank you for the update.

Love that update @agirard !

Looking forward for this update!

Waiting for updates!

Excited for this update

Will be great to set Email as a required field for imports!

This is exactly the kind of request I asked HubSpot support about.

And after a a week in conversation with them, they replied that the product development team is working on a feature called “Saved Import Templates”. This would, for instance, allow an admin to create an import template that requires specific properties, and permission them out so specific users in their portal can only do a contact import if it has a specific set of properties.

Let’s see how this works once the beta version of it comes (if it comes).

But I totally support your thought as mostly in a big company like ours where we deal with tens on thousands of contacts and companies, being able to have rich and clean data is essential for a good segmentation.

Hi @agirard - just wondered if there was any update on this? Or a rough idea of timings for this?