Sprinkle

Sprinkle

  • Docs
  • Tutorials
  • API
  • FAQ's
  • Blog
  • Go to sprinkledata.com

›Segments

Data Warehouse

  • Why the warehouse?
  • Amazon Athena
  • Apache Hive
  • Databricks
  • BigQuery
  • Snowflake
  • Redshift

Storage

  • Why the storage?
  • AWS S3 Bucket
  • Google Cloud Storage
  • Azure Blob Storage

Data Sources

  • Overview and Creating Data Source
  • Ingestion Mode
  • How Sprinkle handles the ingestion if there is a change in schema in the client DB?
  • Flattening JSON columns in DB
  • Column excluding and masking in DB table
  • Ingestion via SSH Tunnel
  • Configurable Destination Schema and table name
  • PostgreSQL
  • Salesforce
  • MySQL
  • MongoDB
  • Mixpanel
  • Hubspot
  • CosmosDB
  • CSV
  • AppsFlyer
  • CleverTap
  • SQL
  • Kafka
  • Amazon Kinesis
  • Azure Event Hub
  • Azure Table Storage
  • Zoho CRM
  • Freshsales
  • Google Analytics
  • GoogleSheet
  • Google Cloud Storage
  • Azure Blob
  • S3
  • Webhook
  • Sendgrid
  • Segment
  • Google Ads
  • Google Analytics MCF
  • Zendesk Support
  • Zendesk Chat
  • Google Search Console
  • Shopify
  • Facebook Ads
  • Mailchimp
  • WebURL
  • Klaviyo
  • SAP S4
  • Intercom
  • Marketo
  • Freshdesk
  • Leadsquared
  • Bigquery
  • MongoDB Atlas
  • Paytm
  • HDFS
  • FTPS
  • FTP

CDC Setup

  • MySQL
  • Postgres
  • Mongo

Transform

  • Schema Browser
  • Overview and Creating Flow
  • Advanced Features in Flow

KPI

    Models

    • Overview
    • Creating Model
    • Joins
    • Hierarchical Filters
    • Default Date Filters
    • Column Description in reports

    Segments

    • Overview
    • Creating Segment
    • Publish segment as table
    • Transpose
    • Show Labels Annotations on Charts
    • Tooltips
    • Fixed Columns
    • Conditional Builders
    • Cumulative Sum and Percentages
    • Embed Segment

    Metric Alerts

    • Overview and Creating Metric Alerts

Dashboards

  • Overview and Creating Dashboard
  • Embed Dashboard
  • Restricting filters
  • Sharing resources

Drill Down

  • Drill Down Feature In Segments And Dashboards
  • Drill Down Hierarchical Dimensions
  • Drill Down Expression Hierarchical Dimensions

Explores

  • Overview and Creating Explore
  • Show Labels Annotations on Charts
  • Tooltips

Machine Learning

  • Jupyter
  • Notebook Setup Guide

Sharing

  • Sharing Segments and Explore Reports
  • Share folders with users or groups

Scheduling

  • Schedule Timeline
  • Autorun

Notifications

  • Email Notifications
  • Slack Notifications

View Activity

  • View Activity

Admin

  • Admin -> usage
  • User Permissions & Restrictions
  • Github Integration

Launch On Cloud

  • AWS
  • Azure
  • Setup Sprinkle

Security

  • Security at Sprinkle
  • GDPR

Feedback

  • Option to take feedback from UI

Release Notes

  • Release Notes

Segments

Overview

A Cube is needed to create segments. By choosing dimensions and measures on your cube, segments can be created. Dimensions are used to bucket or group the measures for e.g. by country, city, and region. There can be multiple dimensions in a cube, say for example, like total sales by a country, top 10 users by sum of sales, etc. Here total sales is a measure, country is a dimension. By choosing country as dimension we can see the total sales by a country. In this way, we can create multiple segments. Basically segment is a report that gives deep analysis on particular dimension.

The page lists all the segments that have been created by you and other team members.

  • My Segments tab Lists all segments owned by you.

  • Shared with me tab Lists all the segments (identified by the owner field).

Segment View

The page lists the result of the latest job run on your segment report. The segment report can be scheduled thereby relieving you for running the same report again and again. You can schedule segment report for your daily, weekly or monthly reports.

  • Email button

    Report through Emails to your team members. Email can be scheduled daily, weekly or monthly.

  • Save button

    Save changes made to the chart options.

Segment Edit

This page provides the ability to modify your existing segment reports by adding or removing dimensions or measures, re running report again or schedule the segment report for auto run.

  • Save And Run

    After you are done editing your report click this button to get the latest results. A new job is launched and results are available in the result view below.

  • Auto-Run

    Schedule segment report. The segment report will run every night at scheduled time of 00:30 AM. Users with Developer role can change the default schedule.

  • Save

    Save your changes. Job is not run in this case and only measures and dimensions are saved.

Cube

Select a cube to prepare a segment report. Selecting a cube will list the dimensions and measures within that cube.

Filter

Restrict the data that is aggregated further by choosing appropriate filters on the dimensions.

Jobs

For every run of your segment query, a job is launched against your cluster. A job has a state of Queued, Running, Success, Failed and Cancelled. To see the results of Job, click Show. You can also see the results of the last 3 successful jobs run by choosing the job and click Show. The reason for last 3 failed jobs are also listed.

Result

The results of the job are displayed as a data table. You can download the result as a CSV file also.

← Column Description in reportsCreating Segment →
  • Overview
    • Segment View
    • Segment Edit
    • Cube
    • Filter
    • Jobs
    • Result

Product

FeaturesHow it worksIntegrationsDeploymentPricing

Industries

Retail & EcommerceUrban MobilityFinanceEducation

Departments

MarketingOperationsTechnology

Connect

Free trialAbout Us

Actionable Insights. Faster.

Sprinkle offers self-service analytics by unlocking enterprise scale data via simple search and powerful reporting service.


Copyright © 2021 Sprinkle data