Intentwise for DSP brands, when AMC dashboards beat manual pulls

Intentwise Explore for AMC starts at $1,000 a month as of April 2026. Amazon Marketing Cloud now retains 25 months of ad-traffic data, up from 13. Those two facts changed the math on whether DSP brands should keep paying an analyst to write SQL, or hand that work to a dashboard layer.

We run AMC for clients spending anywhere from $40k/mo to $1.4M/mo on Amazon DSP. The cutover point where Intentwise dashboards beat manual AMC pulls is sharper than most operators realize. It is not about ad spend. It is about query cadence and team composition.

What Intentwise actually ships in 2026

Intentwise Explore is the AMC product. It sits on top of your AMC instance, runs context-aware dashboards on path-to-purchase, lifetime value, new-to-brand decay, shopper abandonment, and Sponsored-to-DSP overlap. The dashboards refresh on AMC’s underlying cadence, 14-day lag for most tables, near-real-time for streaming.

The Analytics Cloud (IAC) tier starts at $1,500/month and centralizes reporting across Sponsored Ads, DSP, and AMC into one warehouse. That tier is the one most $5M+ DSP advertisers actually need, because the AMC-only product still leaves you correlating against Sponsored Ads exports manually.

The DSP Optimizer is a separate product. It pulls audience-level performance out of DSP and feeds reach-frequency curves and audience overlap reports that DSP’s native console hides. For brands running 12+ audiences with overlapping seed lists, this is where the tool earns its retainer.

The break-even math: $1,000/mo vs an analyst

A senior AMC analyst writes an audience-overlap query in roughly 90 minutes. Path-to-purchase, with proper deduping across DSP and Sponsored, takes 3-5 hours the first time and 60 minutes on a refresh. New-to-brand cohort decay against a 25-month window, now possible since AMC’s retention extension, runs 4 hours.

If you run those three queries monthly, that is roughly 8-10 analyst hours. At a loaded agency rate of $180/hour, that is $1,440-$1,800. Intentwise Explore at $1,000/mo undercuts that, and the dashboards refresh automatically when AMC drops new data.

The math flips when query cadence is quarterly instead of monthly. A brand pulling AMC twice a year does not save anything against $12,000 in annual Intentwise license. The break-even is around 6-7 distinct queries per quarter. Below that, keep the analyst on retainer.

Where the dashboards actually beat manual SQL

Three workflows where the productized version wins on more than cost:

1. New-to-brand cohort tracking across DSP retargeting. Building this from raw AMC requires joining the dsp_impressions, conversions_with_relevance, and amazon_attributed_events_by_traffic_time tables on a 90-day window per cohort. The Intentwise dashboard hands you the same view in two clicks and refreshes weekly. We’ve seen this single dashboard catch retargeting-pool exhaustion 3-4 weeks earlier than monthly manual pulls. For the deeper context on why this matters, our analysis of DSP retargeting incremental lift walks through how exhaustion shows up in conversion lag.

2. Sponsored Ads to DSP halo measurement. The cleanest way to prove DSP is lifting Sponsored Brands CTR is the Path-to-Purchase template. Manual SQL works, but every operator we audit writes this query slightly differently and the numbers diverge. The productized template removes that variance, useful when the conversation goes to a CFO who wants a defensible number.

3. Audience overlap and frequency capping. DSP’s native console will not show you that 31% of impressions on Audience A are also hitting Audience C. AMC will, but you have to write the query. Intentwise pre-builds it. We’ve used this exact dashboard to cut wasted DSP impressions by 18-22% on three different clients in 2026. The 2026 DSP landscape, covered in our Amazon DSP 2026 piece, is moving toward audience consolidation, and you can’t consolidate what you can’t see overlap on.

Where manual SQL still wins

The dashboard layer is template-driven. That means anything off-template costs you the same engineering time you would have spent in raw SQL, sometimes more, because you’re now writing a custom query and integrating it back into a dashboard tool.

Specific cases where we still write SQL by hand:

• Custom attribution windows. The default is 14-day. Several CPG clients want 28-day or 7-day for specific category dynamics. Intentwise’s templates assume 14-day. Custom windows mean custom queries.
• Cross-marketplace attribution. Brands running DSP US plus Walmart Connect plus retail.com properties have to stitch identity outside AMC. Intentwise does not solve that. Neither does Pacvue. You need a CDP or a warehouse.
• Margin-weighted reporting. AMC has zero concept of unit margin. If your DSP ROAS varies wildly by SKU because some have 12% margin and some have 41%, the off-the-shelf dashboards lie to you. We rebuild this in the warehouse with a margin lookup table.
• Anomaly investigation. When a campaign falls off a cliff, you want to ask AMC 14 questions in 20 minutes. A dashboard lets you ask 3. SQL wins for forensic work.

The decision framework

Three questions decide it:

Do you run more than 6 distinct AMC queries per quarter? If yes, Intentwise pays back. If no, retain a fractional analyst.

Do your queries fit AMC templates? If your reporting is standard path-to-purchase, NTB cohort, audience overlap, yes, the templates cover 80% of work. If you need custom attribution or margin-weighted metrics, you need warehouse infrastructure regardless of what dashboard tool sits on top.

Who consumes the output? If it’s an in-house analyst who can read SQL, raw AMC is fine. If it’s a CMO, brand manager, or external CFO, dashboards beat raw query exports every time. Defensibility matters when budget conversations happen.

The brands we see getting the most out of Intentwise are $5M-$30M GMV DSP advertisers with no in-house data team. They’re running enough query cadence to justify the spend, but not enough scale to justify a $200k-a-year analytics hire. Above $30M GMV, the calculus shifts back toward in-house infrastructure plus Intentwise as a layer, the dashboards stay, but the warehouse does the heavy lifting.

Get a free audit if you’re trying to decide whether your DSP program has graduated past manual AMC pulls. We’ve run this evaluation on 14 brands in 2026 and the answer splits roughly 60/40, most are underspending on dashboard tooling, but a non-trivial minority should not be paying $12k a year for templates they only run twice.