Looker Studio Integration

Overview

Looker Studio (formerly Google Data Studio) is a free business intelligence tool from Google. The ClicksFlyer integration allows you to create custom visualizations and reports using your mobile marketing data.

Connection Methods

1. Native Connector

Use ClicksFlyer's native Looker Studio connector for direct data access.

2. BigQuery Export

Export ClicksFlyer data to BigQuery and connect via Looker Studio's BigQuery connector.

3. Google Sheets

Schedule exports to Google Sheets and connect those sheets to Looker Studio.

Setup Guide

Available Data Fields

Dimensions

• Date, Week, Month
• Campaign, Ad Group, Creative
• Country, Region, City
• Platform (iOS, Android)
• Publisher/Source

Metrics

• Impressions, Clicks, CTR
• Installs, Events, Conversions
• Revenue, LTV
• Spend, CPI, CPA
• ROAS, ROI

Dashboard Templates

ClicksFlyer provides starter templates for common use cases:

• Executive Overview: High-level KPIs and trends
• Campaign Performance: Detailed campaign analysis
• Creative Analysis: Creative-level performance
• Geographic Report: Performance by region

Best Practices

• Use date range controls for flexibility
• Create filtered views for different teams
• Set up scheduled email delivery
• Blend data sources for comprehensive views
• Use calculated fields for custom metrics

Troubleshooting

• Connection timeout: Reduce date range or metrics selected
• Missing data: Verify API permissions and data availability
• Slow loading: Use data extracts for large datasets