チュートリアル: 新しいディメンションに関するレポート

Sitecore.Analytics.Aggregation
Sitecore.ExperienceAnalytics.Aggregation
Sitecore.XConnect
Sitecore.Kernel
Sitecore.XConnect.Collection.Model

class BrowserMetrics : DictionaryValue, IMergeableMetric<BrowserMetrics>
    {
        public int Visits { get; set; }
        public int EngagementValue { get; set; }
        public int Bounces { get; set; }


        public T MergeWith<T>(T other) where T : BrowserMetrics, new()
        {
            if (other == null)
            {
                throw new ArgumentNullException(nameof(other));
            }

            return new T
            {
                Visits = Visits + other.Visits,
                Bounces = Bounces + other.Bounces,
                EngagementValue = other.EngagementValue
            };
        }
    }

class BrowserResolver : IGroupResolver<BrowserData>
    {
        public IEnumerable<VisitGroupMeasurement<BrowserData>> MeasureGroupOccurrences(IInteractionAggregationContext context)
        {
            if (context == null)
            {
                throw new ArgumentNullException(nameof(context));
            }

            var browserData = context.Interaction.WebVisit()?.Browser; 
            var occurrences = new List<VisitGroupMeasurement<BrowserData>>();

            if (browserData != null)
            {
                var serializedBrowserDataKey = JsonConvert.SerializeObject(browserData, new JsonSerializerSettings
                {
                    TypeNameHandling = TypeNameHandling.All
                });

                occurrences.Add(new VisitGroupMeasurement<BrowserData>(new VisitGroup(serializedBrowserDataKey), new[] { browserData }));
                return occurrences;
            }

            return occurrences;
        }
    }

class BrowserFactCalculator : IFactCalculator<BrowserMetrics, BrowserData>
    {
        public BrowserMetrics CalculateFactsForGroup(VisitGroupMeasurement<BrowserData> groupMeasurement, IInteractionAggregationContext context)
        {
            if (groupMeasurement == null)
            {
                throw new ArgumentNullException(nameof(groupMeasurement));
            }
            if (context == null)
            {
                throw new ArgumentNullException(nameof(context));
            }

            var pageViewEvents = context.Interaction.Events.OfType<PageViewEvent>().ToList();

            return new BrowserMetrics
            {
                Bounces = pageViewEvents.Count == 1 ? 1 : 0,
                EngagementValue = context.Interaction.EngagementValue,
                Visits = 1
            };
        }
    }

class BrowserParentKeyResolver : IVisitGroupKeyResolver<string>
    {
        public IEnumerable<string> GetKeys(IVisitGroup visitGroup)
        {
            if (visitGroup == null)
            {
                throw new ArgumentNullException(nameof(visitGroup));
            }

            var browserDataKey = JsonConvert.DeserializeObject<BrowserData>(visitGroup.Id, new JsonSerializerSettings
            {
                TypeNameHandling = TypeNameHandling.All
            });

            return new List<string>
            {
                browserDataKey.BrowserMajorName
            };
        }
    } 

class EventFilter : IInteractionFilter
{
  public bool KeepInteraction(Interaction interaction)
  {
     if (interaction.Events.Any(data => ReservedIds.Contains(data.DefinitionId)))
     {
         return true;
     }

     return false;
  }


   internal static readonly Guid[] ReservedIds = 
{ 
// list of guids
};
}

CREATE TABLE [dbo].[Fact_BrowserMetrics](
     -- Mandatory Columns
            [SegmentRecordId] [bigint] NOT NULL,
     [SegmentId] [uniqueidentifier] NOT NULL,
     [Date] [smalldatetime] NOT NULL,
     [SiteNameId] [int] NOT NULL,
     [DimensionKeyId] [bigint] NOT NULL,
     [FilterId] [uniqueidentifier] NULL,
            -- Dimension specific metric columns
     [Visits] [int] NOT NULL,
     [EngagementValue] [int] NOT NULL,
     [Bounces] [int] NOT NULL,
CONSTRAINT [PK_Fact_BrowserMetrics_1] PRIMARY KEY CLUSTERED 
     (
     [SegmentRecordId] ASC
     )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
     ) ON [PRIMARY]

CREATE TYPE [dbo].[BrowserMetrics_Type] AS TABLE(
     -- Mandatory Columns
     [SegmentRecordId] [bigint] NOT NULL,
     [SegmentId] [uniqueidentifier] NOT NULL,
     [Date] [smalldatetime] NOT NULL,
     [SiteNameId] [int] NOT NULL,
     [DimensionKeyId] [bigint] NOT NULL,
     [FilterId] [uniqueidentifier] NULL,

     -- Dimension specific metric columns
     [Visits] [int] NOT NULL,
     [EngagementValue] [int] NOT NULL,
     [Bounces] [int] NOT NULL,
     PRIMARY KEY CLUSTERED 
     (
     [SegmentRecordId] ASC
     )WITH (IGNORE_DUP_KEY = OFF)
     )

CREATE PROCEDURE [dbo].[Add_BrowserMetrics_Tvp]
       @table [dbo].[BrowserMetrics_Type] READONLY
     AS
     BEGIN
       SET NOCOUNT ON;

       BEGIN TRY

         MERGE [Fact_BrowserMetrics] AS Target USING @table AS Source
         ON 
           Target.[SegmentRecordId] = Source.[SegmentRecordId]
         WHEN MATCHED THEN
           UPDATE SET 
             Target.[Visits] = (Target.[Visits] + Source.[Visits]),
             Target.[EngagementValue] = (Target.[EngagementValue] + Source.[EngagementValue]),
             Target.[Bounces] = (Target.[Bounces] + Source.[Bounces])
         WHEN NOT MATCHED THEN
           INSERT (
     [SegmentRecordId],
     [SegmentId],
     [Date],
     [SiteNameId],
     [DimensionKeyId],
     [FilterId],
     [Visits],
     [EngagementValue],
     [Bounces]
           )
           VALUES (
     Source.[SegmentRecordId],
     Source.[SegmentId],
     Source.[Date],
     Source.[SiteNameId],
     Source.[DimensionKeyId],
     Source.[FilterId],
     Source.[Visits],
     Source.[EngagementValue],
     Source.[Bounces]
     );

       END TRY
       BEGIN CATCH

         DECLARE @error_number INTEGER = ERROR_NUMBER();
         DECLARE @error_severity INTEGER = ERROR_SEVERITY();
         DECLARE @error_state INTEGER = ERROR_STATE();
         DECLARE @error_message NVARCHAR(4000) = ERROR_MESSAGE();
         DECLARE @error_procedure SYSNAME = ERROR_PROCEDURE();
         DECLARE @error_line INTEGER = ERROR_LINE();

         RAISERROR( N'T-SQL ERROR %d, SEVERITY %d, STATE %d, PROCEDURE %s, LINE %d, MESSAGE: %s', @error_severity, 1, @error_number, @error_severity, @error_state, @error_procedure, @error_line, @error_message ) WITH NOWAIT;
       END CATCH;
     END