PMA vs native MCPs / TikTok Organic
Organic social · data points

TikTok Organic

Organic TikTok account data — daily profile reach and engagement, per-video performance with watch-time metrics and traffic sources, and lifetime follower demographics by country and gender.

PMA: tiktokorganic Native MCP: hedgehog-social-insights 4 accounts connected 3 report types
In PMA

Historical trends and per-video analytics

  • Daily profile metrics: video views, reach, total engagement, new likes, shares, comments, profile views, and net followers
  • Per-video metrics: watch time, average time watched, full video completion rate, traffic sources, and audience country distribution
  • Lifetime follower demographics: total followers, likes, gender distribution, and country breakdown
  • 4 accounts connected — cross-account querying available
Native MCP

Live data and recent video retrieval

  • social_tt_account_insights — live account-level views, reach, engagement, and follower changes for any date range
  • social_tt_recent_videos — recent videos with caption, embed URL, share URL, thumbnail, and engagement counts
PMA field catalogue

Every queryable field in PMA

Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.

Profile insights (daily account metrics)

report_type: profile_insights · 8 metrics · 24 dimensions
Metrics
Field nameLabelType
video_viewsVideo viewsNUMBER
unique_video_viewsReachNUMBER
total_engagementTotal engagementNUMBER
likesNew likesNUMBER
sharesSharesNUMBER
commentsCommentsNUMBER
profile_viewsProfile viewsNUMBER
followers_countNet followersNUMBER
Dimensions
Field nameLabelType
account_idAccount IDSTRING
configNameUsername — hiddenSTRING
dateDateSTRING
yearYearformulaSTRING
monthYear monthformulaSTRING
weekWeekformulaSTRING
year_weekYear weekformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
dataFreshnessData freshnessSTRING

Video insights (per-video lifetime metrics)

report_type: video_insights · 12 metrics · 32 dimensions
Metrics
Field nameLabelType
video_viewsVideo viewsNUMBER
video_likesVideo likesNUMBER
video_commentsVideo commentsNUMBER
video_sharesVideo sharesNUMBER
video_total_engagementVideo total engagementNUMBER
video_durationVideo durationNUMBER
full_video_viewsFull video viewsNUMBER
full_video_watched_rateFull video watched rateNUMBER
average_time_watchedAverage time watchedNUMBER
total_time_watchedTotal time watchedNUMBER
impression_sources_valueTraffic source distribution — all videos [collection]NUMBER
video_audience_countries_valueTop countries distribution — audience [collection]NUMBER
Dimensions
Field nameLabelType
item_idItem IDSTRING
account_idAccount IDSTRING
captionVideo titleSTRING
create_timePost timeSTRING
share_urlVideo linkSTRING
embed_urlEmbed URLSTRING
thumbnail_urlThumbnail URLSTRING
impression_sources_keyTraffic source — all videos [collection]STRING
video_audience_countries_keyTop countries — audience [collection]STRING
dateDateSTRING
dataFreshnessData freshnessSTRING

Followers insights (audience demographics)

report_type: followers_insights · 4 metrics · 29 dimensions
Metrics
Field nameLabelType
followers_count_lifetimeFollowers count lifetimeNUMBER
total_likesTotal likesNUMBER
countries_valueFollower countries distribution [collection]NUMBER
genders_valueGenders distribution [collection]NUMBER
Dimensions
Field nameLabelType
account_idAccount IDSTRING
usernameUsernameSTRING
display_nameDisplay nameSTRING
profile_imageProfile imageSTRING
countries_keyFollower countries [collection]STRING
genders_keyGenders [collection]STRING
dateDateSTRING
yearYearformulaSTRING
dataFreshnessData freshnessSTRING
Native MCP

What the native MCP adds

The hedgehog-social-insights MCP provides live, on-demand TikTok data. Use it for current-period reporting and recent video retrieval without querying PMA's warehouse.

ToolData points / capability
social_tt_account_insightsLive account-level video views, reach, total engagement, new likes, shares, comments, profile views, and net followers for any date range.
social_tt_recent_videosRecent videos with caption, share URL, embed URL, thumbnail, post time, and per-video engagement totals. Useful for content audits and weekly snapshots.