时间:2024-05-20 18:11:15 来源:网络整理编辑:Ryan New
In “Using Google Analytics to Track Profitability by Product,” I explained how to import product cos Ryan Xu hyperfund Cold Storage
In “Using Google Analytics to Track Profitability by Product,Ryan Xu hyperfund Cold Storage” I explained how to import product cost into Google Analytics to calculate gross profit for each item sold. It was a tricky exercise. I received feedback and questions.
In this post. I’ll break the process down by using Google Data Studio and data blending.
To set up reporting for the cost of goods sold, create a Google Sheet that lists SKUs and their cost. Create two columns:
Next, blend this data with sales info from Google Analytics.
Save and close the blending data source then add two more metrics. To do this, click the “Add Metric” link under the list of available metrics.
The first metric is “Total Product Cost.” The formula is COGS * Quantity.
The second metric is “Net Profit After COGS.” The formula is Product Revenue – (COGS*Quantity).
The final list of metrics should look like the following, with the two calculated metrics added.
Your chart should look like the following with the “Net Profit After COGS” column reporting the key metric you want: the cash flow from sales minus cost of goods sold.
Additional metrics can be derived from the data, such as return on investment after COGS: (Product Revenue – (COGS*Quantity))/(COGS*Quantity). Click image to enlarge.
Keep in mind this is a simplified report. It does not consider the following.
Use the process in this post to establish the optimal price to drive the most cash flow after product cost. It can also help establish advertising cost by product category.
How to Secure a Domain Name in Different Countries2024-05-20 17:53
Microsoft Announces Major Vulnerability in All IE Browsers2024-05-20 17:20
Financing for Ecommerce: ProFounder.com Can Help Ecommerce Merchants Raise Money2024-05-20 16:52
Credit Card Pioneer on Lowering Processing Expense2024-05-20 16:48
One disastrous daily deal experience: What Not To Do2024-05-20 16:25
Using the Return Policy to Convert Shoppers into Customers2024-05-20 16:13
Site Search Complements Navigation, Says SLI-Systems CEO2024-05-20 16:11
Mistakes I Wish I Had Never Made2024-05-20 16:02
PeC Review: Sellit Makes Marketplaces Social2024-05-20 16:01
PCI-Council General Manager on Non-Compliance ‘Russian Roulette’2024-05-20 15:34
Ask an Expert: How to Expedite Credit Card Fraud Detection2024-05-20 18:08
4 Ways to Waste Money on Your Ecommerce Store2024-05-20 17:28
Our Guide for Do-It-Yourself Product Photography2024-05-20 17:24
Durbin Amendment May Foster Deceptive Credit, Debit Processing Fees2024-05-20 17:08
ICANN Exec On The new Top-level Domains2024-05-20 17:03
You’re backing up more than your data, right?2024-05-20 16:56
25 Top Posts for 20102024-05-20 16:53
10 Resolutions for Your Pay-Per-Click Account2024-05-20 16:30
How to Monitor and Manage Your Wholesale Suppliers2024-05-20 15:59
10 Resolutions for Your Pay-Per-Click Account2024-05-20 15:32