How to add fixed and variable costs in Google Analytics?

Question

Business Informatics

The goal is to get ROI from channels, ads.
Project 1. Online pizzeria. Of the 1 million in revenue, the founder takes 200,000 rubles. That is 20%.
Only expenses for Direct through bi.owox.ru are uploaded to analytics.
How, in this case, to convey to Analytics that profit is 20% of income?
Project 2. The site sells digital content. Fixed costs - Direct, imported into Analytics via bi.owox.ru
How to import costs for hosting, programmer into Analytics?
In both cases, a Google spreadsheet would be fine, where the amounts for each month are manually entered, and then imported into Analytics.
1. How to solve the problem?
2. How do you calculate ROI and EPC?

Answer 1

1. Basically, GA is not very good at doing this sanely.
You can play around with the Measurement Protocol - put information on real income in a separate profile.
2. You can try to agree in bi.owox to make the payment of fixed amounts in addition to the costs of the channel. Or you will have to code your import costs, which will support it. Fixed costs plus variables.
As a way out everywhere:
Upload everything to yourself somewhere, and locally already count.

Answer 2

I join Artyom Tsyplakov 's advice to unload.
When I needed to make a more or less simple dashboard for similar tasks (a tricky calculation of ROI for different products and traffic sources), we took all the data to ourselves and aggregated it in the internal system, this is much easier than shamanism with the Measurement Protocol.

Answer 3

Dug up a way for physical goods. Theoretically, you can install the OWOX BI Data Upload Chrome extension .
There you can register the margin for each product. I just don't know how.
Office expenses and salaries will not work out that way, but this is already something.