Pp Stackadapt

<!-- GENERATED FILE — DO NOT EDIT.
     This file is a verbatim mirror of library/marketing/stackadapt/SKILL.md,
     regenerated post-merge by tools/generate-skills/. Hand-edits here are
     silently overwritten on the next regen. Edit the library/ source instead.
     See the repository agent guide, section "Generated artifacts: registry.json, cli-skills/". -->

StackAdapt — Printing Press CLI

Prerequisites: Install the CLI

This skill drives the stackadapt-pp-cli binary. You must verify the CLI is installed before invoking any command from this skill. If it is missing, install it first:

1. Install via the Printing Press installer. It defaults binaries to $HOME/.local/bin on macOS/Linux and %LOCALAPPDATA%\Programs\PrintingPress\bin on Windows:

   npx -y @mvanhorn/printing-press-library install stackadapt --cli-only

2. Verify: stackadapt-pp-cli --version
3. Ensure the reported install directory is on $PATH for the agent/runtime that will invoke this skill.

If the npx install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.6 or newer):

go install github.com/mvanhorn/printing-press-library/library/marketing/stackadapt/cmd/stackadapt-pp-cli@latest

If --version reports "command not found" after install, the runtime cannot see the binary directory on $PATH. Do not proceed with skill commands until verification succeeds.

When to Use This CLI

Use this CLI to analyze StackAdapt campaigns you already run: check pacing against budget, find under-performing or non-delivering campaigns, spot CTR/spend drift, and pull delivery reports. It is the right tool for read-only reporting and analysis, especially for agents and scripts that want JSON output.

Anti-triggers

Do not use this CLI for:

• Creating, editing, pausing, or deleting campaigns, ads, or segments — this CLI is read-only; use the StackAdapt UI or the official SDK.
• Uploading audiences or creatives — out of scope.
• Real-time bidding or pixel firing — not what this CLI does.

Unique Capabilities

These capabilities aren't available in any other tool for this API.

Pacing & delivery observatory

• pacing — See which campaigns are under- or over-pacing against their budget, not just current spend.

  Reach for this to catch campaigns that will overspend or underdeliver before the budget cycle ends.

  stackadapt-pp-cli pacing --advertiser adv_123 --agent

• delivery-drift — Track CTR, CPM, and spend drift week-over-week for a campaign and flag when performance degrades.

  Reach for this to catch a slowly degrading campaign before it wastes budget.

  stackadapt-pp-cli delivery-drift --advertiser adv_123 --days 7 --agent

Audience & efficiency

• bottleneck — Rank the highest-spend campaigns by worst ROAS or CPA, with a reason column.

  Reach for this to find where ad budget is being wasted.

  stackadapt-pp-cli bottleneck --advertiser adv_123 --agent

• stale-campaigns — Find active campaigns with zero delivery in the last N days.

  Reach for this to find live-but-not-delivering campaigns.

  stackadapt-pp-cli stale-campaigns --days 14 --agent

Command Reference

graphql — Raw GraphQL query passthrough (advanced; prefer the typed commands)

• stackadapt-pp-cli graphql — Execute a raw GraphQL query against the StackAdapt API

Offline store — mirror objects locally, then search and query without API calls

• stackadapt-pp-cli sync — Pull advertisers, campaigns, campaign-groups, ads, and segments into a local SQLite store (--resources a,b to scope, --limit N per resource).
• stackadapt-pp-cli search "<term>" — Substring-search synced objects by name or any field offline (--type <resource> to scope).
• stackadapt-pp-cli sql "<SELECT ...>" — Run a read-only SQL query against the store's resources table (resource_type, id, name, data JSON, synced_at). Mutating statements are rejected.
• Any list command accepts --data-source local (store only) or --data-source auto (live, store fallback when the API is unreachable).

Finding the right command

When you know what you want to do but not which command does it, ask the CLI directly:

stackadapt-pp-cli which "<capability in your own words>"

which resolves a natural-language capability query to the best matching command from this CLI's curated feature index. Exit code 0 means at least one match; exit code 2 means no confident match — fall back to --help or use a narrower query.

Recipes

Find under-pacing campaigns

stackadapt-pp-cli pacing --advertiser adv_123 --agent

Returns each campaign's pace (actual vs expected spend) so you can fix budget delivery before the cycle ends.

Catch a degrading campaign

stackadapt-pp-cli delivery-drift --advertiser adv_123 --days 7 --agent

Shows CTR/CPM/spend drift week-over-week and flags when performance slips.

Trim a verbose report for an agent

stackadapt-pp-cli report campaign-delivery --days 30 --agent --select records.campaign_name,records.metrics.cost,records.metrics.ctr

Delivery reports are large; --select with dotted paths returns only the fields an agent needs, saving context.

Find where budget is wasted

stackadapt-pp-cli bottleneck --advertiser adv_123 --agent

Ranks high-spend campaigns by worst ROAS/CPA with a reason column.

Auth Setup

This CLI uses the StackAdapt GraphQL API, which needs a GraphQL API token (the legacy REST key will not work). To get set up:

1. Ask your StackAdapt account manager for a GraphQL API token if you do not have one.
2. Export it so the CLI can read it: export STACKADAPT_API_TOKEN=your-token
3. Run stackadapt-pp-cli doctor to confirm it connects.

The token is sent as Authorization: Bearer <token>. The CLI is read-only and never modifies your campaigns.