Taking Your Financial Reports to the Next Level with Management Reporter – Weekly Campaign Revenue (2 of 8)
The second report in the “Taking your Financial Reports to the Next Level with Management Reporter” series is called “Weekly Campaign Revenue.” Managing the revenue associated with various marketing campaigns can be challenging. But, if you’re using dimensions in your Microsoft Dynamics General Ledger account structure, you can easily create a report in Management Reporter to help you track weekly revenue for the various marketing tactics you’ve put to use in your business.
The rows of the report display the four key marketing campaign tactics being used, as well as the total. The columns are structured to display each week in a five-week period that the marketing campaigns are being tracked, along with the total. Two charts also have been created for this report. One shows a pie chart breaking down the revenue by total marketing campaign, making it easy to see that billboards are driving the least amount of revenue. The second chart shows week-by-week revenue by campaign, allowing someone to easily pinpoint that no revenue was received by banner and search ads over a 2-week period.
This video includes information on how to create a similar “Weekly Campaign Revenue” report for your company.
[embed]https://www.youtube.com/watch?v=ZY3-nEYFPhQ&feature=youtu.be[/embed]
In summary, the key features included in the “Weekly Campaign Revenue” were:
- Start and end dates were defined to create each weekly column
- Charts for total revenue and weekly revenue by campaign were created in the Management Reporter web viewer
Links to other posts in this series:
- Quarterly Revenue by Business Unit - Are we making a profit?
- Weekly Material Usage - Are we being efficient?
- Budget to Target - Are we hitting targets?
- Postings Audit - Are we entering transaction accurately?
- Statement of Cash Flow - Are we making the right investments?
- Quarterly Tax Form - Are we getting the data needed for taxes?
- Financial Matrix - How are we performing?
Comments
Anonymous
July 25, 2013
Hello Jill, This comment is probably not posted in the right area, but you'll understand once you read it. I apologize for the noise on the blog. Feel free to remove it and reply directly to me. What are the available areas (that your team reads) for AX partners to post questions on MR for possible issues? ThanksAnonymous
August 03, 2013
Please feel free to post Management Reporter questions in the Dynamics AX community on http://community.dynamics.com/. We try to log into each of the Dynamics ERP community sites every few days to respond to questions. The Customer Support team also is active on these sites.