Edit

Product recommendation prediction (preview) sample guide

  • Article

[This article is prerelease documentation and is subject to change.]

This guide walks you through an end-to-end example of product recommendation prediction using sample data. We recommend that you try this prediction in a new environment.

Important

  • This is a preview feature.
  • Preview features aren't meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.

Scenario

Contoso is a company that produces high-quality coffee and coffee machines. They sell the products through their Contoso Coffee website. Their goal is to understand which products should they recommend to their recurring customers. Knowing what customers are more likely to purchase can help them save marketing efforts by focusing on specific items.

Prerequisites

Task 1 - Ingest data

Review the articles about data ingestion and connecting to a Power Query data source. The following information assumes you are familiar with ingesting data in general.

Ingest customer data from eCommerce platform

  1. Create a Power query data source named eCommerce and select the Text/CSV connector.

  2. Enter the URL for eCommerce contacts: https://aka.ms/ciadclasscontacts.

  3. While editing the data, select Transform and then Use first row as headers.

  4. Update the datatype for the columns listed below:

    • DateOfBirth: Date
    • CreatedOn: Date/Time/Zone

    Transform date of birth to date.

  5. In the Name field on the right-hand pane, rename your data source to eCommerceContacts.

  6. Save the data source.

Ingest online purchase data

  1. Add another data set to the same eCommerce data source. Choose the Text/CSV connector again.

  2. Enter the URL for online purchases data https://aka.ms/ciadclassonline.

  3. While editing the data, select Transform and then Use first row as headers.

  4. Update the datatype for the columns listed below:

    • PurchasedOn: Date/Time
    • TotalPrice: Currency

  5. In the Name field on the side pane, rename your data source to eCommercePurchases.

  6. Save the data source.

Ingest customer data from loyalty schema

  1. Create a data source named LoyaltyScheme and select the Text/CSV connector.

  2. Enter the URL for loyal customers https://aka.ms/ciadclasscustomerloyalty.

  3. While editing the data, select Transform and then Use first row as headers.

  4. Update the datatype for the columns listed below:

    • DateOfBirth: Date
    • RewardsPoints: Whole Number
    • CreatedOn: Date/Time

  5. In the Name field on the right-hand pane, rename your data source to loyCustomers.

  6. Save the data source.

Task 2 - Data unification

Review the article about data unification. The following information assumes you are familiar with data unification in general.

After ingesting the data, begin the data unification process to create a unified customer profile. For more information, see Data unification.

Describe the customer data to be unified

  1. After ingesting the data, map contacts from eCommerce and Loyalty data to common data types. Go to Data > Unify.

  2. Select the tables that represent the customer profile – eCommerceContacts and loyCustomers.

    unify ecommerce and loyalty datasources.

  3. Select ContactId as the primary key for eCommerceContacts and LoyaltyID as the primary key for loyCustomers.

  4. Select Next. Skip duplicate records and select Next.

Define matching rules

  1. Choose eCommerceContacts : eCommerce as the primary table and include all records.

  2. Choose loyCustomers : LoyaltyScheme and include all records.

  3. Add a rule:

    • Select FullName for both eCommerceContacts and loyCustomers.
    • Select Type (Phone, Name, Address, ...) for Normalize.
    • Set Precision Level: Basic and Value: High.

  4. Add a second condition for email address:

    • Select Email for both eCommerceContacts and loyCustomers.
    • Leave Normalize blank.
    • Set Precision Level: Basic and Value: High.
    • Enter FullName, Email for the name.

    Unify match rule for name and email.

  5. Select Done.

  6. Select Next.

View unified data

  1. Rename the ContactId for loyCustomers table to ContactIdLOYALTY to differentiate it from the other IDs ingested.

  2. Select Next to review and then select Create customer profiles.

Task 3 - Create transaction history activity

Review the article about customer activities. The following information assumes you are familiar with creating activities in general.

  1. Create an activity with the eCommercePurchases:eCommerce table.

  2. Select SalesOrderLine for the Activity Type and PurchaseId for the Primary key.

  3. Enter the following information for the activity:

    • Activity name: eCommercePurchases
    • TimeStamp: PurchasedOn
    • EventActivity: TotalPrice
    • Order line ID: PurchaseId
    • Order date: PurchasedOn
    • Amount: TotalPrice

  4. Create a relationship between eCommercePurchases:eCommerce and eCommerceContacts:eCommerce with ContactID as the foreign key to connect the two tables.

  5. Review your changes and then select Create activities.

Task 4 - Configure product recommendation prediction

With the unified customer profiles in place and activity created, run the product recommendation prediction.

  1. Go to Insights > Predictions.

  2. On the Create tab, select Use model on the Product recommendations (preview) tile.

  3. Select Get started.

  4. Name the model OOB Product Recommendation Model Prediction and the output table OOBProductRecommendationModelPrediction.

  5. Select Next.

  6. Define model preferences:

    • Number of products: 5 to define how many products you want to recommend to your customers.
    • Repeat purchases expected: Yes to include previously purchased products in the recommendation.
    • Look back window: 365 days to define how far the model will look back before recommending a product again.

    Model preferences for the product recommendation model.

  7. Select Next.

  8. In the Add purchase history step, select Add data.

  9. Select SalesOrderLine and the eCommercePurchases table and select Next. The required data is automatically filled in from the activity. Select Save and then Next.

  10. Skip the Add product information and Product filters steps because we don't have product information data.

  11. In the Data updates step, select Monthly for the model schedule.

  12. Select Next.

  13. After reviewing all the details, select Save and Run.

Task 5 - Review model results and explanations

Let the model complete the training and scoring of the data. Review the product recommendation model explanations.

Task 6 - Create a segment of high purchased products

Running the model creates a new table, which is listed on Data > Tables. You can create a new segment based on the table created by the model.

  1. On the results page, select Create segment.

  2. Create a rule using the OOBProductRecommendationModelPrediction table and define the segment:

    • Field: ProductID
    • Value: Select the top three product IDs

  3. Select Save and Run the segment.

You now have a segment that is dynamically updated which identifies the customers who might be interested in purchasing the five most recommended products. For more information, see Create and manage segments.

Tip

You can also create a segment for a prediction model from the Insights > Segments page by selecting New and choosing Create from > Insights. For more information, see Create a new segment with quick segments.

Next steps