Data imports configuration


Once you establish a connection between the data center and a data source, you need to define what type of data gets imported and how. This may be, for example, what the marketing department wants you to track and extract as data from the specific system. You may want to extract data that relates to a specific interaction or data that provides information about specific attributes of contacts.

For the different types of data you import, you need to set different import configurations, that is, set different properties of the import. For each data import configuration, you need to write a separate data query, be it an SQL query or JSON template query. Once you select how to import data from the data source, the query template changes to reflect this.

The following sections describe in more details the query configuration options, that is, type of data to import and query settings.


Interactions represent activities contacts complete, for example download whitepaper X. Sitefinity Insight uses the sentence data model to collect data. The sentence is the data unit that holds the information of what user activity was completed on the website, by whom, and when. The data model consists of:

  • Data source
    The system, in which the contact completed the interaction.
  • Subject
    The contact that interacted.
  • Predicate
    Describes the actual activity that comprises the interaction. In the example above, the predicate is download.

    NOTE: The predicate you define during data import configuration becomes an interaction choice when you define conditions and rules for marketing metrics for analytics and reports. Depending on your scenario, the predicate need to be unique.

  • Object
    The entity, with which the contact interacted

  • Timestamp
    Tells the system when the interaction actually occurs

  • IP address

Contact mapping

When you aggregate contact data from different sources, it is necessary that this data contains information about the user identification in the respective systems. Visitors are mapped to contacts usually when they log in or after they enter information in Sitefinity CMS forms. With this type of data import, you aim at mapping the contacts from the current data source to contacts from another data source through their IDs, so that Sitefinity Insight identifies the visitors from different sources as one and the same contact and uses these details in the contact profile.

Thus, contact mapping describes how a contact is represented in different systems. For example: <-> CRM/ContactA

For more information, see For developers: SubjectMapping.

Contact metadata

Contact metadata comprise any additional information about a contact, apart from contact ID. This includes email address, company, phone, location, and so on. Contact attributes are represented by subject metadata.

Settings for query results

Since query results may represent a very large amount of data and information, in the Settings section you can define how query results are paged. Paging breaks the data into fixed-size chunks that make the results manageable and reduces the amount of information and the speed with which data moves between the server and the client at one time. This affects the speed, with which results are displayed.

SQL queries settings

You configure paging of the results by specifying how many results you can upload (or, import) per page and then setting where a results page starts and where it ends using the Take parameter name and the Last read parameter name fields. Make sure the paging parameters concur with the ones in the query you write.

You also need to specify the number of results per page, which defines how much data is imported in one chunk. By default, paging is split into chunks of 1,000 results.

JSON template settings

You configure paging of the results by specifying the number of results per page, thus defining how much data is imported in one chunk. By default, paging is split into chunks of 25,000 results.

Was this article helpful?