skills.rest
ajayatwal1105-emerson
ajayatwal1105-emersonCOMMUNITY
Explore all skills by this author →
GitHub

live-dashboard

Generate Looker Studio dashboard configurations with data mappings, formulas, and setup guides.

Updated May 18, 2026
Search Tags:#dashboard#marketing analytics#google analytics#kpi tracking#looker studio#data blending#crm reporting
One-click install
npx skills add https://github.com/ajayatwal1105-emerson/digital-marketing-pro --skill live-dashboard-ajayatwal1105-emerson
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: live-dashboard
Source: https://github.com/ajayatwal1105-emerson/digital-marketing-pro/tree/main/skills/live-dashboard
Command: npx skills add https://github.com/ajayatwal1105-emerson/digital-marketing-pro --skill live-dashboard-ajayatwal1105-emerson

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the problem of turning scattered marketing and CRM metrics into a single, always-up-to-date dashboard without manual reporting cycles. It addresses stakeholder requests for real-time visibility that typically require repeated exports, reformatting, and slow turnaround.

Core Features & Use Cases

  • Auto-designed dashboard layout: Selects a metric hierarchy and page structure tailored to the business model (SaaS, eCommerce, B2B lead gen, or agency).
  • Cross-source widget mapping: Connects Google Analytics, Google Ads, Meta Ads, CRM, and email platforms to the right charts, dimensions, and KPIs.
  • Calculated KPI and blending logic: Generates Looker Studio calculated fields for blended metrics like ROAS and weighted conversion rates.
  • Interactive filters & drill-down: Adds date-range controls and segmentation/channel/campaign filters to support operational analysis and executive review.
  • Implementation-ready output: Provides a complete dashboard design specification plus a step-by-step Looker Studio setup guide, including formulas and widget definitions.

Quick Start

Use the command /digital-marketing-pro:live-dashboard with your business model and connected data sources to generate a complete Looker Studio dashboard specification and setup instructions.

Frequently Asked Questions about live-dashboard

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a real-time Looker Studio dashboard for cross-channel marketing analytics?▼

A real-time Looker Studio dashboard connects your marketing data sources to always-current charts, generating complete data source mappings, calculated field formulas, and step-by-step setup guidance for KPI scorecards and cross-channel analysis.

What is the best way to blend Google Analytics and CRM data for KPI tracking?▼

Blending Google Analytics and CRM data for KPI tracking uses Looker Studio calculated fields to combine metrics like ROAS and weighted conversion rates, outputting a complete widget mapping and chart specification for cross-source analysis.

How do I create calculated fields for ROAS and weighted conversion rates in Looker Studio?▼

Creating calculated fields for ROAS and weighted conversion rates in Looker Studio requires defining specific data blending formulas, which are provided as calculated field formulas within an implementation-ready dashboard design specification.

Can I customize a marketing dashboard layout for SaaS, eCommerce, or B2B lead generation models?▼

You can customize marketing dashboard layouts for SaaS, eCommerce, or B2B lead generation by applying an auto-designed metric hierarchy and page structure tailored to the business model, producing tailored KPI scorecards and funnel views.

Does Looker Studio support interactive drill-down and segmentation filters for agency reporting?▼

Looker Studio supports interactive drill-down for agency reporting by applying date-range controls and channel segmentation filters, enabling operational analysis and executive review across campaigns and marketing channels.

Related Skills

Explore More Data & Analytics Skills→
indranilbanerjeeindranilbanerjee
726

live-dashboard

Automate setup of a live Looker Studio dashboard visualizing marketing data.

Community
Advanced
delta-and-betadelta-and-beta

analyst-business-intelligence

Configure BI dashboards and reporting pipelines using Braze data exports.

Community
Intermediate
thatrebeccaraethatrebeccarae
97

looker-studio

Connect data sources and build marketing dashboards in Looker Studio.

Community
Advanced
viethahongviethahong

analytics

Implement scalable tracking and analytics frameworks across GA4, GTM, and pixels.

Community
Advanced