Workflows
6 areas
Copy-and-paste prompts to draw actionable insights from your data — built for non-technical affiliate managers.
Every prompt in this library is designed to be copy-and-pasted directly into your AI client, with your tracking platform connected. No setup, no modifications needed — just replace placeholders in brackets with your actual data.
The prompts are organized around four core workflows: Quality Audit (is this partner worth it?), Budget Allocation (where should I spend more?), Event Tracking (am I measuring the right things?), and Publisher Health (who's still active, who's dropped off?).
Each prompt includes context, dates, and examples so you get consistent, actionable answers. Start with the workflow that matters most this week, then dive in.
Run these prompts first every time you start a new session. They confirm your defaults so all subsequent dates and numbers are interpreted correctly.
"What is my network's default currency, timezone, and account name? Do I have limited affiliate scope?"
"What entity types can I query? Show me all available report dimensions and metrics, with definitions."
"Give me a performance summary for today. Show total clicks, conversions, revenue, payout, and profit. Use my network's default timezone."
Is this partner/offer actually worth your budget? Use these prompts to identify low-quality traffic and assess whether a publisher is driving real users or bot volume.
"For affiliate [AFFILIATE_ID], show me the last 30 days of performance: total clicks, conversions, conversion rate, and invalid click rate. Is this partner above or below my network average?"
"Run a performance report for affiliate [AFFILIATE_ID] between [FROM_DATE] and [TO_DATE] broken down by click error code. Show each error, the count, and what percentage of total clicks each represents."
"For conversions from affiliate [AFFILIATE_ID] in the last 30 days, what percentage of those users made a second purchase within 60 days? How does this compare to my network average?"
"Show me all publishers for offer [OFFER_ID] in the last 7 days. For each, display: clicks, conversions, CVR, and invalid click rate. Flag anyone with CVR below 0.5% or invalid clicks above 10%."
"Which publishers sent traffic to offer [OFFER_ID] in the last 7 days but had zero conversions? Sort by click volume descending."
Where should you increase spend? These prompts identify high-performing publishers and offers with room to scale, plus payback metrics so you know which opportunities you can actually afford.
"Show me my top 10 affiliates by revenue for the past 30 days. For each, display: total revenue, EPC, conversion rate, payout, and profit. Which ones have the highest profit margin and room to scale?"
"Find publishers with conversion rate above [BENCHMARK]% but fewer than [MIN_CLICKS] clicks in the last 30 days. Sort by CVR descending. These are worth increasing budget on."
"For my top 5 publishers by volume, what is the average time from click to payout? Which ones generate profit within 30 days? Which require longer investment?"
"Compare performance across my top 5 offers for the last 30 days. Show: clicks, conversions, CVR, revenue, payout, and profit for each. Which offer should receive more budget?"
"Break down last 30 days of performance by country. Show clicks, conversions, CVR, and revenue. Highlight any country with CVR above my network average but traffic volume below [THRESHOLD]."
Are you measuring the right things? Use these prompts to audit event setup, verify data flow, and ensure conversions are being attributed correctly.
"For offer [OFFER_ID], list all configured conversion events. For each event, show: event name, event type, how many conversions in the last 7 days, and the payout per conversion."
"Look up conversion [CONVERSION_ID]. Show me the full picture: offer, publisher, advertiser, timestamp, payout status, error code, and the original click timestamp."
"For offer [OFFER_ID] in the last 24 hours, how many clicks were registered? How many conversions? What is the click-to-conversion ratio? Are conversions being tracked in real-time or with delay?"
"Which of my offers had clicks in the last 7 days but zero conversions recorded? List them with their click volume. These may have tracking issues."
"For offer [OFFER_ID], compare conversion events by publisher. Which publishers have high click volume but low conversion count? This may indicate tracking gaps on their side."
Who's gone cold? Who's still active? These prompts help you spot publishers that have fallen silent and decide who to follow up with.
"Which publishers sent traffic to any of my offers in [PREVIOUS_MONTH] but had zero clicks in [CURRENT_MONTH]? Sort by previous month's traffic volume descending."
"Compare performance for affiliate [AFFILIATE_ID] between [PREVIOUS_MONTH] and [CURRENT_MONTH]. Show month-over-month change in clicks, conversions, revenue, and payout."
"Which publishers had good traffic last month but are now in the bottom 25% by volume? Show their last 30 days: clicks, conversions, and CVR. These may need re-engagement."
"Which publishers doubled or tripled their traffic week-over-week in the last 14 days? Show their 7-day and 14-day performance for each to confirm the trend is real."
"For my bottom 10 publishers by recent traffic, when did each last send a click? Show their total lifetime revenue and their last 30 days of activity."
Diagnose suspicious activity. Use these prompts to investigate individual clicks, spot patterns that don't add up, and protect your network from fraud.
"Look up transaction ID [TRANSACTION_ID]. Tell me: the offer, publisher, timestamp, whether it was accepted or blocked, any error code and its meaning, and whether it ever converted."
"Show me daily clicks for publisher [AFFILIATE_ID] over the last 14 days. Flag any single day that is more than 2x the daily average. What happened on those days?"
"For publisher [AFFILIATE_ID] between [FROM_DATE] and [TO_DATE], show me all invalid click errors broken down by error code. What percentage of their total clicks are being rejected?"
"For publisher [AFFILIATE_ID], show any conversions marked with error status or declined in the last 30 days. What are the error codes? How much has this cost in unpaid commissions?"
"For offer [OFFER_ID], are there any publishers with extremely high conversion rates (above 10%)? Or unusually high payout values? These may warrant manual review."