At Glance: This guide will assist you to add customised columns in your report.
This section is accessible only for campaign reports, publisher reports, advertiser reports, daily reports, goal reports, hourly reports, smart link reports, manager reports, OS reports, and custom reports.
Trackier lets you customise your reports by adding columns that show data based on the formulas you create.
This feature allows you to make reports that meet your exact needs by using custom calculations that you can get from existing data fields. You can set up these formulas to do things like perform mathematical operations on other data columns, e.g., if you want to calculate the sum of approved conversion and pending conversion ("approved conversion + pending conversion"). This helps you create reports that are more meaningful and better suited to your analysis.
Adding Custom column
To add your customised column, you can navigate to the reports section on your panel and click on the "adding formula" button as shown in the screenshot attached below.
From here, you can select "add formulas" and a box for adding your custom formula will pop up, where you need to fill in the information accordingly:
Name: The name you want to give for your custom column.
Expression: Here, you can enter the formula that will determine how the custom column displays the data.
In the below screenshot, we have first selected "approved conversion," followed by the "+" operator, and then "pending conversion."
Show currency: You can turn this toggle on/off if you want to see the currency in which the field is calculated.
Show comma-separated: If you want to display the numbers in your customised column with or without comma.
Once you have set up your data, click the "Add" button to apply your changes. This will update the reports, adding your custom column and displaying the data according to your specified formula.
You can also add more than one customised column in your report.
Note: You can use only the provided options in your formula.
We're thrilled to have put together a top-notch team of qualified experts who are available to handle any of your concerns and respond to any inquiries you may have. You can contact us at any time by sending an email to support@trackier.com or using the in-platform chat feature.