on 07-19-2018 2:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.