Our
What is the best software to use for tracking Marketing Projects?
Answers
One goal should be to have one consistent data set between finance and marketing, so that marketing has numbers that foot with the G/L. For that to happen, finance should send marketing a transaction level extract, in excel format. That extract should have the GL account numbers in it. If the data does not have specific project codes, Marketing will have to tag each transaction for a specific project. From there, a simple pivot table can be used to summarize the data by project and do a budget to actual comparison.
Mindy - the solution is somewhat simple, but it is dependent on your
If you'd like to discuss more, let me know.
Regards
Len
I probably go against the grain on this one, but I don't like managing the business from the general ledger. Adding G/L account number after G/L account number just means a chart of accounts that becomes to complex to manage. My preference is to build subsystems that then feed the ledger. This allows for the analysis to be done in the details that tie to the G/L on a rolled up basis, but can be obsoleted when it is no longer needed. Unfortunately, Mindy, I can't recommend software as we build ours in house.
1
Mark, I agree with your philosophy, and would like to expand on my comment earlier. If all you need is a 'cost collection bucket' for these types of projects, then a PSA/project sub ledger can become overkill (and also the ROI is missing because the added functionality costs too much).
In the 'cost collection bucket' scenario, users are looking to track budget and actual costs by simply tracking the project ID in the transaction (whether an AP invoice, expense report, or journal entry). An accounting system that can do that is very valuable. Last year I helped a client with such a need select such a package.
Mindy- There are many tools out there that can manage projects or manage financials, the challenge is finding a single solution that has flexibility for the creative and dynamic project team, while maintaining a framework that is also understood/integrated by/to finance and other parts of the executive suite.
Full disclosure; I work for NetSuite, a Software Business Solution leader, as the Vertical Industry Manager for Marketing and Publishing.
For 10+ years I've worked with clients on this important balance of control and flexibility. The power of a suite with Project and Resources (PSA) solution and a Financial platform offers the best solution. PM's are able to have the right people on the right project at the right time, to therefore hit budget and deliverables. At the same time Finance has the financial visibility for real-time profitability and efficient and timely billing. I would encourage you to look at this type of a solution.
Purchasing a cloud off-the-shelf solution allows you to focus on your business growth and infrastructure and integrations. In my role I've seen many internal groups as well as independent agencies thrive on the solution that empowers the PM's and gives Finance the tools it needs for internal accountability and client
Mindy... are there more than 8 items you're watching?
1
Yes, we have MANY campaigns/projects that we are watching at any one time across a number of different Marketing Team Leads.
Filed Under:
Technology