Importing historical data

Importing Historical Data

While TubeAnalytics automatically pulls data from your connected channel, you can also import historical data for deeper analysis.

What Data Can Be Imported?

• Video performance data (views, watch time, engagement)
• Subscriber history
• Revenue data (if monetized)
• Custom metrics you've tracked elsewhere

Supported Import Formats

• CSV: Most common format
• Excel: .xlsx files
• Google Sheets: Direct import
• JSON: For developers

Import Methods

Method 1: Manual Import

1. Go to Settings > Data Import
2. Click Import Data
3. Select your file
4. Map columns to TubeAnalytics fields
5. Preview and confirm

Required columns: Date (YYYY-MM-DD format), Video ID or URL, At least one metric (views, watch time, etc.).

Method 2: Google Sheets Integration

1. Connect your Google Sheets account
2. Select the spreadsheet with your data
3. Choose the sheet and range
4. Map columns automatically
5. Set import frequency (one-time or recurring)

Data Mapping

When importing, you'll map your columns: Your Column maps to TubeAnalytics Field (Video URL -> Video ID, Views -> Views, Watch Time (minutes) -> Watch Time, Likes -> Likes, Comments -> Comments, Subscribers -> Subscriber Change).

After Import

Data appears in: Historical reports, Trend analysis, Comparison tools, Export functions. Data does NOT appear in: Real-time dashboards, Live video monitoring, YouTube API sync.

Tips for Successful Imports

• Clean your data first: Remove duplicates, fix dates
• Use consistent formats: Same date format throughout
• Start small: Test with a single month's data
• Document sources: Note where data came from

Limitations

• Starter plan: 1,000 rows per import
• Pro tier: 50,000 rows per import
• Agency tier: Unlimited

Data older than 3 years may have reduced accuracy due to YouTube API limitations.