Analytics SAQL Developer Guide

Overview
Introduction
Use SAQL in the CRM Analytics Dashboard
SAQL Null Measures and Dimensions
Release Notes
Quick Start
Examples
SAQL Reference
Query Performance
PDF

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Overview

Use SAQL (Salesforce Analytics Query Language) to access data in CRM Analytics dataset. CRM Analytics uses SAQL behind the scenes in lenses, dashboards, and explorer to gather data for visualizations.
Developers can write SAQL to directly access CRM Analytics data via:
  • CRM Analytics REST API

    Build your own app to access and analyze CRM Analytics data or integrate data with existing apps.

  • Dashboard JSON

    Create advanced dashboards. A dashboard is a curated set of charts, metrics, and tables.

  • Compare Table

    Use SAQL to perform calculations on data in your tables and add the results to a new column.

  • Transformations During Data Flow

    Use SAQL to perform manipulations or calculations on data when bringing it in to CRM Analytics.