The reporting database reference

Last updated Wednesday, May 25, 2016 in Sitecore Experience Platform for Developer

The reporting database contains aggregated data from the xDB collection database. This statistical data generated by the aggregation pipeline and used by Sitecore reporting applications is stored in fact and dimension tables organized in a star schema. In a star schema, the fact table is located at the center of the schema with the dimension tables surrounding it.

Note

There are several tables not mentioned in this topic that are intended for system use only and which should not be modified.

For more information on the type of tables used in the reporting database see SQL Server table types used in the reporting database.

The following sections describe the default tables in the reporting database:

Fact tables

Fact table is a data warehousing term used to describe tables that contain measurements and metrics. In a fact table foreign keys allow joins to be made with dimension tables.

The xDB reporting database includes the following fact tables:

Fact_AutomationStates

The xDB uses the Fact_AutomationStates table to enable engagement monitoring.

Key

Column

Description

Picture 305

PlanId

The unique engagement plan identifier.

Picture 306

StateId

The unique identifier of the engagement plan state.

Contacts

The number of contacts currently in this engagement plan state.

Fact_Conversions

The Fact_Conversions table contains the goals triggered by contacts. It provides report data for analyzing goal conversions and other related statistics.

Key

Column

Description

Picture 307

Date

The time period in which the interaction started.

Picture 308

TrafficType

The channel through which a contact receives content, for example, a website, email campaign, phone call or other type of interaction.

Picture 309

ContactId

The unique identifier of the contact that triggered the goal.

Picture 310

CampaignId

The unique identifier of the campaign for the interaction.

Picture 311

GoalId

The unique identifier of the goal triggered.

Picture 312

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 313

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 314

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 315

AccountId

The unique identifier of the entry in the Accounts dimension.

Picture 316

ItemId

The unique identifier of the item on which the goal was triggered.

Picture 317

GoalPoints

The engagement value points associated with the goal.

Visits

The total number of matching interactions.

Value

The aggregated engagement value accumulated by the matching interactions.

Count

The number of times the goal was triggered by the matching interactions.

Fact_Downloads

The Fact_Downloads table contains statistical data about downloaded assets. It enables reporting that lets you analyze download trends.

Key

Column

Description

Picture 318

Date

The time period in which the interaction started.

Picture 319

TrafficType

The channel through which a contact receives content, for example, a website, email campaign, phone call or other type of interaction.

Picture 320

CampaignId

The unique identifier of the campaign triggered by the interaction.

Picture 321

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 322

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 323

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 324

AccountId

The unique identifier of the entry in the Accounts dimension.

Picture 325

ItemId

The unique identifier of the item on which the goal was triggered.

Picture 326

AssetId

The unique identifier of the asset requested.

Visits

The total number of matching interactions.

Value

The total amount of engagement value accumulated by the matching interactions.

Count

The number of times that the asset was requested.

Fact_Failures

The Fact_Failures table contains statistical data about page events indicating errors. It enables reporting on the health of the website.

Key

Column

Description

Picture 327

VisitId

The unique interaction identifier.

Picture 328

AccountId

The unique identifier of the account belonging to the contact making the interaction.

Picture 329

Date

The time period in which the interaction started.

Picture 330

ContactId

The unique identifier of the contact initiating the interaction.

Picture 331

PageEventDefinitionId

The unique identifier of the page event definition.

Picture 332

KeywordsId

The unique identifier of the entry in the Keywords dimension.

Picture 333

ReferringSiteId

The unique identifier of the entry in the ReferringSites dimension.

Picture 334

ContactVisitIndex

The ordinal number of the current interaction among all interactions that contact has made.

Picture 335

VisitPageIndex

The ordinal number of the page visited in the current interaction.

Picture 336

FailureDetailsId

The unique identifier of the entry in the FailureDetails dimension.

Value

The total amount of engagement value accumulated by matching interactions.

Count

The total number of times the failure was encountered.

Fact_FollowHits

The Fact_FollowHits table contains statistical data about site searches.

Key

Column

Description

Picture 337

Date

The time period in which the interaction started.

Picture 338

ItemId

The unique identifier of the item clicked in the search results.

Picture 339

KeywordsId

The unique identifier of the entry in the Keywords dimension.

Visits

The total number of matching interactions.

Value

The total amount of engagement value accumulated by matching interactions.

Count

The total number of times the follow hit event was triggered.

Fact_MvTesting

The Fact_MvTesting table contains statistical data used internally by Sitecore to evaluate the efficiency of content variants used in A/B and multivariate testing.

