Understanding Revenue by Item Affiliation in Google Analytics 4
Analyzing revenue by item affiliation is crucial for businesses that sell products through multiple channels, brands, or categories. This analysis helps identify which product groupings or sales channels are driving the most revenue, enabling better inventory management and marketing resource allocation. We'll show you how to create this insightful report in Google Analytics 4.Basic Report Structure
- Report Type: Free Form Exploration
- Primary Dimension: Item Affiliation
- Metrics Focus: Revenue and Transaction metrics
- Visualization: Table format with optional bar chart
- Time Comparison: Ability to compare periods
Steps to Create the Report
- Open GA4 and navigate to Explore section
- Click the Blank template to start a new exploration
- Under the Dimensions click the + button and search for Item Affiliation, check the checkbox beside it and click Confirm
- Under the Metrics click the + button and search for Total Revenue, Items Purchased, and Average Purchase Price, check the checkboxes and click Confirm
- Drag Item Affiliation to the Rows section of your report
- Drag Total Revenue, Items Purchased, and Average Purchase Price to the Values section
- Click the Settings icon and set Row Numbers to show all rows
- Optional: Add a bar chart visualization by clicking the + icon in the Tabs section
- Set your desired date range in the report settings
Important Dimensions and Metrics
- Item Affiliation: Shows the grouping or channel of products
- Total Revenue: Total revenue generated from each affiliation
- Items Purchased: Number of items sold in each affiliation
- Average Purchase Price: Average price point for items in each affiliation
- Transactions: Number of sales transactions per affiliation
Actionable Insights
- Identify top-performing affiliations to allocate more inventory and marketing budget
- Spot underperforming affiliations that might need promotional support or restructuring
- Compare average purchase prices across affiliations to optimize pricing strategies
- Use transaction data to identify seasonal trends by affiliation
- Analyze which affiliations have the best revenue-to-item ratio for profitability assessment
Answers Similar Questions
- How to track sales by product category GA4
- View revenue by channel in Google Analytics 4
- GA4 item affiliation revenue report
- Track sales performance by product group GA4
- Google Analytics 4 revenue by product source