A missing metric in a social-media export is not the same as a measured zero. Platforms expose different fields across content types and pages, and exported fallback values can hide that distinction. Before ranking posts or calculating ratios, establish which values are actually available for the selected sample.
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 ChromeSeparate three states
| State | Meaning | Analysis treatment |
|---|---|---|
| Observed positive value | A count was available | Use with its collection context |
| Observed zero | A genuine zero was available | Use where the metric is appropriate |
| Unavailable or uncertain | No reliable observed value | Keep unknown; do not infer failure |
A numeric-looking cell does not settle the question. Check the source, export behavior, and content type before deciding what it represents.
Expect platform and format differences
FeedRama’s Instagram and TikTok exports do not have identical fields. TikTok includes Shares and Saves in its standard export; the Instagram export includes Type. View-based research belongs on Instagram Reels rather than assuming every photo post has a comparable public view count.
Use the Posts-versus-Reels guide to choose the right collection. Missing dates should remain unknown in chronological analysis.
Protect calculations from uncertain inputs
A division formula can avoid dividing by zero and still produce a misleading result if the numerator is an unavailable fallback. Check both inputs before calculating a like, share, or save ratio. Document which rows were excluded and why.
Keep a separate availability note or flag when you cannot verify a field. Do not “complete” the table by estimating private metrics from a neighboring post. A smaller valid comparison is more useful than a complete-looking but invented dataset.
Report the coverage of the metric
After using FeedRama with the supported profile workflow, inspect the export before reporting. State how many posts had the required values, not only how many posts were collected.
For example, “ratio calculated for the posts with verified views and likes” is a defensible method note when accompanied by the count. If availability is too limited, switch to a qualitative review rather than forcing a ranking.
Frequently asked questions
Does zero always mean no engagement?
No. Establish whether the value was observed or used as a fallback for unavailable data before interpreting it.
Are Instagram and TikTok exports identical?
No. Their standard fields differ, and available metrics can depend on the source and content type.
Can I estimate a missing metric from similar posts?
Do not present an estimate as observed data. For a source-based ranking, keep unavailable values unknown.
Is avoiding division by zero enough?
No. A ratio also needs valid, comparable inputs. An unavailable numerator can still produce a misleading numeric result.
What should I report about missing data?
The fields required, how availability was checked, the number of usable posts, and the exclusion rule.