Key

Column

Description

Picture 340

TestSetId

The unique identifier of the test set.

Picture 341

TestValues

The test combination used in the test.

Visits

The number of interactions that are associated with this test.

Value

The amount of engagement value accumulated by matching interactions.

Bounces

The number of sessions that bounced for the test. It indicates contacts that only visited this particular test page and then left the site.

TotalPageDuration

The total duration, in milliseconds, that contacts stayed on the test page.

TotalWebsiteDuration

The total duration, in milliseconds, that contacts remained on the site after viewing the test.

PageCount

The number of pages visited after the viewing the test.

Visitors

The number of unique contacts that viewed the tested content.

Fact_MvTestingDetails

The Fact_MvTestingDetails table contains facts about the test performance and the groupings within each test. It is similar to the Fact_MvTesting table, but also includes Value as part of the key.

This table is used by the system to determine when enough data has been collected for a test to be statistically valid.

Key

Column

Description

Picture 342

TestSetId

The unique identifier of the test set.

Picture 343

TestValues

The test combination used in the test.

Picture 344

Value

The amount of engagement value accumulated during a test.

Visits

The number of interactions that accumulated engagement value during a test.

Fact_PageViews

The Fact_PageViews table contains statistical data about online or offline contact interactions.

Key

Column

Description

Picture 345

Date

The time period in which the interaction started.

Picture 346

ItemId

The unique identifier of the item viewed.

Picture 347

ContactId

The unique identifier of the contact viewing the item.

Views

The total number of similar page views.

Duration

The total duration, in seconds, of matching page views.

Visits

The total number of matching interactions.

Value

The amount of engagement value accumulated by matching interactions.

TestId

ID of the test viewed during the page view.

TestCombination

The combination of test values used during a test.

Fact_PageViewsByLanguage

The Fact_PageLanguageViews table contains details on the views recorded for items by language.

Key

Column

Description

Picture 348

Date

The time period in which the interaction started.

Picture 349

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 350

ItemId

The unique identifier of the item that was viewed.

Picture 351

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 352

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Views

The total number of times the page was viewed.

Visits

The number of interactions which included a view of the page.

Duration

The total amount of time contacts spent on the page.

Value

The amount of engagement value accumulated for interactions which included a view of this page.

Fact_Personalization

The Fact_Personalization table contains facts about personalization rules that have been used as part of a test.

Key

Column

Description

Picture 353

Date

The time period in which the interaction started.

Picture 354

RuleSetId

The unique identifier of the rule set used during the test.

Picture 355

RuleId

The unique identifier of the rule.

Picture 356

TestSetId

The unique identifier of the test set.

Picture 357

TestValues

The test combination used during a test.

Picture 358

IsDefault

Indicates if the rule used was a default rule.

Visits

The number of unique interactions using the rule for this test combination.

Value

The amount of engagement value accumulated by the matching interactions.

Visitors

The number of unique contacts who matched the interactions.

Fact_SegmentMetrics

The Fact_SegmentMetrics table contains facts about a segment identified by the SegmentRecords table, and then grouped by contact transition type.

Key

Column

Description

Picture 359

SegmentRecordId

The unique identifier of the entry in the SegmentRecords dimension.

Picture 360

ContactTransitionType

Identifies the transition types measured in this row.

Visits

The number of interactions.

Value

The total amount of engagement value accumulated.

Bounces

The number of bounces.

Conversions

The total number of events in which a conversion took place.

TimeOnSite

The duration of the interaction in seconds.

Pageviews

The total number of page views.

Count

The total count of triggered events.

Fact_SegmentMetricsReduced

The Fact_SegmentMetricsReduced table contains facts about a segment that has been identified by the SegmentRecordsReduced table, and then grouped by contact transition type. These facts are processed by the reduce agent.

Key

Column

Description

Picture 361

SegmentRecordId

The unique identifier of the entry in the SegmentRecords dimension.

Picture 362

ContactTransitionType

Identifies the transition types measured in this row.

Visits

The number of interactions.

Value

The total amount of engagement value accumulated.

Bounces

The number of bounces.

Conversions

The total number of events in which a conversion took place.

TimeOnSite

The duration of the interaction in seconds.

Pageviews

The total number of page views.

Count

The total count of triggered events.

Fact_SiteSearches

The Fact_SiteSearches table contains statistical data about keywords used by contacts searching the site.

Key

Column

Description

Picture 363

Date

The time period in which the interaction started.

Picture 364

