Upgrade the Experience Analytics data
You must only follow this step if you are upgrading from Sitecore XP 9.0.0, 9.0.1, or 9.0.2.
To upgrade Experience Analytics data:
-
Locate the
SXP_reporting_migrate_experience_analytics_data.sqlscript file.This script file is available in the
Database Upgrade Script.zipfile.ImportantIf you have added custom segments, you must update the migration script with these segments. For an example, see Update Experience Analytics custom segments.
-
In SQL Server, select the Reporting database and run the
SXP_reporting_migrate_experience_analytics_data.sqlscript.The script deletes the following database artifacts:
[dbo].Add_DeviceMetrics_Tvp[dbo].Add_GeoMetrics_Tvp[dbo].DeviceMetrics_Type[dbo].GeoMetrics_Type[dbo].Fact_DeviceMetrics[dbo].Fact_GeoMetrics
The script also migrates all the data in the
Fact_DeviceMetricsandFact_GeoMetricstables to other tables in the database.
Update personalization rules
In Sitecore XP 9.1.0, the following personalization conditions were modified:
- Campaign was Triggered
- Entry Page
- Day of Week
- Device Type
- Matches Pattern
If you have implemented any personalization rules that use these conditions, you must update them.
The following table lists the changes:
| Sitecore XP 9.0.2 or earlier | Sitecore XP 9.1 or later |
|---|---|
| where the specific campaign was triggered during the current visit | where at least one of campaigns in list was triggered during the current visit |
| where the Visit started at the Entry Page | where the Visit started at one of pages in list |
| when the current day is day of the week | when the current day is one of days of the week |
| where device type is value | where device type is one of the list |
| where the current contact matches the specific pattern card in the specific profile | where the current contact matches at least one of the profile pattern card in lists |