Adding Calculated Columns

Bob's Keywords - Mouse Image

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).

Finding Negative Keywords - Calculated Columns menu option

Click on the “Calculated Columns” option to show the Calculated Columns window.

Finding Negative Keywords - Calculated Columns 1

Click on 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 on the “Add New” button again for a new column or click on the “Apply” button to save.

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 on the “Apply” button, Bob’s Keywords will refresh the view to reflect your new added column(s). All new columns are added to the right of your Numeric Fields.

Finding Negative Keywords - Calculated Columns after being applied to your data

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.

Finding Negative Keywords - Calculated Columns 2