Activity Record Feed

The Export Activity Record Feed delivers an export that is processed daily and is configurable to include one or more of the supported visitor site activities.

The following are the supported visitor site activities.

Product Browsed
Product Purchased
Product Abandoned
Product Carted
Onsite Searches
Page View
Conversion Event Initiated
Conversion Event Completed

Export Activity Record Feeds are arranged so that every row in the export corresponds to a unique visitor-activity combination. For example, if a visitor browsed five pages and the Export Activity Record Feed is configured to include Page View activity, five rows are included in the export file. Each row corresponds to a page viewed by the visitor. Other related information is also included in the file.

Export key

You can select one of three supported key columns for your Activity Record Feed. Your export can use Cookie ID, Cookie ID | Session ID, or Registration ID as the key column to be included in your export file.

Activity type

The numeric identifiers for the type of activity that is included in every row of the export is as follows.

0: Product Browsed
1: Product Purchased
2: Product Abandoned
3: Product Carted
4: Onsite Searches
5: Page Views
6: Conversion Event Initiated
7: Conversion Event Completed

Category ID

The ID of the category to which the specific activity pertains. For example, a Page View record provides the category ID to which the individual page that was viewed belongs.

Product ID

The ID of the individual item that is related to the activity that was tracked. For example, the Product ID might be the onsite search term that was entered, or the conversion event that was initiated.

Activity time

The start time of the visitor session in which the activity took place.

Activity amount

If the activity is related to the product or conversion-event, the activity amount includes the price of a product carted, purchased, event points, and so on.

To create an Activity Record Feed, drag-and-drop the Activity Record Feed icon to the Integrate frame of Export. Your user interface updates to display a configuration screen that consists of three steps to define your Export data feed.

In the Activities tab, select the key that you want to use for the export and the specific activity types that you want to include. Click the check boxes next to as many of the activities that you want to include in your feed.

Then, you can configure an Activity Record Feed for only a subset of the site visitors for a targeted campaign that you plan to run. Applying a visitor segment definition to your feed is optional. To create a new segment to use with Export, go to the Segment tab and click New.

Note: Export segments are single-session in nature. Visitors must meet all of the segment criteria in a single site-session for the Export segments to be included.

Select an existing category or create a new category, to which you would like your new segment to be assigned.
Provide a name for the segment.
Select the criteria and layer the criteria together to define the segment. In the following example, a segment was created of highly engaged Google paid searchers. The segment criteria consists of visitor sessions and the marketing program is 'Google'. The sessions have at least five page views and have a duration of at least 500 seconds.

When you create your Export segment, you can choose one criterion (for example, Page contains sports) or you can layer together multiple criteria. (For example, Marketing Vendor contains "Google" [or] "Yahoo" [and] Product Name contains "Nike" [or] "Reebok.")

Editing or Deleting an Existing Segment

To edit an existing segment, select the segment that you want to edit from the Available Segments list and click Edit.

To delete an existing segment, click Delete.

Note: If you attempt to edit or delete an existing segment that is applied to an export, you receive a warning because changing the definition affects the output of those feeds.

Click the Name and Other Details tab to specify other required information to describe your Export best practice program export. Provide the following Export information:

Feed Name (required): An appropriate name for your export.
Description (optional): A brief description of your export.
Email Notification List (required): Email addresses of individuals who are to receive notifications about the status of the export's daily processing.
SFTP Target (required): The file server to which Digital Analytics delivers the Export feed. The SFTP Target drop-down menu displays any targets that were previously created by users in your organization. If your export is to be sent to a location that is not yet specified, click Create. Enter the SFTP information that is required by Digital Analytics to successfully transmit your Export file.
Frequency (required): Activity Record Feeds are daily recurring exports. However, you can run a one-time export-based test on a single day's site activity. You can review your Export feed before you schedule it for daily processing.
Inter-field Delimiter (required): A comma is the suggested inter-field delimiter, but you can configure your export file to use tab or pipe (vertical bar |) characters instead.
Intra-field Delimiter (required): A pipe (vertical bar |) character is the suggested intra-field delimiter when a comma is used as the inter-field delimiter. You can configure your export file to use another character instead. You cannot use the same character for both the inter-field and intra-field delimiters.
File Extension (required): The csv extension is the default extension that is used for Export exports irrespective of the inter-field delimiter that you specified. However, you can change the extension of your Export file to .txt instead of .csv if you want.
Note: The file extension that is applied to your Export export is not dictated by the inter-field delimiter selection you specify. For example, you can elect to use comma characters as your delimiter but have your export use a file extension of .txt. If you are reviewing Export export files in Microsoft Excel, Excel formatting assumptions are tied to the file type. The file type is identified by the extension (for example, .csv are assumed to use commas as the field delimiter).
Include Header (optional): If you want your Export file to include a record that contains names for each field in the export, select the Include Header check box.

When you provide all of the required configuration information, click Submit to activate the daily processing of your Export feed. The first instance of the export will be sent the day after it was activated. When you submit the feed, it is docked in the Integrate with Digital Analytics footer. You can edit your feed at any time by double-clicking it.