Who is Green key?


Green Key International is an international eco-label awarded to accommodations and other hospitality facilities that commit to sustainable business practices. Awarded establishments comply with strict criteria, independently verified through regular on-site audits.


You can find out more about Green Key here.


How Do We Work With Green Key?


As a recognised partner of Green Key, we have their permission to download the accreditation data for venues that have achieved their sustainability accreditation.  We are then able to update the venue listing with the accreditation and the Green Key 3rd party ID, where the venue already exists on our database.  (Our partnership does not allow us to add any new venues to our database unless they are part of the Radisson Hotel Group, where we have permission from Radisson.)


How Do We Access The Data?


Green Key works with a data provider called BeCause, a sustainable organisation.  Their partners can choose to either download the venue data via a spreadsheet or connect via the API (at a monthly cost).  Venuedirectory.com has chosen to download the data via an excel spreadsheet.  This should be done monthly.


Summary Process:

  • Download data from BeCause

  • Save in Green Key Folder (In Venue Support Drive)

  • Exclude data for the establishments not appropriate for us e.g. Campsites

  • Raise a ticket to add in theTVD ID using the Green key ID - sort the data to exclude data with a TVD ID and store in a separate worksheet.

  • Complete V Look Up to exclude venues that have been previously supplied to us.

  • Work through the remaining venues adding the Green Key ID to existing venues and adding any Radisson Hotel Group venues to our database if they are not already listed.


Detailed Process:


How to Download the data from BeCause


Go to https://app.because.eco/company-manager/import-export/export

Log In

Username - venuesupport@venuedirectory.com

Password - Cranbr00k


From there - Import/Export drop down - Export data


Select Data Owner - Green Key

From here you are allowed to download the Excel File - tick to accept the Terms & Conditions


Select the Download button


The spreadsheet will now be stored in your C Drive in the Downloads Folder.


Move this file to the Venue Support Shared Drive - Project Work - Green Key


Open the downloaded spreadsheet as there is some data we will not need contained within the file.  The data file will include the date the data was downloaded so you can see which is the latest file.


The data downloaded will include venues we would not add to our database, for example campsites or small accommodation (bed & breakfast) so we now need to exclude this data.




To exclude the data we do not need - Add a filter to the file.


Click the filter button alongside Establishment Categories - select Clear to remove all ticks


.


Then review the drop down list and select the categories we need - click OK

These are:


Attraction

Conference Center

Hotel/Hostel

Restaurant


Copy/Paste the filtered data into a separate worksheet - rename the worksheet Filtered


Next, you will need to go to Endeavour and click on the Groups Tab and select Accreditations and Affiliations 



In the search bar you will need to type in Green Key and click on the accreditation name



Next you will need to click on Venues and untick the box labelled  UK & Ireland Only to show all venues that have a Green Key accreditation added





Once you have unticked the box labelled  UK & Ireland Only you will need to click on Export Venues to be able to download a list of all venues that have a Green Key accreditation added



Once downloaded you will need to open the file and copy and paste into a new sheet on your existing spreadsheet. 



Rename the worksheet Our Data


Create a new worksheet called ExistingGreenKeyVenues and you will need to do a VLOOKUp using the data from the worksheet called Filtered.  Once the data from the Filtered worksheet has been copied and pasted into this new worksheet you will need to do VLOOK up to see which venues that we already have with a Green Accreditation on the system.


Ensuring that the Green Key ID is on Column A of both worksheets; Filtered and ExistingGreenKeyVenues,


Scroll across to the next empty column - probably column S


Click in Row 2 of this column


In the  field type


=VLOOKUP(A2,ExistingGreenKeyVenues!A:A,1,TRUE) 


This means you are comparing the data in cell A2, with the worksheet ExistingGreenKeyVenues  - all cells in column A.  False means you will see all the venues where the Green Key ID cannot be found as N/A which makes it easy to identify them.


Filter by blanks and copy/paste this into a separate worksheet - rename the worksheet VLOOKUP data. 


Copy / Paste the Green Key 3rd Party ID into Column A of the worksheet.


We need to check if the data has been in any previous spreadsheets.  


Go back to the previous months spreadsheet.

This should be named Green - Month  - Data to Map. 

Copy the data from the worksheet labelled "Previous Data".


Go back to the File "Our Data"

Create a new Worksheet in this file and rename as Previous Data and paste the data from the previous month's data.  (Make sure the Green key 3rd Party ID is in column A)


You will now see you have a spreadsheet with lots of worksheets in there


Click on the VLOOKUP data worksheet


Scroll across to the next empty column - probably column S


Click in Row 2 of this column


In the field type


=VLOOKUP(A2,PreviousMonth!A:A,1,TRUE) 


This means you are comparing the data in cell A2, with the worksheet Prev Data - all cells in column A.  False means you will see all the venues where the Green Key ID cannot be found as N/A which makes it easy to identify them.


Drag down the transaction to include all rows  - you will then see either a matching Green Key ID (this means we have seen this venue before or a N/A which means this is new to us.)


Filter on N/A - copy/paste the data into a new worksheet and rename the worksheet Data to Map.


Share this data on Asana and with Zac so someone in the team can complete the matching as you would normally.


Asana Task to contain these notes:


Each venue we have listed on our database must have:


1) the 3rd party ID added to the venue profile (GK ID) 


2) the Green Key accreditation added to the venue profile 


Any Radisson group venues, Park Inn by Radisson, Radisson Red etc. can be added to our database if we do not have them already listed.  


Any other venues we do not have listed must NOT be added.