As a general rule, we don't recommend using imported ratios when using Supermetrics Custom Data Import. Data such as click-through rate and cost per action may give inaccurate data when aggregated to a different granularity than what they were in the original file.
Instead, we suggest creating a custom field for these percentages based on the raw source values. First, you’ll need to import the raw data using Custom Data Import and then you'll create the custom fields for percentage or ratio data. For example, click-through rate = Clicks / Impressions or cost per action = Spend / Actions.
Instructions
- Import your data using Custom Data Import as instructed in this guide.
Make sure to exclude the calculated data from the import. - On the Supermetrics Hub, go to Transform → Custom fields.
- Click New custom field.
- Select either dimension or metric and click Next.
This selection is based on the aspect of the data you aim to manipulate. For instance, if you're looking to calculate Click-Through Rate (CTR), you'd be working with metrics ('Clicks' and 'Impressions'). - Select the data source you want to apply a transformation to and click Next.
- Select Function as your transformation type.
This selection enables you to manipulate your selected data using a variety of mathematical or textual operations. - From the list of available functions, select the one that best suits your needs.
Each function exposes specific fields that you'll need to configure according to your use case. For example, if you selected 'Divide', you'll need to specify the 'Dividend' (the number to be divided) and 'Divisor' (the number to divide by) fields. - After configuring your function, click Next.
- Give a name for your custom field.
- Click Create custom field.
- In your data destination, select the Custom Data Import connector and the custom field you just created.
Learn more about how to use custom fields in your reporting.