Appendices

Appendix C - Update Experience Analytics custom segments

Version: 10.5

If a customer has a custom segment under the By campaign facet dimension called testSegment with the guid acdfb2fc-b2d2-452f-ac5a-6dcb5a3b9cae, the customer must use this guid in the script that migrates data for Campaign facet metrics.

The following example illustrates this:

IF(OBJECT_ID('dbo.[Fact_CampaignMetrics]', 'U') IS NOT NULL)
BEGIN
INSERT INTO Fact_CampaignGroupMetrics
SELECT *
FROM Fact_CampaignMetrics
WHERE SegmentId = '2B6EF914-175F-4DC1-BE6F-05255B437A91';
INSERT INTO Fact_CampaignFacetMetrics
SELECT *
FROM Fact_CampaignMetrics
WHERE SegmentId IN ('F47B44D8-07E4-4CD5-A423-0EB7F8A2A3DE', 'acdfb2fc-b2d2-452f-ac5a-6dcb5a3b9cae');
INSERT INTO Fact_CampaignFacetGroupMetrics
SELECT *
FROM Fact_CampaignMetrics
WHERE SegmentId = 'CA62842F-CBFE-4C7A-856E-4BB5E4FE30E1';
DELETE FROM Fact_CampaignMetrics
WHERE SegmentId IN('2B6EF914-175F-4DC1-BE6F-05255B437A91', 'F47B44D8-07E4-4CD5-A423-0EB7F8A2A3DE', 'CA62842F-CBFE-4C7A-856E-4BB5E4FE30E1');
END;

Note

This is required for segments that are created under the Experience Analytics Dimensions.

If you have suggestions for improving this article, let us know!