Microsoft MVP Stats Tracker Dashboard

$profileUrl = $variable.mvpurl
if ($profileUrl -notmatch '/profile/(?<Id>[0-9a-fA-F-]+)$') {
    Write-Error "Profile URL does not end with a GUID: $profileUrl"
    exit 1
}
$profileId = $Matches.Id
$apiUrl = "https://mavenapi-prod.azurewebsites.net/api/mvp/UserProfiles/public/$profileId"
try {
    $headers = @{
        "Origin"  = "https://mvp.microsoft.com"
        "Referer" = "https://mvp.microsoft.com/"
        "Accept"  = "application/json"
    }
    $response = Invoke-RestMethod -Uri $apiUrl -Headers $headers -Method Get
}
catch {
    Write-Error "Failed to retrieve profile $($profileId): $_"
    exit 1
}
$userprofile = $response.userProfile
if (-not $userprofile) {
    Write-Error "No userProfile node returned for $profileId."
    exit 1
}
[pscustomobject]@{
    FirstName      = $userprofile.firstName
    LastName       = $userprofile.lastName
    FullName       = ($userprofile.firstName, $userprofile.lastName | Where-Object { $_ }) -join ' '
    Headline       = $userprofile.headline
    CompanyName    = $userprofile.companyName
    Country        = $userprofile.addressCountryOrRegionName
    YearsInProgram = $userprofile.yearsInProgram
    Roles          = ($userprofile.functionalRoles -join ', ')
    TechFocus      = ($userprofile.technologyFocusArea -join ', ')
    AwardCategory  = ($userprofile.awardCategory -join ', ')
}

# YouTube Channel Analytics Script
# Requires YouTube Data API v3 key from Google Cloud Console
# Configure your API key and Channel IDs here
$ApiKey = "<key>"
$ChannelIds = @(
    "<ID>"
)
# Configuration
$TopVideosCount = 5  # Number of top videos to fetch
$RecentVideosCount = 5  # Number of recent videos to fetch
# API endpoints
$baseUrl = "https://www.googleapis.com/youtube/v3"
function Get-ChannelStatistics {
    param([string]$channelId, [string]$apiKey)
    $url = "$baseUrl/channels?part=statistics,snippet,contentDetails,brandingSettings,topicDetails&id=$channelId&key=$apiKey"
    try {
        $response = Invoke-RestMethod -Uri $url -Method Get
        if ($response.items.Count -eq 0) {
            return $null
        }
        $channel = $response.items[0]
        $stats = $channel.statistics
        $snippet = $channel.snippet
        $contentDetails = $channel.contentDetails
        # Calculate derived metrics
        $avgViewsPerVideo = if ([int]$stats.videoCount -gt 0) {
            [math]::Round([int64]$stats.viewCount / [int]$stats.videoCount, 2)
        } else { 0 }
        $channelAgeInDays = ((Get-Date) - [datetime]$snippet.publishedAt).Days
        $videosPerMonth = if ($channelAgeInDays -gt 0) {
            [math]::Round(([int]$stats.videoCount / $channelAgeInDays) * 30, 2)
        } else { 0 }
        $result = [PSCustomObject]@{
            ChannelId = $channelId
            ChannelName = $snippet.title
            Description = $snippet.description.Substring(0, [Math]::Min(100, $snippet.description.Length)) + "..."
            CustomUrl = if ($snippet.customUrl) { $snippet.customUrl } else { "N/A" }
            Country = if ($snippet.country) { $snippet.country } else { "N/A" }
            SubscriberCount = [int64]$stats.subscriberCount
            HiddenSubscribers = $stats.hiddenSubscriberCount
            TotalViews = [int64]$stats.viewCount
            TotalVideos = [int]$stats.videoCount
            AvgViewsPerVideo = $avgViewsPerVideo
            VideosPerMonth = $videosPerMonth
            ChannelCreated = [datetime]$snippet.publishedAt
            ChannelAgeYears = [math]::Round($channelAgeInDays / 365.25, 1)
            UploadsPlaylistId = $contentDetails.relatedPlaylists.uploads
            TopicCategories = if ($channel.topicDetails.topicCategories) { 
                ($channel.topicDetails.topicCategories | ForEach-Object { $_.Split('/')[-1] }) -join ", " 
            } else { "N/A" }
        }
        return $result
    }
    catch {
        return $null
    }