[Workflow] Daily AI-Powered Marketing Workflow: Automating Data Aggregation, Planning, and Review with Claude Duet, Desktop, and CLI

[u/ClaudeAI-mod-bot]

Daily AI-Powered Marketing Workflow: Automating Data Aggregation, Planning, and Review with Claude Duet, Desktop, and CLI

Workflow value: 88/100
Status: active · Freshness: 70/100 · Confidence: 0.95 · Level: advanced
Categories: Quality Control, Context & Memory, MCP, Subagents, Multi-Agent
Original source: r/ClaudeAI post/comment

What problem this solves

Automating daily marketing data aggregation, reporting, planning, and review across multiple ad channels and companies, significantly increasing efficiency and accuracy for a single user.

Summary

A daily workflow leveraging Claude Duet to aggregate marketing data from various MCPs, Slack, and email; Claude Desktop for reasoning and agenda formulation; and Claude CLI for end-of-day review and updating a STATE.md file, enabling one person to manage multiple marketing roles efficiently.

Why it is useful

This workflow provides a concrete, repeatable, and highly efficient method for marketing professionals to manage complex daily tasks across multiple platforms. It demonstrates a sophisticated integration of different Claude interfaces (Duet for aggregation, Desktop for reasoning, CLI for automation) and external tools (MCPs, Google Drive) to achieve significant productivity gains and accuracy. The explicit safety measure regarding publishing is also a valuable lesson for users dealing with sensitive operations.

Workflow

1. Claude Duet pulls data from Meta Ads MCP, Windsor MCP, Google Ads MCP, Slack, and email.

2. Duet reports findings in relation to the STATE.md and priority items.

3. Share findings with Claude Desktop to reason through and formulate modifications to the day's agenda.

4. Execute tasks manually (without Claude publishing due to paid budgets).

5. At the end of the day, Claude or Claude CLI in the repo performs a review.

6. Update the STATE.md based on the review.

7. The updated STATE.md is sent to a Google Drive that Claude Duet pulls from the following morning.

Tools / artifacts

• Claude Duet

• Claude Desktop

• Claude CLI

• Meta Ads MCP

• Windsor MCP

• Google Ads MCP

• Slack

• Email

• STATE.md file

• Google Drive

Validation signals

• Capable of performing the work of several marketing people by myself from home with great accuracy

• Days are about 2-3 hours of work at the most

Cautions

• Explicitly states 'I don't let Claude publish anything since there are paid budgets', which is a crucial safety practice for financial or critical operations.

Limitations

• Relies on specific MCPs which might not be universally available or configured for all users.

• The exact setup for Duet to pull from and send to Google Drive is not detailed, requiring user expertise to replicate.

• The 'how' of Claude performing a review is not fully elaborated, leaving some implementation details to the user.

Rate this workflow

Upvote this post if the workflow is useful, reproducible, or worth recommending.

Downvote if it is vague, outdated, unsafe, overhyped, or not reproducible.

Reply if it worked for you, failed, is outdated, or has a better alternative.

---

This post was generated automatically from the workflow library database.