Show Menu
Cheatography

RMMAX Test Cheat Sheet by

Data Pulling

adv_­data
Opera-like data on advert­iser, publisher, device levels
adv_­ove­rsp­end
Overspends of clients
audi­enc­e_r­each
Audience and Reach of account
bucket
Temporary and current bucket of account
budget
Current budget of account
comp­_wi­n_i­nt/­ext
Internal and external compet­ition win
conf­ig_­cam­paign
TOP config­uration of campaign
feed
Latest feed quality
onsite
Account's visitors, sales, OV on-site o
tier­ing
Tiered down/up accounts
top_­pro­ducts
Clicks, displays, sales for top products

Utilities

cmail
Send email with text and data
curr­ency
Currency format for number
data­dum­p_e­xcel
Merge existing excel file with dataframe
nice­tab
Nice tabular format for dataframe
perc­ent
Percent format for number
quer­y_v­/sql
Query Vertica and SQL.
smar­t_d­ates
Give two dates for a string of period
upda­te_­pwd
Update password for running queries
upda­te_­rmmax
Update rmmax with latest version
 

Perfor­mance

acco­unt­_ta­rget
HOUSE account's target
achi­eve­ment
Indivi­dua­l/Team achiev­ements
belo­w_t­arget
CPO/COS vs account's target
comp­_sl­ides
Compet­ition slides
crit­eo_­con­tri­but­ion
Criteo contri­bution on all account's sales
incr­eme­nta­lity
Increm­ent­ality report
indi­vid­ual­_ta­rgets
Individual targets
mark­et_­tar­gets
Market targets

Global analysis

back­_in­_time
WoW, QoQ, YoY of dataframe
churn
All churned clients
cpc_­cha­nge­_si­mul­ator
Forecast perfor­mance with different CPC
fore­cas­t_c­lient
Forecast account's perfor­mance
rete­ntion
Retention, stop&go, and impact of paused accounts
seas­ona­lity
Season­ality of account

Unusual Patterns

fraud
Suspicious user behavior
frau­d_p­ubl­isher
Suspicious publisher behavior
ga_s­ess­ion­s_d­isc­rep­ancy
Discre­pancies with Google Analytics
Trou­ble­shoot
Troubl­eshoot perfor­mance issues (Shiny)
 

Account

bucket
Temporary and current bucket of account
churn
All churned clients
comp­_wi­n_i­nt/­ext
Internal and external compet­ition win
crit­eo_­con­tri­but­ion
Criteo contri­bution to sales, OV
rete­ntion
Retention, Stop&Go, and impact of paused clients
seas­ona­lity
Season­ality of a client
tier­ing
Tiered down/up accounts
top_­pro­duct
Clicks, displays, sales for top products

Publisher

fb_p­erf
Facebook perfor­mance
land­ing­_rate
Account's landing rate
supp­ly_­hea­lth
Addres­sable and captured values per publisher

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

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.