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 > Unique ID Column Overview

Unique ID Column Overview

Introduction

The Unique ID column is found in both the Keywords and Creatives tabs. To bring it into your view:
 

  1. Click on the View Builder.
     
  2. Select Advanced under Columns in the left-hand menu.
     
  3. Select the checkbox next to Unique ID.
     

vb.png

How is the Unique ID column populated?

The column is populated only for keywords and creatives generated in the Platform for which the URL Builder and Tracking ID parser settings are set up correctly.

Once keywords and creatives are created in the Platform, the system will look for the Tracking ID designated in the parser settings and populate this value in the Unique ID column for that object.

When are Unique IDs are created/updated?

  1. When a keyword URL is first created (either on bulk upload or sync).
  2. If there is a duplicate found and Auto-Correct is kicked off.
  3. If the "Keyword ID" section of the Tracking IDs page is updated.

Reasons why the Unique ID column Might Be blank

The Unique ID column will be blank if:

  • Keywords or creatives were first generated on the publisher side and then synced to the Platform.
  • URL Builder or Tracking ID parser settings are not configured correctly.
  • Microsoft creative URLs use {param1}

How to fix the issue

If the Unique ID column is missing its value but the Unique ID can be seen in the URL, no fix is required, however, if you need the column to be populated for reporting purposes, you can edit the Unique ID column manually using a bulk upload. Additionally, you may find that you need to rebuild your URLs if you're trying to assign a different Unique ID or if the Unique ID is not populating in your URL.

In order for the Platform to apply a unique ID in both the Unique ID column, and in the URL, you will need to upload a bulksheet with the following headers:
 

  • For keywords: Account, Campaign, Group, Keyword, Match Type, Landing Page, and Custom Parameters 
     
  • For creatives: Creative ID, Account, Campaign, Group, Landing Page, and Custom Parameters 
     

Note that in order for the Platform to detect that changes are being made to the objects that require a unique ID, you will need to change something small. For example, you can add at the end of the Landing Page URL before the ?

Once uploaded, objects should now have a Unique ID and a Tracking ID in the URL as expected.

how To manually insert a Unique ID value for a keyword or creative

If the Unique ID column is missing its value but the Unique ID can be seen in the URL, no fix is required, however, if you need the column to be populated for reporting purposes, you can edit the Unique ID column manually using a bulk upload. Additionally, you may find that you need to rebuild your URLs if you're trying to assign a different Unique ID or if the Unique ID is not populating in your URL.

 

Note: This process now only applies to non-Google publishers, following Upgraded URLs. For Google-specific instructions, please read our Support Center article

 

  1. Generate a report of objects that are missing the Unique ID value (including columns: Destination URL, Unique ID).
     
  2. Open the report and remove all the report detail rows (detail rows should be Rows 1-9) so that only the column headers and values are included.
     
  3. Copy the Tracking ID within the Destination URL into the Unique ID column.

    Example: http://www.example.com?mwkid=abc123de&pcrid={creative}

    In this example, the Tracking ID parser settings indicate that the Tracking ID is the mkwid value (abc123de).
     
  4. Insert abc123de as the value under the Unique ID column for that object.
     
  5. To do this easily for many items, you can use a formula in the Unique ID column to populate it with the mkwid value in Excel.

    For example: To extract the mkwid value from the URL mentioned above, you can use the following formula:
    If the destination URL is in cell A1: =MID(A1,FIND("&pcrid",A1)-8,8)

    If all URLs have the same format, you can simply drag this formula down for all other items, e.g. row two formula would be like this: =MID(A2,FIND("&pcrid",A2)-8,8) etc.
     
  6. Re-upload this report back into the Platform.
Last modified

Tags

Classifications

This page has no classifications.

 

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