パーソナライズポイント別のパーソナライズ属性のクエリ

このクエリでは、指定された日付範囲のパーソナライズポイント別の属性が表示されます。これには、一意のプロファイルの数、クリックと関連付けられた注文の合計数、日付別の関連付けられた収益が含まれます。

SELECT 
AttributionDate__c,
PersonalizationDecision__c,
PersonalizationPoint__c,
Personalizer__c,
SUM(PersonalizationRequestCount__c) as personalization_requests,
SUM (UniqueProfileCount__c) as unique_individuals,
SUM (AttributedViewsCount__c) as views,
SUM (AttributedClicksCount__c) as clicks,
SUM (AttributedCartsCount__c) as carts,
SUM (AttributedOrdersCount__c) as orders,
SUM(AttributedOrdersCount__c) / NULLIF(SUM(AttributedViewsCount__c), 0)*100 as orderConversionRate,
SUM (AttributedRevenue__c) as revenue
FROM scm_PersonalizationPointViewAttribution__dlm
WHERE  AttributionDate__c >= date('2024-01-01') AND AttributionDate__c <= date('2024-04-01')
GROUP BY 1,2,3,4
ORDER BY AttributionDate__c ASC;