{"uid":"cap_rKnAm1JZnW_xz5UQywCGj","slug":"social-post-observations-duplicate-key-report-adjacent-row-changes-6acdd3fc","name":"Social Post Observations — Duplicate Key Report + Adjacent Row Changes","description":"Social post observations — Duplicate key report + Adjacent row changes: Duplicate key report + Adjacent row changes for supplied social post observations records (impressions, engagement_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-13-062?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","impressions","engagement_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"impressions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"channel_group":{"type":"string","default":"","maxLength":80},"engagement_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","impressions":10,"channel_group":"group-a","engagement_count":1},{"date":"2026-10-02","row_id":"row-2","impressions":20,"channel_group":"group-b","engagement_count":2},{"date":"2026-10-03","row_id":"row-3","impressions":15,"channel_group":"group-a","engagement_count":3},{"date":"2026-10-04","row_id":"row-4","impressions":30,"channel_group":"group-b","engagement_count":4}],"maxItems":200,"minItems":1},"field":{"enum":["impressions","engagement_count"],"type":"string","default":"impressions"}}},"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_qk4jQavtzXthZugW-VphH","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":"Analyzes up to 200 social post observation rows to produce a duplicate key report and an adjacent row changes report for impressions or engagement_count metrics.","exampleAgentPrompt":"Can you run a duplicate key report and adjacent row changes analysis on my social post data — here are 50 rows with row_id, channel_group, date, impressions, and engagement_count — analyze the impressions field for the row changes part.","exampleUseCases":[{"title":"Duplicate detection in social campaign data","prompt":"I have a batch of 120 social post observation records from our Q3 campaign with row_id, channel_group, date, impressions, and engagement_count columns — can you check for any duplicate row IDs and also show me how impressions change between consecutive rows?"},{"title":"Engagement count audit across channels","prompt":"Here are 80 rows of social post data across multiple channel groups — run the duplicate key report and show me the adjacent row changes for the engagement_count field so I can spot any anomalies."},{"title":"Daily impression trend audit","prompt":"I've got 200 social post observation rows I want to audit — please generate the duplicate key report and adjacent row changes report focused on the impressions field so I can validate the data before our weekly review."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying rows that share the same row_id, and (2) an adjacent row changes report showing value differences between consecutive rows for the selected metric field (impressions or engagement_count). Both reports are computed locally without any external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, channel_group, date, impressions, or engagement_count) on any row — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid field value (not 'impressions' or 'engagement_count') — enum validation error","Empty rows array — schema minItems violation"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously detect duplicate row keys and measure adjacent row-to-row metric changes in social post observation data (impressions or engagement_count) within a single low-cost call. Ideal for data quality audits of social analytics exports before downstream processing or reporting, especially when you want both structural integrity checks and trend delta analysis in one pass without any live data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:51.410Z","isFirstParty":false,"canonicalSlug":"social-post-observations-duplicate-key-report-adjacent-row-changes-6acdd3fc"}