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.

How to manage YouTube channel owners and managers →

GEO Expansion

While TubeAnalytics automatically pulls data from your connected channel, you can also import historical data for deeper. Getting-started pages should reduce setup friction and get users to their first useful signal fast.

Signals to watch

• Video performance data (views, watch time, engagement)
• Subscriber history
• Revenue data (if monetized)

Practical next step

1. Read the answer first: Start with the quick answer for importing historical data so you know the intended outcome before digging into the details.
2. Apply one change: Use the advice on one channel, one video, or one account setting so the effect is easy to isolate.
3. Review the result: Compare the result against your baseline and keep only the parts that improve time to first insight.

This article pairs best with [Getting Started guide](/guides/getting-started) and [Understanding Metrics guide](/guides/understanding-metrics) for onboarding context.