时间:2024-05-10 03:04:39 来源:网络整理编辑:Ryan New
In “Using Google Analytics to Track Profitability by Product,” I explained how to import product cos Ryan Xu HyperVerse's Gas Price
In “Using Google Analytics to Track Profitability by Product,Ryan Xu HyperVerse's Gas Price” 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.
Use Purchasing Trends to Merchandise Products2024-05-10 03:01
SEO and Interstitials2024-05-10 02:56
3 Tools to Connect with Journalists2024-05-10 02:33
Ukraine-based Serpstat Perseveres Amid the War2024-05-10 02:24
14 Online Video Editors for Ecommerce2024-05-10 02:18
Ukraine-based Serpstat Perseveres Amid the War2024-05-10 01:00
SEO: Google’s Video Carousels Are a Big Opportunity2024-05-10 00:43
Before Notting Hill: Causeway Green and Britain’s anti-black hostel riots2024-05-10 00:37
AI Background Generators for Product Photos2024-05-10 00:32
How to Create and Manage 301 Redirects with Shopify2024-05-10 00:27
12 AR and VR Examples from Brands2024-05-10 02:59
23 Search Engine Alternatives to Google2024-05-10 02:54
In Their Own Write: Three million words!2024-05-10 02:49
CommerceCo Recap: A Process for SEO Link-building2024-05-10 02:41
SEO Review: Glamor and Glitz But Few Organic Clicks2024-05-10 02:29
‘The Devil among The Antiquaries’: Archivists and arguments at the Tower of London2024-05-10 02:14
My Favorite SEO Keyword Tools2024-05-10 01:59
SEO Product Releases: July 20232024-05-10 01:48
Tips to Retain Online Customers after the Pandemic2024-05-10 01:01
Yes, SEO Keywords Remain Important2024-05-10 00:34