Dataset queries let you extract, filter, and transform data from your Scoop datasets. Use them when blending datasets, pulling data into Google Sheets, or creating aggregated views of your data.

Where Queries Are Used

Query Configuration

Basic Options

Date Range

Control the time period of data returned:

💡

Snapshot datasets: "Use latest snapshot" gives you point-in-time state, while a date range gives you historical snapshots.

Dataset Source

Select which dataset and table to query:

1. Dataset — The Scoop dataset to pull from
2. Table — If dataset has multiple tables, select which one

Column Selection

Check the columns you want in your query results. Only selected columns appear in the output.

Tips:

• Select only needed columns for better performance
• Include key columns for blending
• Deselect sensitive columns for sharing

Column Filters

Click the filter icon next to any column to add conditions:

Multiple filters combine with AND logic.

Advanced Options

Click Advanced to access additional query capabilities:

Date to Group By

By default, Scoop uses the load date (when data was ingested). Switch to a business date in your data for more meaningful analysis.

See Intelligent Date Handling for details.

Aggregation

Aggregate by Selected Attributes

When enabled, numbers are summed and grouped by selected text columns:

Example: Sales data with Rep, Region, Amount

Why aggregate?

• Reduce data volume for blending
• Match aggregation levels between datasets
• Create summary views

Aggregate by Time Period

Control the time granularity of aggregated data:

Example: Daily transactions → Monthly totals

Data Retrieval Mode

For snapshot datasets, choose what data to retrieve:

Changes mode returns:

• What value changed (column)
• From what value
• To what value
• When the change occurred

Useful for detailed lifecycle analysis without building custom queries.

Query Examples

Simple Filter Query

Goal: Get all closed-won deals from Q4

Configuration:

• Date range: 2024-10-01 to 2024-12-31
• Columns: Deal ID, Name, Amount, Rep
• Filter: Stage = "Closed Won"

Aggregated Summary

Goal: Monthly revenue by region

Configuration:

• Columns: Region, Amount
• Aggregate by: Region
• Time period: Monthly
• Date: Close Date

Result: One row per region per month with total amount

Change Analysis

Goal: Track deal stage changes

Configuration:

• Data retrieval: Changes
• Columns: Deal ID, Stage, Change Date
• Filter: Stage column changes

Result: Every stage transition with before/after values

Blending Preparation

Goal: Summarize support tickets by account for blending with CRM

Configuration:

• Columns: Account ID, Ticket Count, Avg Resolution Time
• Aggregate by: Account ID
• Time period: Monthly

Result: One row per account with ticket metrics, ready to blend with CRM account data

Filter Syntax Reference

Text Filters

Numeric Filters

Date Filters

Best Practices

Performance

• Filter data as early as possible
• Select only needed columns
• Use aggregation to reduce row counts
• Choose appropriate date ranges

Data Quality

• Verify filters return expected results
• Test with preview before processing
• Check for NULL handling in filters

Maintainability

• Use consistent date column choices
• Document complex filter logic
• Name blended datasets descriptively

Troubleshooting

No Data Returned

Causes:

• Filters too restrictive
• Date range doesn't contain data
• Wrong table selected

Solutions:

1. Remove filters and verify base data exists
2. Expand date range
3. Check table selection

Too Much Data

Causes:

• Aggregation not enabled
• Too wide date range
• Missing filters

Solutions:

1. Enable aggregation by attributes
2. Narrow date range
3. Add appropriate filters

Wrong Aggregation

Causes:

• Wrong date column selected
• Missing grouping columns
• Incorrect time period

Solutions:

1. Verify date column choice
2. Select all needed attribute columns
3. Adjust time period granularity

Related Topics

• Blending Datasets - Combine data from multiple sources
• Google Sheets Plugin - Pull live data into sheets
• Intelligent Date Handling - Date intelligence
• Snapshot Datasets - Change tracking