Platform And Field Mapping

Whale serves cross-platform public content data. Source platforms have different raw structures, but the external query layer stays unified: consumers query by platform, content type, time, keyword, semantics, and structured fields without knowing how each platform is collected.

Contents

SectionDescription
Platform scopeFrozen platform enums for the first version
Content typesExternal unified content_type values
Common fieldsStable cross-platform fields
Platform casesTypical platform data shapes
Metric semanticsHow views, reads, likes, comments, and other metrics map
Extension fieldsHow platform-specific fields are preserved

Initial Platform Scope

GroupPlatforms
Chinese content platformsdouyin, kuaishou, bilibili, wechat_channels, xiaohongshu, weibo, wechat_article, zhihu
Chinese marketplace casexianyu
Global content platformsreddit, medium, linkedin, instagram, tiktok, youtube
Discovery and webgoogle_search, google_news, google_trends, website, rss, news

Availability depends on data-product authorization, collection coverage, and compliance policy. API responses use source_platform as the stable platform enum.

Content Types

content_typeMeaningPlatform examples
postSocial post, feed item, short contentWeibo, Xiaohongshu, Reddit
articleLong article, public account article, columnMedium, WeChat Articles, Zhihu
videoVideo content, possibly with description, transcript, or audio transcriptionYouTube, TikTok, Bilibili, WeChat Channels
commentComment, reply, thread itemReddit, Weibo, Xiaohongshu
productProduct or marketplace listingXianyu
job_postingJob postingLinkedIn
web_pageWeb page, news page, RSS articlewebsite, news, rss

Common Fields

FieldMeaning
document_idWhale document ID used for details, versions, and snapshots
dataset_idData product or data domain, such as social, ecommerce, or recruitment
source_platformPlatform enum
external_content_idStable source-platform content ID
canonical_urlCanonical content URL
content_typeUnified content type
authorAuthor, account, channel, seller, or company identity
contentTitle, body summary, URL, publish time, and other standard content
metricsCurrent projection of engagement and distribution metrics
partsTranscripts, OCR, chapters, specs, comment slices, and other multi-part content
factsFilterable structured facts such as price, company, location, and skills
platform_payloadPlatform-specific fields

Platform Cases

PlatformExternal content shapeKey fieldsNotes
YouTubevideoTitle, description, channel, publish time, views, likes, comments, transcript or audio transcriptionIf a video has no body, parts.transcript or parts.audio_transcript can still be searched
TikTok / Douyin / KuaishouvideoDescription, author, topics, plays, likes, comments, sharesShort videos may have no title; searchable text often comes from description, OCR, or transcription
Bilibili / WeChat ChannelsvideoTitle, description, creator/account, plays, likes, favorites, danmakuPlatform-specific metrics remain in extension metrics
Xiaohongshu / InstagrampostTitle/body, images, OCR, author, likes, favorites, commentsImage text can be indexed as parts.ocr
Weibo / Redditpost or commentBody, author, publish time, reposts, comments, likesSuitable for topic, event, and sentiment tracking
Medium / WeChat Article / ZhihuarticleTitle, body, author, publish time, reads/likes/commentsLong text is chunked for search; detail APIs return full content
XianyuproductProduct title, price, want count, area, status, seller informationPrice, status, and seller sold/onsale counts are useful snapshot trends
LinkedInjob_postingJob title, company, location, salary, skills, work modeStructured fields enter facts for filtering and aggregation
Google / website / RSS / newsweb_page or articleTitle, summary, URL, source site, publish timeSuitable for web discovery, news tracking, and topic monitoring

Metric Semantics

Standard metricMeaningNotes
view_countViews, reads, or impressionsNames vary by platform; externally means “viewed”
play_countVideo playsPreferred for video platforms
like_countLikesCommon across social platforms
comment_countCommentsCommon across posts, videos, and articles
share_countSharesEmpty when unsupported by the platform
collect_countFavorites, saves, or wantsSimilar but not identical across Xiaohongshu, Bilibili, Xianyu
repost_countRepostsUsed by platforms such as Weibo
author_follower_countAuthor follower snapshotAuthor state, not body content

Time-varying metrics are stored as snapshots. Consumers that need trends should read document snapshots instead of relying only on the current projection returned by document detail.

Extension Fields

Stable cross-platform fields enter the standard model first. Fields that cannot be normalized reliably stay in platform_payload or platform_metrics. Examples:

  • Bilibili danmaku and coins.
  • Xianyu seller credit, Zhima credit, product status.
  • LinkedIn application count, job level, remote work mode.
  • Google Trends interest and regional distribution.

Usage Guidance

  • For cross-platform search, start with content_type, source_platform, published_at, and keyword/semantic query.
  • For platform-specific analysis, read facts, platform_payload, and platform_metrics.
  • For trends, read snapshots sorted by snapshot_at.
  • For full body, transcripts, or specs, load document content, parts, and facts.