...

The right column is based on an attribution of the E-shop Transactions and Revenue from the E-shop data as well as the Margin (if available) from the E-shop or ERP data as per the following Diagram:

...

The attribution process can be described as follows:

1. The Shopping Performance Data is aggregated with the following dimensions:

   • Date

   • Device

   • Campaign Id

   • Offer Id (i.e.: one id per Product Detail Page, even if each product variant is individually advertised)
     

2. For each defined attribution model (by default 'Google Ads - Last Click is the only one defined) each Google Analytics Transaction (according to GA4 data in BigQuery) is attributed to a traffic source and if applicable a GCLID (Google Click Identifier) and the Offer id related to this GCLID.
   
   GA4 plays therefore a key role to connect the Google Ads data with the E-shop/ERP data in this report.
   

3. The Google Analytics transaction ids are themselves mapped with the e-shop (and optionally the ERP) data in order to retrieve the Attributed: Transactions, Revenue, and Margin.

Differences between CENTER and RIGHT

...

As the following pages are taking the right columns as a basis for the Shopping analysis, it is important to understand where the numbers are coming from.

To help diagnose the causes of differences, we have added the controlling numbers:

1. GAds Offer Conv.: this the number of Google Ads Shoppings Conversions which have a valid offer id.
   Normally, they should match 100% the Google Shopping Ads Conversions
   

2. GAds Product Conv. this is number of Google Ads Shoppings Conversions which have an offer id which is mapped to an existing product in the e-shop
   If this number is very different than the first number, it means there is a problem to map the Google Shopping Offer Ids with the products of the e-shop
   

3. GA Item Conv.: this is the number of Google Ads Shoppings Conversions of dimensions (per date, device, campaignid and offer id) for which there was an attribution to Google Analytics data

   If this number is very different than the first number, it means there is a problem to map the Google Shopping Offer Ids and GCLIDS
   
   If this number is very different than the Attributed (Shopping) Transactions, it means there is a problem to map the Google Analytics Transactions with the E-shop Data