XMTD formula and instructions for adding CM ID for DSP creative names

XMTD formula and instructions for adding CM ID for DSP creative names


If you're ever in an instance where you work in an DSP and you need the CM Placement ID to the DSP creative name, here's how you'd do it so you don't have to manually add the id to the name in platform.

Idea
CM Placement name and ID = DSP creative name and ID

How to use excel to add the placement id to the placement name

  1. Open the tag sheet you've received from AdOps. 
  2. Go to the next available blank column on the tag sheet
  3. paste the following formula into the blank column:
    1. =CONCATENATE(first placement name cell &"_"&first placement id cell)
    2.       depending on your tag sheet, the formula may be slightly different but a sample would look like this: =CONCATENATE(J12&"_"&F12)
  4. drag the formula down
  5. check to make sure the 'new' name is what you want it to be
  6. copy the formulas and then paste values to make them actual text

like this:


  1. OPTIONAL: copy and paste values of the 'new' placement name you've made into the existing placement column.
    1. if you do this, do so with care
This is commonly used with Youtube but can also be used with The Trade Desk or another DSP where the CM placement id is needed.

Formula breakdown

the formula takes two cells and adds the contents together, inserting an underscore between the placement name and the placement id

=
opens the equation
concatenate
what you want the formula to do
(
opens the formula
placement name cell
collects the placement name
&
tells the formula to add another parameter
"_"
specifically adding the underscore
&
tells the formula to add another parameter
placement id cell
collects the placement id
)
closes the formula


    • Related Articles

    • Dynamic Creative Optimization (DCO) and You - executing with AdOps

      Your client team or their creative house says 'let's do DCO!' First thing's first. Reach out to technology@xmedia.com The immediate next steps are not included in this KB. This KB will focus on the after a DCO partner is chosen, not the steps to ...
    • XM Standard naming conventions

      Below are Crossmedia’s standard naming conventions, inclusive of examples for campaign, placement, creative and utm structure for DNAV media – Display, Native, Audio & Video - purchased via direct supplier or programmatically. Each of the pieces ...
    • Publisher Side - Specifying creative to different same size ad containers on one page

      This article will discuss specifying which creative will run in different same-sized ad containers on a single publisher’s webpage. Please note XM AdOps does not control this! The publisher will need to complete on their end and placements will need ...
    • OSD FAQ

      A running list of OSD, frequently asked questions, nuances and how to solve for them. This is both agency and AdOps facing. There is a compressed table of contents to the right (see 'On this page'). You can also search the doc by hitting command and ...
    • Pausing a creative

      Pausing is used best to take a creative out of rotation temporarily. To pause the creative, do you want us to update the end dates or do you want us to unassign. Details on what happens with each is below. Updating the end date: we change the end ...