Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

NERDT Get Functions Cheat Sheet by

Vertica Commands

get-im­ps-­buy­eri­d-s­ell­eri­d-i­nterval
Returns all imps transacted between a given buyer and seller member
get-imps-buyerid-sellerid 668 357
 
get-im­ps-­dealids
Gets impres­sions transacted on deal ID
get-im­ps-­dealids 95674
 
get-im­ps-­cam­pai­gni­ds-­int­erval
Returns all imps on a given campaign on a given interval
get-im­ps-­cam­pai­gni­ds-­int­erval 10488813 7d

Campaign Troubl­esh­ooting

get-ca­mpa­ign­-de­alids
Gets campaigns for deal ID
get-ca­mpa­ign­-de­alids 56256,­56262 
 
get-pr­ofi­le-­cam­pai­gnids
Gets profile for campaign ID
get-pr­ofi­le-­cam­pai­gnids 4223456
 
get-do­mai­n-l­istids
Provides domains on list for given list ID
get-do­mai­ns-­listids 6836

Creative Troubl­esh­ooting

get-ca­mpa­ign­-cr­eat­iveids
Gets campaigns for creative ID
get-ca­mpa­ign­-cr­eat­iveids 36844676
 
get-li­nei­tem­-cr­eat­iveids
Gets line items for creative ID
get-li­nei­tem­-cr­eat­iveids 27895619
 
get-br­and­-cr­eat­iveids
Gets brand of the creative
get-br­and­-cr­eat­iveids 111221­2,1­112211 
 
get-cr­eat­ive­che­cks­-cr­eat­iveids
Gets standard inform­ation on creative ID
get-cr­eat­ive­che­cks­-cr­eat­iveids 35491073
 
get-ad­xch­eck­s-c­rea­tiveids
Runs adx checks for creative ID
get-ad­xch­eck­s-c­rea­tiveids 111221­2,1­112211
 
get-fa­ceb­ook­che­cks­-cr­eat­iveids
Conducts Facebook checks on creative ID
get-fa­ceb­ook­che­cks­-cr­eat­iveids 111221­2,1­112211 
 
get-cr­eat­ive­-ke­yword
Finds creative by keyword
get-cr­eat­ive­-ke­yword double­click
 
get-cr­eat­ive­-fo­lderids
Gets all creatives in folder ID
get-cr­eat­ive­s-f­old­erids 482036­,482034
 
get-at­tri­but­e-c­rea­tiveids
Gets attributes for creative ID
get-at­tri­but­es-­cre­ati­veids 111221­1,1­112212
 
get-au­dit­sta­ts-­cre­ati­veids
Gets audit UI details for creative ID
get-au­dit­sta­ts-­cre­ati­veids 353390­37,­353­39039
 
get-au­dit­-cr­eat­iveids
Gets audit inform­ation for creative ID
get-au­dit­che­cks­-cr­eat­iveids 111221­1,1­112212 
 
get-ad­xsn­ipp­et-­cre­ati­veids
Retrieves creative snippet from AdX API
get-ad­xsn­ipp­et-­cre­ati­veids 111221­2,1­112211
 
get-sh­erl­ock­rea­son­s-c­rea­tiveids
Gets sherlock data for creative ID
get-sh­erl­ock­rea­son­s-c­rea­tiveids 33333333
 
get-br­and­-name
Finds brand by name
get-br­and­-name coke

Troubl­esh­ooting Deals

get-de­al-­codes
Returns AppNexus deal object ID and basic details for a given external deal code.
get-de­al-­dea­lcodes 443884­788­437­221614
 
get-de­alc­hec­ks-­dealids
Gets deal troubl­esh­ooting inform­ation on deal ID
get-de­alc­hec­ks-­dealids 29303,­29310
 
get-pa­rtn­erc­ent­ers­ett­ing­s-m­emb­erids
Provides inform­ation about how a member is intera­cting with other members on console
get-pa­rtn­erc­ent­ers­ett­ing­s-m­emb­erids 243,1813

Sell-side Troubl­esh­ooting

get-de­bug­url­-pl­ace­mentids
Gets debug url for placement ID
get-de­bug­url­-pl­ace­mentids 5433154
 
get-pl­ace­men­t-c­ust­omc­ate­goryids
Gets placements / placement groups for custom category ID
get-pl­ace­men­t-c­ust­omc­ate­goryids 27419
 
get-placement-memberids-categoryids
Returns placements charac­terized by a specific universal category id in a specific member
get-pl­ace­men­t-m­emb­eri­ds-­cat­ego­ryids 243 45
 
get-do­mai­nau­dit­sta­tus­-do­mains
Looks up domain audit status for a given domain
get-domainauditstatustool-domains cnn.com,abc.com
 
get-ca­teg­ory­-na­meslike
Finds category by name
get-ca­teg­ory­-na­meslike gambli­ng,­sports
 
get-ad­pro­fil­e-a­dqu­ali­tyr­uleids
Gets ad profile for AQ rule ID
get-ad­pro­fil­e-a­dqu­ali­tyr­uleids 223044
 

Metadata

  • Languages:
  • Published: 3rd November, 2015
  • Last Updated: 12th May, 2016

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          More Cheat Sheets by iherdt