僅在使用時載入搜尋。在下方瀏覽所有類別。

MCP 工具

預覽自訂指標

sosoapi_preview_custom_metric

預覽自訂指標。使用明確指定且已審閱的資料集與版本;不會自動更新資料來源。 可透過管線將渲染輸入傳給 sosoapi report render --output FILE。

閱讀 Markdown

設定與傳輸方式

設定: full · 傳輸方式: stdio、http

選擇 core 或 full 以控制用戶端顯示的工具;這不會變更權限。本機檔案上傳需要 stdio,無法透過 HTTP 使用。設定 SOSOAPI_OUTPUT_SCHEMAS=1 可在探索結果加入輸出結構描述。無論是否啟用此設定,工具皆會回傳結構化結果。

權限與副作用

註解幫助用戶端描述工具。每次呼叫仍會檢查使用者身分驗證、角色、資源存取和能力授權。

{
  "readOnlyHint": true,
  "destructiveHint": false,
  "idempotentHint": true,
  "openWorldHint": false
}

輸入欄位

「必填」是指在其父物件及所選分支內必填。必填子欄位不會使選填父物件變成必填。下列規則與欄位名稱均複製自契約。

輸入欄位
欄位 / 分支類型 / 必填約束
$object在父物件中必填
  • additionalProperties: false
workspace_idstring在父物件中必填
  • format: "uuid"
formulaobject在父物件中必填
  • additionalProperties: false
formula.contractVersionstring在父物件中必填
  • enum: ["analytics-metric/v1"]
formula.idstring在父物件中必填
  • format: "uuid"
formula.workspaceIdstring在父物件中必填
  • format: "uuid"
formula.namestring在父物件中必填
  • minLength: 1
  • maxLength: 100
formula.versioninteger在父物件中必填
  • minimum: 1
  • maximum: 1000000
formula.expressionstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
formula.fieldsarray在父物件中必填
  • maxItems: 32
formula.fields[]object選填/項目
  • additionalProperties: false
formula.fields[].identifierstring在父物件中必填
  • pattern: "^[a-z][a-z0-9_]{0,63}$"
formula.fields[].selectorobject在父物件中必填
  • additionalProperties: false
formula.fields[].selector.platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
formula.fields[].selector.keystring在父物件中必填
  • pattern: "^[A-Za-z][A-Za-z0-9_]{0,100}$"
formula.fields[].selector.definitionstring在父物件中必填
  • minLength: 1
  • maxLength: 500
formula.fields[].selector.unitstring在父物件中必填
  • enum: ["count","seconds","minutes","percent","ratio"]
formula.fields[].selector.grainstring在父物件中必填
  • enum: ["post","account"]
formula.fields[].selector.measurementKindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
formula.fields[].selector.nativePeriodstring | null在父物件中必填—
formula.fields[].selector.nativePeriodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
formula.fields[].selector.nativePeriodanyOf 2null在父物件中必填—
formula.fields[].selector.timezonestring | null在父物件中必填—
formula.fields[].selector.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
formula.fields[].selector.timezoneanyOf 2null在父物件中必填—
formula.fields[].aggregationstring在父物件中必填
  • enum: ["single","sum"]
formula.roundingobject在父物件中必填
  • additionalProperties: false
formula.rounding.decimalPlacesinteger在父物件中必填
  • minimum: 0
  • maximum: 8
formula.rounding.modestring在父物件中必填
  • enum: ["half_away_from_zero"]
datasetobject在父物件中必填
  • additionalProperties: false
dataset.contractVersionstring在父物件中必填
  • enum: ["analytics-report/v1"]
dataset.idstring在父物件中必填
  • format: "uuid"
dataset.reviewedAtstring在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.selectionobject在父物件中必填
  • additionalProperties: false
dataset.selection.workspaceIdstring在父物件中必填
  • format: "uuid"
dataset.selection.accountIdsarray在父物件中必填
  • minItems: 1
  • maxItems: 50
dataset.selection.accountIds[]string選填/項目
  • format: "uuid"
dataset.selection.platformsarray在父物件中必填
  • minItems: 1
  • maxItems: 4
dataset.selection.platforms[]string選填/項目
  • enum: ["facebook","instagram","threads","youtube"]
dataset.selection.startDatestring在父物件中必填
  • pattern: "^\\d{4}-\\d{2}-\\d{2}$"
dataset.selection.endDatestring在父物件中必填
  • pattern: "^\\d{4}-\\d{2}-\\d{2}$"
dataset.selection.timezonestring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.accountsarray在父物件中必填
  • maxItems: 50
dataset.accounts[]object選填/項目
  • additionalProperties: false
dataset.accounts[].idstring在父物件中必填
  • format: "uuid"
dataset.accounts[].workspaceIdstring在父物件中必填
  • format: "uuid"
dataset.accounts[].platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
dataset.accounts[].namestring在父物件中必填
  • maxLength: 500
dataset.accounts[].connectionStatusstring選填/項目
  • maxLength: 100
dataset.accounts[].healthMessagestring選填/項目
  • maxLength: 1000
dataset.postsarray在父物件中必填
  • maxItems: 1000
dataset.posts[]object選填/項目
  • additionalProperties: false
dataset.posts[].social_post_idstring在父物件中必填
  • format: "uuid"
dataset.posts[].workspace_idstring在父物件中必填
  • format: "uuid"
dataset.posts[].social_account_idstring在父物件中必填
  • format: "uuid"
dataset.posts[].platformstring在父物件中必填
  • enum: ["instagram","facebook","threads","youtube"]
dataset.posts[].provider_post_idstring在父物件中必填
  • minLength: 1
  • maxLength: 512
dataset.posts[].provider_published_atstring | null在父物件中必填—
dataset.posts[].provider_published_atanyOf 1string在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.posts[].provider_published_atanyOf 2null在父物件中必填—
dataset.posts[].content_formatstring | null在父物件中必填—
dataset.posts[].content_formatanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.posts[].content_formatanyOf 2null在父物件中必填—
dataset.posts[].permalinkstring | null在父物件中必填—
dataset.posts[].permalinkanyOf 1string在父物件中必填
  • format: "uri"
  • maxLength: 2048
dataset.posts[].permalinkanyOf 2null在父物件中必填—
dataset.posts[].provider_statestring在父物件中必填
  • enum: ["available","deleted","unavailable","unknown"]
dataset.posts[].first_seen_atstring在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.posts[].last_seen_atstring在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.posts[].scheduled_post_idstring | null在父物件中必填—
dataset.posts[].scheduled_post_idanyOf 1string在父物件中必填
  • format: "uuid"
dataset.posts[].scheduled_post_idanyOf 2null在父物件中必填—
dataset.posts[].provenanceobject在父物件中必填
  • additionalProperties: false
dataset.posts[].provenance.providerstring在父物件中必填
  • enum: ["instagram","facebook","threads","youtube"]
dataset.posts[].provenance.sourcestring在父物件中必填
  • enum: ["provider_api","provider_webhook","publication_outcome","backfill"]
dataset.posts[].provenance.source_job_idstring | null在父物件中必填—
dataset.posts[].provenance.source_job_idanyOf 1string在父物件中必填
  • format: "uuid"
dataset.posts[].provenance.source_job_idanyOf 2null在父物件中必填—
dataset.posts[].provenance.provider_api_versionstring | null在父物件中必填—
dataset.posts[].provenance.provider_api_versionanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 200
dataset.posts[].provenance.provider_api_versionanyOf 2null在父物件中必填—
dataset.posts[].provenance.schema_versionstring | null在父物件中必填—
dataset.posts[].provenance.schema_versionanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 200
dataset.posts[].provenance.schema_versionanyOf 2null在父物件中必填—
dataset.sourcesarray在父物件中必填
  • maxItems: 30
dataset.sources[]object選填/項目
  • additionalProperties: false
dataset.sources[].accountIdstring在父物件中必填
  • format: "uuid"
dataset.sources[].platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
dataset.sources[].resourceKindstring在父物件中必填
  • enum: ["account","post"]
dataset.sources[].providerResourceIdstring | null在父物件中必填—
dataset.sources[].providerResourceIdanyOf 1string在父物件中必填
  • maxLength: 512
dataset.sources[].providerResourceIdanyOf 2null在父物件中必填—
dataset.sources[].requestIdstring | null在父物件中必填—
dataset.sources[].requestIdanyOf 1string在父物件中必填
  • format: "uuid"
dataset.sources[].requestIdanyOf 2null在父物件中必填—
dataset.sources[].statusstring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
dataset.sources[].reasonstring | null在父物件中必填—
dataset.sources[].reasonanyOf 1string在父物件中必填
  • maxLength: 8000
dataset.sources[].reasonanyOf 2null在父物件中必填—
dataset.sources[].envelopeobject | null在父物件中必填—
dataset.sources[].envelopeanyOf 1object在父物件中必填
  • additionalProperties: false
