Using Google Analytics to Track Profitability by Product

Using Google Analytics to Track Profitability by Product

May 5, 2017 1:04 pm

Area of interest ecommerce retailers should give attention to money move. They don't have giant capital reserves to help unprofitable investments. Though rising gross sales is sweet for the ego, rising money movement is what places meals on the desk. On this article, I’ll tackle how one can use Google Analytics to trace profitability by product class — reporting on gross sales, value of products bought, and promoting expense — to maximise money movement.

Not all the knowledge has to return from Google Analytics, by the best way. Retailers might use knowledge from different sources, as long as these sources present:

  • Gross sales by product class;
  • Value of products bought by product class;
  • Promoting value by product class.

Reporting Gross sales by Product Class

Google Analytics ecommerce monitoring can report gross sales by product class. To view gross sales by class, go to Conversions > Ecommerce > Product Efficiency and choose “Product Class.”

To view sales by category, go to “Conversions > Ecommerce > Product Performance.”

To view gross sales by class, go to Conversions > Ecommerce > Product Efficiency.

Reporting Value of Items Bought by Product Class

Google Analytics has a function to import product value knowledge. To set this up, first create a brand new customized metric at Admin > Property > Customized Definitions > Customized Metrics.

Under “Custom Definitions”, click on “Custom Metrics.”

Beneath “Customized Definitions,” click on on “Customized Metrics.”

Identify the metric “Product Value” and assign the scope to be “Product” degree and the formatting sort as “Foreign money (Decimal).” Depart “Minimal Worth” and “Most Worth” clean.

Name the custom metric “Product Cost” and assign the scope to be “Product” level and the formatting type as “Currency (Decimal).”

Identify the customized metric “Product Value” and assign the scope to be “Product” degree and the formatting sort as “Foreign money (Decimal).”

For the info import, go to Admin > Property > Knowledge Import.

Select “Data Import” under the Property column.

Choose “Knowledge Import” underneath the Property column.

Then create a brand new knowledge set for “Product knowledge.”

Create a new Product data set.

Create a brand new knowledge for “Product knowledge.”

Identify the info set “Product Value” and choose a Google Analytics View to obtain the imported knowledge and click on “Proceed.”

Name the data set "Product Cost."

Identify the info set “Product Value.”

Then choose “Product Value” because the imported knowledge.

Select “Product Cost” as the Imported Data.

Choose “Product Value” because the imported knowledge.

Depart “Overwrite hit knowledge” set to “No” when each imported knowledge and hit knowledge can be found. Save after which click on on “Get schema.”

Leave “Overwrite hit data” set to “No” when both imported data and hit data are available. Save and then click on “Get schema.”

Depart “Overwrite hit knowledge” set to “No” when each imported knowledge and hit knowledge can be found. Save after which click on on “Get schema.”

Click on on “Obtain schema template” to get the template to populate product value knowledge.

Click on “Download schema template” to get the template to populate product cost data.

Click on on “Obtain schema template” to get the template to populate product value knowledge.

Populate the schema template with all product SKUs and their per-merchandise value.

Populate the schema template with all product SKUs and their per-item cost.

Populate the schema template with all product SKUs and their per-merchandise value.

Then save the schema template and go to “Handle uploads” to add the product value knowledge.

Go to “Manage uploads” to upload the product cost data.

Go to “Handle uploads” to add the product value knowledge.

Observe that the product value import isn't retroactive (until you're utilizing Google Analytics 360, the enterprise model). So product value will begin populating after you import an SKU and its value.

Create a “Calculated Metric” for value of products bought by going to Admin > View > Calculated Metrics.

Create a "Calculated Metric" for cost of goods sold by going to Admin > View > Calculated Metrics.

Create a “Calculated Metric” for value of products bought by going to Admin > View > Calculated Metrics.

Identify it “COGS” and set the Formatting Sort to “Foreign money (Decimal).” Enter the next formulation.

( ( Amount ) / ( Distinctive Purchases + Product Element Views + Product Provides To Cart ) ) * Product Value

Name the calculated metric “COGS” and set the Formatting Type = “Currency (Decimal).”

Identify the Calculated Metric “COGS” and set the Formatting Sort = “Foreign money (Decimal).”

Create one other Calculated Metric referred to as “Product Revenue”  — which can also be formatted as “Foreign money (Decimal)”) — utilizing the next formulation.

 Product Income - ( ( ( Amount ) / ( Distinctive Purchases + Product Element Views + Product Provides To Cart ) ) * Product Value )

Create another Calculated Metric called “Product Profit.”

Create one other Calculated Metric referred to as “Product Revenue.”

You at the moment are able to report gross revenue  — gross sales much less value of products bought — by product class. Right here is the customized report that may present this knowledge.

Use this custom report for gross profit by product category. <em>Click image to download.</em>

Use this tradition report for gross revenue by product class. Click on picture to obtain.

Reporting Promoting Value by Product Class

Establishing a reporting dashboard to trace gross revenue after promoting value allows retailers to determine which classes generate probably the most money circulate. The optimum strategy to report promoting value by product class is to construction promoting campaigns and advert teams to align with product classes. That means Google AdWords, Bing Advertisements, and different campaigns and their advert teams might be mixed with class gross sales to report gross revenue after promoting.

Google AdWords value knowledge must be obtainable in Google Analytics when you have built-in AdWords with Analytics. You possibly can import into Google Analytics the fee for Bing Advertisements and different promoting channels. I defined tips on how to set this up at “Utilizing Google Analytics to Optimize Bing Advertisements, Different Channels.”

Promoting spend reviews are at Acquisition > Campaigns > Value Evaluation or you'll be able to create a customized report for output you want.

Find advertising spend reports at Acquisition > Campaigns > Cost Analysis.

Discover promoting spend reviews at Acquisition > Campaigns > Value Evaluation.

Placing It All Collectively

Having arrange the Google Analytics reporting detailed above, we then generate two stories to assemble a “Gross Revenue after Promoting” report.

  • Gross Revenue by Class
  • Promoting Value by Class

Export these reviews from Google Analytics and mix right into a spreadsheet. Identify the spreadsheet “Gross Revenue after Promoting” and it’s executed. Now you can monitor profitability for every of your product classes.


You may also like...