{"uid":"cap_umx8p-SBEovWEwLP0SuGQ","slug":"font-production-analytics-string-normalisation-date-by-category-pivot-6364ffc1","name":"Font Production Analytics — String Normalisation + Date by Category Pivot","description":"Font production — String normalisation + Date by category pivot: String normalisation + Date by category pivot for supplied font production records (glyph_count, kerning_pairs). 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-creative-18-035?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","glyph_count","kerning_pairs"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"glyph_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"kerning_pairs":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","glyph_count":10,"kerning_pairs":1},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","glyph_count":20,"kerning_pairs":2},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","glyph_count":15,"kerning_pairs":3},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","glyph_count":30,"kerning_pairs":4}],"maxItems":200,"minItems":1},"field":{"enum":["glyph_count","kerning_pairs"],"type":"string","default":"glyph_count"}}},"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_JaCHkVbtK9uwnlMcnqjNI","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 font production data: string normalisation of asset group labels and a date-by-category pivot on glyph_count or kerning_pairs, for up to 200 rows.","exampleAgentPrompt":"I have font production records with glyph_count and kerning_pairs for several asset groups across dates in October 2026 — can you normalize the asset group strings and pivot the glyph_count data by date and category? I have 4 rows: row-1 (group-a, 2026-10-01, 10 glyphs, 1 kerning), row-2 (group-b, 2026-10-02, 20 glyphs, 2 kerning), row-3 (group-a, 2026-10-03, 15 glyphs, 3 kerning), row-4 (group-b, 2026-10-04, 30 glyphs, 4 kerning).","exampleUseCases":[{"title":"Font studio monthly glyph summary","prompt":"I've got 50 rows of font production data with glyph_count values across groups like 'Latin-Core', 'Cyrillic-Ext', and 'Symbol-Set' for September 2026 — normalize the group names and pivot the glyph_count by date and category so I can see production trends."},{"title":"Kerning pair output review by typeface group","prompt":"Can you run the date-by-category pivot on kerning_pairs for my font production records? I have about 120 rows covering October and November 2026 across several asset groups and want to see how kerning output varied by group over time."},{"title":"QA audit of font batch asset group labels","prompt":"My font production export has inconsistent asset group labels — some are uppercase, some have extra spaces — across 80 rows with glyph_count data from 2026. Run the string normalisation report and pivot glyph_count by date and category so I can review both cleanly."}],"resultDescription":"Returns two analytical reports: (1) a string normalisation report that standardises asset_group label formats across the submitted rows, and (2) a date-by-category pivot table summarising the selected numeric field (glyph_count or kerning_pairs) broken down by date and asset_group, computed entirely from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request exceeds the maxItems limit","Missing required fields (row_id, asset_group, date, glyph_count, or kerning_pairs) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Invalid field selector (not 'glyph_count' or 'kerning_pairs') causes enum validation failure","Numeric values outside the allowed range cause schema rejection","Empty rows array (minItems: 1 violated) causes request failure","Payment of 0.01 USDC not included or rejected causes 402 response"],"whenToPreferThis":"Choose this endpoint when you have font production records with glyph_count or kerning_pairs metrics and need both string normalisation of asset group labels AND a date-by-category pivot in a single call. It is a good fit for offline batch analytics on up to 200 rows where no live data lookup, prediction, or external enrichment is needed. Prefer sibling endpoints if you need daily sum series, record quality audit, or duplicate key detection instead of a date pivot.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:39:50.495Z","isFirstParty":false,"canonicalSlug":"font-production-analytics-string-normalisation-date-by-category-pivot-6364ffc1"}