Skip to main content

Usage Data Dashboard and overage calculations

Get an overview of your platform usage to understand your billing processes better, and learn how the Productsup platform calculates overages.

Introduction

According to the Productsup License Agreement, you get access to the platform based on specific service entitlement. If you exceed your entitlement and overuse the platform, you face additional charges for overages. The platform automatically calculates overages based on particular metrics.

This document explains the formulas used to calculate excessive use of the Productsup platform.

The Usage Data Dashboard overviews your platform usage and helps you understand charges and overages. The Usage Data Dashboard shows the essential metrics affecting bills, such as SKUs, Export channels, Sites, Users, and Syndication frequency overages.

The Dashboard is available in the Billing section of the platform, and only account admins can access it.

You can also download the detailed usage reports in the CSV format.

To access the Usage Data Dashboard:

  1. Select your admin profile menu in the top-right corner and choose Billing.

  2. Select the Usage tab.

    Tip

    You can find metrics' meanings in the info boxes () next to each metric name.

    Usage dashboard

Metrics of overage calculations

The platform calculates overages for the following metrics:

Note

Overage calculations exclude the sandbox project usage.

Max SKU or Offer

The platform identifies the maximum SKUs imported or exported daily for each non-manual site run for every account or edition and calculates monthly overage. 

The formula for overage calculation is:

Overage = the highest SKU of a day within a month - your service entitlement

See the example of the overage calculations if the SKU entitlement is 5000:

Max SKUs

Export channels

The platform takes daily snapshots of the number of your configured main and standard export channels for every account or edition and calculates monthly overage. See Channel clustering to learn about different types of channels.

The formula for overage calculation is:

Overage = the total number of channels within a month - your service entitlement

Note

The platform doesn’t count the sandbox project’s export channels.

The overage calculations for the Export channels metric follow the principles of Channel clustering. See Channel clustering to learn how it works.

See the example of the overage calculations if the Export channels entitlement is 60:

Export Channels

Edition Users

The platform makes a daily snapshot of the number of users in each account or edition and calculates monthly overage.

The formula for overage calculation is:

Overage = the highest number of users daily within a month - your service entitlement

See the example of the overage calculations if the Edition Users entitlement is 10:

Edition Users

Onboarding Catalogs

The platform makes a daily snapshot of the number of sites or catalogs in every Seller/Vendor Onboarding Module in each account and measures monthly overage.

The formula for overage calculation is:

Overage = the highest number of catalogs within a month - your service entitlement

See the example of overage calculations if the sites or catalogs entitlement is 10:

Onboarding Catalogs

Syndication frequency overages

The platform makes a daily snapshot of the number of syndications per channel in each account and calculates monthly overage.

Warning

The platform doesn't count manual site runs triggered when you select the Export or Run buttons. However, if the manual site run triggers another site run, the triggered site run counts as syndication and increases the total sum of the syndication frequency count by one (1). To prevent the overages in this case, check the triggering settings of your sites in Scheduling. See Set up scheduling and triggering processes in Scheduling for more information.

The following example shows overage calculation.

Suppose the account has three (3) active channels: A and B are from site 1, and C is from site 2. The Syndication Frequency entitlement is 1.

The following syndication frequency happened during January 2021:

  • 01.01.2021: Three (3) syndication cases for channel A and one (1) – for each B and C channels.

  • 02.01.2021: Two (2) syndication cases for channel A, one (1) – for B, and two (2) – for C.

  • 03.01.2021: One (1) syndication case for each channel.

See the following table:

Syndication frequency daily snapshot

The platform doesn’t count the number of syndications but only the fact of exceeding the entitlement per channel per day and sums up these daily cases for a month. In this example, the number of daily syndications with overages on 01.01.2021 is only one (1) because only channel A exceeds the entitlement. On 02.01.2021, it is two (2) as two (2) channels exceed the entitlement. And on 03.01.2021, there were no overages. See the following table:

Number of daily syndication with overages

January overages equal the sum of one (1) exceeding syndication case on 01.01.2021 and two (2) cases on 02.01.2021, which makes three (3) in total for January. See the following table:

Overage results

Syndication Frequency Overages Details

