Co-Buit Standard Insight for Products (商品の共同購入標準インサイト)

このインサイトを作成するときは、Data 360 ドキュメントの「Create a Calculated Insight Using SQL (SQL を使用した計算済みインサイトの作成)」の手順を使用します。その後、インサイトを Salesforce Personalization のほぼリアルタイムの項目データグラフに追加できます。

SELECT
     ssot__GoodsProduct__dlm.ssot__Id__c as p1__c,
     Table2.productId__c as p2__c,
     SUM(Table2.count__c) as countP2__c
FROM
(
     SELECT 
          ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c as      
          productId__c,
          ssot__ProductOrderEngagement__dlm.ssot__Id__c as orderNumber__c,
          count(ssot__SalesOrderProductEngagement__dlm.ssot__Id__c) as 
          count__c
FROM 
     ssot__SalesOrderProductEngagement__dlm
JOIN 
     ssot__ProductOrderEngagement__dlm
ON 
     ssot__ProductOrderEngagement__dlm.ssot__Id__c =      
     ssot__SalesOrderProductEngagement__dlm.ssot__ProductOrderEngagementId__c
GROUP BY
     ssot__ProductOrderEngagement__dlm.ssot__Id__c,
     ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c
) as Table1
JOIN
(
     SELECT 
          ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c as 
          productId__c,
          ssot__ProductOrderEngagement__dlm.ssot__Id__c as orderNumber__c,
          count(ssot__SalesOrderProductEngagement__dlm.ssot__Id__c) as 
          count__c
FROM 
     ssot__SalesOrderProductEngagement__dlm
JOIN 
     ssot__ProductOrderEngagement__dlm
ON 
     ssot__ProductOrderEngagement__dlm.ssot__Id__c =    
     ssot__SalesOrderProductEngagement__dlm.ssot__ProductOrderEngagementId__c
GROUP BY
     ssot__ProductOrderEngagement__dlm.ssot__Id__c,
     ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c
) as Table2
ON 
     Table1.orderNumber__c = Table2.orderNumber__c
JOIN 
     ssot__GoodsProduct__dlm
ON 
     ssot__GoodsProduct__dlm.ssot__Id__c = Table1.productId__c
WHERE 
     Table1.productId__c <> Table2.productId__c
GROUP BY 
     ssot__GoodsProduct__dlm.ssot__Id__c,
     Table2.productId__c