Affiliate Partner Custom Report

This guide outlines how to access the new Custom Report feature that will be available in the Analytics section of the Partner Center. Below, we explain how you can use this feature to export data so you can see the success of creators and sellers participating in your campaigns.

Custom Report is a new feature within the Analytics section that has been designed specifically to help Affiliate Partners effortlessly access and export data so it can be viewed in Excel. This will help you better visualize the data and perform any necessary additional analysis in Excel, which can ultimately aid you in devising effective long-term strategies for future campaigns.

1. Enables customization of data: Customize filters and dimensions to fulfill key campaign review needs, such as getting hot product lists for specific campaigns and examining overall performance across campaigns.
2. Improves efficiency: Streamlines the process so campaign data can be easily viewed, exported and analyzed all in one place.
3. Offers enhanced Insights: Exporting enables further analysis and manipulation of data within Excel, empowering you to delve deeper into insights, leading to more informed decision-making and strategic planning.

Image

Case 1: I want to know the hot product list for a specific list of campaigns.

• You can use the Dimensions setting to select Time and Product, which will provide you with the following search result headings: Date, Product ID and Product name.
• Next, you can use the Filters option to add in your date range and the specific list of campaign IDs you want. Once you click on Search, you will be given the list of all products for the campaigns that meet your filter options. You can easily export this file to further analyze the data in Excel and filter the top-performing products across your campaigns.

Case 2: I want to know the overall performance for 3 campaigns.

• In order to see overall performance, simply select Time in Dimensions, (You will not need **** to select any other Dimensions) which will produce the following headings in your search results: Date, Commission, Revenue, Orders, LIVE GMV, Video GMV and Showcase GMV (these are the default headings when no Dimensions are selected).
• You can also use the Filters option to add your date range and input the campaign IDs for which you’re interested in overall performance. Once you click on Search, you will be given the overall performance for the 3 campaigns you selected in the filters.

Case 3: I want to know the creator list for several campaigns in weekly view.

• You can use the Dimensions setting to select Week (a week always starts on Sunday) and Creator, which will result in the following headings appearing in your search results: Date, Creator name and Creator nickname.
• Next, you can use the Filters option to add the specific campaign IDs for which you want to see creators. Once you click Search, you will be given the list of all creators in your selected campaigns.

Case 4: I want to know the collaborated progress of products with specific shops across several campaigns.

• You can use the Dimensions setting to select Time, Shop and Product, which will provide you with the following headings in your search results: Date, Shop ID, Shop name, Product ID and Product name.
• Next, you can use the Filters option to add specific Shop IDs and campaign IDs. Once you click Search, you will be given the list of all products and shops for the campaigns selected in your filter options. You can easily export this file to further analyze the data in Excel, including filtering the results further to understand which shops produce the most top-selling products.

Image

Go to: Partner Center > Analytics > Custom Report There are several sections within Custom Report, which we delve into below to help you understand how to effectively use this feature to export data. Note:

1. If an agency provides TSP or MCN/CAP services as well as the TAP services, at present they will only be able to see the Custom Report data in the region their TAP service is linked to.
2. For example: If an agency is registered as an MCN/CAP in both MY and ID but is registered as an Affiliate Partner in MY only, then they will only be able to open the Custom Report page in MY region.
3. The region in Custom Report will not automatically be the same as the region selected on other tabs of the Analytics section.
4. For example: An agency is registered as an ++MCN/CAP and Affiliate Partner++ in both MY and ID. While viewing data in the Video Analytics tab, they switch their region from ID to MY. However, when they open the Custom Report tab, the region will revert back to ID instead of remaining consistent with the region they were viewing in the Video Analytics tab.

Using Dimensions

Within the Dimensions section, you can select a number of different dimensions. Dimensions correspond to the headings displayed in your search results.

1. Time Dimension — Here, you can select from one of the below.
2. By Day
3. By Week (starting on Sunday)
4. By Month
5. By Entire Period (extends 6 months into the past and is selected by default when the time dimension is checked)

Image

1. Other Dimensions — you can multi-select any of the below. The only exception is that LIVE and Video cannot be selected together.

Note: When you select each dimension, all the types associated with that dimension are automatically selected and will be displayed in your results.

Image

Using Filters

Filters can help you better refine search results. You can select from the time filter as well as the categories, as detailed below.

1. Time — both fixed and dynamic time periods are supported, with the oldest date option 6 months in the past.
2. Fixed Date Range: Select your desired date range in the calendar box.
3. Dynamic Date Range: Select from one of the following:
4. Last 7 days
5. Last 28 days

Image

1. Creator Handle, Product ID, Shop ID, Campaign ID filters — each of these 4 filters supports single search as well as batch input. With batch input, you can separate each item by a comma and paste a maximum of 500 items per filter.
2. You can select whether you want to Include or Exclude the items you have pasted for each filter.
3. This section is useful as it allows you to refine your results so that the data displayed will only be for the items you have added into the filters.

Image Image

Exporting data

1. Once you have selected your dimensions and filters, press Search to get the corresponding results. You will see the total number of search results provided.

Note: If the number of search results is greater than 500, only the top 500 results will be displayed which you can view by navigating through the different pages. To view the additional results, you'll need to press Export, which will then export all results to Excel. Image To export this data to Excel, click on the Export icon on the right. This will automatically download all items into an Excel file that will be saved to your laptop. Image You'll also see the Export report icon, which lists previous reports you have exported and which you can still download within 7 days (max 500,000 records can be displayed). Image

1. Can I choose which corresponding type for a selected dimension I want in my search results?

No, you cannot select an individual type associated with the dimension. All types linked to the dimension will automatically be selected and displayed in your results. For instance, if you select the LIVE dimension, your search results will automatically display all associated types: Room ID, Livestream name and Time info.

1. Is Custom Report available for MCN/CAP or TSP service categories as well?

Currently, only Affiliate Partners can access Custom Report, but we will be launching this function for MCN/CAP in the next few months.