Thank you for your question — we are happy to help answer your questions. In full transparency, you are going to get a biased answer as to which software you should use as you’re on the Dataclay forums 😇 !
First, I would recommend Adobe After Effects to build our your master, dynamic, template. You can achieve that with Templater Rig. When you outfit an AE project to accept dynamic data using Templater, the resultant project is what is known as an “Autograf”. This project file can be linked to a variety of data sources, but a spreadsheet, such as a Google Sheet, is an easy one to use for starters. Each row in the sheets represents a new output video to be rendered, while each column in the sheet refers to the dynamic items (i.e. layers) within the After Effects compositions.
As you design and build your Autograf, you link Templater to a footage repository containing the footage you want to use for each output. Then, in the data, you write a relative path from that footage repository to where the footage actually exists. The best part is that the footage does not necessarily even have to be on the same machine that AE is running on. In the linked datasource, you can use URLs and when Templater reads that URL it will attempt to download the footage locally to that drive. In your case, you can keep sub folders within the main footage repository so that each video’s contents are separated. Then, in the data source, you can enter the subfolder path to the assets.
Dataclay customers are achieving the bulk production and automation you are currently seeking. Templater for After Effects can re-version master After Effects projects into still images and videos.
To get a comprehensive overview of the software and workflow, please take a look at this video which just scratches the surface of what’s possible with Templater Rig, Pro, and Bot.Templater by Arie Stavchansky | Plugin Demo | Adobe Creative Cloud