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

参考データ(年度別)

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

年度所属順位勝ち点年間総入場者数ホーム試合数リーグ戦平均入場者数客単価(円)
2011J1750224,4471713,2032,041
2012J1164325,0282017,7211,695
2013J1163302,6742116,2091,787
2014J1850297,6882314,9971,696
2015J1174332,2232116,3821,920
2016J1655293,9862115,4641,915
2017J11533267,2382114,0421,856
2018J1257267,4312014,3461,870
2019J1655264,4002313,8862,069
2020J184877,271174,5453,520
2021J11149120,619225,9202,172
2022J1355209,3642310,4931,934
2023J1358294,1032016,1282,146
2024J1268554,2052425,6093,616

項目名称(日本語)

メイン項目

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": "sanfrecce",
  "clubName": "サンフレッチェ広島",
  "years": [
    {
      "year": 2011,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 208,
            "items": []
          },
          "ticket": {
            "value": -102,
            "items": []
          },
          "distribution": {
            "value": -63,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 448,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 108,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -80,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 218,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 250,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 125,
                "items": []
              },
              {
                "item": "business_expenses",
                "value": -1013,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -48,
            "items": []
          },
          "sga": {
            "value": 286,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2012,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -33,
            "items": []
          },
          "ticket": {
            "value": 93,
            "items": []
          },
          "distribution": {
            "value": 7,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 401,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -8,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 441,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 21,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 4,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 7,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 88,
            "items": []
          },
          "sga": {
            "value": 158,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2013,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -33,
            "items": []
          },
          "ticket": {
            "value": -10,
            "items": []
          },
          "distribution": {
            "value": -7,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 28,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -1,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 73,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 24,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 25,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -6,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 37,
            "items": []
          },
          "sga": {
            "value": 42,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2014,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 164,
            "items": []
          },
          "ticket": {
            "value": -36,
            "items": []
          },
          "distribution": {
            "value": -13,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -228,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -6,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -157,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 34,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 20,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 12,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -100,
            "items": []
          },
          "sga": {
            "value": -17,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2015,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -68,
            "items": []
          },
          "ticket": {
            "value": 133,
            "items": []
          },
          "distribution": {
            "value": 17,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 0,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 430,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -4,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 382,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -24,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -18,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -10,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 460,
            "items": []
          },
          "sga": {
            "value": 12,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2016,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 151,
            "items": []
          },
          "ticket": {
            "value": -75,
            "items": []
          },
          "distribution": {
            "value": 54,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 173,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -602,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 4,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -437,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -2,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 142,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 28,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -256,
            "items": []
          },
          "sga": {
            "value": -232,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2017,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -74,
            "items": []
          },
          "ticket": {
            "value": -67,
            "items": []
          },
          "distribution": {
            "value": 194,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -60,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -373,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -5,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -293,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -8,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 108,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -24,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 49,
            "items": []
          },
          "sga": {
            "value": -56,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2018,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -16,
            "items": []
          },
          "ticket": {
            "value": 4,
            "items": []
          },
          "distribution": {
            "value": -120,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -3,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 190,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -6,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 73,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 20,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -148,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 5,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 262,
            "items": []
          },
          "sga": {
            "value": 9,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2019,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 52,
            "items": []
          },
          "ticket": {
            "value": 47,
            "items": []
          },
          "distribution": {
            "value": 402,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": -32,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -93,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -2,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -60,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 44,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -14,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 67,
            "items": []
          },
          "sga": {
            "value": 53,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2020,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 11,
            "items": []
          },
          "ticket": {
            "value": -275,
            "items": []
          },
          "distribution": {
            "value": -196,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 1,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 246,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": -19,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -8,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": -162,
                "items": []
              },
              {
                "item": "team_operations",
                "value": -74,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": -36,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 109,
            "items": []
          },
          "sga": {
            "value": -104,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2021,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 186,
            "items": []
          },
          "ticket": {
            "value": -10,
            "items": []
          },
          "distribution": {
            "value": -72,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 1,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -129,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 7,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 103,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 94,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 26,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 33,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 86,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": -164,
            "items": []
          },
          "sga": {
            "value": -27,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2022,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": -77,
            "items": []
          },
          "ticket": {
            "value": 143,
            "items": []
          },
          "distribution": {
            "value": -74,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 18,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": 3,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 14,
                "items": []
              },
              {
                "item": "women_revenue",
                "value": 233,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 236,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 41,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 72,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 145,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 180,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": 42,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 444,
            "items": []
          },
          "sga": {
            "value": 130,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2023,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 162,
            "items": []
          },
          "ticket": {
            "value": 226,
            "items": []
          },
          "distribution": {
            "value": -109,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 3,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -233,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 21,
                "items": []
              },
              {
                "item": "women_revenue",
                "value": 78,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": -229,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 1,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 5,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 5,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 46,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": 46,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 115,
            "items": []
          },
          "sga": {
            "value": 84,
            "items": []
          }
        }
      },
      "notes": []
    },
    {
      "year": 2024,
      "headline": {
        "items": []
      },
      "details": {
        "revenue": {
          "sponsor": {
            "value": 855,
            "items": []
          },
          "ticket": {
            "value": 1373,
            "items": []
          },
          "distribution": {
            "value": 178,
            "items": []
          }
        },
        "profitMetrics": {
          "merchandise": {
            "value": 14,
            "items": []
          },
          "other": {
            "headline": {
              "items": []
            },
            "total": -46,
            "revenue": [
              {
                "item": "academy_revenue",
                "value": 4,
                "items": []
              },
              {
                "item": "women_revenue",
                "value": 182,
                "items": []
              },
              {
                "item": "transfer_income",
                "value": 306,
                "items": []
              },
              {
                "item": "transfer_overseas",
                "value": 187,
                "items": []
              },
              {
                "item": "transfer_domestic",
                "value": 119,
                "items": []
              },
              {
                "item": "other_revenue",
                "value": 918,
                "items": []
              }
            ],
            "expense": [
              {
                "item": "match_expenses",
                "value": 286,
                "items": []
              },
              {
                "item": "team_operations",
                "value": 86,
                "items": []
              },
              {
                "item": "academy_expenses",
                "value": 28,
                "items": []
              },
              {
                "item": "women_expenses",
                "value": 155,
                "items": []
              },
              {
                "item": "other_cogs",
                "value": 901,
                "items": []
              }
            ]
          }
        },
        "expense": {
          "personnel": {
            "value": 813,
            "items": []
          },
          "sga": {
            "value": 252,
            "items": []
          }
        }
      },
      "notes": []
    }
  ]
}

期待する出力形式

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


使用方法

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

注意事項

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