{"uid":"cap_UetGmRC8fWDJfVUSsadJT","slug":"translation-delivery-analytics-string-normalisation-date-by-category-0ab35c55","name":"Translation Delivery Analytics — String Normalisation & Date-by-Category Pivot","description":"Translation delivery — String normalisation + Date by category pivot: String normalisation + Date by category pivot for supplied translation delivery records (translated_words, source_words). 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-writing-04-035?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","translated_words","source_words"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_words":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"document_group":{"type":"string","default":"","maxLength":80},"translated_words":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_words":1,"document_group":"group-a","translated_words":10},{"date":"2026-10-02","row_id":"row-2","source_words":2,"document_group":"group-b","translated_words":20},{"date":"2026-10-03","row_id":"row-3","source_words":3,"document_group":"group-a","translated_words":15},{"date":"2026-10-04","row_id":"row-4","source_words":4,"document_group":"group-b","translated_words":30}],"maxItems":200,"minItems":1},"field":{"enum":["translated_words","source_words"],"type":"string","default":"translated_words"}}},"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_91DvEF4h9Trq94OtImWUX","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 on translation delivery data: string normalisation and a date-by-category pivot, for up to 200 rows of translated_words or source_words.","exampleAgentPrompt":"I have 4 translation delivery records with document groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and translated_words counts. Can you normalise the string fields and give me a date-by-category pivot of the translated_words field?","exampleUseCases":[{"title":"Monthly translation volume pivot by team","prompt":"I've got 150 rows of translation delivery records from last month with document groups for each team and daily word counts. Can you normalise the string fields and pivot the translated_words by date and document group so I can see each team's daily output?"},{"title":"Source word count breakdown for billing","prompt":"Here are 80 translation job records with source_words counts across several document groups over the past two weeks. Run the string normalisation and give me a date-by-category pivot of source_words so I can use it for billing reconciliation."},{"title":"Translation QA data prep for review","prompt":"I need to clean up and summarise these 60 translation delivery rows before our weekly review — can you normalise the text fields and produce a date-by-category pivot of translated_words grouped by document group?"}],"resultDescription":"Two reports: (1) string-normalised versions of the text fields in the supplied rows, and (2) a date-by-category pivot table aggregating the selected numeric field (translated_words or source_words) by date and document_group, covering up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, document_group, date, translated_words, source_words) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric field values outside allowed range — rejection","Empty rows array — minimum items constraint violation"],"whenToPreferThis":"Choose this endpoint when you have up to 200 translation delivery records and need both string normalisation and a date-by-category pivot of word count data in a single low-cost call. It is ideal for offline/batch analytics on supplied data without needing external lookups or live data connections. Prefer it over general data tools when the specific combination of string normalisation and date pivot for translation delivery metrics is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T18:36:48.535Z","isFirstParty":false,"canonicalSlug":"translation-delivery-analytics-string-normalisation-date-by-category-0ab35c55"}