Explore

Fabric_Dashboard_Data_Sources

Fabric_Dashboard_Data_Sources

Dashboard View

KPI

Primary Source(s)

Alternates

Notes

Total Reach / Impressions

Meta/IG Graph, TikTok Business, YouTube Data, LinkedIn Marketing

X Ads, Pinterest, Snapchat

OAuth2; normalize per platform definitions before summing. Daily pull.

Engagement Rate

Same as above

Calculate consistently (engagement ÷ reach) per channel, then weighted roll-up.

Website Traffic

Google Analytics 4 (GA4)

Plausible, Adobe Analytics

OAuth2 service acct; hourly or daily.

Conversion Rate

GA4 (events/conversions)

Server-side events, Adobe

Align naming conventions: purchase, lead, signup.

Reputation Score

Awario API or Brandwatch

Sprout, Meltwater

Build score from sentiment + volume + avg review rating.

AI Summary

Internal LLM prompt

Feed KPIs + deltas; cache outputs.

Follower Growth

Meta/IG Graph, TikTok, YouTube Data, LinkedIn Marketing

Pinterest, Snapchat

Store time series; daily diff.

Reach / Impressions

Same as above

Standardize naming.

Engagement Rate

Same as above

Likes + comments + shares + saves (platform-specific).

Top 3 Posts

Same as above

Rank by engagement or reach; include permalinks.

Audience Demographics

IG Graph, YouTube Analytics, TikTok

Some platforms restrict granularity; cache weekly.

Posting Cadence

Platform APIs + CMS/scheduler

RSS/website scrape

If no scheduler API, infer from published posts.

Total Ad Spend

Google Ads API, Meta Marketing API

LinkedIn Ads, TikTok Ads, Microsoft Ads

Currency normalization required.

Cost per Result

Same as above

Compute CPC/CPL/CPA in warehouse.

Conversion Rate

Google Ads conv., Meta CAPI + GA4

Server-side tracking

Prefer server-side tracking.

ROAS

Channel APIs + GA4 revenue

Shopify API, WooCommerce REST

Ensure shared attribution window.

Top Campaigns

Channel APIs

Rank by conversions/ROAS; include status.

AI Budget Suggestions

Internal model + historical perf

Guardrails: min/max budgets, pacing.

Open Rate

Klaviyo, Mailchimp, HubSpot Marketing

SendGrid Marketing, Campaign Monitor

Apple MPP inflates opens — flag adjusted metric.

Click-Through Rate

Same

Use unique clicks if available.

Conversion Rate

ESP → GA4 (UTM) joins

Direct commerce API

Join by UTM + session.

Unsubs / Bounce

ESP APIs

Daily pull; track list health trend.

Campaign Frequency

ESP APIs

Count sends per week vs. target.

Automation Health

ESP flow/journey endpoints

Monitor trigger counts, errors.

Brand Consistency Score

Internal evaluator (LLM)

Prompt on tone/visual tags; 0–100 score.

Asset Usage Rate

DAM API or repo logs

Google Drive/SharePoint API

Track approved templates usage vs total.

Campaign Alignment

Internal tag mapping + LLM checks

Map posts/ads to brand pillars; % aligned.

Content Mix Breakdown

Social + Email metadata

Classify content (education/promo/relationship).

Total Mentions

Awario API (keyword monitors)

Brandwatch, Meltwater

Web + social coverage; rate-limit aware.

Sentiment Breakdown

Awario/Brandwatch sentiment

Internal sentiment model

Calibrate per language; weekly QA.

Review Ratings

Google Business Profile, Yelp, FB Graph

Trustpilot, G2, Tripadvisor

Aggregate per-location; handle quotas.