{"queries":[{"id":"date_bounds","compiledQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'","inputQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'","compiled":false,"inline":true},{"id":"profile_views","compiledQueryString":"SELECT\n date,\n value as profile_views\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'\n AND metric = 'profile_views'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nORDER BY date","inputQueryString":"SELECT\n date,\n value as profile_views\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'\n AND metric = 'profile_views'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nORDER BY date","compiled":false,"inline":true},{"id":"search_vs_maps","compiledQueryString":"SELECT\n date,\n SUM(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views\nFROM analytics.gbp_insights\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(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views\nFROM analytics.gbp_insights\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":"actions_trend","compiledQueryString":"SELECT\n date,\n SUM(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\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(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\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":"current_metrics","compiledQueryString":"SELECT\n SUM(CASE WHEN metric = 'profile_views' THEN value ELSE 0 END) as total_views,\n SUM(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views,\n SUM(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","inputQueryString":"SELECT\n SUM(CASE WHEN metric = 'profile_views' THEN value ELSE 0 END) as total_views,\n SUM(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views,\n SUM(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","compiled":false,"inline":true},{"id":"previous_metrics","compiledQueryString":"SELECT\n SUM(CASE WHEN metric = 'profile_views' THEN value ELSE 0 END) as total_views,\n SUM(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views,\n SUM(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\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 SUM(CASE WHEN metric = 'profile_views' THEN value ELSE 0 END) as total_views,\n SUM(CASE WHEN metric = 'search_views' THEN value ELSE 0 END) as search_views,\n SUM(CASE WHEN metric = 'maps_views' THEN value ELSE 0 END) as maps_views,\n SUM(CASE WHEN metric = 'phone_calls' THEN value ELSE 0 END) as phone_calls,\n SUM(CASE WHEN metric = 'website_clicks' THEN value ELSE 0 END) as website_clicks,\n SUM(CASE WHEN metric = 'direction_requests' THEN value ELSE 0 END) as direction_requests\nFROM analytics.gbp_insights\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

Google Business Profile