You can view details of Syndication Frequency Overages per day:

  1. Select a necessary month bar on the Syndication frequency overages graph.

    Syndication Frequency Overages graph
  2. Select a necessary day bar on the day view of the Syndication frequency overages graph.

    Day view of Syndication Frequency Overage

The Syndication Frequency Overages Details table shows all sites that lead to overages. You can check the following metrics for each site in your account for a selected day:

  • Overage

  • Export Channels

  • Entitlement

  • Syndications

Syndication frequency

On the Syndication Frequency Overage Details table, you can do the following actions:

  1. Select another day.

    1. Open the day picker drop-down. The red dots in the upper-right corner of a day indicate the days with overages.

      day_selection_overages.png
    2. Select a necessary day.

  2. View the list of exports for each site and deactivate unnecessary exports to reduce overages.

    1. Select a number next to the necessary site in the Export Channels column to get to the Export Overview page of the site.

    2. Check the active exports and deactivate unimportant exports.

  3. View scheduling of each site.

    1. Hover over a necessary site line and select the View Scheduling button to get to the Site Scheduling page.

    2. Adjust your schedule to match your entitlement. See Schedule your site runs in Site Scheduling.

Channel clustering

The Productsup platform uses channel clustering to calculate overages for export channels. According to it, there are three types of channels in Productsup:

  • Standard - in green

  • Main - in yellow

  • Sub-channel - in red

Standard channels

A standard channel is a channel that doesn’t have category-specific channels associated with it. It is the most common type of channel.

Examples of standard channels:

  • Google Merchant Center

  • Facebook Dynamic Ads

  • Pinterest Shopping

To count standard channels on the site level, use the following formula:

The same standard channel added N times = N

Standard Channel

Main channels

The main channel is not a category-specific channel itself. Still, it can include category-specific channels associated with it, or you can add a main channel multiple times to a site to manually create category-specific exports. If a channel has different templates for different countries, they all count as individual main channels.

Examples of main channels:

  • Amazon Vendor US

  • Amazon Vendor UK

  • FabDis

To count main channels on the site level, use the following formulas:

  • The same main channel added N times = 1

  • N different main channels added = N

    Main channels

Sub-channels

A sub-channel is a channel that belongs to the main channel and contains category-specific information. However, there might be cases where a sub-channel doesn’t belong to the main channel because there are no main channels in the site. In this case, the platform creates a non-global placeholder main channel and associates sub-channels with it.

Examples of sub-channels:

  • Amazon Vendor - Computer Bags & Cases

  • FabDis - 00 Cartouche

To count sub-channels on the site level, use the following formulas:

  • The same sub-channel added N times = 1

    Sub Channel
  • N different sub-channels belonging to the same main channel = 1

  • Sub-channels from N different main channels = N

    Miltiple sites, different channels

Download the usage reports

You can download the detailed usage reports in CSV format. The reports contain information for one selected month with daily data. You get a zip folder named usage-report-YYYY-MM that consists of the following CSV files:

  • excluded sites with names

  • exports with names

  • max products with names

  • sites with names

  • syndication frequency with names

  • users with names

Note

You can download the reports only for the months starting November 2022.

To download the reports, do the following:

  1. Go to the Usage tab.

  2. Select the download icon.

    Download the Usage reports
  3. Select the year and month for the report.

    Download CSV report
  4. Select Download.

Tip

If the CSV files show all data in a single cell instead of separate rows and columns, you may need to set a delimiter in the Table settings of your tool:

For Numbers on MacOS, do as follows:

  1. Select the Table button.

  2. Select the Adjust Import Settings…button.

  3. Select comma (,) in Separate Value Using.

  4. Select Update Table.

For Microsoft Excel, do as follows:

  1. Go to the Data tab.

  2. In Get & Transform Data, select From Text/CSV.

  3. In Import Data, find and select your CSV file.

  4. In Text Import Wizard, select Delimited and select Next.

  5. Choose comma (,) or semicolon (;) as a delimiter and select Next.

  6. Check if the preview shows all the necessary columns highlighted and select Next.

  7. Choose the appropriate data format for each column, such as General, Text, or Date, and select Finish.

The Productsup Help Center doesn't bear any responsibility and accountability for the accuracy and relevance of the processes, features, UI elements, and other information mentioned in this tip instructions about third-party tools. The instructions aim to help you perform activities outside the Productsup platform.