RMMAX Test Cheat Sheet

A cheat sheet in English by ivanov
6,184 views 1,950 downloads 27 Sep 2017 History
3.7 avg · 0 ratings

Data Pulling

adv_data
Opera-like data on advert­iser, publisher, device levels
adv_ov­erspend
Overspends of clients
audien­ce_­reach
Audience and Reach of account
bucket
Temporary and current bucket of account
budget
Current budget of account
comp_w­in_­int/ext
Internal and external compet­ition win
config­_ca­mpaign
TOP config­uration of campaign
feed
Latest feed quality
onsite
Accoun­t's visitors, sales, OV on-site o
tiering
Tiered down/up accounts
top_pr­oducts
Clicks, displays, sales for top products

Utilities

cmail
Send email with text and data
currency
Currency format for number
datadu­mp_­excel
Merge existing excel file with dataframe
nicetab
Nice tabular format for dataframe
percent
Percent format for number
query_­v/sql
Query Vertica and SQL.
smart_­dates
Give two dates for a string of period
update_pwd
Update password for running queries
update­_rmmax
Update rmmax with latest version

Perfor­mance

accoun­t_t­arget
HOUSE accoun­t's target
achiev­ement
Indivi­dua­l/Team achiev­ements
below_­target
CPO/COS vs accoun­t's target
comp_s­lides
Compet­ition slides
criteo­_co­ntr­ibution
Criteo contri­bution on all accoun­t's sales
increm­ent­ality
Increm­ent­ality report
indivi­dua­l_t­argets
Individual targets
market­_ta­rgets
Market targets

Global analysis

back_i­n_time
WoW, QoQ, YoY of dataframe
churn
All churned clients
cpc_ch­ang­e_s­imu­lator
Forecast perfor­mance with different CPC
foreca­st_­client
Forecast accoun­t's perfor­mance
retention
Retention, stop&go, and impact of paused accounts
season­ality
Season­ality of account

Unusual Patterns

fraud
Suspicious user behavior
fraud_­pub­lisher
Suspicious publisher behavior
ga_ses­sio­ns_­dis­cre­pancy
Discre­pancies with Google Analytics
Troubl­eshoot
Troubl­eshoot perfor­mance issues (Shiny)

Account

bucket
Temporary and current bucket of account
churn
All churned clients
comp_w­in_­int/ext
Internal and external compet­ition win
criteo­_co­ntr­ibution
Criteo contri­bution to sales, OV
retention
Retention, Stop&Go, and impact of paused clients
season­ality
Season­ality of a client
tiering
Tiered down/up accounts
top_pr­oduct
Clicks, displays, sales for top products

Publisher

fb_perf
Facebook perfor­mance
landin­g_rate
Accoun­t's landing rate
supply­_health
Addres­sable and captured values per publisher

Badges

Nice Cheat Sheet

Comments

No comments yet.

Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.