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

Google Ads is the leading online advertising platform for search, display, video, and shopping campaigns. Exporting your advertising data into clariBI enables advanced analysis of campaign performance, budget optimization, and return on ad spend.

What You Can Export from Google Ads

• Campaign performance metrics (impressions, clicks, CTR, CPC, cost, conversions)
• Ad group and individual ad performance data
• Keyword performance with quality scores and bid data
• Search terms report (actual queries triggering your ads)
• Audience performance (demographics, interests, remarketing lists)
• Device and location performance breakdown
• Conversion tracking data (conversion actions, values, rates)
• Ad schedule performance (day-of-week and hour-of-day data)

Export CSV Data from Google Ads

Method 1: Export from Campaign Views

1. Log in to your Google Ads account at ads.google.com
2. Navigate to the data view you want to export — Campaigns, Ad groups, Ads & assets, Keywords, or Audiences
3. Set your desired date range using the date selector in the top right
4. Apply any filters or segments you need (e.g., filter by campaign type, segment by device)
5. Click the Download button (download icon, located in the toolbar above the data table)
6. Select .csv from the format options
7. The file will download with all visible columns and rows from the current view

Method 2: Export Predefined or Custom Reports

1. Click Reports (the reports icon) in the top navigation bar
2. Select Predefined reports (Dimensions) to choose from standard report types, or click Custom to build your own
3. Configure the report with your desired metrics, dimensions, and date range
4. Once the report is generated, click the Download button (download icon at the top of the report)
5. Choose CSV as the export format
6. Custom reports let you combine dimensions and metrics in ways that the default campaign views do not

Method 3: Schedule Automated Report Exports

1. After creating a custom report, click the Schedule button
2. Set the frequency (daily, weekly, monthly) and email recipients
3. Scheduled reports are emailed as CSV attachments, which you can then import into clariBI regularly

Tips for Clean Exports

• Add the columns you need before exporting — click Columns > Modify columns to add metrics like conversion value, ROAS, or quality score to your export
• The Search Terms report (Keywords > Search terms) is extremely valuable for understanding which actual queries are triggering your ads
• For large accounts, filter by campaign or date range before exporting to keep file sizes manageable

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., "Google Ads - Campaign Performance Jan 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 campaigns have the highest return on ad spend (ROAS) this quarter?"
- "How does my cost per conversion differ between mobile and desktop devices?"
- "What search terms are driving the most conversions at the lowest CPC?"

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