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) ⭐