Raw Data Export

Use Raw Data Export when you need to move from dashboard trends to precise, joinable event rows—enabling custom pivots, cohort retention, feature adoption deep-dives, and external BI modeling.

What You Can Answer

Engagement Spike Root Cause
Long Tail Visibility
Format Performance
Role Analysis
Cohort Retention

Which users & post types drove yesterday’s reaction surge?

Export Workflow

Select Date Range

Adjust widget timeframe (e.g., last 7 / 30 days). Smaller ranges export faster & reduce row truncation risk.

Open Widget Menu

In the target widget header (Daily Engagements, Post Types, Reach & Impressions) click the Download icon.

Confirm Email

Pre-filled from your account; update if you need to CC an alias that’s allowed.

Generate Snapshot

Click Generate to queue export—toast confirmation appears.

Retrieve Email Links

Email contains signed URLs for each CSV; links valid 24h.

Archive & Version

Store files with a date-stamped naming convention (e.g., posts_2025-08-17.csv).

Join & Analyze

Combine on shared keys (postId, user IDs, targetId) in your BI / spreadsheet tool.

Available Files

Widget	File(s)	Granularity	Primary Keys	Typical Question
Daily Engagements	posts.csv	One row per post created on date	postId, posterUserId	Which creators spiked output?
Daily Engagements	comments.csv	One row per comment/reply on date	commentId, parentCommentId, postId	Where did discussion concentrate?
Daily Engagements	reactions.csv	Each reaction event	reactionId, postId, reactorUserId	Are reactions broad or concentrated?
Post Types	post_types.csv	One row per post (lifecycle snapshot)	postId	Are video posts share increasing?
Reach & Impressions	reach.csv	Post-day tuple (unique viewers)	postId + date	Which dormant posts regained visibility?
Reach & Impressions	impressions.csv	Post-day tuple (total renders)	postId + date	Frequency vs reach divergence?

All files capped at 10,000 rows. Split large periods or narrow filters (community, post type) when approaching limit.

Column Reference

Common Core Fields

Column	Description
date	UTC ISO 8601 day of the event/render
postId / commentId / reactionId	Unique event identifiers
posterUserId / commenterUserId / reactorUserId	Originating user IDs
targetType	Location container (community, userFeed, etc.)
targetId	ID of target container
postType	Content classification (text, image, video, poll, etc.)
deleted	Boolean flag (excludes rows if deleted before export)

File Specific Highlights

posts.csv

Includes postText, postType, tag arrays, and deletion flags for content mining & classification.

comments.csv

Contains parentCommentId enabling thread reconstruction & depth analysis.

reactions.csv

Lightweight engagement events; join to posts for reaction intensity per post type.

post_types.csv

One row per post with full creator, timing, and type metadata for mix / composition trends.

reach.csv

Each row = post + day; reflects distinct viewer exposure irrespective of creation date.

impressions.csv

Frequency dimension per post + day; compare with reach to compute repetition (Impressions/Reach).

Data Freshness & Snapshot Semantics

Aspect	Behavior
Point-in-Time	Export reflects current state at generation moment.
Edits	Latest edited text retained (no historical versions).
Deletions	Hard-deleted content omitted to respect policy.
Late Events	Events arriving after generation won’t appear (re-export if critical).
Timezone	All timestamps normalized to UTC (convert downstream as needed).

Governance & Limits

Area	Policy
Row Cap	10,000 rows per CSV (enforced server-side).
Frequency	Manual—no scheduling yet (automation roadmap).
Security	Links are signed & expire in 24h; share internally only.
Permissions	Respects dashboard visibility scopes; if you can’t see it, you can’t export it.
Format	UTF-8 CSV, comma-delimited, quoted where needed.

For larger ongoing pipelines plan migration to forthcoming API / warehouse sync instead of stitching multiple manual exports.

Joining & Derived Metrics

Goal	Join Strategy	Derived Formula
Reactions per Post Type	reactions.csv → posts.csv on postId	count(reactions)/count(posts) per postType
Comment Depth	comments.csv self-join via parentCommentId	avg(reply_depth)
Visibility Decay Curve	impressions.csv grouped by days since post creation	impression_count over lag day index
Frequency Factor	impressions.csv join reach.csv (postId+date)	impressions / reach
Content Creator Mix	posts.csv aggregated by posterUserRole	% share by role

Troubleshooting

Symptom	Likely Cause	Investigation	Resolution
Missing expected post	Deleted before export	Check moderation logs	Re-run earlier (if recoverable) or note exclusion
Row count hits 10k	Range too broad	Count estimate via shorter sample	Split date range / add filter
Stale email arrival	Mail delay / processing backlog	Check status page & timestamp	Wait; re-trigger if >30m
Empty CSV	No events in range	Validate widget chart shows data	Adjust date or remove restrictive filters
Data mismatch vs chart	Filter drift after export	Confirm filters at generation vs current	Regenerate with correct filters
Character encoding issues	Non-UTF tool import settings	Inspect raw file header	Force UTF-8 in BI tool

Best Practices

Narrow First

Export smallest viable slice; expand gradually to avoid hitting limits.

Version Files

Use ISO date naming; store in a controlled folder for reproducibility.

Pre-Join Profiles

Create small dimension tables (user roles, community metadata) and join post-import.

Automate Later

Prototype insights manually before investing in pipeline automation.

Retention Modeling

Use impressions.csv to build decay curves for evergreen content strategy.

FAQ

Can I exceed 10k rows? Not currently—split range or await API export. Are private communities included? Yes, if your role grants visibility. Scheduled exports? On roadmap—use calendar reminder interim. Historical text versions? Not stored—only latest edit at generation time.

Overview

Admin Console

Admin Portal

Analytics Dashboard

Support

What You Can Answer

Export Workflow

Available Files

Column Reference

Common Core Fields

File Specific Highlights

Data Freshness & Snapshot Semantics

Governance & Limits

Joining & Derived Metrics

Troubleshooting

Best Practices

FAQ

​What You Can Answer

​Export Workflow

​Available Files

​Column Reference

​Common Core Fields

​File Specific Highlights

​Data Freshness & Snapshot Semantics

​Governance & Limits

​Joining & Derived Metrics

​Troubleshooting

​Best Practices

​FAQ

What You Can Answer

Export Workflow

Available Files

Column Reference

Common Core Fields

File Specific Highlights

Data Freshness & Snapshot Semantics

Governance & Limits

Joining & Derived Metrics

Troubleshooting

Best Practices

FAQ