For Reportei to interpret your spreadsheet correctly, you need to classify the data type of each column or row, depending on the spreadsheet’s layout. This ensures the data can be read, grouped, and displayed correctly in charts, tables, metrics, and filters.
Before configuring the integration, check these two key aspects of your spreadsheet:
1. Identify the spreadsheet layout
First, check how your data is organized and which of the following layouts your spreadsheet uses:
- Vertical spreadsheets: headings are in the first row, with data below them.
- Horizontal spreadsheets: headings are in the first column, with data alongside them in subsequent columns.
2. Check the decimal separator
Check that the spreadsheet’s decimal separator (a period or comma) matches the one configured for your Reportei project.
If they differ, change either the spreadsheet or the project settings so both use the same separator.
⚠️ Changing the project settings affects all reports and dashboards linked to that project. We therefore recommend changing the spreadsheet instead.
You can then identify and classify the column types.
Column and row types
When connecting the spreadsheet, specify the type of each column or row. For a vertical layout, classify each column. For a horizontal layout, classify each row.
The available types are:
- Metric
- Dimension
- Date
- Dimension/Metric
- Unidentified
Metric columns
These columns contain numeric values, usually used in calculations.
- Example uses:
- summing
- averaging
- counting.
- Examples of Metric data:
- Amount spent
- Reach
- Clicks
- Where it can be used:
- Number widgets
- Chart series
- Numeric columns in tables
Dimension columns
These columns are used to group or filter data and usually contain text or categories.
- Example data:
- Campaign name
- Channel
- Ad type
- Where it can be used:
- Filters in number cards
- Grouping in charts
- Text columns in tables
Dimension/Metric columns
These columns can be used as either a metric or a dimension: they can represent numeric values or categories.
- Example data:
- Country
- Traffic source
- Device
- Where it can be used:
- Anywhere that accepts dimensions or metrics
Date columns
These columns contain date values.
- Example data:
- Subscription date
- Campaign date
- Month.
Where it can be used:
- Date-range filters (reports, dashboards, and widgets)
- Time-based grouping in charts
- Display in table columns
Unidentified columns
If the system cannot automatically recognize a column’s contents, it is assigned the “Unidentified” type.
You need to review and classify these columns manually before using them. Otherwise, columns with this type are ignored when creating metrics and analyzing data.
Final tip
Correct column classification ensures your data is interpreted properly in every visualization. An incorrect or outdated classification can affect data retrieval, so check these details when importing your spreadsheet.
⚠️ Important: after you complete data classification in Reportei, you cannot edit it. Avoid changing the structure of the original spreadsheet, such as moving, adding, or deleting columns, because these changes can prevent the data from being read correctly. If you need to make a structural change, connect the spreadsheet to Reportei again as a new integration.