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

    • Ad Choices Logo - how is it applied at XM

      If you get any questions related to an ad that does or doesn't have an ad choices logo in the corner (the lil blue triangle in the example ad below): This is controlled by the supplier/DSP. For DV360: This is related to "Online Behavioral Advertising ...

    • CM Video Specs

      As a best practice, here are CM's video specs.  The below can and should be provided to account teams for the creative houses: The maximum size allowed is 1 GB. Always upload a source file with the highest possible specifications you have ...

    • Suppliers and media types that should always be site served

      The following should always be booked as site served: Amazon direct Amazon via a DSP like DV360 or TTD should be 3p served Anzu Apple News Eastward Media Fox Business News video Gimbal Google Responsive ads GSP Hulu direct Hulu via a DSP Jack'd/Perry ...

    • How to pull a media spend report from CM

      video walk through here! https://xmediany-my.sharepoint.com/:v:/g/personal/nickki_duban_xmedia_com/EYCTlU7bz8xOr1P3Nr7sU5cBce1jyC0M0QqnLwaoDBjNng?e=ckOgoP Step-by-Step Directions: Navigate to the reporting area of the adserver by hitting the four ...

    • XM General url appends breakdown for urls

      If the brand doesn't have something specific in mind, talk to adops about using these as the template for the url appends. For URL appends: Google: utm_source=where the media is running utm_medium=display, video, native, etc - whichever applies best ...