Top sold products over time

[former_member357619]

Question from Tobias Schneider:

I have a question: I would like to create a report which shows the top sold products over time. Do you know which data sources I should choose for that use case and how to link them?

That would be really great!

Best regards

Tobias

[former_member357619]

Hi Tobias,

from which source does the product & revenue come from?

In case you import the data for Analytics, you may use standard query C_MKT_RevenueQ (Revenue Query) based on the import table directly from the “Analytics and Report Gallery”.

Import Data for Analytics: https://help.sap.com/viewer/0f9408e4921e4ba3bb4a7a1f75f837a7/1805.500/en-US/9295f855b62efb37e1000000...

The table does not contain the Product ID, but custom fields.

Regards, Karla Brandl

[SCHNEIDERT]

Hi karla.brandl,

the data is coming from ERP and a Hybris Commerce WebShop.

So I thoght about sum up the "Amount" of the "SALES_ORDER"-interactions based on product id.

E.g. that is an import in the Marketing Cloud that comes from a commerce webshop:

Do you think it is possible to use that data for creating a report like I need it?

Best regards

Tobias

[former_member357619]

Hi Tobias,

there is no standard analytical SAP data source available on the interaction product level.

Available is data source "I_MKT_CampaignSuccessCube" ("Campaign Success") on interaction level, which provides "Amount" & "Currency".

Based on this data source, you may build a custom analytical query by using fields "Amount" & "Currency". But, as pointed out, this is on interaction level, not on interaction product level.

Regards, Karla