Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.
Home > English > Your Marin Account > Grids, Tabs & Columns > How To Articles: Grids, Tabs & Columns > Custom Columns

Custom Columns

Introduction

Custom Columns allow you to create a new column based on your own definition, using the metrics that are available in Marin to customize metrics to your precise specifications.

For example, if you have a metric that is unique to your business, you can input the metric's precise formula as a Custom Column, making it available for use in the grid, reports, Saved Views, Dashboards, and more.

Let's look at a few examples of how Custom Columns can be used. 

  • Lifetime Value: Track customer lifetime value as a % of revenue. For example, if your customer lifetime value is 2.5x, their initial order creates the following column: Lifetime Value = [Revenue] * 2.5.
  • Room Nights per Conversion: If you have a Conversion Type called Room Nights, and want to know the average number of Room Nights per Order, you can create the a column with the following formula: Avg. Room Nights = [Room Nights Conversions] / [Conversions].

Ready to get started creating your own Custom Columns? Keep reading to learn how to create, edit, and manage your Custom Columns. 

In this article, we'll cover using Custom Columns in both MarinOne and Marin Search.

Managing Custom Columns


In MarinOne

Custom Columns can be managed from two different locations in MarinOne:

  • From any grid, click on the Column Selector, select Custom, and click the Manage Custom Columns button
  • From the left-hand navigation, click on the Admin button ('gear' icon), then select the Custom Columns sub-tab. 

Both options will take you to the Custom Columns page, where you can create, edit, delete, and manage your Custom Columns. We'll walk through each of these in the following sections. 

 

cc1.jpg

 

Once your Custom Column has been created, it can be added to the grid from any tab by clicking on the Column Selector, selecting Custom, and adding it to the grid, where it can be used just like any other column. 

 

cc2.jpg

 

In Marin Search

Custom Columns can be created and managed on the Custom Columns tab in the Admin section. We'll talk more about creation in the next section.

creating custom columns


in MarinOne

  1. The first step, as always, is to log into MarinOne. 
     
  2. From the left-hand navigation, click on the Admin button ('gear' icon)
     

    cc3.jpg


     
  3. Next, click on the Custom Columns sub-tab.

     

    cc4.jpg


     
  4. Above the grid, click on the Create button ('plus sign' icon)cc5.jpg

     


     
  5. This will launch the Custom Column creation pane. This is where you will build the definition of your new Custom Column and apply other important details.
     

    cc7.jpg


     
  6. Give your Custom Column a name that matches the naming conventions you use in your MarinOne Client Account or a name that meets the needs served by your new Custom Column.
     

    cc6.jpg


     
  7. Next, from the Column Definition field, you'll start building out the formula that will be used to define this column.
     

    cc8.jpg



    Column names are indicated using Square brackets [ ]. Custom Columns can use standard mathematical operations including add (+), subtract(-), multiply,(*) and divide (/). Group operations can be created using Parentheses ( ). For example: ([Impressions] + [Pub. Cost]) / [Clicks].

    For your convenience, there's a list of metrics and columns available at the right-hand side, which you can use to build your Custom Column. You can filter this list using the Search bar above the available columns. Clicking a column in the list will add it to the end of your current Custom Column calculation, but it can be copied/pasted into your definition in any location that suits your needs.
     

    cc9.jpg

     

  8. At the bottom of the Custom Column creation pane, you can identify the Number Format of your new Custom Column. Click the drop-down to select Decimal, Percent, or Currency.
     

    cc10.jpg


     
  9. Lastly, click Save. That's all there is to it! 
     

    cc11.jpg

In Marin Search

Custom Columns are created and managed on the Custom Columns tab in the Admin section. Click Create to define a new Custom Column. The columns that can be used in the definition are listed in the search box on the right. This list can be filtered by typing in the name of the column. Clicking a column in the list will add that column to the end of the calculation. 

using custom columns

  • Custom Columns cannot contain hyphens in any of the values. For example, if any of your conversion types include hyphens in their name, you may receive an error similar to the following:
     
Column Name: Non_space__dash__space_Revenue_space__dash__space_Conversion_space__dash__space_MT_space_Conv_dot_ not valid for this client.

 

  • Please ensure that all of the conversion types you add to your Column Definition are valid. This means they cannot be deleted, spelled incorrectly, etc.
     
  • Change columns can be used in Custom Columns by appending either 'Change' or 'Change %' to the name of the column. For example, to use the the Clicks change column, you would use [Clicks Change].
     
  • Conversion Types can be used as an input to calculated columns. Custom Columns that use Conversion Types tracking both Date of Click and Date of Conversion will calculate both scenarios. When viewing this column in the grid, the data displayed depends on whether you are toggled to view Date of Click or Date of Conversion data.
     
  • If your Custom Column is not calculating correctly, check out our troubleshooting article Custom Column Formula Not Calculating Correctly. This article originally written for Marin Search, but also applies to Custom Columns in MarinOne. 

Using Custom Columns in Custom Columns

Nested Custom Columns​ can use other Custom Columns within their definition. 

