Pipeline Intelligence SQL Query Examples

Use these SQL query examples to derive insights and visibility into the Salesforce Personalization pipeline, its metrics, and performance.

• Get Information About Personalization Pipeline Requests
  This query retrieves who made the request and when, the response time, and which content was returned.
• Aggregate the Requests Served to Individuals per Day
  This query gets the number of requests served and how many individuals received those requests on a daily basis.
• View Personalization Pipeline Metrics by Date
  This query shows various pipeline metrics grouped by date, personalization point, and personalization decision over the selected date range.