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. However, it may take up to 24 hours for processed data to be available in all tables.

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

Configuration

Once you have your connection information, you can:

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).

Contact supportStill need assistance? Contact Acquia Support

Acquia: Think Ahead

53 State Street, 10th Floor
Boston, MA 02109
United States
Phone: 888-922-7842

Map: Google Maps
View other locations