Manage Custom Fields

Here’s how to manage custom fields in your Administration settings in Bionic for Agencies.

Custom fields enable you to expand the data you want to track and account for in Bionic. Custom Fields give you flexibility around the data you store and report on in Bionic.

Custom fields can be used to:

  • Track additional data related to your placements
  • Build your naming conventions and custom tracking URLs
  • Enable mapping to other platforms or reporting purposes

Custom data fields can be used for Ads, Advertisers, Vendors, Programs, Campaigns, Placements, Orders, and Bills.

Here, we’ll cover how to:

  1. Access Your Organization’s Custom Fields
  2. Understand Custom Fields in Bionic
  3. Sort Your Custom Fields
  4. Search Your Custom Fields
  5. Add a New Custom Field
  6. Update a Custom Field
  7. Lock/Unlock Multiple Picklist Fields
  8. Deactivate & Reactivate a Custom Field
  9. Delete a Custom Field

Accessing Your Organization’s Custom Fields

Here is where to manage your company's custom fields:

  1. Click on Your Company Name in the Upper Right Corner.
  2. Click on Administration.
  3. Click on the Custom Fields tab.

A screenshot of how to access your Custom Fields tab as explained on this page.

A screenshot of the Custom Fields tab in your administration settings.

 

Understanding Custom Fields in Bionic

Custom Fields have an array of uses in Bionic and we allow them to be used in almost all areas of the platform.

When you create Custom Fields, you will associate the field with the type of object it will relate to. For example, if you create a Placement field called Tactic, it will enable you to identify a tactic for each placement in your media plan. Or, if you create a Campaign field for Objective, you can set a value that will apply to the campaign as a whole instead of individual placements.

These fields can then be utilized for a variety of purposes such as reporting, naming conventions, tracking URLs, and mapping.

You will find there are some existing Custom Fields that are automatically available including fields for DCM to support your DCM import file, and Advantage to support the Advantage import file. You will need to Activate these to utilize them.

A screenshot of the Custom Fields Table.

Each custom field has the following attributes:

  • Name – The name of the custom field.
  • Status – Active vs. Inactive.
  • Object Type – This attribute ties the custom data field to what level this field will apply to. For example, if it is a Placement Object Type, the custom data field will be available to be selected in the Media Plan as a custom column. If it is a Campaign Object Type, the custom data field will be available on the Campaign level as metadata. The available object types include Ad, Advertiser, Bill, Campaign, Order, Payment, Placement, Program, and Vendor.
  • Field Type – There are 4 Field Types to choose from:
    • Date – Date columns enable you to track informational dates not tied to Task due dates. Date format supported is mm/dd/yyyy.
    • Number - Number columns can represent any numeric value. You can set the number of decimal placements. Selecting "Can Be Totaled" adds a sum of the values at the bottom of your Media Plan.
    • Picklist - A text field that enables a predefined list of values for users to select from. Picklists provide consistency and easier entry when values are repetitive. Picklists also support codes for custom naming conventions or for importing data to external systems.
    • Text - Text columns offer the ability to free-type any text values up to 2000 characters. They can be used instead of Picklist columns when their expected values have little to no consistency, such as Job Numbers or PO Numbers.

NOTE: Field Types can be restricted to a set character limit length when using Picklist or Text.

  • Values – The number of values the custom field has.
  • Available To – Details if the custom field is available to All Advertisers or a specific Advertiser.
  • Association – The number of times the custom field has been used/associated with.
  • Description – An explanation of what the custom field represents and any other pertinent information.

A screenshot of the Lock Icon Displayed in the Custom Fields Table.

Lock Picklist

When Lock is selected, users can only select from the available list of values. When not locked (default), users can add to the list of values directly from the media plan. Locking is recommended when no other possible options are available or when standardization is critical.

Sorting Your Custom Fields

You can sort the Custom Fields Table by column header. Here’s how:

  1. Click on the sortable Column Header you’d like to sort by.

A screenshot of how to sort by Column Header.

 

