Adding Calculated Columns
Bob’s Keywords provides the ability to create custom calculated columns based on your current data. Use custom calculated columns to combine your data into new fields that can bring different insights and help you find Negative Keywords.
The Calculated Columns option will be shown on the left menu after you click on “Find Negative Keywords” (or any of the Trusted Keywords Analysis options).
Click on the “Calculated Columns” option to show the Calculated Columns window.
Click the “Add New” button to add a new calculated column. A new panel is shown, and you can choose the fields and the operation to compose your new calculated column. Choose the fields and the operation from the dropdowns and type a new name for your new column. After filling all fields, click the “Add New” button again for a new column or click on the “Apply” button to make the new columns effective.
Currently, there are five ways of combining your columns:
- C1 + C2
- C1 – C2
- C1 * C2
- C1 ÷ C2
- (C1 ÷ C2) * 100 – (how much percentage of C2 the C1 field represents)
When you click the “Apply” button, Bob’s Keywords will refresh the view to reflect your newly added column(s). All new columns are added to the right of your Numeric Fields.
Calculated Columns are persistent. The next time you open your project, they will still be there.
If you want to remove a Calculated Column, click on the “minus” button located on the right of the calculated column panel. Click on the “Apply” button to save, and Bob’s Keywords will refresh the view to reflect the column(s) you’ve deleted.
You can add up to five Calculated Columns per Project, and they can also be used on Numeric Filters.
