This repository contains SQL scripts used in the article Troubleshooting Sitecore content tests:
Interactions.sql- this script checks raw interactions data in Shard databases with ability to filter by a date and/or contact ID.Contact facets.sql- checks if a contact contains a special facet with A/B test combinations, i.e. validates the fact that this contact participated in an A/B test. Results can be filtered by contact ID.Reporting.sql- checks test results in the Reporting database for specific test ID:- overall test statistics
- test conversions for specific goal
- test page clicks
Screeenshots with example data are saved for reference to the folder /screenshots.