New Advanced Reports FAQ

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.

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 originLevel1 property.

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:

  • Product A is attributed to the search service

  • Product B is attributed to the listings service

  • Product C is attributed to the recommendations service

  • Product D and E aren’t attributed to any Coveo service

In that case the transaction was split as follows:

  • Search contributed to 0.2 of the transaction

  • Listings contributed to 0.2 of the transaction

  • Recommendations contributed to 0.2 of the transaction

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:

  • Product A is attributed to the search service

  • Product B is attributed to the listings service

  • Product C is attributed to the recommendations service

  • Product D and E aren’t attributed to any Coveo service

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 46.78 transactions attributed to the search service will no longer appear in your reports.

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.
Additionally, certain exchange rates were unavailable and were artificially assigned a value of 1.

In Coveo’s Core model, foreign exchange rates are computed daily and cover all currencies.

Transactions that were made in a currency other than USD will now have more accurate conversion rates.
Revenue metrics will show different values, meaning that they can increase or decrease depending on how the rates have changed since June 1, 2021.

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 boots, and then, in a new tab, opened the products listed in positions 1 and 9, the average click rank would be 1.

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 boots, and then, in a new tab, opened the products listed in positions 1 and 9, the average click rank would be 5.

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:

Conversion rate = conversions / visits

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:

Conversion rate = converting visits / visits

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:

Recommendation conversion rate = conversions attributed to recommendations / clicks on recommendations

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:

Recommendation conversion rate = conversions attributed to recommendations / visits with recommendations shown

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 visits with recommendations shown represents a higher number than clicks on recommendations.

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 product123 and another named PRODUCT123 were treated as identical. Consequently, if a customer initially clicked the first product (product123) and subsequently made a purchase of the second product (PRODUCT123), the credit for that purchase would be attributed to the initial click action on the first product.

In Coveo’s Core model, product identifiers are treated as explicitly defined.

For example, a product named product123 and another named PRODUCT123 are now recognized as distinct entities. Consequently, if a customer clicks the first product (product123) and later makes a purchase of the second product (PRODUCT123), the credit for the purchase is not linked to the initial click action on the first product but rather to the event that led the user to purchase the second product.

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.