Sprinkle

Sprinkle

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

›Data Sources

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

Google Ads

Google Ads is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.

Sprinkle now supports Google Ads as a data source. So, if you are running multiple campaigns across Google Ads, Sprinkle serves as a single source of truth for all the campaigns. In order to add Google Ads as a Data Source, the user can click on Data Sources and then on the ‘+’ sign. Upon clicking on the ‘+’ sign a list of data sources appears. The user needs to select Google Ads in this case and name the data source.

alt_text     

Once the datasource is selected and named, the user will need to enter the** Developer Token** and also the Client Id. The Developer Token can be used to target any Google Ads account and download reports by using OAuth2 authentication.

For details on how to generate Developer Token, click here.

alt_text     

Next to Developer Token, the user needs to enter the Client Id. For getting the Client Id, the user needs to sign up for the AdWords API access through the **Manager Account. **Next, the user needs to sign in and navigate to the following path. TOOLS & SETTINGS > SETUP > API Center.The API Center option will appear only for Google Ads Manager Accounts. For more details click here.

alt_text     

Client Customer Id is referred to the account the user is targeting and this could be found at the top right corner near to Account Id.

alt_text     

Once the Developer Token and Client Id details are filled, the user needs to Reauthorize Google.

alt_text     

Once the connection is established, users can go to Datasets and select the table type as per their choice. Sprinkle offers three kinds of tables. They are campaign Data, Reports and Query.

alt_text     

If the user selects campaign Data, then it shows a drop down to select the table name. The table name could be Ad_Group or Campaign.

alt_text      If the user selects reports, then need to select the report in the Table Name field from the drop down.

alt_text     

At the last, if the user selects a Query then it is required to select the name of the dataset and write the AWQL in the box provided. This will enable the user to deep dive into the Adwords campaign that he might be running.

alt_text     

← SegmentGoogle Analytics MCF →

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