How to Export CSV Data from TikTok Ads Manager and Import It into clariBI

TikTok Ads Manager is the platform for creating and managing advertising campaigns on TikTok. Exporting your ad data into clariBI allows you to analyze creative performance, audience targeting effectiveness, and campaign ROI with AI-powered insights.

What You Can Export from TikTok Ads Manager

• Campaign, ad group, and ad-level performance metrics
• Impressions, clicks, CTR, CPC, CPM, and total spend
• Video view metrics (2-second views, 6-second views, full video views)
• Conversion data (installs, purchases, sign-ups, custom events)
• Audience targeting performance (age, gender, interests, behaviors)
• Placement breakdown (TikTok, Pangle, Global App Bundle)
• Creative performance data (which video ads perform best)
• Daily and hourly performance trends

Export CSV Data from TikTok Ads Manager

Method 1: Export from Campaign Page

1. Log in to TikTok Ads Manager at ads.tiktok.com
2. Navigate to the Campaign page from the top navigation
3. Select the level of data you want: Campaign, Ad Group, or Ad tabs
4. Set your desired date range using the date selector at the top right
5. Apply any filters (status, campaign objective, delivery type)
6. Select the campaigns, ad groups, or ads you want to export by checking the boxes
7. Click the Export button in the toolbar above the data table
8. Choose CSV as the export format
9. The file will download with performance data for your selected items

Method 2: Export Custom Reports

1. Click Reporting in the top navigation menu (or go to Analytics > Custom Reports)
2. Click Create Report to build a new custom report
3. Select your dimensions (campaign name, ad group, ad, date, placement, etc.)
4. Choose your metrics (impressions, clicks, conversions, cost, video views, etc.)
5. Set the date range and any filters
6. Click Generate Report to preview the data
7. Click Export to download the report as CSV
8. Custom reports allow more flexible data combinations than the standard campaign page export

Method 3: Export Dashboard Data

1. Navigate to the Dashboard overview page
2. Review the summary metrics and trend charts
3. Click the download or export option on dashboard widgets where available
4. This provides a high-level summary export suitable for overview analysis

Tips for Clean Exports

• TikTok video view metrics have unique thresholds (2-second, 6-second, full view) — include these in your export for content performance analysis in clariBI
• Custom reports are the most flexible option and allow you to combine dimensions and metrics in ways the campaign page does not support
• Export at the ad level to compare creative performance across different video ads and identify top performers

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "TikTok Ads - Campaign Performance Feb 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "Which TikTok ad creatives have the highest video completion rate?"
- "What is my average cost per install by campaign objective?"
- "How does ad performance vary by age group and gender on TikTok?"

clariBI's AI will automatically analyze your data and suggest relevant insights.