Exporting visitor information

Although Profile Manager allows you to view information about your website visitors as you serve them personalized content, you can track many other pieces of information about your visitors, across many different applications. You may already have a business analytics application that allows you to combine information about your visitors and customers to draw better insights about their behaviors. You can create export files of recent Profile Manager visitor information that you can later use in your applications.

Export files can contain up to 31 days of visitor data, consisting of their person, event, and touch information. These files are saved to your assigned Amazon S3 directory.

Creating an export file

To create a visitor information export file, complete the following steps:

  1. Sign in to the Profile Manager interface as an administrator, and then click the Admin tab.
  2. Click the Bulk file management link.
  3. At the bottom of the webpage, click Export data.
  4. In the From field, select a beginning date for the information in the export file. The export file will contain all selected information from the current date to midnight of the beginning date that you select.
  5. In the Data Exports section, select one or more of the following check boxes to determine which information to export:
    • Person - Visitors that have been uniquely identified with first-party cookies, their email addresses, or some other identifier.
    • Touch - A series of contiguous events (such as content views) with a duration between events of no more than 30 minutes.
    • Event - Discrete visitor actions, such as a content view of an article or a click-through on a subscription offer.
    • Rankings - Links to the Person, Touch, and Event tables separated by metadata classifications. For example, the person_ranking table can track how many times a person has accessed a webpage by platform.
    • Matched Segment - A list of the events and segments that are associated with each segment, linking the Segments table to the Event table.
    • Segment - A list of the segments defined in the Acquia Lift service, synchronized with the configuration database.
  6. In the Identifier Types section, select one or more of the following check boxes to limit the export file's results to display information from only visitors with the selected identity properties:
    • Purged - Displays results for visitors with an associated tracking ID that has been purged from the database.
    • Email Address - Displays results for visitors with an associated email address.
    • Tracking ID - Displays results for visitors with an associated tracking cookie ID.
    • Account ID - Displays results for visitors with an associated account ID, which can be an identifier from another tracking system.
    • Facebook ID - Displays results for visitors with an associated Facebook username.
    • Twitter ID - Displays results for visitors with an associated Twitter username.
    • Name - Displays results for visitors with an entered name, including first, middle, last, or any combination of these.
  7. Click OK.

Profile Manager begins to export your requested information. Depending on your selections in the Data Exports section, the Acquia Lift service will create a file for each export option, with filenames that include the selected option.

The Bulk File Management webpage will update the list of files with each of the new Pending export files. The export file creation process can take some time to complete.

To refresh the list of files and their statuses, click Find on the webpage.

After the Acquia Lift service completes an export file, it changes the file's status to Complete, and you can download the file.

Retrieving your export file

Profile Manager saves completed export files to an Amazon S3 directory that is associated with your account. To download your export file, complete the following steps:

  1. Connect to the Amazon S3 directory provided by Acquia using a local computer client. For example, the S3 folder path will be similar to the following, based on where your S3 directory is located:
    • US - lift.prod.api-file.us-east-1/<account_id>/OUTBOX
    • Europe - lift.prod.api-file.eu-central-1/<account_id>/OUTBOX
    • Australia - lift.prod.api-file.ap-southeast-2/<account_id>/OUTBOX

    If you need assistance accessing your S3 directory, contact Acquia Support.

  2. Download the export file that you requested from your Amazon S3 directory.

Each export file includes a separate file that includes the headers for each column of field data in the export file. Header files have the same names as their associated export files, with _header appended to each file name. For example, exporting the event information from Profile Manager would create files with names similar to the following:

  • event_2014-12-27_1.csv
  • event_2014-12-27_1.csv_header

Examining the export file

To ensure that other applications are able to read the export file's data correctly, Profile Manager adds escape characters ( \ ) to the export file. The escape characters precede certain special characters in the file, including the following:

  • Pipe symbol ( | ) - \|
  • Carriage return - \n
  • Linefeed - \r

Using escape characters ensures that there is no confusion if these special characters are included in the content of a field, such as Content Title.

Contact supportStill need assistance? Contact Acquia Support