• #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リーグシーズンの出来事を調べてください。

参考データ(年度別)

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

年度所属順位勝ち点年間総入場者数ホーム試合数リーグ戦平均入場者数客単価(円)
2011J11243287,1572114,1451,564
2012J11442317,6112116,9131,559
2013J1459361,1032118,8192,642
2014J11731426,1582221,6272,009
2015J2467270,7732212,2321,714
2016J2478316,0483812,5091,614
2017J1363427,2243920,9701,964
2018J1750371,5853718,8111,663
2019J1559413,6533821,5181,637
2020J1460141,534377,0142,190
2021J11248112,345225,0703,213
2022J1551242,7762311,4272,867
2023J1949325,6442017,0742,764
2024J11052347,5352017,9032,877

項目名称(日本語)

メイン項目

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": "cerezo",
  "clubName": "セレッソ大阪",
  "years": [
    {
      "year": 2011,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 79,
            "items": []
          },
          "ticket": {
            "value": 21,
            "items": []
          },
          "distribution": {
            "value": -67,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -18,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 20,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -80,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 348,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 184,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 56,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 7,
                "items": []
              },
              {
                "item": "business_expenses",
                "value": -637,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -116,
            "items": []
          },
          "sga": {
            "value": 200,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2012,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -241,
            "items": []
          },
          "ticket": {
            "value": 46,
            "items": []
          },
          "distribution": {
            "value": 5,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 48,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 301,
                "items": []
              },
              {
                "item": "academy_revenue",
                "value": -20,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -58,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 354,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -56,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": -7,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -216,
            "items": []
          },
          "sga": {
            "value": -41,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2013,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 379,
            "items": []
          },
          "ticket": {
            "value": 459,
            "items": []
          },
          "distribution": {
            "value": -8,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -523,
            "revenue": [
              {
                "item": "other_revenue",
                "value": -235,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 174,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 114,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 243,
            "items": []
          },
          "sga": {
            "value": 124,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2014,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 12,
            "items": []
          },
          "ticket": {
            "value": -98,
            "items": []
          },
          "distribution": {
            "value": 12,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 728,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 632,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -123,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 27,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 468,
            "items": []
          },
          "sga": {
            "value": 286,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2015,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -6,
            "items": []
          },
          "ticket": {
            "value": -392,
            "items": []
          },
          "distribution": {
            "value": -123,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -313,
            "revenue": [
              {
                "item": "other_revenue",
                "value": -538,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -44,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -181,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -157,
            "items": []
          },
          "sga": {
            "value": -282,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2016,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 233,
            "items": []
          },
          "ticket": {
            "value": 46,
            "items": []
          },
          "distribution": {
            "value": -7,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 50,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -89,
            "revenue": [
              {
                "item": "other_revenue",
                "value": -215,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 27,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -153,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -29,
            "items": []
          },
          "sga": {
            "value": -246,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2017,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -138,
            "items": []
          },
          "ticket": {
            "value": 329,
            "items": []
          },
          "distribution": {
            "value": 358,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 79,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 125,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 290,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 125,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 40,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 840,
            "items": []
          },
          "sga": {
            "value": 205,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2018,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 186,
            "items": []
          },
          "ticket": {
            "value": -221,
            "items": []
          },
          "distribution": {
            "value": 94,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -24,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -148,
            "revenue": [
              {
                "item": "other_revenue",
                "value": -214,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -138,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 72,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 0,
            "items": []
          },
          "sga": {
            "value": -74,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2019,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -79,
            "items": []
          },
          "ticket": {
            "value": 59,
            "items": []
          },
          "distribution": {
            "value": -75,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -14,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 116,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 170,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -9,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 63,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 72,
            "items": []
          },
          "sga": {
            "value": 106,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2020,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -8,
            "items": []
          },
          "ticket": {
            "value": -367,
            "items": []
          },
          "distribution": {
            "value": -85,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -59,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -210,
            "revenue": [
              {
                "item": "other_revenue",
                "value": -367,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -55,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -102,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -386,
            "items": []
          },
          "sga": {
            "value": -156,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2021,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 295,
            "items": []
          },
          "ticket": {
            "value": 51,
            "items": []
          },
          "distribution": {
            "value": 104,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 44,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 47,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 294,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 77,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 170,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 429,
            "items": []
          },
          "sga": {
            "value": 145,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2022,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 290,
            "items": []
          },
          "ticket": {
            "value": 335,
            "items": []
          },
          "distribution": {
            "value": -92,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -5,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 106,
            "revenue": [
              {
                "item": "other_revenue",
                "value": 141,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 133,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -98,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -406,
            "items": []
          },
          "sga": {
            "value": 158,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2023,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 457,
            "items": []
          },
          "ticket": {
            "value": 204,
            "items": []
          },
          "distribution": {
            "value": -126,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 61,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -176,
            "revenue": [
              {
                "item": "women_revenue",
                "value": 182,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -193,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -45,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 54,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 156,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -33,
            "items": []
          },
          "sga": {
            "value": 227,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2024,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -4,
            "items": []
          },
          "ticket": {
            "value": 100,
            "items": []
          },
          "distribution": {
            "value": 39,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -16,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 368,
            "revenue": [
              {
                "item": "women_revenue",
                "value": 129,
                "items": []
              },
              {
                "item": "transfer_income",
                "value": 493,
                "items": []
              },
              {
                "item": "transfer_overseas",
                "value": 134,
                "items": []
              },
              {
                "item": "transfer_domestic",
                "value": 359,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -268,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 90,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -232,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 128,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 542,
            "items": []
          },
          "sga": {
            "value": 80,
            "items": []
          }
        }
      },
      "notes": []
    }
  ]
}

期待する出力形式

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


使用方法

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

注意事項

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