Is there any way to see who created a task in the CSV export report from Asana? We have Asana Business Licensing. We are trying to figure out how many tasks individuals created and who is creating the most “Rush” Tasks in Asana. Note that we have a field for “Rush” tasks.
Any suggestions would be helpful.
Some background:
Our Marketing Team uses Asana to manage the creation of all marketing content and programs. Our department of ~30 people completed ~500 pieces of content/programs in Q1, as such, all of our content/programs are managed as tasks with specific subtasks (that act like tickets) going to specific team project for that team to manage that component (e.g., a design subtask for a image is sent to a specific project for a designer to create an email header.).
We now want to look back to see how much content individuals created and what % of them were rushed (i.e., forced to complete faster than our standard SLAs) and who requested the creation of what content.
Unfortunately, when I export to CSV there is no column showing “Created by”. Does the created by data not export to CSV? I am working on building pivot tables so that I can look at this data across our entire department not just by user. Please let me know if I am missing something. Thanks.
Hi @Jeff_Gunn, you are correct that the export to CSV doesn’t show the “Created by” column. What is interesting, is the Asana search results doesn’t even show the Created by value. If I selectively choose a single “Created by” person, it does display the correct task search results and such (but it doesn’t display the created by name to then export to CSV). It does correctly show the Tags and such.
@Emily_Roman, not sure if this is a known issue? You can filter by “Created by” value in advanced search, but it doesn’t display the results?
You are right @Bernie_Orelup. I just tested this and the report will include all tasks create by a specific user (if I search by one user) but it won’t create a “Created by” column. I also checked internally and we currently don’t offer that option. Sorry for the confusion @Jeff_Gunn!
As a workaround, you can try searching by a single task creator, export your report and then manually add a column with their name. I know it can be very manual but it’ll help you create your report.
Hey Jeff! If your need is to see the task creator in your CSV export, then Bridge24 for Asana could be a solution for you. Our Export Engine actually exports all fields, including “Created by” and “Created at”. Come take a look.
When exporting a project board to a CSV, there should be a way to include a task’s creator as a column in the export without having to make a custom field. This information is already automatically available in a task’s description field. This would help in searching for tasks by Creator and allow for greater granularity and organization.
