New Advanced Reports FAQ
New Advanced Reports FAQ
- What are the main changes introduced by the new data model?
- How’s attribution now computed?
- What does the removal of fractional conversions mean?
- How are foreign exchange rates now computed?
- How’s the click rank now computed?
- How’s the conversion rate now computed?
- How’s the recommendation conversion rate now computed?
- How’s transaction duplication now handled?
- How are product identifiers now normalized?
- Why do I no longer see the "Click rank with purchase" and "Click rank without purchase" metrics?
- Why do I no longer see the "Country" and "Is internal" filters?
Starting on November 17, 2023, the Advanced Reports (platform-ca | platform-eu | platform-au) of the Coveo Administration Console have switched to using the Coveo Core data model.
With the adoption of Coveo’s Core model, these reports now provide a more precise representation of essential commerce metrics and adhere to the latest industry standards.
Note
If you’re already using the Data Share or Snowflake reader account feature to access your data and create custom dashboards through self-service queries, your data should now be aligned with the Advanced Reports, as they’re now based on the same data model. |
If you were already using the Advanced Reports before the migration, you’ll notice that the value of some metrics has changed. This is because the new data model uses different formulas to calculate the metrics, which are more accurate and better aligned with industry standards.
This article aims at explaining the differences between the old and new data models and the impact of the migration on your reports.
What are the main changes introduced by the new data model?
How’s attribution now computed?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, transactions were attributed to a Coveo service (search, listings, or recommendations) based on client-side events, using the value of the event’s |
Transactions are now attributed to a Coveo service (search, listings, or recommendations) based on server-side events. These events are automatically sent when the Search API is queried. This ensures that all transactions are attributed to the correct service, even if the client-side events aren’t sent, or don’t contain the correct information. |
You should notice an increase in transactions counts and in revenue attributed to the different Coveo services. |
What does the removal of fractional conversions mean?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, a transaction that was attributed to multiple Coveo services was split among the different services. EXAMPLE
Consider a transaction that contains products A,B,C,D, and E:
In that case the transaction was split as follows:
This resulted in having 0.6 of the transaction attributed to Coveo services, and 0.4 of the transaction not attributed to any Coveo service. |
In Coveo’s Core model, transactions that are attributed to multiple Coveo services are counted individually. EXAMPLE
Consider a transaction that contains products A,B,C,D, and E:
In that case, one transaction will be attributed to the search service, one transaction will be attributed to the listings service, and one transaction will be attributed to the recommendations service. |
You’ll no longer see fractional transactions in your reports. For example, numbers like |
How are foreign exchange rates now computed?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, foreign exchange rates were statically configured to align with the exchange values of June 1, 2021. |
In Coveo’s Core model, foreign exchange rates are computed daily and cover all currencies. |
Transactions that were made in a currency other than |
How’s the click rank now computed?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, when a customer clicked many products following the same query (for example, by using a product’s Quick view or opening a result in a new tab), only the click action on the product that appeared highest in the results was considered. For example, if a customer searched for |
In Coveo’s Core model, when a customer clicks multiple products (from the same query), the average click rank is computed based on the position of each product that was clicked. For example, if a customer searched for |
You should notice an increase in click ranks, as the average click rank is now computed based on the position of each product that was opened. |
How’s the conversion rate now computed?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, the conversion rate was computed using the following formula:
This means that the conversion rate was computed based on the number of transactions divided by the total number of visits. |
In Coveo’s Core model, the conversion rate is computed using the following formula:
This means that the conversion rate is now computed based on the number of visits that contain at least one transaction, divided by the total number of visits. |
You should notice a decrease in conversion rates, as a visit that contains multiple transactions will now be counted as one converting visit. This is to avoid cases where conversions were greater than the number of visits. |
How’s the recommendation conversion rate now computed?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, the conversion rate attributed to the recommendations service was computed using the following formula:
This means that the recommendation conversion rate was computed based on the number of transactions attributed to the recommendations service, divided by the total number of click actions on recommendations. |
In Coveo’s Core model, the conversion rate attributed to the recommendations service is computed using the following formula:
The recommendation conversion rate is now calculated by dividing transactions attributed to the recommendations service by total visits with at least one recommendation event. |
You should notice a decrease in conversion rates attributed to the recommendations service, as |
How’s transaction duplication now handled?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, transactions that were sent more than once were counted multiple times. |
In Coveo’s Core model, transactions that are sent more than once are counted only once. |
If you were sending purchase events more than once, you should notice a decrease in transaction counts. |
How are product identifiers now normalized?
Previous state | New state | Effect on reports |
---|---|---|
In the previous data model, Coveo usage analytics (UA) employed a process of lowercasing product identifiers before associating a click event with a purchase event. For example, both a product named |
In Coveo’s Core model, product identifiers are treated as explicitly defined. For example, a product named |
If you were using different casing for your product identifiers, you should notice a decrease in transactions counts and revenue attributed to the different Coveo services. |
Why do I no longer see the "Click rank with purchase" and "Click rank without purchase" metrics?
The Click rank with purchase and Click rank without purchase metrics were removed from the Advanced Reports because they were providing limited additional value to users.
Why do I no longer see the "Country" and "Is internal" filters?
The Country and Is internal filters were removed from the Advanced Reports for performance reasons.
However, the Tracking ID and Device category filters are still available.