{"uid":"cap_2g2vj0g5CxB3X4-r--Bkb","slug":"social-post-observations-string-normalisation-secondary-measure-dc4a4cdd","name":"Social Post Observations — String Normalisation + Secondary-Measure Weighted Mean","description":"Social post observations — String normalisation + Secondary-measure weighted mean: String normalisation + Secondary-measure weighted mean 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-034?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_sUDvdgO015eS0TtWSdGnh","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":"Performs string normalisation and secondary-measure weighted mean calculations on up to 200 social post observation records containing impressions and engagement counts.","exampleAgentPrompt":"I have a batch of social post records with impressions and engagement counts across different channel groups — can you run string normalisation on the channel_group field and compute a secondary-measure weighted mean for impressions across up to 200 rows, and give me two reports?","exampleUseCases":[{"title":"Normalise messy channel group labels","prompt":"I've got 150 rows of social post data where the channel_group names are inconsistently formatted — things like 'Group-A', 'group_a', 'GROUP A'. Can you run string normalisation on that field and also compute the weighted mean of impressions weighted by engagement_count?"},{"title":"Weighted mean engagement analysis","prompt":"I have 80 social post observations with impressions and engagement_count columns across dates in October. Can you compute the secondary-measure weighted mean for the engagement_count field and also normalise the channel group strings, giving me two separate reports?"},{"title":"Multi-channel social performance summary","prompt":"Here are 200 rows of social post data broken out by channel group and date — please normalise the channel_group strings and calculate a weighted mean of impressions, using engagement_count as the secondary measure, and return both analytical reports."}],"resultDescription":"Two analytical reports: one covering string normalisation results for channel group labels, and one covering a secondary-measure weighted mean calculation for the selected field (impressions or engagement_count), computed locally on the supplied data without any external lookups.","failureModes":["Exceeding 200 rows results in rejection","Missing required fields (row_id, channel_group, date, impressions, engagement_count) cause validation errors","Invalid date format (non YYYY-MM-DD) triggers a pattern mismatch error","Null values for both impressions and engagement_count may affect weighted mean computation","Selecting an invalid field enum value returns a schema validation error"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation of categorical labels and a weighted mean computation on social post metrics (impressions or engagement_count) in a single call, delivered as two reports, without requiring live data lookups or external integrations. Ideal for batch offline analytics on up to 200 rows of owned social data at very low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:47.834Z","isFirstParty":false,"canonicalSlug":"social-post-observations-string-normalisation-secondary-measure-dc4a4cdd"}