Organizing and Managing Large Number of Projects

Wanted to get thoughts from the community on a challenge we are trying to solve and see if this can be achieved within Asana or if there is another alternative solution to achieve the result.

We have some consistent processes that we perform each month for every one of our clients(300+). This involves updating data, running reports, performing analytics, etc. We are wanting to streamline this process in order to have more control and visibility over the progress of the tasks than what a shared spreadsheet provides. In addition, since the same process is performed every single month for each customer, we need to have an easy method to re-create the tasks from a defined template.

One of the challenges we are running into is how best to organize the portfolio/projects/tasks so that it is easy to navigate and see what is being worked on and/or needs to be worked on.

Below is a diagram that shows the hierarchy of how the process works each month for each company. This is a basic diagram showing an example of a structure for a single company, but the concept is the same for all others. We have about 300+ companies that we perform these processes for each month. Each company may have between 1 and 5 “vendors” and under each vendor, they may have 1 or more accounts (generally less than 5). Under the Accounts is where the tasks are defined and the tasks are broken out by the team that needs to perform the task. There are about 4 different teams/groups that perform various tasks under the vendor accounts.

I’m not sure the best way to approach this within Asana (using portfolios or projects with tasks/subtasks). From a portfolio perspective, I would envision the Company level being the portfolio. From a project perspective, the project is defined more from the Period level than the Company level, because there will always be a start and end date for each Period, but the Company level may always remain open.

Not to add another wrench in this, but another key component to this has to do with task dependencies and task durations. Since these are consistently repeated tasks each month, there is an expected time duration for when each task should be completed based on when the project starts. However, rather than manually setting the Start Date and Due Date for every single task in the project each month, we want to see if there is a way to define the number of days that the task should take, or set the number of days after the project start date that the task will be due. For example, if Task #1 is due 2 days after the project start date, then instead of setting an actual due date for Task #1, we would just configure a setting that the task is due 2 days after whatever the defined Start Date for the project is. In turn, all due dates in the template would update accordingly based on that Start Date.

I am open to any suggestions on solutions or alternatives that the community can offer. Thank you in advance.

Hi @Robert_White welcome to the community…

Can definitely understand/see the challenge you have… Not sure I have any solution as per say but more a few things to think about.

  • Assuming Task 1 will have a very similar name for each “Account” so in theory Team A could have 7500 tasks with virtually the same name? (Max 5 Accounts for 5 Vendors for 300+ Clients 5 x 5 x 300) at that level regardless of the system I would think this is a management nightmare and workflow nightmare.
  • How many people in each team to perform these tasks?
  • Has automation been explored?
  • Which aspect in the hierarchy above is critical to monitor and confirm success? Is that the Tasks done by the team are complete for any account or the account has all tasks complete etc.
  • How long does this process take for all clients from start to finish?

The more I think about this the more I see the extent of the Challenge and the less of a solution I can think of.

Sorry for not being much help, maybe engage one of the Asana Professionals to workshop with yourself to come up with the best solution.

Jason.

Hello Jason,

Thank you for the reply. I do agree that this is a bit of a maintenance nightmare and that is ultimately the challenge that we are trying to solve. The current process is quite cumbersome and inefficient and we have tried to automate where we can. Some of the tasks unfortunately require information from some of our vendors, which we don’t have a lot of control over.

There is usually about 8 to 10 people involved in the tasks with 2 to 3 people in each team. The process generally takes about 30 days and then repeats again each month. As far as the monitoring of progress goes, I would say that just making sure all the tasks for the account(s) get completed, not necessarily monitoring by the team. As far as the tasks go, some of the tasks can be done in parallel with each other, while others have dependencies where some task(s) need to be completed before the next can be started.

I do appreciate your response and I think we will take a closer look at some of the tasks and see if there is some additional automation that we can apply. Our current process is fairly antiquated, so any suggestion for process improvement is a step forward.

Thank you again for your reply.
Robert