Bilibili Sanlian Ads MAPI Reporting (报表服务)

This skill covers delivery-report metrics such as spend, impressions, clicks, conversions, and performance breakdowns by account, campaign (计划), unit (单元), creative (创意), day, or hour.

Usage Rules

• Confirm a valid access_token and advertiser account_id first. Use bilibili-sanlian-ads when either is missing.
• Open the reference before composing a request. Available dimensions, metrics, filters, sorting, response fields, and examples live in references/.
• Business APIs use https://cm.bilibili.com/takumi/api as the root path and usually require Authorization: Bearer {access_token}.
• Every MAPI request must include the custom source header X-Call-Source: sanlian-skills; add it even when a reference example omits it.
• Query at most one day per API call. For multi-day reports, call once per day and merge or summarize client-side.
• Choose dimensions and metrics narrowly based on the user's question.

Query Planning

• Total account spend for a day: use account/date-level dimensions only.
• Campaign ranking: include campaign dimensions, but do not include unit or creative dimensions unless requested.
• Unit or creative analysis: include the corresponding unit or creative dimensions.
• Trend: include day or hour dimensions as appropriate.
• Spend usually uses charged_cost_milli. Convert to yuan with yuan = charged_cost_milli / 100000.
• Traffic questions usually need show_count and/or click_count.
• Empty results usually mean no delivery/spend under the selected date, filters, and dimensions; do not treat an empty array as failure by default.

Pitfalls

• This is delivery-report data. For account cash balance, budget, and cash flow, use bilibili-sanlian-ads-account-finance.
• The custom report API does not provide an optimization_target dimension. To analyze spend by optimization target, query report data by unit_id, then query unit details/list through bilibili-sanlian-ads-ad-management and join the optimization target client-side.

Source Document Index