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