Ranketta Logo

Looker Studio Integration

Connect Looker Studio to create custom dashboards and visualize your Ranketta data

Looker Studio (formerly Google Data Studio) allows you to create beautiful, interactive dashboards to visualize your Ranketta data alongside other business metrics.

Why Use Looker Studio?

Looker Studio provides:

  • Custom Dashboards: Create visualizations tailored to your needs
  • Data Blending: Combine Ranketta data with other data sources
  • Sharing & Collaboration: Share dashboards with your team
  • Scheduled Reports: Automate report generation and distribution
  • Interactive Filters: Let users explore data dynamically

Prerequisites

Before connecting Looker Studio, ensure you have:

  • A Google account
  • Access to Looker Studio (free)
  • A Ranketta API key (found in Settings → Company → API Keys)
  • Basic familiarity with Looker Studio

Getting Your API Key

  1. Navigate to Settings → Company → API Keys
  2. Click Create API Key if you don't have one
  3. Copy your API key (you'll need it for the connector)
  4. Keep it secure - treat it like a password

Setting Up the Connector

Step 1: Access Looker Studio

  1. Go to lookerstudio.google.com
  2. Sign in with your Google account
  3. Click Create → Data Source

Step 2: Add Community Connector

  1. Scroll down to find Community Connectors
  2. Click Build a Connector
  3. Select Get Started under Community Connector
  4. You'll see a code editor

Step 3: Add Ranketta Connector Code

  1. Copy the Ranketta connector code from the connector file
  2. Paste it into the code editor
  3. Update the RANKETTA_BASE_URL if needed (default: https://api.ranketta.com)
  4. Click Save and give your connector a name (e.g., "Ranketta Connector")

Step 4: Authorize the Connector

  1. Click Authorize in the connector settings
  2. Review the permissions
  3. Click Authorize to grant access

Step 5: Configure Data Source

  1. Enter your Ranketta API key in the configuration
  2. Click Connect
  3. Looker Studio will fetch the schema

Available Data Fields

The Ranketta connector provides the following fields:

Dimensions

  • Date: Measurement date (YYYY-MM-DD format)

Metrics

  • Visibility Percentage: How visible your brand is (0-100%)
  • Sentiment Score: Brand sentiment score (0-100, higher is better)
  • Average Position: Average ranking position in AI answers
  • Share of Voice: Your share of voice compared to competitors (0-100%)

Creating Your First Dashboard

Step 1: Create a New Report

  1. In Looker Studio, click Create → Report
  2. Select your Ranketta data source
  3. Click Add to Report

Step 2: Add Visualizations

Time Series Chart

  1. Click Add a chart → Time series chart
  2. Drag Date to the Dimension field
  3. Drag Visibility Percentage to the Metric field
  4. Customize colors and styling

Scorecard

  1. Click Add a chart → Scorecard
  2. Select a metric (e.g., Sentiment Score)
  3. Add comparison to previous period
  4. Format the display

Table

  1. Click Add a chart → Table
  2. Add Date as a dimension
  3. Add multiple metrics (Visibility, Sentiment, Position, Share of Voice)
  4. Format numbers and add conditional formatting

Step 3: Add Filters

  1. Click Add a control → Date range control
  2. Users can filter data by date range
  3. Add other filters as needed

Step 4: Style Your Dashboard

  1. Customize colors to match your brand
  2. Add your logo
  3. Format text and headings
  4. Adjust layout and spacing

Advanced Features

Data Blending

Combine Ranketta data with other sources:

  1. Click Resource → Manage blended data
  2. Add Ranketta as one data source
  3. Add another data source (e.g., Google Analytics)
  4. Join on common fields (e.g., Date)
  5. Create visualizations using blended data

Calculated Fields

Create custom metrics:

  1. Click Add a field
  2. Write a formula (e.g., Visibility Percentage * 0.5 + Sentiment Score * 0.5)
  3. Use the calculated field in visualizations

Custom Date Ranges

Set up default date ranges:

  1. Add a date range control
  2. Set default to "Last 30 days" or custom range
  3. Users can override the default

Sharing & Collaboration

Share your dashboard:

  1. Click Share in the top right
  2. Add email addresses or get a shareable link
  3. Set permissions (Viewer, Editor, Owner)
  4. Enable scheduled email delivery

Example Dashboards

Executive Summary Dashboard

  • Scorecards: Key metrics at a glance
  • Time Series: Trends over time
  • Comparison: Current vs. previous period
  • Filters: Date range and other filters

Detailed Analysis Dashboard

  • Tables: Detailed data with all metrics
  • Charts: Multiple visualizations
  • Filters: Multiple filter options
  • Drill-down: Click to explore details

Competitive Analysis Dashboard

  • Comparison Charts: Your metrics vs. competitors
  • Share of Voice: Market share visualization
  • Trend Analysis: Performance over time
  • Rankings: Position comparisons

Troubleshooting

Connection Issues

If you can't connect:

  • Verify your API key is correct
  • Check that the API key is active
  • Ensure the base URL is correct
  • Try regenerating your API key

Missing Data

If data isn't appearing:

  • Check your date range
  • Verify you have data for the selected period
  • Ensure your prompts are active
  • Check API rate limits

Performance Issues

If the dashboard is slow:

  • Reduce date range
  • Limit number of data points
  • Use aggregation where possible
  • Check data source refresh settings

Best Practices

Dashboard Design

  • Keep it Simple: Focus on key metrics
  • Use Consistent Colors: Match your brand
  • Add Context: Include descriptions and notes
  • Make it Interactive: Add filters and controls

Data Management

  • Regular Updates: Set up automatic refresh
  • Data Validation: Verify data accuracy
  • Documentation: Document your dashboards
  • Version Control: Keep track of changes

Sharing

  • Set Permissions: Control who can view/edit
  • Provide Context: Explain what the dashboard shows
  • Schedule Reports: Automate report delivery
  • Get Feedback: Improve based on user input

API Endpoints

The connector uses the following Ranketta API endpoints:

  • /looker-studio/overall/metrics/ - Overall metrics (all metrics in one response)
  • /looker-studio/overall/visibility/ - Visibility data only
  • /looker-studio/overall/sentiment/ - Sentiment data only
  • /looker-studio/overall/position/ - Position data only
  • /looker-studio/overall/share-of-voice/ - Share of voice data only

All endpoints require API key authentication via the X-API-Key header.

Next Steps

After setting up Looker Studio:

  • Create your first dashboard with key metrics
  • Share dashboards with your team
  • Combine with other data sources for comprehensive analysis
  • Set up scheduled reports for regular updates

For more information, check out:

Cloudflare Integration

Set up Cloudflare Workers to track AI bot visits and improve tracking accuracy