7
The Referrer Dimension
The Referrer dimension allows analysis on multiple levels. Information obtained from the domain name of the referrer can be used in high-level country/domain type reports. If the referrer URL is recognized as belonging to a search engine, then the URL can be parsed to obtain the keywords used in the search. (The Search Dimension holds these search keywords, which can give insight into what users are looking for when they come to the site.)
This chapter contains the following topics:
Referrer Dimension Hierarchies
The Referrer dimension contains the following hierarchies:
The sections that follow list all levels in each hierarchy, followed by a diagram that provides a graphical representation of the hierarchy.
The Referrer Campaign Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Referrer Dimension Levels.
Figure 7-1 The Referrer Campaign Level Hierarchy
![Text description of referrer.gif follows](referrer.gif)
Text description of the illustration referrer.gif
The Referrer Category Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Referrer Dimension Levels.
- Referrer Category 3
- Referrer Category 2
- Referrer Category 1
- Referring URL
Figure 7-2 The Referrer Category Level Hierarchy
![Text description of referrea.gif follows](referrea.gif)
Text description of the illustration referrea.gif
The Referrer Geography Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Referrer Dimension Levels.
- Region
- Country
- Domain
- Referring Site
- Referring URL
Figure 7-3 Referrer Geography Level Hierarchy
![Text description of referreb.gif follows](referreb.gif)
Text description of the illustration referreb.gif
The Referrer Organization Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Referrer Dimension Levels.
- Domain Type
- Domain
- Referring Site
- Referring URL
Figure 7-4 Referrer Organization Level Hierarchy
![Text description of referrec.gif follows](referrec.gif)
Text description of the illustration referrec.gif
Referrer Dimension Levels
The Referrer dimension is comprised of the following levels. For each level, information about each attribute (column name) is provided in the following format:
- Attribute: Description (example value)
levels are presented in descending order. In addition to the pre-defined attributes, each level contains five "generic" attributes that can be defined by the user.
CLK_L_CAMPAIGN
- Campaign_ Code: Campaign identifier; natural key (User-defined)
- Campaign_Name : Name of the campaign (User-defined)
- Campaign_Description : Description of the campaign (User-defined)
- Campaign_Attributes 1-5: Campaign level user-defined attributes
CLK_L_REF_CAT3
- Ref_Cat3_Code : Identifying code of the highest-level referrer category; natural key (User-defined)
- Ref_Cat3_Name : Name of the highest-level referrer category (User-defined)
- Ref_Cat3_Description: Description of the highest-level referrer category (User-defined)
- Ref_Cat3_Attributes 1-5: Highest-level referrer category level user-defined attributes
CLK_L_REF_CAT2
- Ref_Cat2_Code : Identifying code of the intermediate level referrer category; natural key (User-defined)
- Ref_Cat2_Name : Name of the intermediate level referrer category (User-defined)
- Ref_Cat2_Description: Description of the intermediate level referrer category (User-defined)
- Ref_Cat2_Attributes 1-5: Intermediate level referrer category level user-defined attributes
CLK_L_REF_CAT1
- Ref_Cat1_Code : Identifying code of the lowest-level referrer category; natural key (User-defined)
- Ref_Cat1_Name : Name of the lowest-level referrer category (User-defined)
- Ref_Cat1_Description: Description of the lowest-level referrer category (User-defined)
- Ref_Cat1_Attributes 1-5: Lowest-level referrer category level user-defined attributes
CLK_L_REGION
- Region_Code: Identifying code of the world region; natural key (EUROPE, MIDDLE_EAST, PACIFIC_ISLANDS)
- Region_Name : Name of the world region in which a country is located (Europe, Middle East, Pacific Islands)
- Region_Attributes 1-5: Region level user-defined attributes
CLK_L_COUNTRY
- Country_Code : Two-letter ISO code of the country; natural key (fi, jp, uk, UNKNOWN)
- Country_Name : Name of the country ( Finland, Japan, United Kingdom, United States)
- Country_Attributes 1-5: Country level user-defined attributes
CLK_L_DOMAIN_TYPE
- Domain_Type_Code : Abbreviated domain type suffix; natural key (co, com, ed, edu, net, org)
- Domain_Type_Name : Name of the domain type (Company, Education, Network, Organization)
- Domain_Type_Attributes 1-5: Domain type level user-defined attributes
CLK_L_DOMAIN
- Domain_Name : Domain name; natural key (dmsjwa.com)
- Domain_Attributes 1-5: Domain level user-defined attributes
CLK_L_REF_SITE
- Ref_Site_DNS_Alias: Full DNS alias of the referring site; natural key (www.oracle.com)
- Ref_Site_Name : Name of the referring site (OTN, Oracle.com)
- Ref_Site_Attributes 1-5: Referring site level user-defined attributes
CLK_L_REF_URL
- Ref_URL_Hostport: Host:Port string taken from the referrer URL; natural key (www.oracle.com,www.oracle.com:8080)
- Ref_URL_Stem : Path component of the referring URL (/cgi/index.pl)
- Ref_URL_Results_Page: Indicates if this referring URL is a search engine results page (Y,N)
- Ref_URL_Search_Param: When this referring URL is a search engine results page, this is the query string parameter containing the search expression (s, search)
- Ref_URL_Attributes 1-5: Referring URL level user-defined attributes