dataset.sources[].envelope.contract_versionanyOf 1string在父物件中必填
  • enum: ["provider-insights/v1"]
dataset.sources[].envelope.request_idanyOf 1string在父物件中必填
  • format: "uuid"
dataset.sources[].envelope.platformanyOf 1string在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
dataset.sources[].envelope.resourceanyOf 1object在父物件中必填
  • additionalProperties: false
dataset.sources[].envelope.resource.kindanyOf 1string在父物件中必填
  • enum: ["account","post"]
dataset.sources[].envelope.resource.social_account_idanyOf 1string在父物件中必填
  • format: "uuid"
dataset.sources[].envelope.resource.provider_resource_idanyOf 1string | null在父物件中必填—
dataset.sources[].envelope.provider_api_versionanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.sources[].envelope.fetched_atanyOf 1string在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.sources[].envelope.statusanyOf 1string在父物件中必填
  • enum: ["available","partial","unavailable"]
dataset.sources[].envelope.availabilityanyOf 1array在父物件中必填
  • minItems: 1
  • maxItems: 64
dataset.sources[].envelope.availability[]anyOf 1object選填/項目
  • additionalProperties: false
dataset.sources[].envelope.availability[].scopeanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 200
dataset.sources[].envelope.availability[].statusanyOf 1string在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed"]
dataset.sources[].envelope.availability[].reasonanyOf 1string選填/項目
  • minLength: 1
  • maxLength: 2000
dataset.sources[].envelope.availability[].diagnosticsanyOf 1object選填/項目
  • additionalProperties: false
dataset.sources[].envelope.availability[].diagnostics.http_statusanyOf 1integer在父物件中必填
  • minimum: 0
  • maximum: 599
dataset.sources[].envelope.availability[].diagnostics.failed_stepanyOf 1string選填/項目
  • minLength: 1
  • maxLength: 200
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1number | string選填/項目—
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1 / anyOf 1number選填/項目—
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1 / anyOf 2string選填/項目
  • maxLength: 100
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1number | string選填/項目—
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1 / anyOf 1number選填/項目—
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1 / anyOf 2string選填/項目
  • maxLength: 100
dataset.sources[].envelope.availability[].diagnostics.provider_typeanyOf 1string選填/項目
  • maxLength: 200
dataset.sources[].envelope.availability[].diagnostics.is_transientanyOf 1boolean選填/項目—
dataset.sources[].envelope.availability[].diagnostics.provider_request_idanyOf 1string選填/項目
  • maxLength: 200
dataset.sources[].envelope.availability[].diagnostics.accessanyOf 1object選填/項目
  • additionalProperties: false
dataset.sources[].envelope.availability[].diagnostics.access.login_modeanyOf 1string在父物件中必填
  • enum: ["instagram_login","facebook_login","threads_user"]
dataset.sources[].envelope.availability[].diagnostics.access.provider_hostanyOf 1string在父物件中必填
  • maxLength: 200
dataset.sources[].envelope.availability[].diagnostics.access.required_permissionsanyOf 1array在父物件中必填
  • maxItems: 16
dataset.sources[].envelope.availability[].diagnostics.access.required_permissions[]anyOf 1string選填/項目
  • maxLength: 100
dataset.sources[].envelope.availability[].diagnostics.access.current_connection_policy_permissionsanyOf 1array在父物件中必填
  • maxItems: 16
dataset.sources[].envelope.availability[].diagnostics.access.current_connection_policy_permissions[]anyOf 1string選填/項目
  • maxLength: 100
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1array | null在父物件中必填—
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1 / anyOf 1array在父物件中必填
  • maxItems: 128
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissions[]anyOf 1 / anyOf 1string選填/項目
  • maxLength: 100
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1 / anyOf 2null在父物件中必填—
dataset.sources[].envelope.availability[].diagnostics.access.grant_evidenceanyOf 1string在父物件中必填
  • enum: ["exact","unknown"]
dataset.sources[].envelope.availability[].diagnostics.access.permission_stateanyOf 1string在父物件中必填
  • enum: ["granted","missing","unknown"]
dataset.sources[].envelope.availability[].diagnostics.access.grant_observed_atanyOf 1string選填/項目
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.sources[].envelope.availability[].diagnostics.access.app_accessanyOf 1string在父物件中必填
  • enum: ["unverified"]
dataset.sources[].envelope.availability[].diagnostics.access.next_stepanyOf 1string在父物件中必填
  • maxLength: 1500
dataset.sources[].envelope.provider_dataanyOf 1any JSON value | null在父物件中必填—
dataset.sources[].envelope.provider_dataanyOf 1 / anyOf 1any JSON value在父物件中必填—
dataset.sources[].envelope.provider_dataanyOf 1 / anyOf 2null在父物件中必填—
dataset.sources[].envelope.requested_date_rangeanyOf 1object | null在父物件中必填—
dataset.sources[].envelope.requested_date_rangeanyOf 1 / anyOf 1object在父物件中必填
  • additionalProperties: false
dataset.sources[].envelope.requested_date_range.start_dateanyOf 1 / anyOf 1string在父物件中必填
  • pattern: "^\\d{4}-\\d{2}-\\d{2}$"
dataset.sources[].envelope.requested_date_range.end_dateanyOf 1 / anyOf 1string在父物件中必填
  • pattern: "^\\d{4}-\\d{2}-\\d{2}$"
dataset.sources[].envelope.requested_date_rangeanyOf 1 / anyOf 2null在父物件中必填—
dataset.sources[].envelope.cacheanyOf 1object在父物件中必填
  • additionalProperties: false
dataset.sources[].envelope.cache.authoritativeanyOf 1boolean在父物件中必填
  • enum: [false]
dataset.sources[].envelope.cache.statusanyOf 1string在父物件中必填
  • enum: ["stored","hit","bypassed"]
dataset.sources[].envelope.cache.expires_atanyOf 1string在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.sources[].envelopeanyOf 2null在父物件中必填—
dataset.sources[].metricsarray在父物件中必填
  • maxItems: 5000
dataset.sources[].metrics[]object選填/項目
  • additionalProperties: false
dataset.sources[].metrics[].keystring在父物件中必填
  • minLength: 1
  • maxLength: 150
dataset.sources[].metrics[].definitionstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
dataset.sources[].metrics[].unitstring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.sources[].metrics[].grainstring在父物件中必填
  • enum: ["post","account"]
dataset.sources[].metrics[].valuenumber | null在父物件中必填—
dataset.sources[].metrics[].availabilitystring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
dataset.sources[].metrics[].reasonstring | null在父物件中必填—
dataset.sources[].metrics[].reasonanyOf 1string在父物件中必填
  • maxLength: 4000
dataset.sources[].metrics[].reasonanyOf 2null在父物件中必填—
dataset.sources[].metrics[].measurementobject在父物件中必填
  • additionalProperties: false
dataset.sources[].metrics[].measurement.kindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
dataset.sources[].metrics[].measurement.periodstring | null在父物件中必填—
dataset.sources[].metrics[].measurement.periodanyOf 1string在父物件中必填
  • maxLength: 100
dataset.sources[].metrics[].measurement.periodanyOf 2null在父物件中必填—
dataset.sources[].metrics[].measurement.startstring | null在父物件中必填—
dataset.sources[].metrics[].measurement.startanyOf 1string在父物件中必填
  • maxLength: 100
dataset.sources[].metrics[].measurement.startanyOf 2null在父物件中必填—
dataset.sources[].metrics[].measurement.endstring | null在父物件中必填—
dataset.sources[].metrics[].measurement.endanyOf 1string在父物件中必填
  • maxLength: 100
dataset.sources[].metrics[].measurement.endanyOf 2null在父物件中必填—
dataset.sources[].metrics[].measurement.timezonestring | null在父物件中必填—
dataset.sources[].metrics[].measurement.timezoneanyOf 1string在父物件中必填
  • maxLength: 100
dataset.sources[].metrics[].measurement.timezoneanyOf 2null在父物件中必填—
dataset.sources[].metrics[].sourcePathstring在父物件中必填
  • minLength: 1
  • maxLength: 2000
dataset.coverageobject在父物件中必填
  • additionalProperties: false
dataset.coverage.populationstring在父物件中必填
  • enum: ["discovered_posts"]
dataset.coverage.postsCompleteboolean在父物件中必填—
dataset.coverage.nextCursorstring | null在父物件中必填—
dataset.coverage.nextCursoranyOf 1string在父物件中必填
  • maxLength: 16384
dataset.coverage.nextCursoranyOf 2null在父物件中必填—
dataset.coverage.postLimitinteger在父物件中必填
  • minimum: 0
  • maximum: 1000
dataset.coverage.postInsightsLimitinteger在父物件中必填
  • minimum: 0
  • maximum: 20
dataset.coverage.omittedPostInsightsinteger在父物件中必填
  • minimum: 0
  • maximum: 9007199254740991