Depending on the length and number of Custom Columns being used, you may experience performance issues when generating this column in the grid and when running reports. 

Editing Custom columns


In MarinOne

  1. The first step, as always, is to log into MarinOne. 
     
  2. From the left-hand navigation, click on the Admin button ('gear' icon)
     

    cc3.jpg


     
  3. From the list of available Custom Columns, click the check-box next to the Custom Column you wish to edit. 
     

    cc12.jpg

     

  4. Above the grid, click on the Edit button ('pencil' icon)cc13.jpg
     
  5. From here, you can apply your desired edits to your Custom Column.
     

    cc8.jpg



    Column names are indicated using Square brackets [ ]. Custom Columns can use standard mathematical operations including add (+), subtract(-), multiply,(*) and divide (/). Group operations can be created using Parentheses ( ). For example: ([Impressions] + [Pub. Cost]) / [Clicks].

    For your convenience, there's a list of metrics and columns available at the right-hand side, which you can use to build your Custom Column. You can filter this list using the Search bar above the available columns. Clicking a column in the list will add it to the end of your current Custom Column calculation, but it can be copied/pasted into your definition in any location that suits your needs.
     

    cc9.jpg
     

  6. Lastly, click Save. That's all there is to it! 

In Marin Search

From the Custom Columns tab in the Admin section, select the check-box next to the column you would like to edit, and then click the Edit button ('pencil' icon)

deleting custom columns


In MarinOne

  1. The first step, as always, is to log into MarinOne. 
     
  2. From the left-hand navigation, click on the Admin button ('gear' icon)
     

    cc3.jpg


     
  3. From the list of available Custom Columns, click the check-box next to the Custom Column you wish to edit. 
     

    cc12.jpg


     
  4. Above the grid, click on the Delete button ('trash can' icon)cc13.jpg
     
  5. This will trigger a warning, confirming the action that will take place if you proceed.

    Note: This action cannot be undone. Be certain this is the action you wish to take before you proceed.
     

    cc14.jpg


     
  6. Click Continue. That's all there is to it!
     

    cc15.jpg

In Marin Search

From the Custom Columns tab in the Admin section, select the check-box next to the column you would like to edit, and then click the Delete button ('X' icon)

Valid Columns for use in Custom Column Definitions


Impr.
Clicks
CTR %
Pub. Cost
Avg. CPC
Avg. Bid
Headroom %
Avg. Pos.
Conv.
Conv. Rate %
Cost/Conv.
Revenue
Rev./Conv.
Rev./Click
ROAS
Gross Profit
GP/Conv.
GP/Click
GPOAS %
Profit
Margin %
Profit/Click
ROI %
Ad Serving Fee Chg. %
Agency Fee
Agency Fee Chg.
Assist Adj.
Assist Rev.
Assists

Note: If your Conversion Type name contains an '&', you will not be able to use this Conversion Type in the column definition.

Errors with custom columns


  • If you are having issues when creating or editing Custom Columns​, please see the help article Unable to Parse Formula Definition. Though this article was created for Marin Search, the information is relevant to Custom Columns in both MarinOne and Marin Search
  • If you encounter the error Could not execute JDBC batch update, please read our help article on that subject. Though this article was created for Marin Search, the information is relevant to Custom Columns in both MarinOne and Marin Search
  • Reports with '0' in the Custom Column formulas may cause discrepancies in metric data over a given period.

Important notes


  • Creating, editing, and deleting Custom Columns in MarinOne or Marin Search will also sync the corresponding update to the other platform.
  • Using certain special characters, including ampersands '&', dashes '-', dollar signs '$' and colons ':' in the Conversion Type name may result in an error when. We therefore recommend using plain text-only names where possible.

    To resolve this issue, please remove the special character from the Conversion Type and Column Header names. The Custom Column that references these Conversion Types or Column headers will update correspondingly. Do not edit the Conversion Type's ID, as this might impact your conversion tracking.
  • When naming Custom Columns, please do not use any name that is already in use as a column in the Platform, as this will cause confusion when running calculations.
  • You may experience slower page loads when including Custom Columns in the grid view, depending on the complexity of the column's calculation. This usually occurs when using Nested Custom Columns -- i.e. using existing Custom Column definitions to calculate new Custom Columns. One way to alleviate this is to lay out the calculation in its most raw format.
  • If your Custom Column data is not appearing, make sure that all appropriate information is available in the platform. For example, if your Custom Column is for ROI or Multi-click Conversion, make sure your Tracker Revenue has been uploaded or nothing will appear in your Custom Column.
  • We do not currently support the creation of Custom Columns that calculate metrics spanning multiple Marin Client IDs.
  • Unlike most pages in MarinOne, the Custom Columns page uses pagination. This means that if you have a lot of Custom Columns, these will be visible across multiple pages, rather than on a single page. If you do not see the Custom Column you need, it might simply be available on another page. Try adjusting the number of visible rows or navigating to the next page to find a specific Custom Column.
Last modified

Tags

Classifications

This page has no classifications.

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")