Reference

Unified Reporting Dashboard Data

Prepare data for a unified dashboard across all platforms.

On this page

Category: Integration. Difficulty: Intermediate. Estimated time: 1 hour. Estimated time saved: 8h/month. These estimates depend on your account and task.

Platforms

Integrations

Google Sheets
BigQuery

Connect these services separately in the AI client or automation tool you use. A cookbook example does not add a native Ad Superpowers integration.

Best for

Prerequisites

Multiple platforms connected

Connect the required accounts and your AI assistant, then confirm the workspace and client context. Open a recipe for its prerequisites, prompts and expected output. Treat durations and time savings as editorial estimates, not guarantees. Check proposed writes before approving them. Recipes involving another service need a separate connection to that service.

Tools used

Tool	Purpose
`meta_get_insights`	Meta data
`google_ads_run_gaql`	Google data
`linkedin_get_analytics`	LinkedIn data
`tiktok_get_report`	TikTok data

The tools available to your assistant depend on account connections, workspace permissions and client support. Browse the tool catalog.

Prompts

Use these prompts in your connected AI assistant. Replace account names, dates and targets as needed. Read the result before following a recommendation or approving a write.

Dashboard Data

Pull this month's data from all my ad platforms and format it into a unified schema suitable for a dashboard. Include: platform, campaign name, spend, impressions, clicks, conversions, CPA, ROAS. Standardize metric names across platforms.

Expected output: Unified data export with standardized schema

Automation

This recipe is marked as suitable for automation. It still needs a configured scheduler or automation service, account access and appropriate approval for writes. Saving a prompt or workflow does not schedule it.

All recipes · Featured · Quick wins · Deep dives · Automated workflows · Integrations · Platforms · Roles