dataset.coverage.notesarray在父物件中必填
  • maxItems: 50
dataset.coverage.notes[]string選填/項目
  • maxLength: 2000
dataset.customMetricsarray在父物件中必填
  • maxItems: 50
dataset.customMetrics[]object選填/項目
  • additionalProperties: false
dataset.customMetrics[].idstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].namestring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].versioninteger在父物件中必填
  • maximum: 9007199254740991
  • exclusiveMinimum: 0
dataset.customMetrics[].expressionstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
dataset.customMetrics[].definitionstring在父物件中必填
  • maxLength: 1000
dataset.customMetrics[].unitstring在父物件中必填
  • maxLength: 100
dataset.customMetrics[].grainstring在父物件中必填
  • enum: ["post","account","compatible_sum"]
dataset.customMetrics[].roundingobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].rounding.decimalPlacesinteger在父物件中必填
  • minimum: 0
  • maximum: 8
dataset.customMetrics[].rounding.modestring在父物件中必填
  • enum: ["half_away_from_zero"]
dataset.customMetrics[].inputsarray在父物件中必填
  • maxItems: 5000
dataset.customMetrics[].inputs[]object選填/項目
  • additionalProperties: false
dataset.customMetrics[].inputs[].requestIdstring | null在父物件中必填—
dataset.customMetrics[].inputs[].requestIdanyOf 1string在父物件中必填
  • format: "uuid"
dataset.customMetrics[].inputs[].requestIdanyOf 2null在父物件中必填—
dataset.customMetrics[].inputs[].sourcePathstring在父物件中必填
  • maxLength: 2000
dataset.customMetrics[].inputs[].valuenumber | null在父物件中必填—
dataset.customMetrics[].inputs[].availabilitystring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
dataset.customMetrics[].valuenumber | null在父物件中必填—
dataset.customMetrics[].availabilitystring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
dataset.customMetrics[].reasonstring | null在父物件中必填—
dataset.customMetrics[].reasonanyOf 1string在父物件中必填
  • maxLength: 4000
dataset.customMetrics[].reasonanyOf 2null在父物件中必填—
dataset.customMetrics[].formulaobject選填/項目
  • additionalProperties: false
dataset.customMetrics[].formula.contractVersionstring在父物件中必填
  • enum: ["analytics-metric/v1"]
dataset.customMetrics[].formula.idstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].formula.workspaceIdstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].formula.namestring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].formula.versioninteger在父物件中必填
  • minimum: 1
  • maximum: 1000000
dataset.customMetrics[].formula.expressionstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
dataset.customMetrics[].formula.fieldsarray在父物件中必填
  • maxItems: 32
dataset.customMetrics[].formula.fields[]object選填/項目
  • additionalProperties: false
dataset.customMetrics[].formula.fields[].identifierstring在父物件中必填
  • pattern: "^[a-z][a-z0-9_]{0,63}$"
dataset.customMetrics[].formula.fields[].selectorobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].formula.fields[].selector.platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
dataset.customMetrics[].formula.fields[].selector.keystring在父物件中必填
  • pattern: "^[A-Za-z][A-Za-z0-9_]{0,100}$"
dataset.customMetrics[].formula.fields[].selector.definitionstring在父物件中必填
  • minLength: 1
  • maxLength: 500
dataset.customMetrics[].formula.fields[].selector.unitstring在父物件中必填
  • enum: ["count","seconds","minutes","percent","ratio"]
dataset.customMetrics[].formula.fields[].selector.grainstring在父物件中必填
  • enum: ["post","account"]
dataset.customMetrics[].formula.fields[].selector.measurementKindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
dataset.customMetrics[].formula.fields[].selector.nativePeriodstring | null在父物件中必填—
dataset.customMetrics[].formula.fields[].selector.nativePeriodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
dataset.customMetrics[].formula.fields[].selector.nativePeriodanyOf 2null在父物件中必填—
dataset.customMetrics[].formula.fields[].selector.timezonestring | null在父物件中必填—
dataset.customMetrics[].formula.fields[].selector.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].formula.fields[].selector.timezoneanyOf 2null在父物件中必填—
dataset.customMetrics[].formula.fields[].aggregationstring在父物件中必填
  • enum: ["single","sum"]
dataset.customMetrics[].formula.roundingobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].formula.rounding.decimalPlacesinteger在父物件中必填
  • minimum: 0
  • maximum: 8
dataset.customMetrics[].formula.rounding.modestring在父物件中必填
  • enum: ["half_away_from_zero"]
dataset.customMetrics[].calculationobject選填/項目
  • additionalProperties: false
dataset.customMetrics[].calculation.contractVersionstring在父物件中必填
  • enum: ["analytics-metric/v1"]
dataset.customMetrics[].calculation.workspaceIdstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].calculation.datasetIdstring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].calculation.formulaIdstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].calculation.namestring在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].calculation.versioninteger在父物件中必填
  • maximum: 9007199254740991
  • exclusiveMinimum: 0
dataset.customMetrics[].calculation.expressionstring在父物件中必填
  • maxLength: 1000
dataset.customMetrics[].calculation.roundingobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].calculation.rounding.decimalPlacesinteger在父物件中必填
  • minimum: 0
  • maximum: 8
dataset.customMetrics[].calculation.rounding.modestring在父物件中必填
  • enum: ["half_away_from_zero"]
dataset.customMetrics[].calculation.valuenumber | null在父物件中必填—
dataset.customMetrics[].calculation.unitstring在父物件中必填
  • minLength: 1
  • maxLength: 200
dataset.customMetrics[].calculation.statusstring在父物件中必填
  • enum: ["available","not_returned"]
dataset.customMetrics[].calculation.codestring在父物件中必填
  • enum: ["ok","invalid_expression","missing_input","incompatible_input","zero_denominator","numeric_limit","workspace_mismatch","ambiguous_input","unknown_exclusion"]
dataset.customMetrics[].calculation.reasonstring | null在父物件中必填—
dataset.customMetrics[].calculation.reasonanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 500
dataset.customMetrics[].calculation.reasonanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.excludedInputIdsarray在父物件中必填
  • maxItems: 5000
dataset.customMetrics[].calculation.excludedInputIds[]string選填/項目
  • minLength: 1
  • maxLength: 1500
dataset.customMetrics[].calculation.inputsarray在父物件中必填
  • maxItems: 5000
dataset.customMetrics[].calculation.inputs[]object選填/項目
  • additionalProperties: false
dataset.customMetrics[].calculation.inputs[].inputIdstring在父物件中必填
  • minLength: 1
  • maxLength: 1500
dataset.customMetrics[].calculation.inputs[].selectorobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].calculation.inputs[].selector.platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
dataset.customMetrics[].calculation.inputs[].selector.keystring在父物件中必填
  • pattern: "^[A-Za-z][A-Za-z0-9_]{0,100}$"
dataset.customMetrics[].calculation.inputs[].selector.definitionstring在父物件中必填
  • minLength: 1
  • maxLength: 500
dataset.customMetrics[].calculation.inputs[].selector.unitstring在父物件中必填
  • enum: ["count","seconds","minutes","percent","ratio"]
dataset.customMetrics[].calculation.inputs[].selector.grainstring在父物件中必填
  • enum: ["post","account"]
dataset.customMetrics[].calculation.inputs[].selector.measurementKindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
dataset.customMetrics[].calculation.inputs[].selector.nativePeriodstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].selector.nativePeriodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
dataset.customMetrics[].calculation.inputs[].selector.nativePeriodanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].selector.timezonestring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].selector.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].calculation.inputs[].selector.timezoneanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].valuenumber | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].availabilitystring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
dataset.customMetrics[].calculation.inputs[].reasonstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].reasonanyOf 1string在父物件中必填
  • maxLength: 8000
dataset.customMetrics[].calculation.inputs[].reasonanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurementobject在父物件中必填
  • additionalProperties: false
dataset.customMetrics[].calculation.inputs[].measurement.kindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
dataset.customMetrics[].calculation.inputs[].measurement.periodstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.periodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
dataset.customMetrics[].calculation.inputs[].measurement.periodanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.startstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.startanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
dataset.customMetrics[].calculation.inputs[].measurement.startanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.endstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.endanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
dataset.customMetrics[].calculation.inputs[].measurement.endanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.timezonestring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].measurement.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
dataset.customMetrics[].calculation.inputs[].measurement.timezoneanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].requestIdstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].requestIdanyOf 1string在父物件中必填
  • format: "uuid"
dataset.customMetrics[].calculation.inputs[].requestIdanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].sourcePathstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
dataset.customMetrics[].calculation.inputs[].accountIdstring在父物件中必填
  • format: "uuid"
