Sometimes reports you are looking to import contain ratio data such as click-through rate (CTR) or cost per action (CPA). As a general rule, we don't recommend using ratio fields directly from your import as the data may give inaccurate results 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 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 Custom Data Import data source and click Next.
- In the Select report type dropdown, select the data import you want to create the custom field for.
- 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. For percentages and ratios, select Divide.
- Then, specify the Divide (the number to be divided) and by (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, the data import you created the custom field for, and the custom field you just created.
Learn more about how to use custom fields in your reporting.