# Add analytics products

Source: https://help.cyreen.de/en/cap-explorer/kampagnen/kontaktbasiert/schritt-2/ | Language: en | Reviewed: 2026-11-02

Analytics products are the products whose sales are evaluated for the campaign. Without them, you cannot request the Performance dashboard. You enter them one by one or by file import.

## Before you start

- The campaign has been created, see [Create a contact-based campaign](https://help.cyreen.de/en/cap-explorer/kampagnen/kontaktbasiert/schritt-1.md). You can add analytics products at any time, also while the campaign is running.
- Products with the same **Group No.** belong to the same analysis group. What analysis groups are for is described in [Measuring campaign impact](https://help.cyreen.de/en/cap-explorer/auswertungen/messmethodik.md#analysis-groups). The [rules for analysis groups](#rules-for-analysis-groups) apply.
- As soon as the campaign has the status «Report Requested» or «Report Available», the analytics products can no longer be changed. Changes are then only possible in individual cases through the contact form.

## Bundle Size: make multipacks comparable

With the **Bundle Size** you bring multipacks to a common denominator. A crate of beer with 24 bottles, for example, gets the bundle size 24. A crate that is bought then counts like 24 single bottles and is comparable with the purchase of a single bottle.

- Whether you convert multipacks like this depends on the analysis you want. For single products and without conversion, enter 1.
- The bundle size affects the **Basket Size** key figure (average sales). The **Conversion Rate** does not change.

## Rules for analysis groups

These rules apply to analysis groups. The examples come from a campaign for iced tea.

| Rule | Works | Does not work |
|---|---|---|
| One campaign can have multiple analysis groups. | Group 1 «Advertised products» and group 2 «Whole category» | |
| One or more products can be assigned to an analysis group. | Group 1 with lemon iced tea and peach iced tea | |
| The same product can be in multiple analysis groups as long as the article description and the bundle size stay the same. A product only counts as a duplicate when all five fields (description, GTIN, group number, group name, bundle size) are identical. | Lemon iced tea in group 1 and in group 2 | Lemon iced tea twice in group 1 with all five fields identical. CAP Explorer then reports «Duplicate row» (manual entry) or «Duplicate record» (import). |
| Group number and group name belong together. Two analysis groups cannot have the same name. | Group 1 is called «Advertised products» in every row | Group 1 is called «Advertised products» once and «Promotion items» once, or groups 1 and 2 are both called «Iced tea» |
| A GTIN has the same description and the same bundle size everywhere. | The same GTIN appears in both groups as «Lemon iced tea 0.5 l» with bundle size 1 | The same GTIN has bundle size 1 in group 1 and bundle size 6 in group 2 |

In addition, a description belongs to exactly one GTIN. **GTIN**, **Group No.** and **Bundle Size** contain only digits, and the **Bundle Size** is not 0.

## Steps

### Enter a single product

1. **Open the gear menu**

   Click the gear icon in the **Action** column of the campaign. New with the upcoming CAP Explorer release.

   ![Campaign list with the gear icon in the Action column](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/01-zahnrad-oeffnen.webp)

2. **Choose Analytics products**

   In the menu, choose **Analytics products**.

   ![Gear menu with the Analytics products entry](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/02-analytics-products.webp)

3. **Add a new row**

   Under **Existing analytics products**, click **Add new**. An empty row appears.

   ![Existing analytics products section with the Add new button](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/03-add-new.webp)

4. **Fill in the row**

   Enter **Group No.**, **Analysis Group Name**, **Description**, **GTIN** and **Bundle Size**.

   [Video: A product row is filled in with group number, group name, description, GTIN and bundle size](https://help.cyreen.de/loops/kontaktbasiert-schritt-2-analyseprodukte/04-zeile-ausfuellen.mp4)

5. **Confirm the row**

   Click the check mark in the **Action** column. The product is checked and saved.

   ![Product row with the check mark in the Action column](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/05-zeile-speichern.webp)

### Enter many products by import

1. **Download the template**

   Click **Download template**. Always download the template in the CAP Explorer, so that you have the current version. Enter your products in the template. Allowed formats are .csv, .xlsx and .xls. The order and names of the columns must match the template, and every row needs values in all columns.

   ![Import section with the Download template link](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/06-vorlage-herunterladen.webp)

2. **Upload the file**

   Drag the file into the **Drag & Drop to Upload File or Click to Browse** field or click to choose it. The preview shows **Total Records** before anything is saved. Errors are shown in the window.

   ![Upload field with the preview of the import file](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/07-datei-hochladen.webp)

3. **Save the import**

   Check the preview and click **Save Products**.

   ![Save Products button below the upload field](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/08-import-speichern.webp)

## Result

All products appear under **Existing analytics products**. There you search, edit and delete them and download them as CSV. For the Performance dashboard, you need at least one visual and one analytics product in an analysis group.

![Existing analytics products list with the entered products](https://help.cyreen.de/media/kontaktbasiert-schritt-2-analyseprodukte/09-produkte-in-liste.webp)

## Rules and messages

### Who can change what, and when

- Changes are only possible as long as the campaign does not have the status «Report Requested» or «Report Available».
- Only users with the right to edit campaign products can change analytics products.

### Field rules

All fields are required.

| Field | Rule |
|---|---|
| **Description** (Article description) and **Analysis Group Name** | Spaces at the start and the end are removed. |
| **GTIN** | Digits only. |
| **Group No.** (Analysis group number) | Digits only, no upper limit. |
| **Bundle Size** | Required for manual entry, digits only, not 0. On import, an empty value or a numeric 0 is saved as 1. A 0 as text is rejected. |

### Rules between rows

The rules apply against existing products and against other rows of the same file.

- The combination of all five fields (Article description, GTIN, Analysis group number, Analysis group name, Bundle size) occurs only once. Only then is a product a duplicate. The same product may be in several analysis groups as long as the article description and the bundle size stay the same.
- One article description belongs to exactly one GTIN and vice versa. Spaces inside the description do not count.
- One GTIN belongs to exactly one bundle size.
- Group number and group name belong to each other one to one.

### Import

- One faulty row rejects the whole file. **Your file contains error, please fix and try again.** appears.
- The errors are listed under **Rejected File Errors**. If a row has several errors, they are separated by commas.
- The API can still reject individual rows. Its text then appears.
- Field errors appear as a tooltip on the row, API rejections as a toast.

### All messages

The messages appear in English.

| Message | When it appears |
|---|---|
| **Article description must not be empty** | The description is missing. |
| **GTIN must not be empty and may not contain letters** | The GTIN is missing or contains letters. |
| **Analysis group number must not be empty and may not contain letters** | The group number is missing or contains letters. |
| **Analysis group name must not be empty** | The group name is missing. |
| **Bundle size cannot be empty and may not contain letters** | The bundle size is missing or contains letters. |
| **Bundle size cannot be 0** | The bundle size is 0. |
| **Duplicate row** | Manual entry: all five fields match an existing product. |
| **Duplicate record. Check the import file for duplicate rows and check if the record is already added to existing analytics products.** | Import: all five fields match another row or an existing product. |
| **A specific Article Description must not be associated with multiple GTINs** | One description has several GTINs. |
| **A specific GTIN must not be associated with multiple Article Descriptions** | One GTIN has several descriptions. |
| **A specific GTIN must not be associated with multiple Bundle Size values** | One GTIN has several bundle sizes. |
| **An Analysis Group Name must not be associated with multiple Group Numbers.** | One group name has several group numbers. |
| **A Group Number must not be associated with multiple Analysis Group Names.** | One group number has several group names. |
| **Your file contains error, please fix and try again.** | Import: at least one row is faulty, the whole file is rejected. |
| **Multiple entries are not valid. Expand to see error details.** | A row has several errors. Expand it to see the details. |
| **Rejected File** and **Records with error** | Title and counter in the window with the rejected rows. |

**No Analytics Products added yet** is not an error, it is the text of an empty list.

## Problems?

**A row is rejected.** Check the row against the [rules for analysis groups](#rules-for-analysis-groups).

**The import shows errors.** The errors are listed under **Rejected File Errors**, see [Rules and messages](#rules-and-messages). Correct the file, which must match the format of the template, or edit the rows in the list.

**I can no longer change a product.** The Performance dashboard has already been requested. Changes are only possible through the contact form.

Watch the whole process as a video (45 seconds)

[Video: Whole process as a video](https://help.cyreen.de/loops/kontaktbasiert-schritt-2-analyseprodukte/ganzer-ablauf.mp4)