Salin dan Bagikan

Cara Membuat SEO Dashboard dengan Looker Studio

Looker Studio (sebelumnya Google Data Studio) adalah free tool untuk membuat interactive dashboards. Pelajari cara build SEO dashboard untuk monitoring dan reporting.

Apa Itu Looker Studio?

Overview

Looker Studio:
- Free from Google
- Data visualization
- Interactive reports
- Auto-refresh data
- Shareable dashboards

Benefits untuk SEO

Advantages:
- Combine multiple sources
- Automated reporting
- Visual presentations
- Custom metrics
- Client-friendly

Getting Started

Create Account

Steps:
1. Go to lookerstudio.google.com
2. Sign in with Google
3. Start with blank report
4. Or use template

Interface Overview

Main areas:
- Canvas (design area)
- Data panel (right)
- Chart types (toolbar)
- Properties panel

Connecting Data Sources

Google Search Console

Add GSC:
1. Add data → Search Console
2. Select property
3. Choose tables:
   - Site impression
   - URL impression
4. Connect

Google Analytics 4

Add GA4:
1. Add data → Google Analytics
2. Select GA4 property
3. Connect
4. Data available

Multiple Sources

Combine data:
- GSC for search data
- GA4 for behavior
- Sheets for custom data
- Third-party connectors

Building SEO Dashboard

Overview Page

Include:
- Total organic traffic
- Impressions
- Clicks
- CTR
- Average position
- Date range selector

Traffic Metrics Card

Scorecard setup:
1. Add → Scorecard
2. Metric: Sessions
3. Filter: Organic
4. Add comparison period
5. Style as needed

Trend Charts

Line chart:
1. Add → Time series
2. Dimension: Date
3. Metrics: Sessions, Clicks
4. Compare to previous period

Key SEO Visualizations

Organic Traffic Trend

Chart: Time series
Dimension: Date
Metric: Sessions (organic filter)
Comparison: Previous period

Shows traffic over time.

Top Landing Pages

Chart: Table
Dimension: Landing page
Metrics:
- Sessions
- Bounce rate
- Avg. session duration
- Conversions

Sorted by sessions desc.

Keyword Performance

Chart: Table
Dimension: Query (GSC)
Metrics:
- Impressions
- Clicks
- CTR
- Position

Top performing keywords.

Position Distribution

Chart: Pie/Donut
Dimension: Position (bucketed)
Metric: Impressions

Shows ranking distribution.

Advanced Features

Calculated Fields

Examples:
- CTR: Clicks / Impressions
- Conversion Rate: Conversions / Sessions
- Engagement Score: Custom formula

Creating Calculated Field

Steps:
1. Add a field
2. Name: Custom CTR
3. Formula: Clicks / Impressions
4. Format as percentage

Blended Data

Combine sources:
1. Resource → Manage blended data
2. Add data sources
3. Define join key
4. Create blended charts

Filters & Controls

Date Range Control

Add date control:
1. Add → Date range control
2. Set default range
3. Connect to all charts
4. Users can change dates

Filter by dimension:
1. Add → Drop-down list
2. Dimension: Landing page
3. Users filter specific pages

Filter Controls

Add interactive filters:
- Page filter
- Country filter
- Device filter
- Query contains filter

Dashboard Pages

Page 1: Overview

Include:
- Key metrics scorecards
- Traffic trend
- Quick insights
- Top pages/keywords

Page 2: Technical SEO

Include:
- Core Web Vitals
- Index coverage
- Crawl stats
- Error tracking

Page 3: Content Performance

Include:
- Top content
- Engagement metrics
- Content by category
- New content performance

Page 4: Keywords

Include:
- Keyword rankings
- Position changes
- Search volume
- Opportunity keywords

Data Source: Google Sheets

Why Use Sheets

Use cases:
- Rank tracking data
- Custom metrics
- Manual data
- Third-party imports

Connecting Sheets

Steps:
1. Add data → Google Sheets
2. Select spreadsheet
3. Choose worksheet
4. Connect

Keep sheets updated.

Styling Dashboard

Theme & Colors

Consistent styling:
- Brand colors
- Readable fonts
- Clear headers
- Consistent charts

Layout Tips

Best practices:
- Important metrics top-left
- Related charts grouped
- White space for clarity
- Mobile consideration

Chart Formatting

Style each chart:
- Colors
- Axis labels
- Legend position
- Data labels

Share as:
- Viewer (read only)
- Editor (can modify)
- Public (anyone with link)
- Scheduled email

Scheduled Reports

Email delivery:
1. File → Schedule email delivery
2. Set recipients
3. Choose frequency
4. Select format (PDF)

Embedding

Embed in website:
1. File → Embed report
2. Copy iframe code
3. Paste in webpage
4. Interactive dashboard

Dashboard Templates

SEO Template Structure

Page 1: Executive Summary
- KPI scorecards
- Traffic trend
- Top metrics

Page 2: Organic Performance
- Search Console data
- Keyword performance
- Position tracking

Page 3: Technical Health
- Core Web Vitals
- Errors & issues
- Index status

Page 4: Content Analysis
- Page performance
- Engagement metrics
- Content gaps

Tips & Best Practices

Performance

Optimization:
- Limit data range
- Use extracts for large data
- Minimize blended data
- Cache settings

Data Accuracy

Ensure accuracy:
- Correct filters
- Proper date ranges
- Verified formulas
- Regular checks

Looker Studio Checklist

Setup:
☐ Connect GSC
☐ Connect GA4
☐ Add Sheets if needed
☐ Verify data flowing

Dashboard Design:
☐ Overview page
☐ Keyword page
☐ Content page
☐ Technical page

Visualizations:
☐ Scorecards for KPIs
☐ Trend charts
☐ Tables for details
☐ Comparison data

Controls:
☐ Date range selector
☐ Page filter
☐ Device filter
☐ Country filter

Styling:
☐ Consistent colors
☐ Clear labels
☐ Readable fonts
☐ Organized layout

Sharing:
☐ Share settings
☐ Scheduled emails
☐ Access permissions
☐ Documentation

Kesimpulan

Looker Studio adalah powerful free tool untuk SEO dashboards. Connect GSC dan GA4, build custom visualizations, dan automate reporting. Invest time upfront untuk create comprehensive dashboard yang saves time long-term.