Business intelligence and dashboard creation for marketing analytics and reporting
Creates business intelligence dashboards and automated marketing reports across major analytics platforms.
npx claudepluginhub a5c-ai/babysitterThis skill is limited to using the following tools:
The BI and Reporting skill provides comprehensive capabilities for business intelligence dashboard development, data visualization, and automated marketing reporting across major BI platforms. This skill enables creation of insightful marketing performance dashboards, custom metric calculations, and automated report distribution.
const dashboardConfig = {
name: 'Marketing Performance Dashboard',
platform: 'looker-studio',
dataSources: [
{
name: 'Google Analytics 4',
connector: 'ga4',
refreshSchedule: 'daily'
},
{
name: 'Google Ads',
connector: 'google-ads',
refreshSchedule: 'daily'
},
{
name: 'Meta Ads',
connector: 'meta-ads',
refreshSchedule: 'daily'
},
{
name: 'CRM Data',
connector: 'salesforce',
refreshSchedule: 'daily'
}
],
pages: [
{
name: 'Executive Summary',
charts: ['kpi-scorecard', 'trend-chart', 'channel-breakdown']
},
{
name: 'Paid Media',
charts: ['spend-by-channel', 'roas-trend', 'campaign-table']
},
{
name: 'Organic',
charts: ['organic-traffic', 'seo-rankings', 'content-performance']
},
{
name: 'Conversion',
charts: ['funnel-visualization', 'conversion-rate', 'revenue-attribution']
}
],
filters: [
{
name: 'Date Range',
type: 'date-range',
default: 'last-30-days'
},
{
name: 'Channel',
type: 'dropdown',
allowMultiple: true
},
{
name: 'Campaign',
type: 'search'
}
]
};
const customMetrics = {
blendedROAS: {
formula: '(ga4_revenue + offline_revenue) / total_ad_spend',
dataSources: ['ga4', 'crm', 'google-ads', 'meta-ads'],
description: 'Blended ROAS including offline conversions'
},
customerAcquisitionCost: {
formula: 'total_marketing_spend / new_customers',
dataSources: ['all-paid-media', 'crm'],
description: 'Cost to acquire one new customer'
},
marketingEfficiencyRatio: {
formula: 'total_revenue / total_marketing_spend',
dataSources: ['crm', 'all-paid-media'],
description: 'Revenue generated per marketing dollar spent'
},
leadToCustomerRate: {
formula: 'new_customers / marketing_qualified_leads',
dataSources: ['crm'],
description: 'Percentage of MQLs that become customers'
},
pipelineVelocity: {
formula: '(opportunities * avg_deal_size * win_rate) / avg_sales_cycle',
dataSources: ['crm'],
description: 'Expected revenue flow through pipeline'
}
};
const reportSchedule = {
name: 'Weekly Marketing Report',
frequency: 'weekly',
dayOfWeek: 'monday',
time: '08:00',
timezone: 'America/New_York',
recipients: [
{
email: 'marketing-team@company.com',
format: 'pdf'
},
{
email: 'executives@company.com',
format: 'pdf',
summaryOnly: true
},
{
email: 'analytics-team@company.com',
format: 'csv',
includeRawData: true
}
],
conditionalSend: {
enabled: true,
condition: 'data-updated'
},
alerts: {
onFailure: ['admin@company.com'],
onDataIssue: ['data-team@company.com']
}
};
const alertConfig = {
alerts: [
{
name: 'Budget Pacing Alert',
metric: 'daily_spend',
condition: 'exceeds',
threshold: 'daily_budget * 1.1',
frequency: 'realtime',
channels: ['email', 'slack']
},
{
name: 'ROAS Drop Alert',
metric: 'roas_7day',
condition: 'drops_below',
threshold: 2.0,
comparedTo: 'previous_period',
frequency: 'daily',
channels: ['email']
},
{
name: 'Conversion Anomaly',
metric: 'conversions',
condition: 'anomaly_detected',
sensitivity: 'high',
frequency: 'hourly',
channels: ['slack']
},
{
name: 'Monthly Goal Tracking',
metric: 'monthly_revenue',
condition: 'pacing_below',
threshold: 0.9,
frequency: 'daily',
channels: ['email']
}
]
};
This skill integrates with the following digital marketing processes:
| Process | Integration Points |
|---|---|
| marketing-performance-dashboard.js | Dashboard creation, metric definitions, automated reporting |
| attribution-measurement.js | Attribution visualization, ROI reporting |
| competitive-intelligence.js | Competitive benchmarking dashboards |
| Metric | Description | Target |
|---|---|---|
| Report Accuracy | Data matches source systems | 100% |
| Dashboard Load Time | Time to render dashboard | <5 seconds |
| Data Freshness | Time since last update | <24 hours |
| User Adoption | Active dashboard users | >80% of stakeholders |
| Alert Accuracy | True positive rate for alerts | >95% |
| Report Delivery | Successful scheduled deliveries | >99% |
Activates when the user asks about AI prompts, needs prompt templates, wants to search for prompts, or mentions prompts.chat. Use for discovering, retrieving, and improving prompts.
Search, retrieve, and install Agent Skills from the prompts.chat registry using MCP tools. Use when the user asks to find skills, browse skill catalogs, install a skill for Claude, or extend Claude's capabilities with reusable AI agent components.
This skill should be used when the user wants to "create a skill", "add a skill to plugin", "write a new skill", "improve skill description", "organize skill content", or needs guidance on skill structure, progressive disclosure, or skill development best practices for Claude Code plugins.