TrafficType

The channel through which a contact interacts with your organization, for example, a website, email campaign, phone call or other type of interaction.

Picture 365

CampaignId

The unique identifier of the campaign.

Picture 366

ItemId

The unique identifier of the item on which the search was initiated.

Picture 367

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 368

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 369

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 370

AccountId

The unique identifier of the entry in the Accounts dimension.

Picture 371

KeywordsId

The unique identifier of the entry in the Keywords dimension.

Visits

The total number of matching interactions.

Value

The total amount of engagement value accumulated in the matching interactions.

Count

The number of times that the search was executed.

Fact_SlowPages

The Fact_SlowPages table contains information about pages that rendered slowly.

Key

Column

Description

Picture 372

Date

The time period in which the interaction started.

Picture 373

ItemId

The unique identifier of the item that was rendered.

Picture 374

Duration

The time, in milliseconds, that it took to render the item.

Picture 375

VisitId

The unique identifier of the interaction.

Picture 376

AccountId

The unique identifier of the entry in the Accounts dimension.

Picture 377

ContactId

The unique identifier of the contact.

Picture 378

ContactVisitIndex

The ordinal number of the current interaction among all interactions that were made by the contact.

Picture 379

Value

The amount of engagement value accumulated during the interaction.

Views

The number of times that the item was viewed.

Fact_TestConversions

The Fact_TestConversions table contains information about the goal conversions recorded as a result of a test.

Key

Column

Description

Picture 380

GoalId

The unique identifier of the goal that was converted.

Picture 381

TestSetId

The unique identifier of the test set.

Picture 382

TestValues

The test combination that the contact was exposed to.

Visits

The number of unique interactions where the goal was converted.

Value

The amount of engagement value accumulated during the test.

Count

The total number of times that the goal was converted after the test began.

Fact_TestOutcomes

The Fact_TestOutcomes table contains information about the outcome of tests. It is used to rank and report on individual testers, for example, authors and optimization experts.

Key

Column

Description

Picture 383

TestSetId

The unique identifier of the test set.

TestOwner

The user name of the user who owns the test.

CompletionDate

The date and time that the test was completed.

TestScore

The test score that was awarded for the test.

Effect

The change in value over the original content.

Guess

The test owner's guess on the outcome of the test.

Fact_TestPageClicks

The Fact_TestPageClicks table contains facts about which pages were visited directly after the test.

Key

Column

Description

Picture 384

TestSetId

The unique identifier of the test set.

Picture 385

TestValues

The test combination used in the test.

Picture 386

ItemId

The ID of the next item navigated to directly after the test.

Views

The number of times that a contact navigated to the item.

Fact_TestStatistics

The Fact_TestStatistics table contains facts about the current statistical significance of the test. Unlike other fact tables, the data is not populated through aggregation but by the system.

Key

Column

Description

Picture 387

TestSetId

The unique identifier of the test set.

Power

The power of the test as calculated using Pearson’s Chi squared test.

P

The P value of the test as calculated using Pearson’s Chi squared test.

IsStatisticalRelevant

Indicates whether the test is statistically significant.

Fact_Traffic

The Fact_Traffic table contains statistical data about interactions. The Fact_Traffic table is optimized for inserts and date range queries.

Key

Column

Description

Picture 388

Date

The time period in which the interaction started.

Checksum

A value that is derived from the logical primary key for fast lookups.

Picture 389

TrafficType

The channel through which a contact came to a website.

Picture 390

CampaignId

The unique identifier of the entry in the Campaigns dimension.

Picture 391

ItemId

The unique identifier of the entry in the Items dimension.

Picture 392

KeywordsId

The unique identifier of the entry in the Keywords dimension.

Picture 393

ReferringSiteId

The unique identifier of the entry in the ReferringSites dimension.

Picture 394

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 395

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 396

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 397

FirstVisit

Indicates whether the interaction is the first interaction for the contact.

Visits

The total number of matching interactions.

Value

The total amount of engagement value accumulated by the matching interactions.

Fact_ValueBySource

The Fact_ValueBySource table contains statistical data about the source channels that contacts use to interact with your organization or brand.

Key

Column

Description

Picture 398

Date

The time period in which the interaction started.

Picture 399

TrafficType

The channel through which a contact came to a website.

Picture 400

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 401

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 402

LanguageId

The unique identifier of the entry in the Languages dimension.

FirstVisitValue

The total amount of engagement value accumulated during the first interaction of a contact.

Contacts

The number of unique contacts that accessed the content.

