← Back to skills

extension

Category: Marketing & GrowthNo API key required

analytics-design

Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications. Trigger on "Looker Studio", "レポート設計", "ダッシュボード".

Analytics Design

Workflow

Purpose: Define what to visualize (link to design doc with KPIs)
Data Sources: Design SQL queries and field definitions
Report Structure: Define pages and their purposes
Visualization: Specify charts with dimensions, metrics, filters

Templates

See references/looker-studio-template.md for report design template.

Looker Studio Best Practices

Data Source Design

One data source per analytical purpose
Pre-aggregate in SQL for performance
Include bucket fields for distribution analysis
Include sort-order fields for proper chart ordering
Descriptive data source names

Report Structure

Separate pages by time granularity (daily/monthly)
Group related metrics per page
Consistent filter scopes within pages

Visualization

Scorecards for KPI current values
Time series for trends
Stacked area/bar for category breakdown over time
Tables for detailed data
Add comparison periods where relevant