How-to guide

TL;DR
To report Amazon ad performance to clients with Xnurta MCP, connect Claude or ChatGPT, name one client's ad account, and ask for the weekly or monthly report, then carry the table and summary into your own slide template. Xnurta MCP connects Claude, ChatGPT and other MCP clients to your Xnurta data, and every report question is a read-only query. This guide is for agency teams that send Amazon ad reports to clients every week or month, whether you own the client relationship or build the numbers.
You ask your assistant for the report, one client ad account at a time, and Xnurta MCP reads the numbers from Xnurta. Claude or ChatGPT gets three query tools: ad performance, entity settings and the operation log. The official reporting skills tell the assistant what data to pull, in what order, and what shape to hand back.
Picture the last Thursday of the month. Six client reports are due Friday, and every client wants the same three answers: how did we do, why, and what did you do about it. You are not rebuilding that report six times by hand. You are asking for it six times.
Two setup steps come first, and they are separate. Connect the assistant, which Connect Claude or ChatGPT to Xnurta MCP walks through, then install the skills. Adding a connector never installs them.
A client report can run to seven sections: headline KPIs, trend, structure, products, search terms, what you changed, and next steps. Each one maps to a skill or a query you can ask for by name.
| Report section | Where it comes from | What to ask for |
|---|---|---|
| Headline KPIs | Weekly Ads Report or Monthly Ads Report | Spend, sales, ACOS and ROAS against the prior week or month |
| Trend | Weekly Ads Report | The last 7 days, day by day |
| Structure | Ads Structure Analysis | Spend and output split by SP, SB and SD, and by manual and auto |
| Products | Product Diagnosis | Ranking tiers for ASINs and parent ASINs, and products that are declining |
| Search terms | A plain search-term question | Which terms earned their spend, with CTR, CVR, ACOS and orders |
| What we changed | Operation log query | Human and AI actions in the same window |
| Next steps | Weekly Ads Report | Suggested actions for next week, for you to review before they reach the client |
You will not use every row every time. A weekly note to a small client might be rows one, two and seven. A quarterly sit-down with a big one wants all of them.
You name the ad account and ask for last week's report. The Weekly Ads Report skill returns week-over-week KPIs, 7-day trends, anomalies, AI and automation activity, top movers and suggested actions for next week. That covers sections one, two and seven of the table in one request.
Say what you want back. The window is last week against the week before. The shape is a KPI table and a short takeaway. Tell the assistant both, and it stops guessing.
Prompt: weekly client report
Create a weekly advertising report for ad account [client account name] covering last week. Include period-over-period KPIs, a 7-day trend, top movers, and recommended actions for next week. Put the KPIs in a table, then end with a three-sentence summary I can paste into an email to the client.
Want it every Monday? Ask the assistant to run the same report every Monday morning. Review it before it goes out, because a report you did not read is still your report.
You ask for last month's report and hand over the client's goals. The Monthly Ads Report skill returns month-over-month and year-over-year KPI baselines, ad-group-level structural share, product and keyword performance, goal attainment and new-product detection. Goal attainment needs a goal, so paste the targets you agreed with the client.
Prompt: monthly client report with goals
Generate last month's ads report for ad account [client account name]. Include month-over-month and year-over-year KPIs, spend share by ad group, product and keyword performance, and any new products. Measure it against these goals: [target ACOS, sales target, other goals]. Use a table for KPIs and bullets for takeaways.
A quarter is a window you set yourself. Give the assistant the date range and a comparison, such as the prior quarter. Performance history reaches back about 15 months, so a quarter and its comparison both fit.
One more thing worth saying to clients: the data follows Xnurta's platform update cadence. It is not second-by-second. Run the report after the platform has refreshed, not before.
You pull the skill that matches the question. A client who asks why spend moved between ad types wants Ads Structure Analysis, which breaks spend and output out by SP, SB and SD and by manual and auto, diagnoses imbalance, and reviews ACOS and CPA trends by section. A client who asks which products are slipping wants Product Diagnosis, which ranks ASINs and parent ASINs into tiers, detects declining products, compares variants, and checks ad eligibility and inventory.
Search Term Traffic Diagnosis is also an official skill. For a plain search-term view, ask which search terms performed well over the last 30 days, with CTR, CVR, ACOS and orders, and which high-ACOS, low-conversion terms look like negation candidates.
Then ask follow-ups in the same chat. Start broad, ask why, drill into one object. That beats one giant question.
Prompt: products dragging the account down
Diagnose product performance in ad account [client account name] for the last [30] days. Rank the parent ASINs into tiers, flag declining products, and check ad eligibility and inventory. Give me one plain sentence per flagged product that I can use in the client report.
You ask the operation log for the actions in the reporting window. The log holds human and AI actions on campaigns, ad groups, targets, bids, budgets and managed groups, and you can filter by operator, action type, entity and time. This is the section that answers the client who asks what you actually did all month, with actions and operators instead of adjectives.
Prompt: what we did this period
In ad account [client account name], list the human and AI actions on campaigns, bids and budgets over the last [30] days. Show bid and budget increases and decreases, pauses and enables, and who or what made each one. Group them by campaign.
For a single campaign that moved overnight, Who changed my Amazon campaign? shows the filters in detail.
You name one ad account in every request and check that the same name sits at the top of the answer. Ask the assistant to list the ad accounts you are authorized to access first, then pick one. You see only the ad accounts and permissions your own Xnurta login carries, main accounts and sub-accounts included.
To check what your connection reaches, ask the assistant to call get_user_authorized_context. It returns your user ID and your authorized profile IDs. If the marketplace matters, say so in the request.
Start a fresh chat for each client. That is a habit, not a product feature, and it keeps one client's tables out of the next client's thread.
You choose the shape of the answer, then build the slide in your own template. Ask for a table, a Top-N list, a one-line takeaway or a CSV export. Paste the table in, put the takeaway in the headline, and keep the CSV for the appendix.
Check the numbers before they leave your hands. Open the account in Xnurta and spot-check two or three against the report. The assistant reads the data. You stand behind the deck.
If your agency has a house format, you can teach it once. Tell your assistant you want to build a skill, then describe the scenario, set the rules and define the output. Test it on a real client's data, save it, and keep it private or share it with your organization. Write a Sponsored Ads SOP a new hire can follow shows the steps, and How an SOP becomes something an AI assistant can run covers the official skills.
No. Queries on performance, settings and operation logs are read only, so a report cannot change a client's account.
The access rule
Generally available from 27 Oct for Sponsored Ads. Write access is turned on per account by your CSM.
If a report points to a fix and write access is on for that account, changes involving money, bids or archiving get a preview first: which objects, and from what value to what value. Nothing is submitted until you confirm. Archiving cannot be undone, so pause a campaign if you only want it to stop. Read-only vs read-write MCP for Amazon advertisers explains the difference.
FAQ
Yes. Once connected, the assistant pulls performance, settings and operation log data from Xnurta through read-only queries, and the official Weekly Ads Report and Monthly Ads Report skills set the structure.
Use Monthly Ads Report. It returns month-over-month and year-over-year KPI baselines, ad-group-level structural share, product and keyword performance, goal attainment and new-product detection.
You choose. Ask for a table, a Top-N list, a one-line takeaway or a CSV export, then build the slide in your own template.
Any ad account your own Xnurta login can access, main accounts and sub-accounts included. Name one ad account per request.
About 15 months. Performance data is daily by default, and it follows the Xnurta platform's update cadence rather than real time.
Xnurta MCP
Xnurta MCP is for Xnurta customers only. Create your MCP connection directly in the Xnurta platform. New to Xnurta? Book a demo and we'll walk through your account with you.