Visits

The total number of matching interactions.

Value

The total amount of engagement value accumulated during the matching interactions.

Fact_Visits

The Fact_Visits table contains statistical data about interactions.

Key

Column

Description

Picture 403

Date

The time period in which the interaction started.

Picture 404

ItemId

The unique identifier of the first item that a contact viewed during the interaction.

Picture 405

ContactId

The unique identifier of the contact making the interaction.

Picture 406

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 407

FirstVisit

Indicates whether this is the first interaction for the contact.

PagesCount

The number of items viewed during the interaction.

Fact_VisitsByBusinessContactLocation

The Fact_VisitsByBusinessContactLocation table contains statistical data about the geographical distribution of contacts who interact with your organization.

Key

Column

Description

Picture 408

AccountId

The unique identifier of the entry in the Accounts dimension.

Picture 409

BusinessUnitId

The unique identifier of the entry in the BusinessUnits dimension.

Picture 410

Date

The time period in which the interaction started.

Picture 411

TrafficType

The channel through which a visitor came to a website.

Picture 412

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

Picture 413

DeviceNameId

The unique identifier of the entry in the DeviceNames dimension.

Picture 414

ContactId

The unique identifier of the contact making the interaction.

Picture 415

LanguageId

The unique identifier of the entry in the Languages dimension.

Picture 416

Latitude

The latitude from where the interaction was initiated.

Picture 417

Longitude

The longitude from where the interaction was initiated.

Visits

The total number of matching interactions.

Value

The total amount engagement value points accumulated in the matching interactions.

Dimension Tables

Dimension tables are companion tables to fact tables, and are similar to Microsoft SQL Server lookup tables. They contain descriptive attributes or textual fields that help you understand and analyze the data in fact tables.

The xDB reporting database includes the following dimension tables:

Accounts

The Accounts table contains information about the organization based on their IP addresses.

Key

Column

Description

Picture 418

AccountId

The unique identifier of the organization.

BusinessName

The organization name that is returned by the IP Geolocation provider.

Country

The name of the country in which the organization is located.

Classification

The classification of the location.

IntegrationId

A unique identifier that connects this entry to an external data source.

IntegrationLabel

A label that provides additional information about the relationship between this entry and an entry in an external data source.

ExternalUser

Connects the account to a Sitecore user.

Assets

The Assets table contains the URLs of downloadable content.

Key

Column

Description

Picture 419

AssetId

A generated surrogate key that is used to reference entries in this table.

Url

The URL of the downloadable content.

BusinessUnits

The BusinessUnits table contains information about business units.

Key

Column

Description

Picture 420

BusinessUnitId

The unique identifier of the business unit.

AccountId

The unique identifier of the account connected to the business unit.

BusinessName

The name of the business unit.

Country

The ISO code of the country in which the business unit is located.

Region

The region within the country in which the business unit is located.

City

The city within the region in which the business unit is located.

CampaignActivityDefinitions

The CampaignActivityDefinitions table contains the classified campaign activity definitions matching those found in the Marketing Control Panel. This is populated by deploying campaign definitions in Sitecore and should not be modified directly using SQL.

Key

Column

Description

Picture 421

Id

The unique identifier of the campaign activity definition item.

Picture 422

Version

The campaign item version.

Picture 423

Language

The language that the campaign activity is deployed in.

IsActive

This indicates whether the campaign is active.

Data

Campaign execution – this link is used to associate the campaign with an item for tracking or to associate it with an engagement plan.

Campaigns

The Campaigns table contains information about deployed campaigns.

Key

Column

Description

Picture 424

CampaignId

The unique identifier of the campaign.

CampaignName

The name or title of the campaign.

Cost

The total cost of the campaign.

CostPerClick

The cost of the campaign per click.

CostPerDay

The cost of the campaign per day.

CostBase

The base cost of the campaign.

Category1Label

The taxonomy classification of the campaign definition item. This column maps to the folder where you store your campaign.

Category1Id

The taxonomy classification of the campaign definition item. This column maps to the folder where you store your campaign.

Category2Label

The taxonomy classification of the campaign definition item. This column maps to the folder where the campaign is stored.

Category2Id

The taxonomy classification of the campaign definition item. This column maps to the folder where the campaign is stored.

Category3Label

The taxonomy classification of the campaign definition item. This column maps to the folder where the campaign is stored.

Category3Id

The taxonomy classification of the campaign definition item. This column maps to the folder where the campaign is stored.

IntegrationLabel

