Calculated Insight Example SQL Expressions

Use these example SQL expressions to create calculated insights for use in near real-time item data graphs.

• Lifetime Value by Brand and Category Calculated Insight
  This insight calculates a sum of the lifetime value. You can filter the insight by brand or category.
• Product Top Sellers Standard Insight
  This insight calculates the sum of products that have been sold. Salesforce Personalization uses the output from this insight to create a list of top-selling products. The Maximize Revenue objective-based recommender requires the provided SQL code in the calculated insight.
• Co-Bought Standard Insight for Products
  This insight determines products purchased along with the product currently being viewed.
• Co-Browsed Standard Insight for Articles
  This insight determines the articles most co-browsed in reference to the current article.