导入历史数据

虽然 TubeAnalytics 会自动从连接的频道提取数据，但您也可以导入历史数据，以便进行更深入的分析。

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

虽然 TubeAnalytics 自动从连接的通道中提取数据，但您还可以导入历史数据以进行更深入的分析。 Getting-started pages should reduce setup friction and get users to their first useful signal fast.

Signals to watch

• 视频表现数据（观看次数、观看时间、参与度）
• 订户历史记录
• Revenue data (if monetized)

Practical next step

1. Read the answer first: Start with the quick answer for 导入历史数据 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.