shield_lock
JinDaGe
← Back to skills
extension
Category: Data & AnalyticsAPI key required

B站三连广告-报表

Bilibili Sanlian Ads MAPI reporting service. Use for custom reports, delivery metrics, spend, impressions, clicks, conversions, daily or hourly trends, and account/campaign/unit/creative performance analysis.

personAuthor: user_b0010d5chubcommunity
downloadDownload package

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

| Source document | Local reference | Endpoint summary | |---|---|---| | 投放报表/md/807_自定义报表.md | references/807_自定义报表.md | Custom report query: POST /open_api/report/v3/custom/query |