You may think that matching products to videos is all you need to create a video commerce experience; but what if the shopper does not get a relevant video or product? Clearly, there is much more when it comes to product and video matches.

We've created a solution that enables you to evaluate product to video matches in order to improve primary product coverage. The result: your shoppers have more relevant videos when shopping for products.

Match levels 

What exactly do we mean by "primary products"? and "recommended products"? There are three levels of product to video matches:

  • Recommended - The product is potentially related to the video. Useful when associating products to a video.
  • Associated - The product is related to the video. Useful when you are trying to upsell or cross-sell products.
  • Primary - The product is an exact match to the video. Useful in category or product detail pages (PDP) so the shopper may watch the video that is exactly about that product.

All these match levels exist in your account to some extent. For example, you may have more associated products than primary products (low coverage). How would you know this?

All you have to do is create an export schedule to retrieve a csv, txt or zipped file of all product with video matches. All accomplished within the TVPage video commerce cloud.

In addition, you can configure the schedule to update daily (or any update cycle of your preference) with one of these three export filters:

  • Primary Associated - Retrieves all primary products associated with videos
  • All Associated - Retrieves all products associated with videos in your account
  • Recommended - Retrieves all videos recommended with products in your account

Although you cannot export one file with two or three filters, you can export all three files with one different filter for each. 

Create an Export Schedule

Configuration

  1. Log in to your TVPage account and go to the Schedule Manager under the user menu

2. Click SCHEDULE and select Product With Video Export

3. Provide the following:

  • Label - Enter an identifiable name like "Primary Product Associations", "All Product Associations", "All Product Recommendations", etc.
  • Export URL - Enter an FTP URL in order to download your file
  • Delimiter - Comma, pipe or tab 
  • Enclosure - Double quotes, single quote or space
  • Schedule Cycle - Select the update cycle for your schedule. Enter a short cycle if you will export regularly. Although the shortest cycle is one (1) day, you don't have to wait one day to get the most recent record. Press the RUN NOW button to get the current record (continue reading).
  • Filter - You can use one filter per file. If you plan to export one of each, be sure to name your schedule respectively.
  • Active - If you are not going export regularly, leave it OFF. Remember to turn it back ON once you need it.
  • Press Save once complete

Run Job

1. To finish creating you export schedule, press the Run Now button. If you skip this step, your export file will not be created. As mentioned earlier, once your schedule exists, and you happen to associate some products, press the Run Now button to update the export schedule and see your recent associations in the csv.

2. Go to the Job Manager by clicking the link in the confirmation alert

or accessing it in the user options

3. Make sure the job is Complete

Download and Open File

1. Your file is available in the export URL. To download your file, go back to the Schedule Manager, click on the schedule, and press the Download File link:

2. When you open your file, be sure to provide the same delimiter and enclosure used when you created the export schedule

3. The following fields are present in the file:

  • Id = Video ID
  • referenceId = Product SKU
  • __grouporder__ = natural order between product and video associations
  • title = Video Title
  • thumbnailUrl = Video Thumbnail

Primary Associated

The export file will only include all videos that are are associated with primary products. Let's say video A and video B have product 1 as a primary product. The CSV will look something like this:

Video A (video id) - Product 1 (product sku)
Video B (video id) - Product 1 (product sku)

Although you can have primary product with different videos, remember that this feature is to help maintain exact product to video matches. A primary product with one unique video will retrieve a unique video in a PDP. 

In the TVPage VCC, primary products are identified with a star:

All Associated 

The export file will only include all videos associated with products. The file might include a primary product but not because it cares about the primary product; it only retrieves videos that have product associations.  Let's say video A has product 1 as primary product, and products 2 and 3 as non primary. The csv will look something like this:

Video A (video id) - Product 1 (product sku)
Video A (video id) - Product 2 (product sku)
Video A (video id) - Product 3 (product sku)

One way to see the products associated to a video is in the PRODUCTS section within the video details page:

Recommended

The export file will only include all videos that have product recommendation. Even if the video has product associations of any kind, it will only include the product recommendations.  Let's say video A has 3 products assigned (products A, B, and C) and 10 products recommended (products 1, 2, 3, etc.). The csv will look something like this:

Video A (video id) - Product 1 (product sku)
Video A (video id) - Product 2 (product sku)
Video A (video id) - Product 3 (product sku)
Video A (video id) - Product 4 (product sku)
Video A (video id) - Product 5 (product sku)
Video A (video id) - Product 6 (product sku)
Video A (video id) - Product 7 (product sku)
Video A (video id) - Product 8 (product sku)
Video A (video id) - Product 9 (product sku)
Video A (video id) - Product 10 (product sku)

You can view a video's recommended products in the RECOMMENDED section in the PRODUCTS section within a video details page:

Increasing Coverage

One way to increase primary product coverage is to export a All Associated file and a Primary Associated file. 

In the All Associated csv, filter out those with primary products. Once those are removed, assign primary products to the rest of the videos.

Perhaps there are more creative solutions or improvements within the TVPage VCC. Don't be afraid to send us your feedback!

Continue

Next article in Management Settings: Network - Manage your Contributor Network.

Did this answer your question?