Sitecore.Support.159444

Reach metric calculated incorrectly for personalized component in the Personalized experience dialog.

Solution 1

There a way to address this issue by tweaking the defined query for get exposure metrics.

• Navigate to /sitecore/system/Settings/Content Testing/Report Queries/Ruleset Exposure item
• Replace SQL query in the Data field to this one:

SELECT
	[RuleId],
    SUM([Visitors]) as [Visitors]
FROM 
	[dbo].[Fact_RulesExposure]
WHERE
	[Date] >= @StartDate AND [Date] <= @EndDate AND
	[ItemId] = @ItemId AND
	[RuleSetId] = @RuleSetId
GROUP BY [RuleId]

Solution 2

Use the code based solution located in the branches of this project. You can download already built zip with the DLL and the config file for it from releases section.

License

This patch is licensed under the Sitecore Corporation A/S License for GitHub.

Download

Downloads are available via GitHub Releases.