“App Market Media saw a 300% increase in Revenue with Affise. The сompany commits to generate efficient user-engagement strategies through performance-based models to ensure the maximum ROI for clients.”
How to Ask the Affise MCP for Data: A Prompt Library
Copy these prompts. Change the IDs and dates. Get your answer in seconds.
The Affise MCP connects your AI assistant (Claude, Cursor, or any MCP-compatible client) to your live Affise data. You ask a question in plain English, and the assistant calls the right Affise API for you. No exports, no filters, no pivot tables.
But the answer you get depends on the question you ask. A clear prompt returns the exact number you need. A vague prompt returns something close, and then you spend three follow-ups fixing it.
This article is a library of prompts you can copy and reuse. First it shows the few patterns that make any prompt work. Then it gives you ready-made prompts for the tasks you run every week.
What makes a good prompt work
You do not need to learn a query language. Be clear about five things and any prompt works.
Be clear about five things: the metric, the period, the entity, the breakdown, and the format.
Ask for the outcomeSay what you want to know. Let the assistant pick the tool.
Name the metric and period"Revenue last 7 days" — not "how are things going?"
Give the exact IDPartner 3554, offer 95119. IDs get the right record first try.
Say how to slice itBy country, by offer, by day, by sub ID. Name the breakdown.
Ask for the comparison"This week vs last week" returns the change in one answer.
Say the formatTop 10, a sortable table, or CSV for a spreadsheet.
The prompt library
Copy any prompt below. Replace the IDs, dates, and geos with yours. Use the search box to find a task, or click the tags to filter. Open Why this works on any card to see the pattern behind it.
Portfolio
PortfolioComparePartners
Top partners, week over week
Top 20 partners by revenue last week vs the week before, with the change.
Names the metric (revenue), the period, and the comparison in one line — so the assistant pulls both weeks and shows the delta.
Portfolio
PortfolioOffers
Best offers this month
Top 10 offers by conversions this month.
A metric, a limit, and a period. The assistant ranks and stops at 10.
Portfolio
PortfolioPartners
Who went quiet
Which partners sent zero traffic in the last 7 days but were active the week before?
Describes the outcome, not the query. The assistant compares two periods to find the drop-offs.
Portfolio
Portfolio
Whole-account snapshot
Total clicks, conversions, revenue, and CR for the whole account last month.
Lists the exact metrics you want, so nothing is guessed.
Partners
Partners
One partner, full picture
Full performance for partner 3554 last 30 days: clicks, conversions, revenue, and CR.
The exact partner ID plus a metric list gets the right record on the first try.
Partners
Partners
Slice a partner every way
Break partner 3554 down by offer, then by country, then by device and OS.
Names each breakdown in order, so you build a full profile without restarting.
Partners
Partners
Daily trend
Show partner 3554's daily trend for the last 30 days.
Asks for the time breakdown (daily), so you see the shape, not just a total.
Partners
PartnersConversions
Goals and sub IDs
Conversions by goal for partner 3554 last month, plus the top sub2 and sub5 values.
Groups by goal and sub ID together, so quality and source come back in one answer.
Partners
Partners
Summarize the deep-dive
/analyze_stats on partner 3554 last 30 days across all those breakdowns.
Hands the collected slices to an analysis prompt for a written read-out.
Conversions
Conversions
Approved conversions
Approved conversions from yesterday for partner 193 in the US.
Status, period, partner, and geo — four filters that return exactly what cleared.
Conversions
Conversions
Last 100 with payouts
Last 100 conversions for partner 3554 with payouts and statuses.
A clear limit and the fields you need to reconcile before payout.
Conversions
ConversionsPartners
Pending before payout
All pending conversions for offer 95119 this week, grouped by partner.
Filters by status and groups by partner, so you see who is waiting on what.
Conversions
ConversionsLookups
One conversion, full detail
Get the full detail for conversion 8f3a2c.
The exact conversion ID returns one record with every field.
Trafficback
Trafficback
Trafficback by reason
Show trafficback for the last 7 days, broken down by reason.
Names the data type and the breakdown, so wasted traffic is grouped by cause.
Trafficback
TrafficbackPartners
Worst partners for waste
Trafficback by partner last month, top 10 by wasted clicks.
Groups by partner and ranks, so the biggest sources surface first.
Trafficback
Trafficback
Summarize trafficback
/analyze_trafficback on the last result.
Turns the raw breakdown into a written analysis of likely causes.
Quality
QualityOffers
Retention by offer
Retention rate for the last 30 days by offer.
Asks for a quality metric grouped by offer, not just volume.
Tracking
Tracking
Generate a tracking link
Generate a tracking link for offer 95119 and affiliate 3554 with sub1: campaign_x and sub2: creative_y.
Gives the offer, the affiliate, and the sub IDs, so the link comes back ready to copy.
Tracking
TrackingLookups
Confirm before you send
Get partner 3554 detail so I can confirm the affiliate before I generate the link.
Looks up the record first, so you send the link to the right partner.
Compare
CompareOffers
Offer, month over month
Compare offer 95119 this month vs last month: clicks, conversions, revenue, and CR.
Both periods and the metrics in one prompt return the change, not two separate tables.
Compare
Compare
Geo shifts
Revenue by country this week vs last week, and highlight the geos that dropped.
Asks for the comparison and the takeaway (which geos dropped) together.
Lookups
LookupsPartners
List partners
List the first 50 partners, name and ID only.
A limit and the two fields you need to find an ID for the next prompt.
Lookups
LookupsAdvertisers
Advertisers with balances
Show the advertisers with unpaid balances.
Describes the outcome; the assistant filters the advertiser list for you.
Lookups
LookupsOffers
Offer detail
Get offer 95119 detail: payout, countries, and caps.
The offer ID plus the exact fields returns a focused record.
No prompts match. Try clearing the filters.
Fix a vague prompt
If an answer is not what you expected, the prompt was probably missing the metric, the period, or the entity. Here is how to sharpen the common ones.
Vague prompt
Sharper prompt
What changed
"How are my partners doing?"
"Top 20 partners by revenue last 7 days, with the change vs the week before."
Added metric, period, and comparison.
"Show me conversions."
"Approved conversions from yesterday for partner 193 in the US."
Added status, period, entity, and geo.
"Check offer 95119."
"Clicks, conversions, revenue, and CR for offer 95119 this month, by country."
Added metrics, period, and breakdown.
"Any bad traffic?"
"Trafficback for the last 7 days by reason, top 10."
Named the data type, period, breakdown, and limit.
Good to know: the limits
The MCP is honest about a few boundaries. Knowing them helps you write prompts that succeed on the first try.
Custom stats cover up to 6 months per request. For a longer view, ask for the periods one at a time.
Conversion records go back 365 days in normal mode.
Filters accept sub1 to sub8. You can group by any sub ID up to sub30, but you can only filter on the first eight.
The session is temporary. The assistant sees your data only while you are connected. When you start a new session, you connect again.
State these in your prompt when they matter. For example: "Split the last 12 months into two 6-month pulls and show revenue for each."
Start asking
You do not need to memorize any of this. Keep this page open, copy the prompt that matches your task, and change the IDs and dates. After a week, you will have your own short list of prompts you run every Monday.
If you have not connected yet, it takes about two minutes. Open the Client Quickstart, add the connector, and start asking.
