Skip to main content
Data Needed for Certifications
Janus Mohr Hovgaard avatar
Written by Janus Mohr Hovgaard
Updated over 2 months ago

When importing data into our platform, the goal is to ensure that each piece of information is accurately matched and updated according to the correct company profile. This guide will help you understand what data is needed for us to make sure that data is precise and validated βœ…

❗Please only import up to 500 certified properties in an import❗


Video Guide


Needed data points

Down below you will find a list of the data points needed and why they're crucial to achieve correct mapping:

  • CLICK ON THE ARROW TO FOLD OUT THE DROP-DOWN πŸ”½

Company Name

The name of the company you are importing certification data on. You should provide the same name that the company has provided you with.
​

Unique ID

A unique identifier (ID) for the establishment you are importing certification on. The unique ID should be non-immutable to ensure that succeeding changes to any data for the establishment are matched correctly, thus avoiding duplicating data.
​

VAT Number (Optional)

The VAT (Value Added Tax) number is a unique identifier used in many countries for tax purposes. We understand that not all countries operate with VAT numbers, which is why this data point is optional. It is however highly recommended because it's unique making it perfect for mapping data to the correct company when multiple companies share similar or identical names, addresses, etc.
​

Full Website URL (Optional)

The website/domain name of the establishment you're importing certification data on. You must include the right path for the specific hotel in case they're part of a hotel chain. We understand that not all establishments might have a website, which is why this data point is optional. It is however highly recommended, as it makes the sign-up process on BeCause easier for the establishment.

  • Example: https://www.because.eco/

  • Full website URLs are including protocol: https://...
    ​

Latitude & Longitude

The latitude and longitude coordinates for the establishment you are importing certification on - in Decimal Degrees (very important). These can be found via Google Maps. Geographic coordinates allow for precise location matching, and it's crucial for distinguishing companies with similar names in different locations.

  • Example: Latitude 55.66620829, Longitude 12.580812097
    ​

Address details

These details ensure accurate geographical mapping and are essential for local and global business operations, enabling us to differentiate between entities with similar names across regions.

  • Street name + number:

    The street name and number of the establishment you are importing data on.

  • Zip Code:
    The zip code of the establishment you are importing data on.

  • City:

    The city of the establishment you are importing data on.

  • Country name:

    The country name of the establishment you are importing data on.

Certification data

These timestamps help verify the current status of a certification, ensuring that the data we map is correct and stays that way.

  • Standard Issued Date UTC:

    The issued date of the certification for the establishment you are importing data on. Accepted format examples: β€œ2021-12-09”, β€œ2021-12-09T17:37:39.282109”

  • Standard Expiration Date UTC:

    The expiration date of the certification for the establishment you are importing data on. Accepted format examples: β€œ2021-12-09”, β€œ2021-12-09T17:37:39.282109”

  • Certification level or custom metrics (optional):

    Any level or custom metric that you have added when you created the certification in the BeCause platform.

Sample data file

To streamline the data import process and avoid errors, we strongly recommend starting with our sample file as a foundation for your import every time. The sample file contains all relevant columns and the header names already match what the import tool expects, ensuring you provide all the necessary information in the correct format. You can find this in the "Import Establishment Data" section of the "Import" menu:

β›” Please remember to remove the sample company details in row 2 from the sample file if you are importing a newly certified property, and leave the BeCause Profile ID column empty. The BeCause Profile ID will automatically be created when you import your property.

➑️ Please continue to the following guide on how to import your file after it has been structured correctly ⬅️

❗Please only import up to 500 certified properties in an import❗


If you are unsure about how to do the import, please contact support via the chat in the right-hand corner 🀝. We are here to help πŸ’œ.

Did this answer your question?