Can you refer to the attached budget breakdown as I updated the expenses, later on you may need to get a list of all internet expenses in June because I may miss some (for now use these numbers as both yourself, and Tak are new I dont need it 100% perfect).
Basically I have added in the column where you can apply the budget too, you will see many are applied to organic and direct. The reason is that these services all combine to help our website but we cannot define the exact medium for revenue so I just split it. So add up the total of all internet/direct costs in the attached then split 50% in organic and 50% in direct. The others are easier such as PPC, email and social.
ROI = Return on Investment, your calculation is correct. % of profit will be nice thanks. Just always bare in mind, the GA reports are good but never 100% accurate. The sales tracking, top downs/internet reports should always be 100%. You can see how data is mixed up by looking at the PPC ROI (see attached log in details), its always very hard to get perfect revenue per source so its more of an educated guess.
Its still a nice report though, the important information is how much we spend on online marketing, and how much profit we make.
Thanks
Dan