A label that provides additional information about the relationship this entry has with an entry in an external data source.

IntegrationId

A unique identifier that connects this entry to an external data source.

IsActive

Indicates whether the campaign is active.

StartDate

The start date for the campaign.

EndDate

The end date for the campaign.

Data

Custom data associated with the campaign.

DeviceNames

The DeviceNames table contains the names of devices used by the contact.

List of table columns with descriptions:

Key

Column

Description

Picture 425

DeviceNameId

A generated surrogate key used to reference entries in this table.

DeviceName

The name of the device.

DimensionKeys

The DimensionKeys table translates the raw representation of a key to a lightweight unique hash.

List of table columns with descriptions:

Key

Column

Description

Picture 426

DimensionKeyId

The hash of the DimensionKey.

DimensionKey

The unique string value identifying the variations of a dimension.

FailureDetails

The FailureDetails table contains details about failure events.

Key

Column

Description

Picture 427

FailureDetailsId

A generated surrogate key used to reference entries in this table.

Url

The URL that is used when the failure occurs.

ErrorText

The description of the error.

PreviousUrl

The URL that was visited prior to the failure occurring.

DataKey

The first 100 characters of the data associated with the event.

Data

The first 450 characters of the data associated with the event.

Items

The Items table contains the URLs of items.

Key

Column

Description

Picture 428

ItemId

The unique identifier of the item.

Url

The URL of the item.

Keywords

The Keywords table contains both the external and the local search terms used.

Key

Column

Description

Picture 429

KeywordsId

A generated surrogate key used to reference entries in this table.

Keywords

The search term used.

Languages

The Languages table contains the names of the languages used.

Key

Column

Description

Picture 430

LanguageId

A generated surrogate key used to reference entries in this table.

Name

The English name of the language.

PageEventDefinitions

The PageEventDefinitions table contains the definitions of both the predefined and custom analytics page events.

Key

Column

Description

Picture 431

PageEventDefinitionId

The unique identifier of the page event definition.

Name

The name of the event.

Value

The engagement value associated with the event.

IsSystem

Indicates whether the event is a system event.

IsAuthorFeedback

Indicates whether the event provides feedback to content authors.

IsGoal

Indicates whether the event is a goal.

IsFailure

Indicates whether the event is an error.

Category1Label

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

Category1Id

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

Category2Label

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

Category2Id

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

Category3Label

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

Category3Id

The taxonomy classification of the page event definitions. This maps to the folder where your page events are stored.

SegmentRecords

The SegmentRecords table contains the measurements performed for a segment, date, site and dimension key. The dimension key contains the ID of the type of entity being measured by the segment, and is defined by the dimension or segment type.

Key

Column

Description

Picture 432

SegmentRecordId

A surrogate identifier derived from the SegmentId, Date, SiteNameId, and DimensionKeyId.

SegmentId

The unique identifier of the entry in the Segments dimensions.

Date

The date for the measurements of this record.

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

DimensionKeyId

The unique identifier of the entry in the DimensionsKeys dimension.

SegmentRecordsReduced

The SegmentRecordsReduced table contains the measurements performed for a segment, date, site, and dimension key processed by the reduce agent. The dimension key contains the ID of the type of entity being measured by the segment, and is defined by the dimension or segment type.

Key

Column

Description

Picture 433

SegmentRecordId

A surrogate identifier derived from the SegmentId, Date, SiteNameId and DimensionKeyId.

SegmentId

The unique identifier of the entry in the Segments dimensions.

Date

The date for the measurements of this record.

SiteNameId

The unique identifier of the entry in the SiteNames dimension.

DimensionKeyId

The unique identifier of the entry in the DimensionsKeys dimension.

Segments

The Segments table contains a local representation of segment items created in the Marketing Control Panel under Experience Analytics. The contents of the Segments table are used by xAnalytics when aggregating interactions.

Key

Column

Description

Picture 434

SegmentId

The unique identifier of the Sitecore item that contains the original representation of a segment.

DimensionId

The unique identifier of the Sitecore item that contains the original representation of the dimension that defines the type of this segment.

Filter

The serialized representation of the Sitecore item that this segment refers to as its filter.

DeployDate

The date after which this segment is expected to have processed all interactions using live aggregation.

Status

The status codes of segments during the rebuild process:

  • Not initialized = 0
  • Initializing = 1
  • Initialized = 2
  • Failed = 200

ReferringSites

The ReferringSites table contains the URLs of the websites that link to your site.

Key

Column

Description

Picture 435