dataset.customMetrics[].calculation.inputs[].providerResourceIdstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].providerResourceIdanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 512
dataset.customMetrics[].calculation.inputs[].providerResourceIdanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].fetchedAtstring | null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].fetchedAtanyOf 1string在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
dataset.customMetrics[].calculation.inputs[].fetchedAtanyOf 2null在父物件中必填—
dataset.customMetrics[].calculation.inputs[].identifierstring在父物件中必填
  • pattern: "^[a-z][a-z0-9_]{0,63}$"
dataset.customMetrics[].calculation.inputs[].includedboolean在父物件中必填—
excluded_input_idsarray選填/項目
  • maxItems: 5000
excluded_input_ids[]string選填/項目
  • maxLength: 4000
完整 JSON Schema
{
  "type": "object",
  "properties": {
    "workspace_id": {
      "type": "string",
      "format": "uuid"
    },
    "formula": {
      "type": "object",
      "properties": {
        "contractVersion": {
          "type": "string",
          "enum": [
            "analytics-metric/v1"
          ]
        },
        "id": {
          "type": "string",
          "format": "uuid"
        },
        "workspaceId": {
          "type": "string",
          "format": "uuid"
        },
        "name": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "version": {
          "type": "integer",
          "minimum": 1,
          "maximum": 1000000
        },
        "expression": {
          "type": "string",
          "minLength": 1,
          "maxLength": 1000
        },
        "fields": {
          "maxItems": 32,
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "identifier": {
                "type": "string",
                "pattern": "^[a-z][a-z0-9_]{0,63}$"
              },
              "selector": {
                "type": "object",
                "properties": {
                  "platform": {
                    "type": "string",
                    "enum": [
                      "facebook",
                      "instagram",
                      "threads",
                      "youtube"
                    ]
                  },
                  "key": {
                    "type": "string",
                    "pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
                  },
                  "definition": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 500
                  },
                  "unit": {
                    "type": "string",
                    "enum": [
                      "count",
                      "seconds",
                      "minutes",
                      "percent",
                      "ratio"
                    ]
                  },
                  "grain": {
                    "type": "string",
                    "enum": [
                      "post",
                      "account"
                    ]
                  },
                  "measurementKind": {
                    "type": "string",
                    "enum": [
                      "lifetime",
                      "snapshot",
                      "period",
                      "unknown"
                    ]
                  },
                  "nativePeriod": {
                    "anyOf": [
                      {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 64
                      },
                      {
                        "type": "null"
                      }
                    ]
                  },
                  "timezone": {
                    "anyOf": [
                      {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 100
                      },
                      {
                        "type": "null"
                      }
                    ]
                  }
                },
                "required": [
                  "platform",
                  "key",
                  "definition",
                  "unit",
                  "grain",
                  "measurementKind",
                  "nativePeriod",
                  "timezone"
                ],
                "additionalProperties": false
              },
              "aggregation": {
                "type": "string",
                "enum": [
                  "single",
                  "sum"
                ]
              }
            },
            "required": [
              "identifier",
              "selector",
              "aggregation"
            ],
            "additionalProperties": false
          }
        },
        "rounding": {
          "type": "object",
          "properties": {
            "decimalPlaces": {
              "type": "integer",
              "minimum": 0,
              "maximum": 8
            },
            "mode": {
              "type": "string",
              "enum": [
                "half_away_from_zero"
              ]
            }
          },
          "required": [
            "decimalPlaces",
            "mode"
          ],
          "additionalProperties": false
        }
      },
      "required": [
        "contractVersion",
        "id",
        "workspaceId",
        "name",
        "version",
        "expression",
        "fields",
        "rounding"
      ],
      "additionalProperties": false
    },
    "dataset": {
      "type": "object",
      "properties": {
        "contractVersion": {
          "type": "string",
          "enum": [
            "analytics-report/v1"
          ]
        },
        "id": {
          "type": "string",
          "format": "uuid"
        },
        "reviewedAt": {
          "type": "string",
          "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
          "format": "date-time"
        },
        "selection": {
          "type": "object",
          "properties": {
            "workspaceId": {
              "type": "string",
              "format": "uuid"
            },
            "accountIds": {
              "minItems": 1,
              "maxItems": 50,
              "type": "array",
              "items": {
                "type": "string",
                "format": "uuid"
              }
            },
            "platforms": {
              "minItems": 1,
              "maxItems": 4,
              "type": "array",
              "items": {
                "type": "string",
                "enum": [
                  "facebook",
                  "instagram",
                  "threads",
                  "youtube"
                ]
              }
            },
            "startDate": {
              "type": "string",
              "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
            },
            "endDate": {
              "type": "string",
              "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
            },
            "timezone": {
              "type": "string",
              "minLength": 1,
              "maxLength": 100
            }
          },
          "required": [
            "workspaceId",
            "accountIds",
            "platforms",
            "startDate",
            "endDate",
            "timezone"
          ],
          "additionalProperties": false
        },
        "accounts": {
          "maxItems": 50,
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "id": {
                "type": "string",
                "format": "uuid"
              },
              "workspaceId": {
                "type": "string",
                "format": "uuid"
              },
              "platform": {
                "type": "string",
                "enum": [
                  "facebook",
                  "instagram",
                  "threads",
                  "youtube"
                ]
              },
              "name": {
                "type": "string",
                "maxLength": 500
              },
              "connectionStatus": {
                "type": "string",
                "maxLength": 100
              },
              "healthMessage": {
                "type": "string",
                "maxLength": 1000
              }
            },
            "required": [
              "id",
              "workspaceId",
              "platform",
              "name"
            ],
            "additionalProperties": false
          }
        },
        "posts": {
          "maxItems": 1000,
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "social_post_id": {
                "type": "string",
                "format": "uuid"
              },
              "workspace_id": {
                "type": "string",
                "format": "uuid"
              },
              "social_account_id": {
                "type": "string",
                "format": "uuid"
              },
              "platform": {
                "type": "string",
                "enum": [
                  "instagram",
                  "facebook",
                  "threads",
                  "youtube"
                ]
              },
              "provider_post_id": {
                "type": "string",
                "minLength": 1,
                "maxLength": 512
              },
              "provider_published_at": {
                "anyOf": [
                  {
                    "type": "string",
                    "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                    "format": "date-time"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "content_format": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "permalink": {
                "anyOf": [
                  {
                    "type": "string",
                    "maxLength": 2048,
                    "format": "uri"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "provider_state": {
                "type": "string",
                "enum": [
                  "available",
                  "deleted",
                  "unavailable",
                  "unknown"
                ]
              },
              "first_seen_at": {
                "type": "string",
                "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                "format": "date-time"
              },
              "last_seen_at": {
                "type": "string",
                "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                "format": "date-time"
              },
              "scheduled_post_id": {
                "anyOf": [
                  {
                    "type": "string",
                    "format": "uuid"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "provenance": {
                "type": "object",
                "properties": {
                  "provider": {
                    "type": "string",
                    "enum": [
                      "instagram",
                      "facebook",
                      "threads",
                      "youtube"
                    ]
                  },
                  "source": {
                    "type": "string",
                    "enum": [
                      "provider_api",
                      "provider_webhook",
                      "publication_outcome",
                      "backfill"
                    ]
                  },
                  "source_job_id": {
                    "anyOf": [
                      {
                        "type": "string",
                        "format": "uuid"
                      },
                      {
                        "type": "null"
                      }
                    ]
                  },
                  "provider_api_version": {
                    "anyOf": [
                      {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 200
                      },
                      {
                        "type": "null"
                      }
                    ]
                  },
                  "schema_version": {
                    "anyOf": [
                      {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 200
                      },
                      {
                        "type": "null"
                      }
                    ]
                  }
                },
                "required": [
                  "provider",
                  "source",
                  "source_job_id",
                  "provider_api_version",
                  "schema_version"
                ],
                "additionalProperties": false
              }
            },
            "required": [
              "social_post_id",
              "workspace_id",
              "social_account_id",
              "platform",
              "provider_post_id",
              "provider_published_at",
              "content_format",
              "permalink",
              "provider_state",
              "first_seen_at",
              "last_seen_at",
              "scheduled_post_id",
              "provenance"
            ],
            "additionalProperties": false
          }
        },
        "sources": {
          "maxItems": 30,
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "accountId": {
                "type": "string",
                "format": "uuid"
              },
              "platform": {
                "type": "string",
                "enum": [
                  "facebook",
                  "instagram",
                  "threads",
                  "youtube"
                ]
              },
              "resourceKind": {
                "type": "string",
                "enum": [
                  "account",
                  "post"
                ]
              },
              "providerResourceId": {
                "anyOf": [
                  {
                    "type": "string",
                    "maxLength": 512
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "requestId": {
                "anyOf": [
                  {
                    "type": "string",
                    "format": "uuid"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "status": {
                "type": "string",
                "enum": [
                  "available",
                  "partial",
                  "not_returned",
                  "unsupported",
                  "permission_required",
                  "threshold_not_met",
                  "no_data",
                  "failed",
                  "pending",
                  "stale"
                ]
              },
              "reason": {
                "anyOf": [
                  {
                    "type": "string",
                    "maxLength": 8000
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "envelope": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "contract_version": {
                        "type": "string",
                        "enum": [
                          "provider-insights/v1"
                        ]
                      },
                      "request_id": {
                        "type": "string",
                        "format": "uuid"
                      },
                      "platform": {
                        "type": "string",
                        "enum": [
                          "facebook",
                          "instagram",
                          "threads",
                          "youtube"
                        ]
                      },
                      "resource": {
                        "type": "object",
                        "properties": {
                          "kind": {
                            "type": "string",
                            "enum": [
                              "account",
                              "post"
                            ]
                          },
                          "social_account_id": {
                            "type": "string",
                            "format": "uuid"
                          },
                          "provider_resource_id": {
                            "type": [
                              "string",
                              "null"
                            ]
                          }
                        },
                        "required": [
                          "kind",
                          "social_account_id",
                          "provider_resource_id"
                        ],
                        "additionalProperties": false
                      },
                      "provider_api_version": {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 100
                      },
                      "fetched_at": {
                        "type": "string",
                        "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                        "format": "date-time"
                      },
                      "status": {
                        "type": "string",
                        "enum": [
                          "available",
                          "partial",
                          "unavailable"
                        ]
                      },
                      "availability": {
                        "minItems": 1,
                        "maxItems": 64,
                        "type": "array",
                        "items": {
                          "type": "object",
                          "properties": {
                            "scope": {
                              "type": "string",
                              "minLength": 1,
                              "maxLength": 200
                            },
                            "status": {
                              "type": "string",
                              "enum": [
                                "available",
                                "partial",
                                "not_returned",
                                "unsupported",
                                "permission_required",
                                "threshold_not_met",
                                "no_data",
                                "failed"
                              ]
                            },
                            "reason": {
                              "type": "string",
                              "minLength": 1,
                              "maxLength": 2000
                            },
                            "diagnostics": {
                              "type": "object",
                              "properties": {
                                "http_status": {
                                  "type": "integer",
                                  "minimum": 0,
                                  "maximum": 599
                                },
                                "failed_step": {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 200
                                },
                                "provider_code": {
                                  "anyOf": [
                                    {
                                      "type": "number"
                                    },
                                    {
                                      "type": "string",
                                      "maxLength": 100
                                    }
                                  ]
                                },
                                "provider_subcode": {
                                  "anyOf": [
                                    {
                                      "type": "number"
                                    },
                                    {
                                      "type": "string",
                                      "maxLength": 100
                                    }
                                  ]
                                },
                                "provider_type": {
                                  "type": "string",
                                  "maxLength": 200
                                },
                                "is_transient": {
                                  "type": "boolean"
                                },
                                "provider_request_id": {
                                  "type": "string",
                                  "maxLength": 200
                                },
                                "access": {
                                  "type": "object",
                                  "properties": {
                                    "login_mode": {
                                      "type": "string",
                                      "enum": [
                                        "instagram_login",
                                        "facebook_login",
                                        "threads_user"
                                      ]
                                    },
                                    "provider_host": {
                                      "type": "string",
                                      "maxLength": 200
                                    },
                                    "required_permissions": {
                                      "maxItems": 16,
                                      "type": "array",
                                      "items": {
                                        "type": "string",
                                        "maxLength": 100
                                      }
                                    },
                                    "current_connection_policy_permissions": {
                                      "maxItems": 16,
                                      "type": "array",
                                      "items": {
                                        "type": "string",
                                        "maxLength": 100
                                      }
                                    },
                                    "granted_permissions": {
                                      "anyOf": [
                                        {
                                          "maxItems": 128,
                                          "type": "array",
                                          "items": {
                                            "type": "string",
                                            "maxLength": 100
                                          }
                                        },
                                        {
                                          "type": "null"
                                        }
                                      ]
                                    },
                                    "grant_evidence": {
                                      "type": "string",
                                      "enum": [
                                        "exact",
                                        "unknown"
                                      ]
                                    },
                                    "permission_state": {
                                      "type": "string",
                                      "enum": [
                                        "granted",
                                        "missing",
                                        "unknown"
                                      ]
                                    },
                                    "grant_observed_at": {
                                      "type": "string",
                                      "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                                      "format": "date-time"
                                    },
                                    "app_access": {
                                      "type": "string",
                                      "enum": [
                                        "unverified"
                                      ]
                                    },
                                    "next_step": {
                                      "type": "string",
                                      "maxLength": 1500
                                    }
                                  },
                                  "required": [
                                    "login_mode",
                                    "provider_host",
                                    "required_permissions",
                                    "current_connection_policy_permissions",
                                    "granted_permissions",
                                    "grant_evidence",
                                    "permission_state",
                                    "app_access",
                                    "next_step"
                                  ],
                                  "additionalProperties": false
                                }
                              },
                              "required": [
                                "http_status"
                              ],
                              "additionalProperties": false
                            }
                          },
                          "required": [
                            "scope",
                            "status"
                          ],
                          "additionalProperties": false
                        }
                      },
                      "provider_data": {
                        "anyOf": [
                          {},
                          {
                            "type": "null"
                          }
                        ]
                      },
                      "requested_date_range": {
                        "anyOf": [
                          {
                            "type": "object",
                            "properties": {
                              "start_date": {
                                "type": "string",
                                "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
                              },
                              "end_date": {
                                "type": "string",
                                "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
                              }
                            },
                            "required": [
                              "start_date",
                              "end_date"
                            ],
                            "additionalProperties": false
                          },
                          {
                            "type": "null"
                          }
                        ]
                      },
                      "cache": {
                        "type": "object",
                        "properties": {
                          "authoritative": {
                            "type": "boolean",
                            "enum": [
                              false
                            ]
                          },
                          "status": {
                            "type": "string",
                            "enum": [
                              "stored",
                              "hit",
                              "bypassed"
                            ]
                          },
                          "expires_at": {
                            "type": "string",
                            "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                            "format": "date-time"
                          }
                        },
                        "required": [
                          "authoritative",
                          "status",
                          "expires_at"
                        ],
                        "additionalProperties": false
                      }
                    },
                    "required": [
                      "contract_version",
                      "request_id",
                      "platform",
                      "resource",
                      "provider_api_version",
                      "fetched_at",
                      "status",
                      "availability",
                      "provider_data",
                      "requested_date_range",
                      "cache"
                    ],
                    "additionalProperties": false
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "metrics": {
                "maxItems": 5000,
                "type": "array",
                "items": {
                  "type": "object",
                  "properties": {
                    "key": {
                      "type": "string",
                      "minLength": 1,
                      "maxLength": 150
                    },
                    "definition": {
                      "type": "string",
                      "minLength": 1,
                      "maxLength": 1000
                    },
                    "unit": {
                      "type": "string",
                      "minLength": 1,
                      "maxLength": 100
                    },
                    "grain": {
                      "type": "string",
                      "enum": [
                        "post",
                        "account"
                      ]
                    },
                    "value": {
                      "type": [
                        "number",
                        "null"
                      ]
                    },
                    "availability": {
                      "type": "string",
                      "enum": [
                        "available",
                        "partial",
                        "not_returned",
                        "unsupported",
                        "permission_required",
                        "threshold_not_met",
                        "no_data",
                        "failed",
                        "pending",
                        "stale"
                      ]
                    },
                    "reason": {
                      "anyOf": [
                        {
                          "type": "string",
                          "maxLength": 4000
                        },
                        {
                          "type": "null"
                        }
                      ]
                    },
                    "measurement": {
                      "type": "object",
                      "properties": {
                        "kind": {
                          "type": "string",
                          "enum": [
                            "lifetime",
                            "snapshot",
                            "period",
                            "unknown"
                          ]
                        },
                        "period": {
                          "anyOf": [
                            {
                              "type": "string",
                              "maxLength": 100
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "start": {
                          "anyOf": [
                            {
                              "type": "string",
                              "maxLength": 100
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "end": {
                          "anyOf": [
                            {
                              "type": "string",
                              "maxLength": 100
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "timezone": {
                          "anyOf": [
                            {
                              "type": "string",
                              "maxLength": 100
                            },
                            {
                              "type": "null"
                            }
                          ]
                        }
                      },
                      "required": [
                        "kind",
                        "period",
                        "start",
                        "end",
                        "timezone"
                      ],
                      "additionalProperties": false
                    },
                    "sourcePath": {
                      "type": "string",
                      "minLength": 1,
                      "maxLength": 2000
                    }
                  },
                  "required": [
                    "key",
                    "definition",
                    "unit",
                    "grain",
                    "value",
                    "availability",
                    "reason",
                    "measurement",
                    "sourcePath"
                  ],
                  "additionalProperties": false
                }
              }
            },
            "required": [
              "accountId",
              "platform",
              "resourceKind",
              "providerResourceId",
              "requestId",
              "status",
              "reason",
              "envelope",
              "metrics"
            ],
            "additionalProperties": false
          }
        },
        "coverage": {
          "type": "object",
          "properties": {
            "population": {
              "type": "string",
              "enum": [
                "discovered_posts"
              ]
            },
            "postsComplete": {
              "type": "boolean"
            },
            "nextCursor": {
              "anyOf": [
                {
                  "type": "string",
                  "maxLength": 16384
                },
                {
                  "type": "null"
                }
              ]
            },
            "postLimit": {
              "type": "integer",
              "minimum": 0,
              "maximum": 1000
            },
            "postInsightsLimit": {
              "type": "integer",
              "minimum": 0,
              "maximum": 20
            },
            "omittedPostInsights": {
              "type": "integer",
              "minimum": 0,
              "maximum": 9007199254740991
            },
            "notes": {
              "maxItems": 50,
              "type": "array",
              "items": {
                "type": "string",
                "maxLength": 2000
              }
            }
          },
          "required": [
            "population",
            "postsComplete",
            "nextCursor",
            "postLimit",
            "postInsightsLimit",
            "omittedPostInsights",
            "notes"
          ],
          "additionalProperties": false
        },
        "customMetrics": {
          "maxItems": 50,
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "id": {
                "type": "string",
                "format": "uuid"
              },
              "name": {
                "type": "string",
                "minLength": 1,
                "maxLength": 100
              },
              "version": {
                "type": "integer",
                "exclusiveMinimum": 0,
                "maximum": 9007199254740991
              },
              "expression": {
                "type": "string",
                "minLength": 1,
                "maxLength": 1000
              },
              "definition": {
                "type": "string",
                "maxLength": 1000
              },
              "unit": {
                "type": "string",
                "maxLength": 100
              },
              "grain": {
                "type": "string",
                "enum": [
                  "post",
                  "account",
                  "compatible_sum"
                ]
              },
              "rounding": {
                "type": "object",
                "properties": {
                  "decimalPlaces": {
                    "type": "integer",
                    "minimum": 0,
                    "maximum": 8
                  },
                  "mode": {
                    "type": "string",
                    "enum": [
                      "half_away_from_zero"
                    ]
                  }
                },
                "required": [
                  "decimalPlaces",
                  "mode"
                ],
                "additionalProperties": false
              },
              "inputs": {
                "maxItems": 5000,
                "type": "array",
                "items": {
                  "type": "object",
                  "properties": {
                    "requestId": {
                      "anyOf": [
                        {
                          "type": "string",
                          "format": "uuid"
                        },
                        {
                          "type": "null"
                        }
                      ]
                    },
                    "sourcePath": {
                      "type": "string",
                      "maxLength": 2000
                    },
                    "value": {
                      "type": [
                        "number",
                        "null"
                      ]
                    },
                    "availability": {
                      "type": "string",
                      "enum": [
                        "available",
                        "partial",
                        "not_returned",
                        "unsupported",
                        "permission_required",
                        "threshold_not_met",
                        "no_data",
                        "failed",
                        "pending",
                        "stale"
                      ]
                    }
                  },
                  "required": [
                    "requestId",
                    "sourcePath",
                    "value",
                    "availability"
                  ],
                  "additionalProperties": false
                }
              },
              "value": {
                "type": [
                  "number",
                  "null"
                ]
              },
              "availability": {
                "type": "string",
                "enum": [
                  "available",
                  "partial",
                  "not_returned",
                  "unsupported",
                  "permission_required",
                  "threshold_not_met",
                  "no_data",
                  "failed",
                  "pending",
                  "stale"
                ]
              },
              "reason": {
                "anyOf": [
                  {
                    "type": "string",
                    "maxLength": 4000
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "formula": {
                "type": "object",
                "properties": {
                  "contractVersion": {
                    "type": "string",
                    "enum": [
                      "analytics-metric/v1"
                    ]
                  },
                  "id": {
                    "type": "string",
                    "format": "uuid"
                  },
                  "workspaceId": {
                    "type": "string",
                    "format": "uuid"
                  },
                  "name": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  "version": {
                    "type": "integer",
                    "minimum": 1,
                    "maximum": 1000000
                  },
                  "expression": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 1000
                  },
                  "fields": {
                    "maxItems": 32,
                    "type": "array",
                    "items": {
                      "type": "object",
                      "properties": {
                        "identifier": {
                          "type": "string",
                          "pattern": "^[a-z][a-z0-9_]{0,63}$"
                        },
                        "selector": {
                          "type": "object",
                          "properties": {
                            "platform": {
                              "type": "string",
                              "enum": [
                                "facebook",
                                "instagram",
                                "threads",
                                "youtube"
                              ]
                            },
                            "key": {
                              "type": "string",
                              "pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
                            },
                            "definition": {
                              "type": "string",
                              "minLength": 1,
                              "maxLength": 500
                            },
                            "unit": {
                              "type": "string",
                              "enum": [
                                "count",
                                "seconds",
                                "minutes",
                                "percent",
                                "ratio"
                              ]
                            },
                            "grain": {
                              "type": "string",
                              "enum": [
                                "post",
                                "account"
                              ]
                            },
                            "measurementKind": {
                              "type": "string",
                              "enum": [
                                "lifetime",
                                "snapshot",
                                "period",
                                "unknown"
                              ]
                            },
                            "nativePeriod": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 64
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            },
                            "timezone": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 100
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            }
                          },
                          "required": [
                            "platform",
                            "key",
                            "definition",
                            "unit",
                            "grain",
                            "measurementKind",
                            "nativePeriod",
                            "timezone"
                          ],
                          "additionalProperties": false
                        },
                        "aggregation": {
                          "type": "string",
                          "enum": [
                            "single",
                            "sum"
                          ]
                        }
                      },
                      "required": [
                        "identifier",
                        "selector",
                        "aggregation"
                      ],
                      "additionalProperties": false
                    }
                  },
                  "rounding": {
                    "type": "object",
                    "properties": {
                      "decimalPlaces": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 8
                      },
                      "mode": {
                        "type": "string",
                        "enum": [
                          "half_away_from_zero"
                        ]
                      }
                    },
                    "required": [
                      "decimalPlaces",
                      "mode"
                    ],
                    "additionalProperties": false
                  }
                },
                "required": [
                  "contractVersion",
                  "id",
                  "workspaceId",
                  "name",
                  "version",
                  "expression",
                  "fields",
                  "rounding"
                ],
                "additionalProperties": false
              },
              "calculation": {
                "type": "object",
                "properties": {
                  "contractVersion": {
                    "type": "string",
                    "enum": [
                      "analytics-metric/v1"
                    ]
                  },
                  "workspaceId": {
                    "type": "string",
                    "format": "uuid"
                  },
                  "datasetId": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  "formulaId": {
                    "type": "string",
                    "format": "uuid"
                  },
                  "name": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  "version": {
                    "type": "integer",
                    "exclusiveMinimum": 0,
                    "maximum": 9007199254740991
                  },
                  "expression": {
                    "type": "string",
                    "maxLength": 1000
                  },
                  "rounding": {
                    "type": "object",
                    "properties": {
                      "decimalPlaces": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 8
                      },
                      "mode": {
                        "type": "string",
                        "enum": [
                          "half_away_from_zero"
                        ]
                      }
                    },
                    "required": [
                      "decimalPlaces",
                      "mode"
                    ],
                    "additionalProperties": false
                  },
                  "value": {
                    "type": [
                      "number",
                      "null"
                    ]
                  },
                  "unit": {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 200
                  },
                  "status": {
                    "type": "string",
                    "enum": [
                      "available",
                      "not_returned"
                    ]
                  },
                  "code": {
                    "type": "string",
                    "enum": [
                      "ok",
                      "invalid_expression",
                      "missing_input",
                      "incompatible_input",
                      "zero_denominator",
                      "numeric_limit",
                      "workspace_mismatch",
                      "ambiguous_input",
                      "unknown_exclusion"
                    ]
                  },
                  "reason": {
                    "anyOf": [
                      {
                        "type": "string",
                        "minLength": 1,
                        "maxLength": 500
                      },
                      {
                        "type": "null"
                      }
                    ]
                  },
                  "excludedInputIds": {
                    "maxItems": 5000,
                    "type": "array",
                    "items": {
                      "type": "string",
                      "minLength": 1,
                      "maxLength": 1500
                    }
                  },
                  "inputs": {
                    "maxItems": 5000,
                    "type": "array",
                    "items": {
                      "type": "object",
                      "properties": {
                        "inputId": {
                          "type": "string",
                          "minLength": 1,
                          "maxLength": 1500
                        },
                        "selector": {
                          "type": "object",
                          "properties": {
                            "platform": {
                              "type": "string",
                              "enum": [
                                "facebook",
                                "instagram",
                                "threads",
                                "youtube"
                              ]
                            },
                            "key": {
                              "type": "string",
                              "pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
                            },
                            "definition": {
                              "type": "string",
                              "minLength": 1,
                              "maxLength": 500
                            },
                            "unit": {
                              "type": "string",
                              "enum": [
                                "count",
                                "seconds",
                                "minutes",
                                "percent",
                                "ratio"
                              ]
                            },
                            "grain": {
                              "type": "string",
                              "enum": [
                                "post",
                                "account"
                              ]
                            },
                            "measurementKind": {
                              "type": "string",
                              "enum": [
                                "lifetime",
                                "snapshot",
                                "period",
                                "unknown"
                              ]
                            },
                            "nativePeriod": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 64
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            },
                            "timezone": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 100
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            }
                          },
                          "required": [
                            "platform",
                            "key",
                            "definition",
                            "unit",
                            "grain",
                            "measurementKind",
                            "nativePeriod",
                            "timezone"
                          ],
                          "additionalProperties": false
                        },
                        "value": {
                          "type": [
                            "number",
                            "null"
                          ]
                        },
                        "availability": {
                          "type": "string",
                          "enum": [
                            "available",
                            "partial",
                            "not_returned",
                            "unsupported",
                            "permission_required",
                            "threshold_not_met",
                            "no_data",
                            "failed",
                            "pending",
                            "stale"
                          ]
                        },
                        "reason": {
                          "anyOf": [
                            {
                              "type": "string",
                              "maxLength": 8000
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "measurement": {
                          "type": "object",
                          "properties": {
                            "kind": {
                              "type": "string",
                              "enum": [
                                "lifetime",
                                "snapshot",
                                "period",
                                "unknown"
                              ]
                            },
                            "period": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 64
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            },
                            "start": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 64
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            },
                            "end": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 64
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            },
                            "timezone": {
                              "anyOf": [
                                {
                                  "type": "string",
                                  "minLength": 1,
                                  "maxLength": 100
                                },
                                {
                                  "type": "null"
                                }
                              ]
                            }
                          },
                          "required": [
                            "kind",
                            "period",
                            "start",
                            "end",
                            "timezone"
                          ],
                          "additionalProperties": false
                        },
                        "requestId": {
                          "anyOf": [
                            {
                              "type": "string",
                              "format": "uuid"
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "sourcePath": {
                          "type": "string",
                          "minLength": 1,
                          "maxLength": 1000
                        },
                        "accountId": {
                          "type": "string",
                          "format": "uuid"
                        },
                        "providerResourceId": {
                          "anyOf": [
                            {
                              "type": "string",
                              "minLength": 1,
                              "maxLength": 512
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "fetchedAt": {
                          "anyOf": [
                            {
                              "type": "string",
                              "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                              "format": "date-time"
                            },
                            {
                              "type": "null"
                            }
                          ]
                        },
                        "identifier": {
                          "type": "string",
                          "pattern": "^[a-z][a-z0-9_]{0,63}$"
                        },
                        "included": {
                          "type": "boolean"
                        }
                      },
                      "required": [
                        "inputId",
                        "selector",
                        "value",
                        "availability",
                        "reason",
                        "measurement",
                        "requestId",
                        "sourcePath",
                        "accountId",
                        "providerResourceId",
                        "fetchedAt",
                        "identifier",
                        "included"
                      ],
                      "additionalProperties": false
                    }
                  }
                },
                "required": [
                  "contractVersion",
                  "workspaceId",
                  "datasetId",
                  "formulaId",
                  "name",
                  "version",
                  "expression",
                  "rounding",
                  "value",
                  "unit",
                  "status",
                  "code",
                  "reason",
                  "excludedInputIds",
                  "inputs"
                ],
                "additionalProperties": false
              }
            },
            "required": [
              "id",
              "name",
              "version",
              "expression",
              "definition",
              "unit",
              "grain",
              "rounding",
              "inputs",
              "value",
              "availability",
              "reason"
            ],
            "additionalProperties": false
          }
        }
      },
      "required": [
        "contractVersion",
        "id",
        "reviewedAt",
        "selection",
        "accounts",
        "posts",
        "sources",
        "coverage",
        "customMetrics"
      ],
      "additionalProperties": false
    },
    "excluded_input_ids": {
      "maxItems": 5000,
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 4000
      }
    }
  },
  "required": [
    "workspace_id",
    "formula",
    "dataset"
  ],
  "additionalProperties": false
}

結構化輸出

此 schema 描述成功工具結果中的 structuredContent。MCP 回應也包含 content,並可能在呼叫失敗時設定 isError。對於發布,請讀取貼文的最終結果,不要把已接受的請求或文字回應當作確認。連結的 API 操作說明了權限和重試規則。

「必填」是指在其父物件及所選分支內必填。必填子欄位不會使選填父物件變成必填。下列規則與欄位名稱均複製自契約。

結構化輸出
欄位 / 分支類型 / 必填約束
$object在父物件中必填
  • additionalProperties: false
contractVersionstring在父物件中必填
  • const: "analytics-metric/v1"
workspaceIdstring在父物件中必填
  • format: "uuid"
datasetIdstring在父物件中必填
  • minLength: 1
  • maxLength: 100
formulaIdstring在父物件中必填
  • format: "uuid"
namestring在父物件中必填
  • minLength: 1
  • maxLength: 100
versioninteger在父物件中必填
  • maximum: 9007199254740991
  • exclusiveMinimum: 0
expressionstring在父物件中必填
  • maxLength: 1000
roundingobject在父物件中必填
  • additionalProperties: false
rounding.decimalPlacesinteger在父物件中必填
  • minimum: 0
  • maximum: 8
rounding.modestring在父物件中必填
  • const: "half_away_from_zero"
valuenumber | null在父物件中必填—
unitstring在父物件中必填
  • minLength: 1
  • maxLength: 200
statusstring在父物件中必填
  • enum: ["available","not_returned"]
codestring在父物件中必填
  • enum: ["ok","invalid_expression","missing_input","incompatible_input","zero_denominator","numeric_limit","workspace_mismatch","ambiguous_input","unknown_exclusion"]
reasonstring | null在父物件中必填—
reasonanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 500
reasonanyOf 2null在父物件中必填—
excludedInputIdsarray在父物件中必填
  • maxItems: 5000
excludedInputIds[]string選填/項目
  • minLength: 1
  • maxLength: 1500
inputsarray在父物件中必填
  • maxItems: 5000
inputs[]object選填/項目
  • additionalProperties: false
inputs[].inputIdstring在父物件中必填
  • minLength: 1
  • maxLength: 1500
inputs[].selectorobject在父物件中必填
  • additionalProperties: false
inputs[].selector.platformstring在父物件中必填
  • enum: ["facebook","instagram","threads","youtube"]
inputs[].selector.keystring在父物件中必填
  • pattern: "^[A-Za-z][A-Za-z0-9_]{0,100}$"
inputs[].selector.definitionstring在父物件中必填
  • minLength: 1
  • maxLength: 500
inputs[].selector.unitstring在父物件中必填
  • enum: ["count","seconds","minutes","percent","ratio"]
inputs[].selector.grainstring在父物件中必填
  • enum: ["post","account"]
inputs[].selector.measurementKindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
inputs[].selector.nativePeriodstring | null在父物件中必填—
inputs[].selector.nativePeriodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
inputs[].selector.nativePeriodanyOf 2null在父物件中必填—
inputs[].selector.timezonestring | null在父物件中必填—
inputs[].selector.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
inputs[].selector.timezoneanyOf 2null在父物件中必填—
inputs[].valuenumber | null在父物件中必填—
inputs[].availabilitystring在父物件中必填
  • enum: ["available","partial","not_returned","unsupported","permission_required","threshold_not_met","no_data","failed","pending","stale"]
inputs[].reasonstring | null在父物件中必填—
inputs[].reasonanyOf 1string在父物件中必填
  • maxLength: 8000
inputs[].reasonanyOf 2null在父物件中必填—
inputs[].measurementobject在父物件中必填
  • additionalProperties: false
inputs[].measurement.kindstring在父物件中必填
  • enum: ["lifetime","snapshot","period","unknown"]
inputs[].measurement.periodstring | null在父物件中必填—
inputs[].measurement.periodanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
inputs[].measurement.periodanyOf 2null在父物件中必填—
inputs[].measurement.startstring | null在父物件中必填—
inputs[].measurement.startanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
inputs[].measurement.startanyOf 2null在父物件中必填—
inputs[].measurement.endstring | null在父物件中必填—
inputs[].measurement.endanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 64
inputs[].measurement.endanyOf 2null在父物件中必填—
inputs[].measurement.timezonestring | null在父物件中必填—
inputs[].measurement.timezoneanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 100
inputs[].measurement.timezoneanyOf 2null在父物件中必填—
inputs[].requestIdstring | null在父物件中必填—
inputs[].requestIdanyOf 1string在父物件中必填
  • format: "uuid"
inputs[].requestIdanyOf 2null在父物件中必填—
inputs[].sourcePathstring在父物件中必填
  • minLength: 1
  • maxLength: 1000
inputs[].accountIdstring在父物件中必填
  • format: "uuid"
inputs[].providerResourceIdstring | null在父物件中必填—
inputs[].providerResourceIdanyOf 1string在父物件中必填
  • minLength: 1
  • maxLength: 512
inputs[].providerResourceIdanyOf 2null在父物件中必填—
inputs[].fetchedAtstring | null在父物件中必填—
inputs[].fetchedAtanyOf 1string在父物件中必填
  • format: "date-time"
  • pattern: "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$"
inputs[].fetchedAtanyOf 2null在父物件中必填—
inputs[].identifierstring在父物件中必填
  • pattern: "^[a-z][a-z0-9_]{0,63}$"
inputs[].includedboolean在父物件中必填—
完整 JSON Schema
{
  "type": "object",
  "properties": {
    "contractVersion": {
      "type": "string",
      "const": "analytics-metric/v1"
    },
    "workspaceId": {
      "type": "string",
      "format": "uuid"
    },
    "datasetId": {
      "type": "string",
      "minLength": 1,
      "maxLength": 100
    },
    "formulaId": {
      "type": "string",
      "format": "uuid"
    },
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 100
    },
    "version": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "expression": {
      "type": "string",
      "maxLength": 1000
    },
    "rounding": {
      "type": "object",
      "properties": {
        "decimalPlaces": {
          "type": "integer",
          "minimum": 0,
          "maximum": 8
        },
        "mode": {
          "type": "string",
          "const": "half_away_from_zero"
        }
      },
      "required": [
        "decimalPlaces",
        "mode"
      ],
      "additionalProperties": false
    },
    "value": {
      "type": [
        "number",
        "null"
      ]
    },
    "unit": {
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "status": {
      "type": "string",
      "enum": [
        "available",
        "not_returned"
      ]
    },
    "code": {
      "type": "string",
      "enum": [
        "ok",
        "invalid_expression",
        "missing_input",
        "incompatible_input",
        "zero_denominator",
        "numeric_limit",
        "workspace_mismatch",
        "ambiguous_input",
        "unknown_exclusion"
      ]
    },
    "reason": {
      "anyOf": [
        {
          "type": "string",
          "minLength": 1,
          "maxLength": 500
        },
        {
          "type": "null"
        }
      ]
    },
    "excludedInputIds": {
      "maxItems": 5000,
      "type": "array",
      "items": {
        "type": "string",
        "minLength": 1,
        "maxLength": 1500
      }
    },
    "inputs": {
      "maxItems": 5000,
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "inputId": {
            "type": "string",
            "minLength": 1,
            "maxLength": 1500
          },
          "selector": {
            "type": "object",
            "properties": {
              "platform": {
                "type": "string",
                "enum": [
                  "facebook",
                  "instagram",
                  "threads",
                  "youtube"
                ]
              },
              "key": {
                "type": "string",
                "pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
              },
              "definition": {
                "type": "string",
                "minLength": 1,
                "maxLength": 500
              },
              "unit": {
                "type": "string",
                "enum": [
                  "count",
                  "seconds",
                  "minutes",
                  "percent",
                  "ratio"
                ]
              },
              "grain": {
                "type": "string",
                "enum": [
                  "post",
                  "account"
                ]
              },
              "measurementKind": {
                "type": "string",
                "enum": [
                  "lifetime",
                  "snapshot",
                  "period",
                  "unknown"
                ]
              },
              "nativePeriod": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 64
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "timezone": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  {
                    "type": "null"
                  }
                ]
              }
            },
            "required": [
              "platform",
              "key",
              "definition",
              "unit",
              "grain",
              "measurementKind",
              "nativePeriod",
              "timezone"
            ],
            "additionalProperties": false
          },
          "value": {
            "type": [
              "number",
              "null"
            ]
          },
          "availability": {
            "type": "string",
            "enum": [
              "available",
              "partial",
              "not_returned",
              "unsupported",
              "permission_required",
              "threshold_not_met",
              "no_data",
              "failed",
              "pending",
              "stale"
            ]
          },
          "reason": {
            "anyOf": [
              {
                "type": "string",
                "maxLength": 8000
              },
              {
                "type": "null"
              }
            ]
          },
          "measurement": {
            "type": "object",
            "properties": {
              "kind": {
                "type": "string",
                "enum": [
                  "lifetime",
                  "snapshot",
                  "period",
                  "unknown"
                ]
              },
              "period": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 64
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "start": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 64
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "end": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 64
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "timezone": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 1,
                    "maxLength": 100
                  },
                  {
                    "type": "null"
                  }
                ]
              }
            },
            "required": [
              "kind",
              "period",
              "start",
              "end",
              "timezone"
            ],
            "additionalProperties": false
          },
          "requestId": {
            "anyOf": [
              {
                "type": "string",
                "format": "uuid"
              },
              {
                "type": "null"
              }
            ]
          },
          "sourcePath": {
            "type": "string",
            "minLength": 1,
            "maxLength": 1000
          },
          "accountId": {
            "type": "string",
            "format": "uuid"
          },
          "providerResourceId": {
            "anyOf": [
              {
                "type": "string",
                "minLength": 1,
                "maxLength": 512
              },
              {
                "type": "null"
              }
            ]
          },
          "fetchedAt": {
            "anyOf": [
              {
                "type": "string",
                "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
                "format": "date-time"
              },
              {
                "type": "null"
              }
            ]
          },
          "identifier": {
            "type": "string",
            "pattern": "^[a-z][a-z0-9_]{0,63}$"
          },
          "included": {
            "type": "boolean"
          }
        },
        "required": [
          "inputId",
          "selector",
          "value",
          "availability",
          "reason",
          "measurement",
          "requestId",
          "sourcePath",
          "accountId",
          "providerResourceId",
          "fetchedAt",
          "identifier",
          "included"
        ],
        "additionalProperties": false
      }
    }
  },
  "required": [
    "contractVersion",
    "workspaceId",
    "datasetId",
    "formulaId",
    "name",
    "version",
    "expression",
    "rounding",
    "value",
    "unit",
    "status",
    "code",
    "reason",
    "excludedInputIds",
    "inputs"
  ],
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false
}

工具呼叫範例

這些範例使用已依結構描述檢查的虛構值。請將 ID 替換為您有權使用的 ID、將媒體替換為已就緒素材,並將日期替換為已確認的發布時間。提交寫入前,請檢查帳號資格。本頁不會傳送 API 請求。

{
  "name": "sosoapi_preview_custom_metric",
  "arguments": {
    "workspace_id": "11111111-1111-4111-8111-111111111111",
    "formula": {
      "contractVersion": "analytics-metric/v1",
      "id": "11111111-1111-4111-8111-111111111111",
      "workspaceId": "11111111-1111-4111-8111-111111111111",
      "name": "example",
      "version": 1,
      "expression": "example",
      "fields": [],
      "rounding": {
        "decimalPlaces": 0,
        "mode": "half_away_from_zero"
      }
    },
    "dataset": {
      "contractVersion": "analytics-report/v1",
      "id": "11111111-1111-4111-8111-111111111111",
      "reviewedAt": "2099-01-15T09:00:00Z",
      "selection": {
        "workspaceId": "11111111-1111-4111-8111-111111111111",
        "accountIds": [
          "11111111-1111-4111-8111-111111111111"
        ],
        "platforms": [
          "facebook"
        ],
        "startDate": "2099-01-15",
        "endDate": "2099-01-15",
        "timezone": "UTC"
      },
      "accounts": [
        {
          "id": "11111111-1111-4111-8111-111111111111",
          "workspaceId": "11111111-1111-4111-8111-111111111111",
          "platform": "facebook",
          "name": "Fictional report account"
        }
      ],
      "posts": [],
      "sources": [],
      "coverage": {
        "population": "discovered_posts",
        "postsComplete": false,
        "nextCursor": null,
        "postLimit": 0,
        "postInsightsLimit": 0,
        "omittedPostInsights": 0,
        "notes": []
      },
      "customMetrics": []
    }
  }
}

structuredContent

{
  "contractVersion": "analytics-metric/v1",
  "workspaceId": "11111111-1111-4111-8111-111111111111",
  "datasetId": "example",
  "formulaId": "11111111-1111-4111-8111-111111111111",
  "name": "example",
  "version": 1,
  "expression": "example",
  "rounding": {
    "decimalPlaces": 0,
    "mode": "half_away_from_zero"
  },
  "value": 0,
  "unit": "example",
  "status": "available",
  "code": "ok",
  "reason": null,
  "excludedInputIds": [],
  "inputs": []
}
安裝或連結 MCP