IF YOU ARE A RETAILER (NETRIVALS USER)

This feature allows you to connect your Google Analytics data (such as sales figures and traffic) directly with NetRivals. By identifying your top-selling products through Google Analytics, you can make informed, data-driven decisions regarding pricing and merchandising.

Feature Overview

The Sales Performance interface is structured into four main sections:

1. Search tab: Filter by brand, category, tags, and date range. You can also perform an advanced search by clicking the button in the top-right corner.
2. Data (KPIs): View high-level metrics including Profit, Views, Units sold, Revenue, Conversion Rate (CR), and Price AVG. Clicking any metric will display its trend on the graph to the right.
3. Graph: Visualise your selected data trends on a daily, weekly, or monthly basis.
4. Products tab: Access granular, item-by-item performance details across your catalogue.

Products Tab Details

The Products tab provides detailed insights arranged across several columns:

1. Favourites (grey heart): Click the grey heart in the left column to bookmark key items, such as top-sellers or products requiring closer monitoring.
2. Product: Lists the products included in your catalogue. You can filter this list at any time.
3. Price AVG: Shows the average product price over the last 7, 30, or 90 days, depending on the active filter.
4. Price today: The price of the product today.
5. Margin: The calculated profit margin percentage for the product.
6. PI today (Price Index): Indicates your price competitiveness compared to competing sellers:
   • Green: Your price is lower than competitors linked to this product.
   • Yellow: Your price is equal or similar to competitors.
   • Red: Your price is higher than competitors.
7. GA Views: Total number of visits to the product page.
8. GA Units sold: Total number of units sold.
9. Revenue: Total revenue generated by the product.
10. Profit: Net profit obtained.
11. CR (%) (Conversion Rate): The percentage of visits resulting in unique purchases. For example, a 70% CR indicates that 70% of people who visited the product page completed a purchase.

Connecting Google Analytics with the Sales Performance Module

Choose the integration guide below that matches your current setup:

Scenario 1: Standard Google Analytics 4 (GA4) Integration

To integrate your Google Analytics 4 from scratch, follow the step-by-step process below:

View the standard integration presentation

Click on the image or link above to view the full guide or follow the steps below: 

1. Grant Permissions in GA4: In your Google Analytics 4, navigate to Admin > Property Access Management. Add and provide an email address with Editor or Administrator permissions to the NetRivals team.
   Note: Should you have more than one store, you are only required to share one master email.
   Any doubts with this step? Visit GA4 Support website here.

   

    

2. Module Initial Setup: The NetRivals technical team will configure the initial setup for your Sales Performance module. Please wait for confirmation from the team before proceeding to the next step.
    

3. Link BigQuery in GA4: Once you receive confirmation from the NetRivals team, go to your GA4 property and click Admin > BigQuery links. Click Link, then locate and select the BigQuery project created by NetRivals (the project name will follow a format similar to: NR_SalesPerformance_ClientName) and confirm.
   Note: If you have more than one store, repeat this linking step for each store; you will see as many projects listed as you have stores.

   
    

4. Configure Data Settings and Submit: Complete the BigQuery link setup by choosing your data configuration options:

   • Location: EU is preferred, but you can select your preferred region.
   • Frequency: NetRivals exports data daily; you may select any option (Daily is recommended).

   Submit the configuration to finalise the link.
   
   
    

5. Final Validation: Notify NetRivals once the setup is submitted. Wait for final confirmation from the NetRivals team confirming that your module is active. Please note that data can take up to 24 hours to display fully within the NetRivals platform.
    

Scenario 2: When your Google Analytics BigQuery project is already linked

In case your Google Analytics BigQuery is already linked to a project in Google Cloud Platform, contact the person with project access and follow the steps below:

Download the PDF guide: Sales Performance Integration – Project Already Linked (GA4)

1. Access Service Accounts: Log in to the Google Cloud Console, select the appropriate project, and navigate to IAM & Admin > Service Accounts.
   
   
    
2. Create a Service Account: Click + Create Service Account. Enter a name and description, then grant the BigQuery Admin role under "Grant this service account access to project" to allow data exports.
   
   
    
3. Generate a JSON Key: Open your newly created service account, go to the Keys tab, click Add Key > Create new key, and choose JSON format (do not choose P12). Save the file securely.
   
   
    
4. Retrieve BigQuery Dataset Name: In the left-hand navigation menu, select BigQuery > SQL workspace to find your dataset name (e.g., analytics_xxxxxxxxx) in the Explorer section.
   
   
    
5. Submit Details to Support: Send the downloaded JSON Key file and your BigQuery dataset name(s) to the NetRivals team. (Note: If you have configured multiple domains in Google Analytics, please provide each corresponding dataset name.)