ReferringSiteId

A generated surrogate key that is used to reference entries in this table.

ReferringSite

The name of the site that links to your website.

SiteNames

The SiteNames table contains the names of the websites defined in your setup.

Key

Column

Description

Picture 436

SiteNameId

A generated surrogate key used to reference entries in this table.

SiteName

The name of the logical website.

Testing_ClusterMembers

The Testing_ClusterMembers table maps between contacts and the clusters that the contacts belong to.

Key

Column

Description

Picture 437

ContactId

The unique identifier of the contact.

Picture 438

ClusterId

The unique identifier for the cluster the contact belongs to.

Date

The date and time when the record was saved.

TestId

The unique identifier of the test set.

Testing_Clusters

The Testing_Clusters table contains the clusters of contacts that have been identified for a test.

Key

Column

Description

Picture 439

ClusterId

The unique identifier for the cluster.

Picture 440

FeatureName

The name of the feature that is used for classification within the cluster.

Date

The date and time that the record was saved.

TestId

The unique identifier of the test set.

FeatureValue

The value of the feature used for classification within the cluster.

TreeDefinitions

The TreeDefinitions table stores a reduced set of properties from the Maps folder where the definition items for Path Analyzer, path maps are stored.

Key

Column

Description

Picture 441

DefinitionId

The GUID of the corresponding path map item ID from the Sitecore master database.

Data

Contains the serialized JSON of reduced set of properties of a given path map definition item, such as type, builder type, start date, end date, and rule based filter.

DeployDate

The deploy date of a given path map definition item.

Status

The status of the path map definition.

TaskId

The unique identifier of the task.

Trees

The Trees table contains the actual data for a particular path map in the form of a tree object serialized as a blob. Each record in this table corresponds to a particular tree definition by ID and corresponds to a date (StartDate and EndDate columns).

Key

Column

Description

Picture 442

DefinitionId

Foreign key reference to the TreeDefinitions.DefinitionId column in the TreeDefinitions table.

Picture 443

StartDate

The start of the date interval that the tree blob corresponds to.

For example: 2013-12-21

Picture 444

EndDate

The end of the date interval that the tree blob corresponds to.

For example: 2013-12-22

TreeBlob

The serialized blob containing the tree object providing the underlying data for a path map and for a given time scale.

Visits

The total count of visits that are stored in a tree object.

This helps to identify empty trees or trees without actual data. The Path Analyzer still creates these trees, but the Visits value will always be ‘0’.

Value

Total amount of engagement value for all nodes in a tree object.

Nodes

Total number of nodes in a tree object.

This helps to identify empty trees or trees without actual data. The Path Analyzer still creates these trees, but the number of nodes will always be ‘1’, with the root node being the only node in the tree.

Version

The auto-generated time stamp of the last update made to the tree. It is used to resolve concurrency issues between multiple processing instances that are trying to update the same tree record.

TrafficTypes

The TrafficTypes table contains the definitions of channels through which contacts discover content.

Key

Column

Description

Picture 445

TrafficType

A predefined surrogate key that is used to reference entries in this table.

Text

The name of the channel.

VisitorClassification

The VisitorClassification table contains a description of the visitor classification values.

Key

Column

Description

Picture 446

VisitorClassification

A predefined surrogate key used to reference entries in this table.

Text

The name of the visitor classification.

Trail Tables

Trail tables are used to ensure that no input data is processed more than once. Each time input data is processed, its unique identifier and a timestamp is recorded in the trail table.

The xDB reporting database includes the following trail tables:

Key

Column

Description

Picture 447

Id

The unique identifier of the data that has been processed. The name of the column varies among trail tables. In some cases, this may be a compound key.

Processed

The date and time that the data was processed.

Views

Views are SQL queries that enable you to create other queries more quickly and efficiently. For example, views enable you to reuse joins between tables.

The xDB reporting database includes the following views:

View

Description

Conversions

Enables you to query the Fact_Conversions table.

Downloads

Enables you to query the Fact_Downloads table.

FollowHits

Enables you to query the Fact_FollowHits table.

SiteSearches

Enables you to query the Fact_SiteSearches table

SlowPages

Enables you to query the Fact_SlowPages table.

TopLeads

Enables you to query the Fact_VisitsByBusinessContactLocation table.

Traffic

Enables you to query the Fact_Traffic table.

TrafficOverview

Provides backwards compatibility.

ValueBySource

Enables you to query the Fact_ValueBySource table.

Send feedback about the documentation to docsite@sitecore.net.