Video · data points

YouTube

3 PMA report types covering channel-level analytics, per-video performance, and the channel subscriber/view snapshot. PMA is the only data source — there is no native MCP for organic YouTube analytics.

PMA: google_youtube Native MCP: None 2 accounts connected 3 report types
In PMA

Organic channel analytics and video performance

  • 3 report types: channel-level insights (views, watch time, revenue, subscribers, demographics), per-video lifetime metrics, and channel snapshot (subscriber count, video count)
  • 21 metrics in the insights report including estimated revenue, CPM, monetised playbacks, and video completion quartiles
  • Demographic dimensions: age group, gender
  • Traffic source, device type, playback location, operating system, and country breakdowns
  • Per-video lifetime stats: view count, like count, comment count, duration
Native MCP

No native MCP — PMA is the only source

  • There is no Hedgehog native MCP for organic YouTube analytics
  • The mechanic-mcp-server tool video_performance covers YouTube ad placements via Google Ads — not organic channel analytics
  • All organic YouTube channel data must be queried via PMA

PMA is the only source for organic YouTube

No native MCP covers organic YouTube analytics. The mechanic-mcp-server / video_performance tool reports on Google Ads video placements (paid), not YouTube channel performance. Use google_youtube in PMA for all organic channel, video, and audience data.

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.

Channel insights

report_type: insights · 21 metrics · 37 dimensions · showing 21 of 21 metrics and 20 of 37 dimensions retrievable via API
Metrics
Field nameLabelType
totalWatchTimeWatch timeformulaNUMBER
viewsViewsNUMBER
averageViewDurationAverage View DurationNUMBER
averageViewPercentageAverage View PercentageNUMBER
estimatedMinutesWatchedEstimated Minutes WatchedNUMBER
subscribersGainedSubscribers GainedNUMBER
subscribersLostSubscribers LostNUMBER
likesLikesNUMBER
dislikesDislikesNUMBER
commentsCommentsNUMBER
sharesSharesNUMBER
videosAddedToPlaylistsVideos Added To PlaylistsNUMBER
videosRemovedFromPlaylistsVideos Removed From PlaylistsNUMBER
estimatedRevenueEstimated partner revenueNUMBER
estimatedAdRevenueEstimated Ad RevenueNUMBER
grossRevenueGross RevenueNUMBER
cpmCPMNUMBER
adImpressionsAd ImpressionsNUMBER
monetizedPlaybacksMonetized PlaybacksNUMBER
playbackBasedCpmPlayback Based CPMNUMBER
viewerPercentageViewer PercentageNUMBER
Dimensions
Field nameLabelType
videoVideo IDSTRING
channel_idChannel IDSTRING
dayDaySTRING
monthYear MonthSTRING
countryCountrySTRING
cityCitySTRING
ageGroupAge GroupSTRING
genderGenderSTRING
deviceTypeDevice TypeSTRING
operatingSystemOperating SystemSTRING
insightTrafficSourceTypeTraffic SourceSTRING
insightPlaybackLocationTypePlayback LocationSTRING
subscribedStatusSubscribed StatusSTRING
liveOrOnDemandLive Or On DemandSTRING
creatorContentTypeCreator Content TypeSTRING
sharingServiceSharing ServiceSTRING
configNameChannelSTRING

Videos (lifetime)

report_type: videos · 6 metrics · 25 dimensions · showing 6 of 6 metrics and 20 of 25 dimensions retrievable via API
Metrics
Field nameLabelType
durationDurationNUMBER
lifetime_viewCountViews (Lifetime)NUMBER
lifetime_likeCountLikes (Lifetime)NUMBER
lifetime_dislikeCountDislikes (Lifetime)NUMBER
lifetime_commentCountComments added (Lifetime)NUMBER
lifetime_favoriteCountFavorites (Lifetime)NUMBER
Dimensions
Field nameLabelType
videoVideo IDSTRING
titleVideo TitleSTRING
descriptionDescriptionSTRING
videoCategoryVideo CategorySTRING
publishedAtPublished TimeSTRING
privacyStatusPrivacy StatusSTRING
liveBroadcastContentLive Broadcast ContentSTRING
definitionDefinitionSTRING
tagsTagsSTRING
thumbnailsThumbnailSTRING
video_urlVideo URLSTRING
channel_idChannel IDSTRING
channel_nameChannel NameSTRING
configNameChannelSTRING

Channel (snapshot)

report_type: channel · 4 metrics · 23 dimensions · showing 4 of 4 metrics and 20 of 23 dimensions retrievable via API
Metrics
Field nameLabelType
channel_lifetime_subscriberCountSubscribersNUMBER
channel_lifetime_videoCountVideosNUMBER
channel_lifetime_viewCountChannel Views (Lifetime)NUMBER
channel_lifetime_hiddenSubscriberCountHidden Channel Subscribers (Lifetime)NUMBER
Dimensions
Field nameLabelType
channel_idChannel IDSTRING
dayDaySTRING
weekWeekformulaSTRING
year_weekYear WeekformulaSTRING
month_onlyMonthformulaSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear QuarterformulaSTRING
configNameChannelSTRING
dataFreshnessData FreshnessSTRING