VIEW DESCRIPTION - PRODUCTS:
A comprehensive product performance report integrating data from key sources: Google Analytics 4, Google Ads Shopping campaigns, and Meta Ads Shopping campaigns. The report enables detailed conversion funnel analysis - from initial product views through add-to-cart events to purchase completion. By default, data is sorted by Google Analytics Net Revenue and displays the last 30 days of data, with customisable date ranges.
The report includes key performance indicators such as:
Google Analytics 4 conversion metrics (views, add-to-carts, checkout initiations)
Advertising campaign metrics (impressions, clicks, costs, ROAS) broken down by platform
Aggregated metrics from all connected advertising systems
Efficiency indicators: conversion rates, CTR, ROAS, and COS
Applied conditional formatting (highest values highlighted in green) facilitates quick identification of best and worst-performing products and potential areas requiring advertising budget optimization.
DATA VIEW CONCLUSIONS:
Check your best-performing products using your preferred metric. By default, the table is sorted by Google Analytics Revenue, but you can change the sorting to find products with the highest impressions, clicks or other metrics.
Review revenue and cost inconsistencies at the product level using conditional formatting. The highest values are highlighted in green, so if you notice color differences between revenue and costs for a product, it may indicate that you're either under-investing or over-investing in that product.
Verify if your bestsellers have impressions across all ad sources by comparing Revenue and Impressions across advertising platforms. For example, if your bestsellers don't have impressions in Meta Ads, this indicates you need to improve your product campaign segmentation and increase ad spend for these products in Meta Shopping Campaigns.
Compare Click-Through Rates (CTR = Clicks/Impressions) across advertising platforms to identify products with high consumer interest. A higher CTR indicates stronger market demand, as more users actively click on the product ads when they appear in search results or feeds.
Evaluate the correlation between ad spend and revenue (ROAS / COS) to identify products where increased advertising investment might yield higher returns, based on historical performance patterns.
Analyze the conversion rate by comparing view_item to add_to_cart events (ADD TO CART CR) in Google Analytics to identify product-specific drop-off points in the purchase funnel.
Use the Purchase Quantity metric to identify high-value products that might benefit from increased promotional focus or special campaign strategies.
TIME RANGE OF DATA
The report is created based on the last 30 days counted from yesterday.
DATA SCHEMA SPECIFICATION:
Product File:
Product Id - Product variant identification number.
Product Name - Product name.
Google Analytics 4:
Item Views - Number of view_item events from Google Analytics.
Add to Cart - Number of add_to_cart events from Google Analytics.
Checkouts - Number of begin_checkout events from Google Analytics.
Add to Cart CR - Ratio of add_to_cart events to view_item events from Google Analytics.
Purchase Quantity - Total quantity of products in purchase events from Google Analytics.
Net Revenue - Total net revenue value (excluding tax and shipping costs) from purchase events in Google Analytics.
Google Ads Shopping Campaigns:
Impressions - Number of product impressions from shopping campaigns in Google Ads.
Clicks - Number of product clicks from shopping campaigns in Google Ads.
Click Through Rate - Percentage ratio of clicks to impressions from shopping campaigns in Google Ads.
Net Costs - Total net cost value from shopping campaigns in Google Ads.
Conversions - Number of product conversions from shopping campaigns in Google Ads. Only main conversions that are campaign objectives are counted.
Net Conversion Value - Total net conversion value from shopping campaigns in Google Ads. Only the value of main conversions that are campaign objectives is counted.
ROAS - Ratio of net conversion value to net costs from shopping campaigns in Google Ads (Net Conversion Value / Net Costs).
COS - Ratio of net costs to net conversion value from shopping campaigns in Google Ads (Net Costs / Net Conversion Value).
Meta Ads Shopping Campaigns:
Impressions - Number of product impressions from shopping campaigns in Meta Ads.
Clicks - Number of product clicks from shopping campaigns in Meta Ads.
Click Through Rate - Percentage ratio of clicks to impressions from shopping campaigns in Meta Ads.
Net Costs - Total net cost value from shopping campaigns in Meta Ads.
Totals:
Total Impressions - Total number of product impressions from shopping campaigns across all advertising systems connected to the DataOctopus application. For example, if you have Google Ads, Meta Ads, and Bing Ads connected to DataOctopus, and a product received 1 impression from Google Ads, 1 from Meta Ads, and 1 from Bing Ads, the total impressions will be 3 (sum from all sources).
Total Clicks - Total number of product clicks from shopping campaigns across all advertising systems connected to the DataOctopus application. For example, if you have Google Ads, Meta Ads, and Bing Ads connected to DataOctopus, and a product received 1 click from Google Ads, 1 from Meta Ads, and 1 from Bing Ads, the total clicks will be 3 (sum from all sources).
Total Click Through Rate - Percentage ratio of clicks to impressions from shopping campaigns across all advertising systems connected to the DataOctopus application.
Total Net Costs - Total net cost value from shopping campaigns across all advertising systems connected to the DataOctopus application. For example, if you have Google Ads, Meta Ads, and Bing Ads connected to DataOctopus, and a product generated costs of 1 PLN from Google Ads, 1 PLN from Meta Ads, and 1 PLN from Bing Ads, the total net costs will be 3 PLN (sum from all sources).
ROAS - Ratio of net revenue from Google Analytics to total net costs from shopping campaigns across all advertising systems connected to the DataOctopus application (Net Revenue / Total Net Costs).
COS - Ratio of total net costs from shopping campaigns across all advertising systems connected to the DataOctopus application to net revenue from Google Analytics (Total Net Costs / Net Revenue).