• #Jリーグ
  • #財務分析
  • #Deep Research
  • #プロンプト
  • #アビスパ福岡

アビスパ福岡 - Deep Researchプロンプト

以下のプロンプトをDeep Researchに投入してください(--- で囲まれた部分)。


あなたはJリーグの財務アナリストです。アビスパ福岡の各年度の営業利益増減について、以下のJSONデータを完成させてください。

決算期に関する注意

アビスパ福岡は 1月決算(会計年度:2月1日〜翌年1月31日)です。

JSONの年度決算期間対応するシーズン
20242024年2月〜2025年1月2024シーズン
20232023年2月〜2024年1月2023シーズン

JSONの「year: 2024」のデータについてコメントを書く場合、2024年のJリーグシーズンの出来事を調べてください。

参考データ(年度別)

以下はコメント作成時の参考情報です。入場者数の増減理由などに活用してください。

年度所属順位勝ち点年間総入場者数ホーム試合数リーグ戦平均入場者数客単価(円)
2011J11722177,0541710,4151,740
2012J21841117,309215,5861,449
2013J21456120,270215,7271,497
2014J21650106,303215,0621,806
2015J2382199,669228,6921,177
2016J11819253,8562112,8571,083
2017J2474209,565229,550907
2018J2770186,323218,873934
2019J21644146,639216,983934
2020J228478,502213,7381,834
2021J1854109,169225,4032,858
2022J11438142,467237,1503,257
2023J1751191,887229,7663,221
2024J11250184,271199,6983,631

項目名称(日本語)

メイン項目

JSONキー日本語名称説明
sponsorスポンサー収入企業スポンサーからの収入
ticket入場料収入チケット販売による収入
distributionJリーグ配分金Jリーグからの配分金・分配金
merchandise物販損益グッズ販売の収入から物販関連費を引いた損益
otherその他損益上記以外の収入・費用の差額
personnel人件費チーム人件費+移籍関連費用
sga販売費および一般管理費販管費

その他損益の内訳(other.revenue / other.expense)

収入項目 (revenue):

item日本語名称
academy_revenueアカデミー関連収入
women_revenue女子チーム関連収入
transfer_income移籍補償金等収入
transfer_overseas国外クラブからの移籍収入
transfer_domestic国内クラブからの移籍収入
other_revenueその他収入

費用項目 (expense):

item日本語名称
match_expenses試合関連経費
team_operationsトップチーム運営経費
academy_expensesアカデミー運営経費
women_expenses女子チーム運営経費
other_cogsその他売上原価
business_expenses事業費

データ構造

各項目は items 配列を持ち、複数の説明と情報源を格納できます:

{
  "value": -115,
  "items": [
    { "text": "主要スポンサーの契約終了により減収", "source": "https://..." },
    { "text": "新規スポンサー獲得の遅れ", "source": "https://..." }
  ]
}

その他損益(profitMetrics.other)の構造

{
  "headline": { "items": [] },  // 内訳を踏まえた総括コメント
  "total": 123,                 // 集計値(変更不可)
  "revenue": [                  // その他収入の内訳
    { "item": "transfer_income", "value": 100, "items": [] }
  ],
  "expense": [                  // その他費用の内訳(増加=マイナス影響)
    { "item": "match_expenses", "value": 50, "items": [] }
  ]
}

前提条件

  • 単位: JSONの value の単位は「百万円」です。
  • 出力形式: 完成したJSONはチャット内にテキストとして表示してください。
  • 情報源の優先度:
    1. 一次ソース(クラブ公式、Jリーグ公式、決算資料)を優先
    2. 一次ソースが見つからない場合、信頼できる二次ソース(スポーツ新聞の報道等)を使用可
    3. どうしても情報源が見つからない項目は items を空のままにする
  • headline(年度総括)の文字数: 20〜50文字程度(各項目より短めでOK)

指示

  1. 各年度の valuetotal は計算済みの実データです。変更しないでください
  2. 各項目の items 配列に、説明と情報源を追加してください:
    • 1つの要因につき1エントリ(複数の要因がある場合は複数エントリ)
    • 各エントリ: { "text": "理由説明(50〜100文字)", "source": "情報源URL" }
  3. 年度の headline.items にその年度を象徴するコメントを追加してください。
  4. profitMetrics.other.headline.items には、その他損益の内訳を踏まえた総括コメントを記入してください。
  5. notes に補足情報を箇条書きで追加してください。

入力データ(完成させてください)

