Enterprise Capabilities
- Live and extract data connections
- Advanced calculated fields
- Cross-source data blending
- Tableau Server publishing
- Row-level security
Overview
Tableau is the industry standard for enterprise business intelligence. The ClicksFlyer integration enables powerful visualizations and analysis of your mobile marketing data alongside other business data sources.
Connection Methods
1. Web Data Connector
Connect directly to ClicksFlyer API using Tableau's Web Data Connector.
2. Database Export
Export ClicksFlyer data to your data warehouse and connect Tableau to that source.
3. CSV/Excel Export
For simpler setups, export data to files and connect in Tableau Desktop.
Setup Guide
Step 1: Prepare API Credentials
- Go to ClicksFlyer Settings â API
- Generate an API key with read permissions
- Note your Account ID and API endpoint
Step 2: Configure Web Data Connector
- Open Tableau Desktop
- Select "Web Data Connector" under Connect
- Enter the ClicksFlyer WDC URL
- Authenticate with your API key
- Select data tables to import
Step 3: Create Extract or Live Connection
- Live: Real-time data, requires constant connection
- Extract: Snapshot of data, faster performance
For large datasets, extracts are recommended with scheduled refreshes.
Available Data Tables
- Campaigns: Campaign-level performance data
- Creatives: Creative and asset performance
- Events: In-app event data
- Cohorts: Retention and LTV cohort data
- Publishers: Source-level attribution
Building Dashboards
Recommended Visualizations
- Time series for trend analysis
- Heat maps for geo performance
- Scatter plots for CPI vs LTV
- Funnel charts for conversion flows
- Tree maps for budget allocation
Calculated Fields
Create custom metrics like:
- ROAS: [Revenue] / [Spend]
- Profit: [Revenue] - [Spend]
- CVR: [Installs] / [Clicks]
- eCPI: [Spend] / [Installs]
Tableau Server
For enterprise deployment:
- Publish dashboards to Tableau Server
- Schedule extract refreshes
- Set up user permissions
- Enable mobile access via Tableau Mobile
Troubleshooting
- Connection timeout: Use extracts instead of live connections
- Missing fields: Verify API permissions include required data
- Performance issues: Filter data at source level