{"uid":"cap_ctyU2PvpRpzWc8CLg6vBD","slug":"subscription-activity-string-normalisation-1a5754bf","name":"Subscription Activity String Normalisation","description":"Subscription activity - String normalisation: String normalisation for Subscription activity. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded string normalisation deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-subscription-activity-normalise?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","plan","date","active_accounts","cancellations"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"plan":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"cancellations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"active_accounts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","plan":"group-a","row_id":"row-1","cancellations":1,"active_accounts":10},{"date":"2026-10-02","plan":"group-b","row_id":"row-2","cancellations":2,"active_accounts":20},{"date":"2026-10-03","plan":"group-a","row_id":"row-3","cancellations":3,"active_accounts":15},{"date":"2026-10-04","plan":"group-b","row_id":"row-4","cancellations":4,"active_accounts":30}],"maxItems":200,"minItems":1}}},"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__BiF4oGdAnqAPKOGQClwd","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":"Normalises string fields in subscription activity records (plan names, dates) across up to 200 typed rows for local data-quality processing.","exampleAgentPrompt":"Can you normalise the string fields in my subscription activity data? I have 4 rows with plan names like 'group-a' and 'group-b', dates like '2026-10-01', active account counts, and cancellation counts — just clean up the strings for me.","exampleUseCases":[{"title":"Cleaning messy SaaS plan name strings","prompt":"I've got 50 rows of subscription activity where plan names are inconsistently capitalised and formatted — things like 'Group A', 'group-a', 'GROUP_A' — can you normalise all those strings so they're consistent before I run my churn report?"},{"title":"Standardising date strings before pipeline ingestion","prompt":"Before I load my subscription activity data into our data warehouse, I need to make sure all the date and plan fields are properly normalised — I have about 120 rows with row IDs, plan names, active account numbers, and cancellation figures. Can you run string normalisation on them?"},{"title":"Data quality pass on exported subscription records","prompt":"I exported subscription activity records from our billing system and the string fields are all over the place. Can you do a data quality normalisation pass on these 30 rows? Each one has a row ID, plan name, a date, active accounts, and cancellations."}],"resultDescription":"A bounded, normalised set of subscription activity records with cleaned and standardised string fields (plan names, dates). Returns up to 200 processed rows with data-quality corrections applied locally — no external enrichment or forecasting is included.","failureModes":["Missing required fields (row_id, plan, date, active_accounts, cancellations) cause validation errors","Submitting more than 200 rows exceeds the maxItems limit and is rejected","Invalid date format (not matching YYYY-MM-DD pattern) causes schema validation failure","Empty row_id (minLength:1 violated) causes rejection","Numeric fields outside ±1,000,000,000,000 bounds are rejected","Payment failure or insufficient USDC balance prevents processing"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local string normalisation specifically for subscription activity data (plan names, dates, account counts, cancellations) and do not need external enrichment or forecasting. Ideal for data pipeline pre-processing steps with batches of up to 200 rows at very low cost ($0.01 per call). Not suitable if you need ML-based enrichment, forecasting, or data outside the subscription activity domain.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:55:51.263Z","isFirstParty":false,"canonicalSlug":"subscription-activity-string-normalisation-1a5754bf"}