Data & Export

A Social Content Research Spreadsheet Template

A useful social-content research spreadsheet separates what the source says from what you think it means. Keep one area for post identity and available metrics, another for content observations, and a third for original ideas. This structure works with FeedRama exports and avoids turning every high-view reference into an unsupported explanation of success.

Try the workflow in Chrome

Use FeedRama on a supported Instagram or TikTok page, and check the available range and actions in your account.

Add FeedRama to Chrome

Start with three groups of columns

GroupSuggested columns
Source evidencePlatform, creator, URL, publication date, collection date, scope
Observed metricsAvailable views, likes, comments, shares or saves
Content notesTopic, opening, demonstration, format, call to action
InterpretationPossible explanation, alternative explanation, uncertainty
Your next testOriginal concept, change to test, evaluation window

Keep unavailable fields blank or explicitly unknown according to a documented rule. Do not fill an Instagram shares column simply because TikTok has one.

Import first, annotate second

Preserve a raw sheet from Instagram CSV or TikTok CSV. Add your research columns in a working copy. This makes it possible to tell which values came from the source and which were added during analysis.

Use a stable source identity to connect notes and media. If you save a permitted video reference, add its local filename rather than pasting the entire file into a cell.

Use one filled example to teach the system

An illustrative row might describe a cooking video as “shows the finished dish first; explains two common mistakes; ends with the ingredient list.” A possible explanation is “the opening makes the result concrete.” An alternative is “the topic was timely.” The original concept should use your own recipe and footage.

Those are analysis notes, not measured causal findings. Add the collection scope and observed counts separately. The separation prevents an appealing hypothesis from becoming an invented fact.

Keep the sheet small enough to use

After installing FeedRama, use the Instagram sorter to choose a documented sample. Review several ordinary posts as well as winners so the sheet does not become a collection of exceptions.

At the end of a session, choose a few original tests and move them into your production plan. A research sheet should help make decisions; if rows accumulate without changing the plan, reduce the sample or sharpen the question.

Frequently asked questions

Should I put metrics and opinions in the same column?

No. Separate source evidence, observed content, interpretation, and your proposed test so each can be checked independently.

Can I combine Instagram and TikTok in one sheet?

Yes with explicit platform labels and suitable fields, but keep platform-specific metrics and comparisons distinct.

What is the minimum useful source information?

Platform, creator, source URL, collection date, scope, and the available fields needed for your question.

Should I study only top posts?

Include ordinary posts from the same sample to see whether the pattern you noticed is actually distinctive.

What should research produce?

A small number of original, testable content decisions with clear evaluation windows, not just a larger reference list.

Put the guide into practice

Sort and review supported Instagram and TikTok content in desktop Chrome.

Add FeedRama to Chrome