This article will help you to:

  • Hide a metric and/or a dimension
  • Rename metrics and/or dimensions
  • Bookmark a metric and/or a dimension
  • Create a calculated metric at the Dataset level
  • Change aggregation and type of metrics

What is "Manage dataset"?

Once your data source is connected, you can customize the metrics and dimensions of your dataset with "Manage dataset".

Go to "Manage dataset"

In the "Data Source" tab, select the desired data source and click on "Manage dataset".

You can then customize all the metrics and dimensions at your disposal.

What are the functionalities at your disposal?

Rename a metric and/or a dimension

To do this, select the desired metric or dimension and then change its name in the space provided.

How to hide a metric and/or dimension

Select the desired metric and/or dimension and then click on the eye nearby (1).

Thus, from the Builder mode, you will only have access to the metrics and/or dimensions relevant to your project and your reading will be facilitated.

Bookmark a metric and/or a dimension

Select the desired metric and/or dimension and then click on the star nearby.

This method is very useful to quickly access these elements in Builder mode. Indeed, when you bookmark a metric or a dimension, they appear first and save you precious time!

Create a calculated metric

Some of the metrics you use are not available natively although they are essential for your reports. You can create these metrics automatically on Reeport.

To do so, you can do the following:

  • Click on "create calculated metric"
  • Enter the desired formula in the box provided. Please note that your formula is written from the metric IDs. In addition, each metric must follow the following syntax: {{metric ID}}. Note that you can enter the first letters of the metric you want to use and Reeport will highlight the corresponding metrics to make it easier for you.

Don't forget to name your metric as desired. It will then be available in Builder mode under the given name.

Modify the aggregation of metrics and dimensions in the case of a database connection or flat file integration

This feature is particularly useful if you want to change the aggregation of your data to meet your reporting needs. The following types of aggregation are available:

  • Sum: Reeport adds up each line of the relevant metric
  • Mean: Reeport is the average of each line of the metric concerned.
  • Count: Reeport counts the number of lines of the metric in question.
  • Distinct: Reeport makes a single count of the metric concerned.
  • Min: Reeport returns the minimum value of the metric concerned
  • Max: Reeport returns the maximum value of the metric concerned

You can also change the type of your metric and dimension according to your needs and switch from one to the other if you wish.

Create a calculated dimension

Same way as you create your calculated metric, you can create calculated dimensions which is extremely useful when you have a direct connection to API.

After clicking on create calculated dimension, you will have an opportunity to choose a dimension of origin, which will go thorough series of logical rules to deduce value for your calculated dimensions.

There are several logical rules which you can access in Reeport:

1. Regular expression

2. Not regular expression (Excludes the observation which corresponds Regular expressions)

3. Contains

4. Not contains

5. Equal

6. Not equal

7. Else

Different logic rules can be combined to create a more complicated case by using logic operators OR (TRUE when any of the conditions is true) and AND (TRUE only when all conditions are true).

For each rule you can chose what value should be assigned to calculated dimensions using operator THEN.

Finally, it is important to keep in mind that there is a priority of order, so, if an observation corresponds two rules, it will be assigned to the rule which goes earlier.

If you use several data source, it would be easier for you to create calculated dimensions simultaneously for each data source. If you do not need it at all, or it is impossible to create it, you can create an empty calculated dimension. If there is a need for same calculated dimension in a different data source, as long as all dimensions are created in the same order, you can simply blend your data on the level of granularity of this dimension. For example: your conversions came from Google analytics, and your costs came FB ads, to get the cost per conversion on different level of granularity calculated dimensions would be very helpful, especially, when two API don’t follow the same policies in naming, so you can create ‘common denominator’ based on different campaign naming.

Did this answer your question?