Consent Registry

From the Elmo control panel, it is possible to manage the consent register linked to each individual banner: let's see how to do this

Step 1: Registry's generation

To generate the consent register, simply:
  • Go to the Statistics and Downloads section
  • A table will appear containing up-to-date statistics of the banners associated with the company
  • Once you have identified the banner whose register you need, proceed by clicking on Generate. A message will confirm that the request has been taken over.
  • After a few minutes (15-30 on average) by reloading the page you will find the link to download the consent register, which will remain valid for 24 hours.
  • After 24 hours the link will no longer be valid and it will be necessary to generate the register again with the latest data.

Step 2: Registry interpretation

The consent register is a technical file designed to be integrated with automated systems or spreadsheets, such as Excel files, and in any case processed before being used.
As it is a CSV file, it is therefore possible to insert it into an Excel spreadsheet using the import data function.
Below is a guide to the fields contained in the register:
  • UserID is an indicator of the website navigator who provided consent, it is a random string that only the user knows by accessing the browser he/she logged in with and inspecting the cookie set by Elmo on the browser he/she accepted.
  • PublicID and RevisionID respectively indicate the banner to which the user has consented and its version identifier, which changes each time the banner is updated from Elmo's interface.
    The former is the value found in step 4 - Configuration, while the latter can be found by examining the cookie set by Elmo to which it refers.
  • To ensure compatibility, we have entered the consent date as UTC timestamp: this particular date format is used by machines, but must be converted to a human format in order to be interpreted.
    One method of interpreting this value may be as follows:
    • Once the Excel file has been imported, among the columns will be UTC Timestamp, which is the consensus date (on the Greenwitch time zone)
    • Create a column adjacent to the one with UTC Timestamp , and enter the formula =(CELLA_TIMESTAMP/86400)+25569, where CELLA_TIMESTAMP is the value of the UTC Timestamp column in the same row.
      You should obtain a column full of numbers.
    • Right-click on the column you have just created, click on Format Cell and enter Number -> Time -> DD-MM-YY HH:mm
  • The last columns indicate the consent provided by the user for necessary, statistical, marketing and non-EU cookies.  A 1 indicates consent given and a 0 a refusal.ù
    All portal surfers provide consent to technical/necessary cookies, while only those with all columns to 1 have consented.
    Users with alternating 0s and 1s have only accepted some cookies, usually by going to banner preferences and clicking on "Accept Selected".