Import this data to Google Sheets with:

Full statements spill as a table. For one cell: =jivedata("SHOT","Revenue") or =jivedata("SHOT","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.