{"uid":"cap_nMl7tOykQR35pfD_QDSlH","slug":"newsletter-observations-record-quality-audit-adjacent-row-changes-506947fa","name":"Newsletter Observations — Record Quality Audit + Adjacent Row Changes","description":"Newsletter observations — Record quality audit + Adjacent row changes: Record quality audit + Adjacent row changes for supplied newsletter observations records (delivered_messages, open_count). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-news-08-011?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","delivered_messages","open_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"open_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"channel_group":{"type":"string","default":"","maxLength":80},"delivered_messages":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","open_count":1,"channel_group":"group-a","delivered_messages":10},{"date":"2026-10-02","row_id":"row-2","open_count":2,"channel_group":"group-b","delivered_messages":20},{"date":"2026-10-03","row_id":"row-3","open_count":3,"channel_group":"group-a","delivered_messages":15},{"date":"2026-10-04","row_id":"row-4","open_count":4,"channel_group":"group-b","delivered_messages":30}],"maxItems":200,"minItems":1},"field":{"enum":["delivered_messages","open_count"],"type":"string","default":"delivered_messages"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_cGPxJL-NQ8zi_Zg4uNA7s","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Runs two local analytical reports (record quality audit and adjacent row change detection) on up to 200 newsletter observation rows containing delivered_messages and open_count fields.","exampleAgentPrompt":"Can you run a record quality audit and adjacent row change detection on my newsletter data? I have rows with delivered_messages and open_count by channel group and date — here are up to 200 rows, and I want the report focused on the delivered_messages field.","exampleUseCases":[{"title":"Pre-send newsletter data validation","prompt":"Before I load my newsletter metrics into our dashboard, can you audit this batch of up to 150 newsletter observation rows for quality issues in the delivered_messages field? I need to catch any bad records and see where values jump unexpectedly between adjacent rows."},{"title":"Detecting open rate anomalies in campaign data","prompt":"I've got a CSV of newsletter observations with open_count and delivered_messages across different channel groups and dates — can you run the quality audit and adjacent row change report on the open_count field so I can find where counts shift suspiciously between rows?"},{"title":"Channel group data consistency check","prompt":"We're comparing newsletter performance across channel groups and I need to check about 200 rows of observation data for record quality issues and sudden changes in delivered_messages between consecutive rows before we present the numbers to the team."}],"resultDescription":"Two independent analytical reports: (1) a record quality audit flagging issues such as nulls, out-of-range values, or formatting problems in each row's delivered_messages or open_count fields; and (2) an adjacent row change report identifying significant value shifts between consecutive rows for the selected field. Both reports cover up to 200 supplied rows and are computed locally without external lookups.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit","Missing required fields (row_id, channel_group, date, delivered_messages, open_count) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema rejection","Field selector not one of 'delivered_messages' or 'open_count' — enum validation failure","Empty rows array — minItems constraint violation","Payment failure or insufficient USDC balance — 402 response"],"whenToPreferThis":"Choose this endpoint when you have tabular newsletter observation data (delivered_messages, open_count) and need two specific local analytical reports — a record quality audit and an adjacent row change detection — without any live lookups, predictions, or external actions. It is well-suited for pre-processing pipelines that need cheap, fast, offline data quality checks on small-to-medium newsletter datasets (up to 200 rows) at $0.01 per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T13:16:23.427Z","isFirstParty":false,"canonicalSlug":"newsletter-observations-record-quality-audit-adjacent-row-changes-506947fa"}