Cuiar
Sign inDownload

Get a weekly report on your Meta ads

Spend, cost per result and return for each campaign, the tired ads, and 2 tests for next week.

  • On a schedule: Every Monday at 8:00
Use in CuiarRun from your AI agent

What it does

The task

Open Meta Ads Manager for the ad account ad account and read the last 7 days. For each active campaign and ad set, record the spend, the results, the cost per result, the return on ad spend and the frequency. Compare each number with the 7 days before. Flag the ads with a frequency above 3 or a cost per result that rose more than 25%. Add the totals to the sheet sheet url, and send me a report of 12 lines or fewer with 2 tests to run next. Do not change any campaign.

  • It works in Meta Ads Manager and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • As a routine it runs every Monday at 8:00 (cron 0 8 * * 1).

What you give it

BlankWhat to giveExample
ad accountThe ad account name or ID in Meta Ads ManagerPinhal Wines (act_2918834410)
sheet urlThe Google Sheet that keeps the weekly totalshttps://docs.google.com/spreadsheets/d/1Ma3pWx6Ry/edit

What you get back

An example run with the example values above. Your run uses your own data.

Meta ads, Pinhal Wines, 20 to 26 October 2026

Spend: 2,140 EUR (+8%). Purchases: 96. Cost per purchase: 22.29 EUR (-4%). ROAS: 3.1

Best: Gift boxes, broad audience, ROAS 4.6

Tired ads (frequency above 3): 'Autumn reds video' (3.8), 'Free shipping carousel' (3.4)

Cost per purchase up more than 25%: Retargeting 30 days (+41%)

Tests for next week:

1. A new hook for the gift box video: show the price in the first 2 seconds

2. Move 20% of the retargeting budget to the broad gift box ad set

Sheet: one row added. No campaign changed.

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 2 blanks

    Type ad account and sheet url. Tab moves to the next blank.

  3. 03

    Run it, then repeat it

    Run sends it once. To run it every Monday at 8:00, make a routine on cuiar.com/routines or with the CLI below.

As a routine, from the terminal

cuiar routines create "Get a weekly report on your Meta ads" --schedule "0 8 * * 1" --time-zone Europe/Berlin \
  "Open Meta Ads Manager for the ad account Pinhal Wines (act_2918834410) and read the last 7 days. For each active campaign and ad set, record the spend, the results, the cost per result, the return on ad spend and the frequency. Compare each number with the 7 days before. Flag the ads with a frequency above 3 or a cost per result that rose more than 25%. Add the totals to the sheet https://docs.google.com/spreadsheets/d/1Ma3pWx6Ry/edit, and send me a report of 12 lines or fewer with 2 tests to run next. Do not change any campaign."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call create_routine yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool create_routine to run my "Get a weekly report on your Meta ads" template with ad account = Pinhal Wines (act_2918834410); sheet url = https://docs.google.com/spreadsheets/d/1Ma3pWx6Ry/edit.

Setup for other agents: AI agents.

The tool call

{
  "name": "create_routine",
  "arguments": {
    "name": "Get a weekly report on your Meta ads",
    "task": "Open Meta Ads Manager for the ad account Pinhal Wines (act_2918834410) and read the last 7 days. For each active campaign and ad set, record the spend, the results, the cost per result, the return on ad spend and the frequency. Compare each number with the 7 days before. Flag the ads with a frequency above 3 or a cost per result that rose more than 25%. Add the totals to the sheet https://docs.google.com/spreadsheets/d/1Ma3pWx6Ry/edit, and send me a report of 12 lines or fewer with 2 tests to run next. Do not change any campaign.",
    "schedule": "0 8 * * 1",
    "time_zone": "Europe/Berlin"
  }
}

Related templates

All marketing templates

  • MarketingAsks first

    Schedule a week of posts from your sheet

    Each approved post from your content sheet set up in its site's scheduler, after your OK.

    On a schedule: Every Friday at 14:00
    • Google Sheets
    • LinkedIn
    • Facebook
    • +1 more: Instagram

  • Marketing

    Find keywords to target for a topic

    Keywords with intent, your current position and difficulty, grouped into topics, with 5 posts to write first.

    You start it: When you start it
    • Google Search Console
    • Google Trends
    • Google Sheets

  • Marketing

    Find wasted spend in Google Ads

    Search terms, keywords and ads that cost money and bring no conversions, with the fix for each.

    You start it: When you start it
    • Google Ads
    • Google Sheets

  • Marketing

    Plan a month of social media posts

    A calendar with a date, channel, format, topic and first draft for each post, based on what worked.

    You start it: When you start it
    • Google Sheets
    • Instagram
    • LinkedIn

  • MarketingAsks first

    Build a press list and draft pitches

    Reporters who covered your topic recently, with their articles, and one pitch for each, sent after your OK.

    You start it: When you start it
    • Google News
    • Any news site
    • Gmail
    • +1 more: Google Sheets

  • MarketingAsks first

    Find best-of lists that leave out your product

    List articles that name your competitors and not you, with the site's contact and a pitch for your OK.

    You start it: When you start it
    • Any website
    • Gmail
    • Google Sheets