Hiya Mike and all
I'd agree with Jane on this. Having just spent a fun but platform-heavy six months working with a bright and bushy-tailed bunch of startup people, I'm now feeling nostalgic for the days when we kept things simple. So one spreadsheet to rule them all - maybe in Google Docs/Sheets or similar. My partner spends ages trying to get different bunches of people to use Trello (and I love it, and Slack) but across a group of partners in different places/sectors, using a new platforms feel hard.
The key tasks over time with content are mainly about managing sign-off of edited text, and keeping that process simple and uniform and understood by all. You ideally want double or triple reading of text by proficient and literate proof readers, followed by sign-off, all of which is recorded in the system.
Then you want media resources accessioned/uploaded into the CMS by someone who knows the provenance of the media, and can fill in copyright status etc. This needs to follow the media wherever and whenever it is used. It's good to get the original author of the text to see the image captions, too, as picture context is often lost when images are stored in separate repositories to the original content.
I'd say from experience the most important thing in the publishing workflow is not what platforms are used, but how to manage key info and data about the content within the CMS itself. Older museum CMS and some newspaper systems manage image and text rights, user permissions and edit/sign off really well. (Index + !!!) If I was commissioning Wordpress plug-ins for museum use now, I'd hope for rights management, legacy management and accessibility at the top of my list of wants.
Just think of all those ancient NOF-Digi projects that no-one can resurrect because we haven't got a clue who owns any of the rights any more...
Jon
Jon Pratty
Creative Producer