---
title: "Weekly CLI Analytics Prompt for Claude Code"
description: "A prompt for Claude Code, Codex or Cursor that runs the postqueen CLI and prints the last 7 days of numbers for each channel. With the commands and a sample."
canonical_url: "https://postqueen.ai/prompts/weekly-numbers-in-the-terminal"
markdown_url: "https://postqueen.ai/prompts/weekly-numbers-in-the-terminal.md"
last_updated: "2026-09-25"
llms_txt: "https://postqueen.ai/llms.txt"
---

# Print a weekly numbers table with the postqueen CLI

For developers who want a quick weekly look at their channels without leaving the terminal.

[Start 7-day trial for $0](https://app.postqueen.ai/auth?utm_source=postqueen.ai&utm_medium=landing&utm_campaign=trial&utm_content=prompt-page-hero) [All prompts](https://postqueen.ai/prompts) $0 due today. Cancel in one click.

Prompt ![X](https://postqueen.ai/assets/channels/x.svg) ![Instagram](https://postqueen.ai/assets/channels/instagram.svg) ![YouTube](https://postqueen.ai/assets/channels/youtube.svg)

Use the postqueen CLI to show the last 7 days of numbers for each of my channels, and print a short summary table.

Works best with ![Claude Code](https://postqueen.ai/assets/agents/claude-code.svg) ![Codex](https://postqueen.ai/assets/agents/codex.svg) ![Cursor](https://postqueen.ai/assets/agents/cursor.png) and any agent connected to PostQueen

What your agent does

## The commands, in order.

1. `postqueen integrations:list` `all channels` Lists your channels with their ids.
2. `postqueen analytics:platform` `<id> -d 7` Reads the last 7 days of numbers for each channel, as JSON.
3. `postqueen posts:list` `--startDate, --endDate` Lists the posts from the same 7 days.
4. `postqueen analytics:post` `<id> -d 7` Reads the numbers of each of those posts, so the table can name the best one.

These are the real postqueen CLI commands your agent runs in the terminal. It picks them on its own; you only send the prompt.

The result

## An answer, from your own data.

Your agent reads your calendar or your results through PostQueen and answers you. Nothing is posted or changed.

- Read from the same data you see in PostQueen
- Nothing is posted, changed or deleted
- Ask for drafts next, when you are ready

Variations

## Make it your own.

- Show the last 30 days instead, with -d 30.
- Save the table as a Markdown file in [./reports] with the date in its name.
- Only include the channels in the customer group [Bloom Bakery].

Tips

## Before you send it.

- Every postqueen command prints JSON, so your agent can read it and build the table itself.
- Analytics cover X, Facebook Pages, Instagram, LinkedIn Pages, YouTube, Threads, Pinterest, TikTok and Google Business.
- Set POSTQUEEN_API_KEY once in your shell profile, and every command in every project uses it.

## More prompts like this

- [Results ![X](https://postqueen.ai/assets/channels/x.svg) ![Instagram](https://postqueen.ai/assets/channels/instagram.svg) ![TikTok](https://postqueen.ai/assets/channels/tiktok.svg) My best openings Creators Open the prompt](https://postqueen.ai/prompts/my-best-openings)
- [Results ![Instagram](https://postqueen.ai/assets/channels/instagram.svg) ![Facebook](https://postqueen.ai/assets/channels/facebook.svg) What worked this month Small business Open the prompt](https://postqueen.ai/prompts/what-worked-this-month)
- [Results ![Instagram](https://postqueen.ai/assets/channels/instagram.svg) ![Facebook](https://postqueen.ai/assets/channels/facebook.svg) ![LinkedIn](https://postqueen.ai/assets/channels/linkedin.svg) Notes for a monthly client update Agencies Open the prompt](https://postqueen.ai/prompts/notes-for-a-monthly-client-update)
- [Results ![X](https://postqueen.ai/assets/channels/x.svg) What resonated Founders Open the prompt](https://postqueen.ai/prompts/what-resonated)

### Copy it. Your agent does the rest.

Connect your agent to PostQueen and send the prompt. The drafts wait on your calendar.

[Start 7-day trial for $0](https://app.postqueen.ai/auth?utm_source=postqueen.ai&utm_medium=landing&utm_campaign=trial&utm_content=band-prompt-page) $0 due today. Cancel in one click.