What column type do I pick for my additional column mappings in Signals?

For Signals to work optimally, we need to understand what type of data the columns in your CSV or XLXS file contain. That’s why the mapping process of Signals is so important.

When mapping your columns for Signals in the web app, the only compulsory columns you are your main date dimension, unique ID and latitude/longitude columns. 

However, you can define additional custom dimensions or attributes that will help you narrow down your results specific to your business or industry. Set a custom name for any extra columns, and they'll become filters in your Signals output.

You can choose between three types of data:

Category

Think of category as a grouping name, like nationality or room type.

Number

For example, a price or quantity. This should be numbers only.

Date

Any dates that are relevant to your business and are different from the supported types.

There are also two other supported dimensions that you can map:

Initiated date

For example, a transaction date, like when a customer placed a booking or made a purchase.

Completed date

For example, a check-out date for accommodation bookings or a drop-off date for car rentals.

The initiated and completed dates are used to take into consideration lead time and time span (duration) when aligning your Signal with events. This is particularly useful for booking transactions, which means you'll be able to see the average lead times from when a booking is made to when the customer actually stays in your hotel or picks up their car rental. 

Please note, you cannot set a custom name for these two data types.

Have more questions? Submit a request Have more questions? Get in touch!

Comments