Summary Query: coll_channel_summary

Back to Summaries
Basic Information
Name: coll_channel_summary
Target Table:
Query Type:
Status: Active
Created: 2025-10-16 04:31:29
Updated: 2025-10-16 04:31:29
Query Configuration
Filters: 1 filter(s) defined
Tags: category_collections channel_analysis

Description

Summary of collections by channel type

Query
SELECT summary_queries.id AS summary_queries_id, summary_queries.name AS summary_queries_name, summary_queries.description AS summary_queries_description, summary_queries.source_table AS summary_queries_source_table, summary_queries.dimensions AS summary_queries_dimensions, summary_queries.metrics AS summary_queries_metrics, summary_queries.filters AS summary_queries_filters, summary_queries.joins AS summary_queries_joins, summary_queries.derived_fields AS summary_queries_derived_fields, summary_queries.filter_expression AS summary_queries_filter_expression, summary_queries.filter_expression_type AS summary_queries_filter_expression_type, summary_queries.post_process_expression AS summary_queries_post_process_expression, summary_queries.post_process_expression_type AS summary_queries_post_process_expression_type, summary_queries.order_by AS summary_queries_order_by, summary_queries."limit" AS summary_queries_limit, summary_queries.tags AS summary_queries_tags, summary_queries.is_public AS summary_queries_is_public, summary_queries.active AS summary_queries_active, summary_queries.created_at AS summary_queries_created_at, summary_queries.created_by AS summary_queries_created_by, summary_queries.updated_at AS summary_queries_updated_at 
FROM summary_queries
Filters
[
  {
    "field": "summary_data.category_code",
    "value": "COLLECTIONS",
    "operator": "="
  }
]