How to Prepare A Data Studio Report

period

weekly data

overall

daily data 🚩

wave/campaign comparison

week day vs weekend

peak time/off-peak time comparison ⭐

WoW comparison

an important check point for campaign optimization ⭐

Overall performance

media & tracking data

Front-end Data
(usually include media & tracking data)

Back-end Data
(usually use tracking & GA data)

Branding/Social
imp,click,ctr
cpm,cpc engagement
(like,repost comment
follow etc.)
reach(frequency,uv)

Estimation vs Actual deliver

cross analysis with period dimension ⭐

Performance
Download, install ,(activate users),CPD, CPI/CPA

new users %,
duration
landing rate,
bounce rate
city distribution

User acquisition quality analysis ⭐

Other Dimensions

demographic analysis

gender, age group, city tier
TGI(interest label)

MAU

Creative analysis

a/b test

ad format analysis: dynamic/ still/ video

contextual relevant/ local relevant

An important landing page & TA accuracy check point ⭐

media/publisher/app analysis

Optional Dimensions
(depends on campaign purpose/approach)

destination

TA

channel

device

h5/landing page analysis

feature analysis
eg. word lens vs conversation :

click to download: drop rate

User journey analysis (thru drop rate analysis) ⭐