{
  "clubId": "avispa",
  "clubName": "アビスパ福岡",
  "years": [
    {
      "year": 2011,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 64,
            "items": []
          },
          "ticket": {
            "value": 102,
            "items": []
          },
          "distribution": {
            "value": 102,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 3,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 144,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -104,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 101,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 157,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 71,
                "items": []
              },
              {
                "item": "business_expenses",
                "value": -292,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 27,
            "items": []
          },
          "sga": {
            "value": 133,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2012,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -140,
            "items": []
          },
          "ticket": {
            "value": -138,
            "items": []
          },
          "distribution": {
            "value": -112,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 23,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 28,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -30,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -15,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -2,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -8,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -17,
            "items": []
          },
          "sga": {
            "value": -65,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2013,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 23,
            "items": []
          },
          "ticket": {
            "value": 10,
            "items": []
          },
          "distribution": {
            "value": -1,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -3,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -1,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -14,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -13,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 6,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -5,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -21,
            "items": []
          },
          "sga": {
            "value": -16,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2014,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 10,
            "items": []
          },
          "ticket": {
            "value": 12,
            "items": []
          },
          "distribution": {
            "value": 2,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 82,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 39,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 13,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 3,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -40,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 7,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 27,
            "items": []
          },
          "sga": {
            "value": -21,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2015,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 140,
            "items": []
          },
          "ticket": {
            "value": 43,
            "items": []
          },
          "distribution": {
            "value": -2,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 245,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 1,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 525,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 20,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 253,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 8,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 209,
            "items": []
          },
          "sga": {
            "value": 163,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2016,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 144,
            "items": []
          },
          "ticket": {
            "value": 40,
            "items": []
          },
          "distribution": {
            "value": 113,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 20,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -80,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -36,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -191,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 46,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -187,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -6,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 311,
            "items": []
          },
          "sga": {
            "value": -37,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2017,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 3,
            "items": []
          },
          "ticket": {
            "value": -85,
            "items": []
          },
          "distribution": {
            "value": -48,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 5,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 264,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 45,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 230,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -24,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 30,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 5,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 63,
            "items": []
          },
          "sga": {
            "value": 46,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2018,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 369,
            "items": []
          },
          "ticket": {
            "value": -16,
            "items": []
          },
          "distribution": {
            "value": -5,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -1,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -539,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -43,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -440,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -11,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 41,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 26,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -91,
            "items": []
          },
          "sga": {
            "value": -51,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2019,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -297,
            "items": []
          },
          "ticket": {
            "value": -37,
            "items": []
          },
          "distribution": {
            "value": 1,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 6,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 41,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 21,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 62,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 6,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 31,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 5,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -125,
            "items": []
          },
          "sga": {
            "value": -56,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2020,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 54,
            "items": []
          },
          "ticket": {
            "value": 7,
            "items": []
          },
          "distribution": {
            "value": 3,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -4,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -46,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -30,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -73,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -4,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -26,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -27,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 184,
            "items": []
          },
          "sga": {
            "value": 14,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2021,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 56,
            "items": []
          },
          "ticket": {
            "value": 168,
            "items": []
          },
          "distribution": {
            "value": 241,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 10,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 66,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -4,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 53,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 10,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -20,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -7,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 675,
            "items": []
          },
          "sga": {
            "value": 61,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2022,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 399,
            "items": []
          },
          "ticket": {
            "value": 152,
            "items": []
          },
          "distribution": {
            "value": 10,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 23,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -73,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -12,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 147,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 21,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -43,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 127,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": 103,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 34,
            "items": []
          },
          "sga": {
            "value": -20,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2023,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -266,
            "items": []
          },
          "ticket": {
            "value": 154,
            "items": []
          },
          "distribution": {
            "value": -99,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 21,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 79,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -1,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 166,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 5,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 25,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -3,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": 59,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -66,
            "items": []
          },
          "sga": {
            "value": 62,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2024,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 89,
            "items": []
          },
          "ticket": {
            "value": 51,
            "items": []
          },
          "distribution": {
            "value": 64,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 1,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -59,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 20,
                "items": []
              },
              {
                "item": "transfer_income",
                "value": 177,
                "items": []
              },
              {
                "item": "transfer_overseas",
                "value": 2,
                "items": []
              },
              {
                "item": "transfer_domestic",
                "value": 175,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -230,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -5,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 72,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 17,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": -58,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 17,
            "items": []
          },
          "sga": {
            "value": 21,
            "items": []
          }
        }
      },
      "notes": []
    }
  ]
}

期待する出力形式

各項目の items 配列に { "text": "...", "source": "..." } を追加した完全なJSONを返してください。


使用方法

  1. 上記プロンプト(--- で囲まれた部分)をDeep Researchに投入
  2. 返ってきたJSONを data/comments/avispa.json に保存
  3. 必要に応じて内容を確認・修正

注意事項

  • value / total の値は変更しないでください(計算済みの実データ)
  • 情報源は可能な限り一次ソース(クラブ公式、Jリーグ公式、決算資料)を優先
  • 推測でなく、確認できた事実のみ記載