Data warehouse

Acquia Lift data warehouse

Acquia Lift Omnichannel provides access to a cloud-based data warehouse that contains all of your Acquia Lift-hosted visitor data. You can directly connect to this data warehouse to use your own business intelligence tools to analyze your visitors and discover new insights.

You can also extend your use of the visitor data warehouse by using the Acquia Lift APIs or the manual Profile Manager file upload feature to import external visitor information (such as from your CRM system) into Profile Manager, providing you with a single location for your aggregated visitor information.

The data warehouse updates either every 10,000 records or approximately every 15 minutes (depending upon which threshold is first met).

After you purchase a license for Omnichannel, you will be provided with connection instructions to your visitor data warehouse.

Field layouts

The data warehouse structure uses the following field layouts for organizing and presenting its data:

  • Person - This field layout describes visitors that have been uniquely identified with first-party cookies, their email addresses, or some other identifier.
  • Touch - This field layout describes a series of contiguous events (such as content views) with a duration between events of no more than 30 minutes. Each touch has a Person record as its parent.
  • Event - This field layout describes discrete visitor actions, such as a content view of an article or a click-through on a subscription offer. An event has a Touch record as its parent. Events also contain information about the specific content that a visitor is consuming.
  • Segments - This field layout describes the segments that are associated with each event for a given person, and is made up of a segments table (for specific segment information) and the matching_segments table (links events with their associated segments).

Using Drupal, you can also map taxonomy terms to the various user-defined fields for Person, Touch, and Event types. These mapped terms will appear as meta tags when applicable to that page.

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.

Contact supportStill need assistance? Contact Acquia Support