Path Analysis Functions - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
September 2017
English (United States)
Last Update
Product Category

The path analysis functions automate path analysis. They are useful for clickstream analysis of web site traffic and other sequence/path analysis tasks, such as advertisement or referral attribution.

The function descriptions use these terms:

  • Path: An ordered, start-to-finish series of actions, such as the page views of a user from the start to the end of a session. For example, if the user visits page a, page b, and page c, in that order, the path is: a,b,c
  • Sequence: A path in this format:

    The carat (^) indicates that a path follows. For example: ^,a,b,c

  • Subsequence or prefix: For a given sequence, a possible subset of steps that start with the initial step. For example, the subsequences for the path a,b,c are:
  • Exit subsequence or prefix: A subsequence or prefix that is the same as its sequence, indicated by a final dollar sign ($). For example: ^,a,b,c$
  • Depth: The number of steps in a sequence or subsequence. For example, the immediately preceding subsequences have depths 1, 2, and 3, respectively.
  • Node: A single step on a path. For example, one web page that the user visits during the session.
  • Parent: The path the user traveled to a given node. For example, the parent of c is ^,a,b.
  • Child: A path the user traveled from a given node. For example, the children of ^,a are:

The functions are:

  • Path_Generator, which takes a set of paths and outputs the sequence and all possible subsequences.
  • Path_Summarizer, which takes Path_Generator output and returns, for each prefix in the input table, the parent and children, and number of times each of its subsequences was traveled.
  • Path_Start, which takes Path_Summarizer output and returns, for each parent in the input table, the parent and children and the number of times that each of its subsequences was traveled.
  • Path_Analyzer, which runs the preceding path analysis functions in the order shown, using the output of Path_Generator as input to Path_Summarizer and the output of Path_Summarizer as the input to Path_Start.