Excel: how to set up your data capture sheet
Published March 21, 2017
This video has 51.6K views and 382 likes, ranking #6,226,185 globally among tracked YouTube videos by view count.
At a glance
Views
51,599
Likes
382
Comments
12
Performance vs. channel
Outlier score
Engagement rate
More features coming
We're working on new analytics and tools. Stay tuned.
About
This video will show you how to set up your data capture sheet in Excel 2016. Now that you have collected the data for your research project, it is now time to capture it on an excel spreadsheet. After your data have been captured, you can proceed with the statistical analysis. If you are a (post)graduate student work…
- Published
- March 21, 2017
- Made for kids
- No
More features coming
We're working on new analytics and tools. Stay tuned.
Frequently asked questions
How accurate are these YouTube video analytics?
View, like, and comment counts come from YouTube's public API and refresh regularly. Growth and revenue figures are estimates built from tracked historical data, so they can differ slightly from what the creator sees privately in YouTube Studio.
What is the outlier score?
How this video's views compare to the channel's usual Shorts or long-form video. A 2x score means double the usual views for that channel, 0.5x means half.
What is engagement rate and how is it calculated?
Likes and comments per view, compared to this channel's typical engagement rate — shown as above or below what's usual for the channel.
How is the revenue estimate calculated?
It's a rough public estimate based on a $0.7–$2.0 CPM (revenue per 1,000 views) applied to view count — not actual creator earnings, which depend on ad rates, audience geography, and monetization settings YouTube doesn't expose publicly.
Is this YouTube video analytics checker free?
Yes. You get 10 free channel and video analytics lookups per rolling hour without an account — logging in, which is also free, removes that limit entirely.