Custom CDS View for Recommendation | Analytics&Report Gallery

[lisa_w]

Hey,

I would like to create a custom CDS view where I can open the impressions, click-through rate and conversion rate of my recommendations in Analytics & Reports Gallery.

Ideally with filtering by scenarios and months Unfortunately,

I cannot find a suitable data source in the CDS View creation. I can't find attributes for the recommendation anywhere. Can anyone help me how to build such a view with which sources?

Thanks for help.

Best regards

Lisa

[Abd_Am_K]

Hi lisa_w,

The impressions, click-throught rate etc should be captured in the different interaction types. You probably will have to calculate them if you are working with I_Mkt_* datasources. You can create your own measure column and use aggregation type sum on it to create the different rate measures. Check this link for how you can create a measure.

Alternatively you can use the C_MKT_InteractionQuery with I_Mkt_InteractionProduct to get to your numberofinteraction per RecommendationModel/scenario by InteractionUTCDate or InteractionTimeStampUTC.

Thanks,

Abdullah Amer

[Abd_Am_K]

Hi lisa_w,

You can request unreleased view by opening a ticket and stating which unreleased view you would like to get released. Regarding the empty ID's I dont know, I will need atleast a screenshot for the datasources for you cds view.

Thanks,

Amer

[lisa_w]

Hey Abdullah Amer,

I thought so. Thanks.

I have seen in the Custom Analytical Query view that the value is filled in correctly there. Only in the preview of the Custom CDS view is nothing displayed. That is ok, if I know that now.

I try to pack the impressions, click rate and conversion rate of the recommendations into a report.As it is in the Manage Recommendation App.I just want to use the report to filter a time limit. So that I can call up an evaluation of the recommendations per month.

But I can't find the data source for the impressions and etc. for the recommendations. This source is only available for Campaigns and that does not work. Or I have created a wrong link of the data sources here.

Currently I am trying out different data sources, which might fit or where I have set something wrong. Maybe what I have in mind won't work at all.

Best regards

Lisa

[Abd_Am_K]

Hi lisa_w,

I would recommend not to mix cubes and dimensions unless you know how to manage the cardinalities effectively. If you want to create your custom report for campaign interactions then try the I_Mkt_Interaction and I_Mkt_Initiative data sources.

Also checkout the video series I mentioned in the previous answer.

There are some Unreleased Recommendation data sources which you can request.

Thanks,

Abdullah Amer

[lisa_w]

Thanks for the tip. How can I learn to deal with the cubes and dimensions so that I can make full use of them? I mean, the data sources are there to be used.

I do not want to analyze the campaign interactions. I want a report on my Recommendations.

In that report I want to see the impressions, click through rate and conversion rate. Just like in the App Manage Recommendations. Only with the report, I can cluster the results by month. So you can compare them. To effectively improve them.

Is this project even possible?

The video series was already helpful. But it is the outdated view and therefore looks different. Maybe it is advisable for SAP to update and extend the documentation in the Custom CDS Views section. This might be an interesting topic for a webinar.

Best regards

Lisa

[Abd_Am_K]

Hi lisa_w,

Understood, there is an unreleased view I_MKT_ClickedRecommendationsC which you may request to get Released.

Alternatively if you want to create your report then I would recommend to use the I_Mkt_InteractionProduct and the I_Mkt_Interaction table only as this should cover your usecase. Prepare your fields before joining like add counters where needed. Add filters on the datasources before joining if needed. You can create the standard cds view for this purpose on top of your base tables.

Once you join the two tables and create a cube, you cannot add filters on secondary DS.

For knowledge on CUBES and Dimension you can check this link.

Hope this helps,

Abdullah Amer

[lisa_w]

Hey Abdullah Amer,

ok, that makes it easier to understand. Thanks.

Can you tell me where I can find out what the impressions, click-through rate and conversion rate for the recommendations are? I can't find these fields in the data sources, so I have to calculate them. Or is there a trick for this?

Best regards

Lisa

[Abd_Am_K]

Hi lisa_w,

Can you please check this answer here:

https://answers.sap.com/questions/13102023/custom-cds-views-selecting-data-sources.html

Using View Browser (Data Source search) and Custom CDS View Depricated (Data Preview) you can analyze which data sources best suits your development.

Thanks,

Abdullah Amer

[lisa_w]

Hey Abdullah Amer,

thanks for your answer.

i have already looked in the 2 apps, but the source is not shown and selectable in my CDS view or it is of no use to me. Is it maybe because not all data sources are released? How could I release such views if they are not my own?

Also, my Recommendation Model ID and Recommendation Scenario are not displayed in the CDS View. The values are always empty. I do not know why. Actually our shop gives the ID.

The documentation is not very informative and rather poor. 😕

Best regards

Lisa