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.

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

Mapping taxonomy terms to Acquia Lift

With Drupal, you can map taxonomy terms to the user-defined fields for Person, Touch, and Event types. These mapped terms will appear as meta tags when applicable for a page. Mapping Drupal-tagged content to Acquia Lift allows you to obtain a better understanding of the kinds of content that your visitors are consuming.

To map your existing taxonomies into Acquia Lift, complete the following steps:

  1. Sign in to your website as a user with the permission to administer the personalization settings.

  2. In the admin menu, click Configuration.

  3. In the Web Services section, click the Acquia Lift link.

  4. In the Data collection settings section, click the Field Mappings left tab.

  5. For the Content Section, Content Keywords, and Persona lists, click your website’s taxonomy that most closely correlates with the item affected by that list.

    Mapping taxonomies

  6. Optional - If your website contains any additional taxonomy vocabularies that you want to map to Acquia Lift, complete the following steps:

    1. In the left tab listing, click the tab with the vocabulary that you want to modify:
      • User Person Mappings
      • User Touch Mappings
      • User Event Mappings
    2. Select the taxonomy that you want to map for each field.
  7. Click Save configuration.

For examples of content mapping for several industries, see Content tagging use case examples.

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