{"uid":"cap_j9q7o0TRKMjTHpFKvWzgp","slug":"data-ingestion-batches-two-measure-correlation-date-by-category-pivot-b6139885","name":"Data Ingestion Batches — Two-Measure Correlation + Date by Category Pivot","description":"Data ingestion batches — Two-measure correlation + Date by category pivot: Two-measure correlation + Date by category pivot for supplied data ingestion batches records (received_rows, accepted_rows). 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-analytics-01-182?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["received_rows","accepted_rows"],"type":"string","default":"received_rows"}}},"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_2Ogrnw9VWqAI9Wiog95o2","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":"Computes a two-measure correlation (received_rows vs accepted_rows) and a date-by-category pivot table for up to 200 supplied data ingestion batch records in a single call.","exampleAgentPrompt":"Can you run a correlation between received_rows and accepted_rows plus a date-by-category pivot on these ingestion batch records I'm uploading — there are about 80 rows covering multiple dataset groups?","exampleUseCases":[{"title":"ETL pipeline acceptance rate analysis","prompt":"I have 150 rows of daily ingestion batch data across three dataset groups. Can you correlate received_rows with accepted_rows and pivot the counts by date and group so I can see where data is being dropped?"},{"title":"Data quality audit across groups","prompt":"Run a two-measure correlation and a date-by-category pivot on these ingestion batch records — I want to understand if the accepted_rows track consistently with received_rows across our group-a and group-b pipelines."},{"title":"Monthly ingestion trend summarization","prompt":"Here are 200 rows of ingestion batch records for October. Please compute the correlation between received_rows and accepted_rows and give me a pivot table breaking down the numbers by date and dataset_group."}],"resultDescription":"Returns two analytical reports: (1) a two-measure correlation result quantifying the relationship between received_rows and accepted_rows across the supplied records, and (2) a pivot table cross-tabulating dates against dataset_group categories with the selected measure's values — all computed locally from the submitted data with no external lookups.","failureModes":["Fewer than 1 row submitted — rejected at schema validation","More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) — schema validation error","Invalid date format (must be YYYY-MM-DD) — pattern validation failure","Null values for both measures across all rows — correlation undefined","Payment not included or insufficient — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you have tabular data ingestion batch records (with received_rows and accepted_rows metrics) and need both a correlation analysis and a date-by-category pivot in a single low-cost call. It is ideal for ETL pipeline monitoring, data quality auditing, and acceptance rate analysis on datasets up to 200 rows, where you supply the data directly rather than connecting to a live database.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T00:52:26.353Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-two-measure-correlation-date-by-category-pivot-b6139885"}