We’d love to learn about your predictive questions and show you how Endor can help.

Thank you!

Your submission has been received

Oops! Something went wrong while submitting the form.

What are the data requirements?

The questions that are listed above derived from the uploaded data. They should be easily transformed to an SQL query which will be later on used as the lookalikes examples.


Transactional data, is the information recorded from transactions.In our case thetransactions should be  human generated and non aggregated.

A transaction, is a sequence of information exchange and related work (such as database updating) that is treated as a unit for the purposes of satisfying a request. Transactional data can be financial, logistical or work-related, involving everything from a purchase order to shipping status to employee hours worked to insurance costs and claims.

As a part of transactional records, transactional data is grouped with associated master data and reference data. Transactional data records a time and relevant reference data needed for a particular transaction record.

The minimum data requirements are:

  • At least 1000 main IDs
  • At least 10 transactions per ID
  • Datetime field granularity of at least a day (its better to use a granularity of minutes)

Endor uses 2 types of data:

Transactional data (At least one) - any human generated footprints (see Appendix):

  • Main Date fields must be date+time in all transactional tables.
  • Example: Impressions,Actions, Etc..

Metadata (Optional) -  information about the users (see Appendix):

  • Example: User Profiles,User descriptive data (segmentation), Etc..

You can use multiple transactional datasets and metadata sets from a variety of sources, as

long as there is a unique column in the datasets that connects them (usually user_id column).

Data hashing:

  • Any sensitive data can be hashed prior to upload. (Make sure to keep the reverse table)

Examples for different data sources :

  • Internal transaction tables
  • CRM
  • IVR
  • Weblog
  • Point of sale
  • Social media
  • Etc..

Customer Data

[Technical expert]

Please complete the following: 

Examples in Green below.

Data types : <Please complete the table below>

  • Estimated number of distinct users (based on the biggest dataset): <Insert>
  • Estimated average number of transactions pre user (based on the biggest dataset): <Insert>
  • Estimated total size of uploaded data: <Insert>

Please share the following prior to the full data transfer:

  • Data samples (up to 100 rows per table).
  • Full list of locations. (map presentation)

Data Examples

[Technical expert]

Please list all the datasets that you have with samples of up to 10 lines.
  • Transactional data

Required fields (per table):

  • Time field (either date, or date+time)
  • ID (the objects we are querying. Phone numbers, usernames, …)

Optional fields:

You may add as many additional data columns as you like in order to enhance the accuracy of the results.

Examples: Transactional data with user action and its geolocation…

‍Date and Time fields should have numeric representation.

  • Metadata data:

          Required fields:

  • ID (the objects we are querying. Phone numbers, usernames, …)

Examples: User’s metadata, in this case we

More related content

Fast, Accurate & Scalable
business predictions

Contact US


© Endor Software Ltd All Right Reserved
Terms & conditions | Privacy policy