Searching Your Custom Fields

In addition to sorting, you can also search for a specific money column using the search bar. The list of money columns will be narrowed by keywords entered.

  1. Type in the Search Bar (the full or partial) money column name.

A screenshot of how to search by Keyword.

 

Adding a New Custom Field

Here is how to add a new Custom Field for your organization:

  1. Click on New Field.
  2. Enter a Descriptive Name in the Name.
  3. Select Object Type.
  4. Select Field Type:
    1. DateWhen selected, the custom field will have a date format of mm/dd/yyyy.
    2. PicklistWhen selected, you can enter the values for the picklist and set a maximum length for the each picklist value (up to 100 characters). Use the Sort A-Z to order the display of the values alphabetically. The picklist values also support short codes, please see Note below. When lock is selected, users can only select from the available list of values. When not locked, users can add to the list of values when updating a custom field.
    3. NumberWhen selected, you can set the number of decimal placements for the custom field as well as choosing if the values can be total as a summary at the bottom of your Media Plan.
    4. TextWhen selected, you can set a maximum length for the text value (up to 2000 characters). 
  5. Select if it is Available to “All Advertisers” or a specific Advertiser.
  6. Enter Description.
  7. Click Save.

NOTE: For Picklists Field Type, if values need codes associated with them for your custom Placement Name or extracting data to import to other systems, use the format: display name|code (see image below).  Alternatively, you can paste from Excel columns - display name in first column, code in 2nd column.  Bionic will automatically translate to the appropriate format.

note-for-picklist-field-types


A screenshot of step 1 on how to add a custom field.

A screenshot of the add new field dialog when adding a custom field.


If Field Type Date is selected:
A screenshot of selecting the date field type when adding a custom field.


If Field Type Picklist is selected:
A screenshot of selecting the picklist field type when adding a custom field.


If Field Type Text is selected:

A screenshot of selecting the text field type when adding a custom field.


If Field Type Number is selected:
A screenshot of selecting the number field type when adding a custom field.

A screenshot of the add new field dialog and how to save a new custom field.

 

Updating a Custom Field

Once a Custom Field has been added, you can update some of its attributes such as name, advertiser restrictions and description. If Field Type is a Picklist, you will be able to update the values in the Picklist. If you are an Administrator of the account, you will also be able to Lock the Picklist.

Here’s how to update a Custom Field:

  1. Click on the Custom Field name in the Name header.
  2. Update the editable fields.
  3. Click Save.

NOTE: Depending on the Field Type selected, Editable Fields may vary. You cannot change Object Type, Field Type, and Maximum Length once a field has been created.

A screenshot of step 1 on how to edit custom fields.

A screenshot of the editable fields when updating a custom field.

Lock/Unlock Multiple Picklist Fields 

When working with Picklist fields, the values that are available in the menu of options can be locked to ensure that users cannot modify the list. If you lock the values, only an Administrator user will be able to modify this list.

  1. Click on the checkbox(es) next to the Name of the Custom Field Picklist you want to Lock/Unlock.
  2. Click on the Lock/Unlock.

A screenshot of how to lock or unlock a custom field.

 

Deactivating & Reactivating a Custom Field

If you have Custom Fields that you no longer want users to see, you can deactivate them.  This will retain historic data where it was used in the past, while making it unavailable for use in the future. You can also reactivate Custom Fields that have been deactivated.

Here is how to deactivate/reactivate Custom Fields:

  1. Use the checkbox next to the name to select which Custom Field(s) to deactivate/reactivate.
  2. Click on the Deactivate or Activate button as appropriate

A screenshot of how to deactivate or reactivate a custom field.

 

Deleting a Custom Field

Here’s how to delete a Custom Field:

NOTE: Custom Fields can only be deleted if they are not in use. Otherwise you would either Deactivate, or remove the field from anything it is associated with.

  1. Use the checkbox to select which Custom Field(s) to delete.
  2. Click on the Delete.

A screenshot of how to delete a custom field.

 

Next Steps: