{"queries":[{"id":"date_bounds","compiledQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'","inputQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'","compiled":false,"inline":true},{"id":"queries_over_time","compiledQueryString":"SELECT\n date,\n SUM(impressions) as impressions,\n SUM(clicks) as clicks,\n ROUND(AVG(ctr), 4) as ctr,\n ROUND(AVG(position), 1) as position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY date\nORDER BY date","inputQueryString":"SELECT\n date,\n SUM(impressions) as impressions,\n SUM(clicks) as clicks,\n ROUND(AVG(ctr), 4) as ctr,\n ROUND(AVG(position), 1) as position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY date\nORDER BY date","compiled":false,"inline":true},{"id":"top_queries","compiledQueryString":"SELECT\n query,\n SUM(impressions) as impressions,\n SUM(clicks) as clicks,\n ROUND(AVG(ctr), 4) as ctr,\n ROUND(AVG(position), 1) as position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY query\nORDER BY clicks DESC\nLIMIT 50","inputQueryString":"SELECT\n query,\n SUM(impressions) as impressions,\n SUM(clicks) as clicks,\n ROUND(AVG(ctr), 4) as ctr,\n ROUND(AVG(position), 1) as position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY query\nORDER BY clicks DESC\nLIMIT 50","compiled":false,"inline":true},{"id":"position_distribution","compiledQueryString":"SELECT\n CASE\n WHEN position <= 3 THEN 'Position 1-3'\n WHEN position <= 10 THEN 'Position 4-10'\n WHEN position <= 20 THEN 'Position 11-20'\n ELSE 'Position 20+'\n END as position_range,\n COUNT(DISTINCT query) as query_count,\n SUM(clicks) as total_clicks\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY position_range\nORDER BY\n CASE position_range\n WHEN 'Position 1-3' THEN 1\n WHEN 'Position 4-10' THEN 2\n WHEN 'Position 11-20' THEN 3\n ELSE 4\n END","inputQueryString":"SELECT\n CASE\n WHEN position <= 3 THEN 'Position 1-3'\n WHEN position <= 10 THEN 'Position 4-10'\n WHEN position <= 20 THEN 'Position 11-20'\n ELSE 'Position 20+'\n END as position_range,\n COUNT(DISTINCT query) as query_count,\n SUM(clicks) as total_clicks\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY position_range\nORDER BY\n CASE position_range\n WHEN 'Position 1-3' THEN 1\n WHEN 'Position 4-10' THEN 2\n WHEN 'Position 11-20' THEN 3\n ELSE 4\n END","compiled":false,"inline":true},{"id":"current_stats","compiledQueryString":"SELECT\n COALESCE(SUM(impressions), 0) as total_impressions,\n COALESCE(SUM(clicks), 0) as total_clicks,\n ROUND(AVG(ctr), 4) as avg_ctr,\n ROUND(AVG(position), 1) as avg_position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","inputQueryString":"SELECT\n COALESCE(SUM(impressions), 0) as total_impressions,\n COALESCE(SUM(clicks), 0) as total_clicks,\n ROUND(AVG(ctr), 4) as avg_ctr,\n ROUND(AVG(position), 1) as avg_position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","compiled":false,"inline":true},{"id":"previous_stats","compiledQueryString":"SELECT\n COALESCE(SUM(impressions), 0) as total_impressions,\n COALESCE(SUM(clicks), 0) as total_clicks,\n ROUND(AVG(ctr), 4) as avg_ctr,\n ROUND(AVG(position), 1) as avg_position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'::DATE - ('${inputs.date_range.end}'::DATE - '${inputs.date_range.start}'::DATE)\n AND date < '${inputs.date_range.start}'","inputQueryString":"SELECT\n COALESCE(SUM(impressions), 0) as total_impressions,\n COALESCE(SUM(clicks), 0) as total_clicks,\n ROUND(AVG(ctr), 4) as avg_ctr,\n ROUND(AVG(position), 1) as avg_position\nFROM analytics.gsc_queries\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'::DATE - ('${inputs.date_range.end}'::DATE - '${inputs.date_range.start}'::DATE)\n AND date < '${inputs.date_range.start}'","compiled":false,"inline":true}]}

Ceiling Pro

Search

No Results