Skip to main content

Export to CSV

Export your analytics data to CSV (Comma-Separated Values) format for analysis in spreadsheets and reporting tools.

What is CSV Export​

CSV exports provide all your dashboard data in a simple, human-readable format perfect for:

  • Excel and Google Sheets analysis
  • Manual reporting and presentations
  • Data archiving and backups
  • Third-party tool integration
  • Client reporting

How to Export CSV​

From Dashboard​

  1. Log in to your Ovyxa dashboard
  2. Select your site
  3. Choose your date range
  4. Click Export → CSV in the top-right corner
  5. Choose what to export (see options below)
  6. Click Download CSV

The file downloads immediately for small datasets (< 100k rows). Large datasets are emailed when ready.

Export Options​

Full Export - Everything from your dashboard:

  • Summary metrics
  • Top pages
  • Traffic sources
  • Geographic data
  • Device breakdown
  • Custom events

Partial Export - Choose specific tables:

  • Pages only
  • Sources only
  • Events only
  • Locations only

CSV File Format​

Structure​

Ovyxa CSV exports use standard formatting:

  • UTF-8 encoding (supports international characters)
  • Comma-separated values
  • Header row with column names
  • Compatible with Excel, Google Sheets, Numbers

Example: Pages Export​

pathname,pageviews,unique_visitors,bounce_rate,avg_time_on_page
/,12450,8923,42.5,125
/blog,8560,6342,38.2,245
/about,3421,2891,55.8,89
/contact,2103,1876,62.1,45
/pricing,5678,4234,31.2,178

Example: Sources Export​

source,medium,pageviews,unique_visitors,conversion_rate
google,organic,25670,18234,5.6
direct,none,15430,10892,8.2
twitter,social,4560,3421,3.1
newsletter,email,8920,6745,12.4
github,referral,2340,1876,9.8

Example: Events Export​

event_name,count,unique_triggers,conversion_rate,total_revenue
signup,1234,982,45.3,0
purchase,567,543,100.0,28450.50
download,892,745,0,0
contact_form,423,398,0,0
video_play,2145,1567,0,0

Column Descriptions​

Pages Columns​

  • pathname - URL path (e.g., /blog/post-title)
  • pageviews - Total page loads
  • unique_visitors - Unique visitors to this page
  • bounce_rate - Percentage who left without visiting another page
  • avg_time_on_page - Average seconds spent (estimated)

Sources Columns​

  • source - Traffic source (google, twitter, direct, etc.)
  • medium - Medium type (organic, social, referral, email)
  • pageviews - Total pageviews from this source
  • unique_visitors - Unique visitors from this source
  • conversion_rate - Percentage who completed a goal

Locations Columns​

  • country - Country name
  • country_code - ISO country code (US, GB, FR, etc.)
  • pageviews - Pageviews from this country
  • unique_visitors - Unique visitors from this country
  • percentage - Percent of total traffic

Devices Columns​

  • device_type - Desktop, Mobile, or Tablet
  • browser - Browser name (Chrome, Safari, Firefox, etc.)
  • os - Operating system (Windows, macOS, iOS, Android, etc.)
  • pageviews - Pageviews from this combination
  • percentage - Percent of total traffic

Using CSV Exports​

Excel Analysis​

  1. Open Excel
  2. Go to Data → From Text/CSV
  3. Select your downloaded CSV file
  4. Click Import
  5. Excel auto-detects formatting

Now you can:

  • Create pivot tables
  • Generate charts
  • Calculate custom metrics
  • Share with stakeholders

Google Sheets​

  1. Open Google Sheets
  2. File → Import
  3. Upload your CSV file
  4. Choose "Replace current sheet"
  5. Click Import Data

Use Sheets for:

  • Collaborative analysis
  • Google Data Studio integration
  • Automated reporting (via scripts)
  • Cloud-based archiving

Data Warehouses​

Import CSV exports to:

  • BigQuery - Google's data warehouse
  • Snowflake - Cloud data platform
  • Redshift - Amazon's data warehouse
  • PostgreSQL - Self-hosted database

Example BigQuery import:

bq load --source_format=CSV \
  --skip_leading_rows=1 \
  mydataset.ovyxa_pages \
  pages_export.csv \
  pathname:STRING,pageviews:INTEGER,unique_visitors:INTEGER

Best Practices​

Regular Exports​

Create export routine:

  • Weekly - For active monitoring
  • Monthly - For reporting and archiving
  • Quarterly - For trend analysis

Automate with our API for programmatic exports.

File Organization​

Keep exports organized:

/analytics-exports/
  /2024/
    /11/
      ovyxa-pages-2024-11-01.csv
      ovyxa-sources-2024-11-01.csv
      ovyxa-events-2024-11-01.csv

Include date and data type in filename for easy reference.

Data Validation​

After export, verify:

  • Row counts match dashboard
  • Date ranges are correct
  • No encoding issues (check special characters)
  • All expected columns present

Privacy Considerations​

CSV exports contain:

  • Aggregated data only - No individual visitor tracking
  • No IP addresses - Only country-level data
  • No personal information - GDPR-safe by design

Safe to:

  • Share with team members
  • Store in cloud services
  • Include in client reports

Advanced Use Cases​

Combining Multiple Exports​

Merge data from different time periods:

import pandas as pd

# Load monthly exports
oct = pd.read_csv('pages-2024-10.csv')
nov = pd.read_csv('pages-2024-11.csv')
dec = pd.read_csv('pages-2024-12.csv')

# Combine and analyze
combined = pd.concat([oct, nov, dec])
quarterly_totals = combined.groupby('pathname').sum()

Custom Dashboards​

Build custom visualization tools:

  • Power BI reports
  • Tableau dashboards
  • Custom web dashboards
  • Executive summaries

Automated Reporting​

Schedule automated exports using API:

// Node.js example
const axios = require('axios');
const fs = require('fs');

async function exportToCSV() {
  const response = await axios.get(
    'https://api.ovyxa.com/v1/stats/pages',
    {
      headers: { Authorization: `Bearer ${API_KEY}` },
      params: {
        site_id: 'YOUR_DOMAIN',
        period: 'month',
        format: 'csv'
      }
    }
  );

  fs.writeFileSync('export.csv', response.data);
}

Limitations​

Free Tier​

  • 1 export per day
  • Maximum 6 months historical data
  • Standard processing queue (may take 5-10 minutes for large exports)
  • Unlimited exports
  • Full historical data (based on retention)
  • Priority processing (typically < 2 minutes)

File Size​

Large exports:

  • Files > 10MB sent via email
  • Files > 100MB split into multiple parts
  • Consider using API with pagination for very large datasets

Troubleshooting​

Export Not Downloading​

  • Check your pop-up blocker
  • Try different browser
  • Check email for download link (large exports)
  • Verify date range isn't too large

Special Characters Displaying Wrong​

Issue: Seeing é instead of é

Solution:

  1. Open CSV in text editor
  2. Verify it says UTF-8 encoding
  3. In Excel: Data → From Text → Choose UTF-8
  4. In Google Sheets: File → Import → Detect encoding

Empty Rows or Missing Data​

  • Verify date range has data
  • Check filters aren't excluding everything
  • Ensure retention period includes selected dates
  • Contact support if data is definitely missing

Need Help?​

Export questions:

See also: Export to JSON for programmatic formats.