►
Description
Sr Marketing Campaigns manager, Agnes Oetama walks through how to pull April 2022 Global Campaigns data from DG dashboard.
A
Hello,
everyone!
It's
me
again,
so
jenny
alerted
me
that
the
number
of
linear
saos
on
the
demand
dashboard
is
significantly
higher
than
the
number
in
the
pmg
dashboard.
So
we
decided
that
for
slide,
four
six
and
seven
on
our
deck,
which
is
really
the
campaign
summary
campaign
performance
by
channel
and
campaign
performance
by
offer
we're
just
going
to
use
the
dimension
dashboard
and
then
notate
that
on
slides,
9,
10
and
11
that
the
data
in
the
pmg
dashboard
is
actually
a
sao
account
is
lower
than
the
demand
gender
dashboard.
A
Just
because
there's
no
way
the
slice
and
dies
the
data
based
on
those
variables
like
on
slides,
9
and
10
and
11
on
the
dimension
dashboard.
So
how
do
we
get
the
numbers
for
the
campaign
summary
from
the
demand
dashboard
as
well
as
campaign
performance
by
channel
and
campaign
performance
by
offer?
A
A
A
So
when
you
do
edit
pivot
group,
the
data
set
by
visible
marketing
channel
path
to
show
you
the
grouping
by
campaign
performance
by
channel
or
really
what
tactics
do
we
use
and
then
you'd
say
under
values?
Drag
sum
of
inquiries,
drag
mql
sum
of
mqls
and
drag
linear,
sao
under
values,
some
of
linear
saos
and
then
so.
This
will
give
you
a
high
level
overview
of
all
the
channels
we
leverage
for
this
campaign.
The
one
thing
that
I
want
to
call
out
is
event.webcast.
A
A
lot
of
these
is
really
the
tech
demos
and
the
way
I
can
verify
that
is
to
edit
pivot
to
make
sure
and
then
add
visible
ad
campaign
name
under
the
rows
under
visible
marketing
channel
path.
That
way,
it
will
tell
you
exactly
the
names
of
the
salesforce
campaign.
You
can
ignore
the
rest
of
the
categories
so,
like
you
can
just
collapse
the
rest
but
like
under
event.webcast.
A
You
can
see
that
a
lot
of
all
of
these
are
tech,
numbers
right
and
tech.
Demos
are
driven
by
email,
so
event.webcast,
it's
really
more
of
an
offer
instead
of
an
instead
of
a
channel.
A
So
I
would
add
this
row
to
the
email
channel,
because
all
of
our
tech
demos
are
driven
by
email,
but
there
was
an
issue
with
the
tracking
from
right
top,
which
is
why
we
had
to
basically
just
put
them
into
the
salesforce
campaign,
which
is
why
it's
causing
the
tracking
to
look
a
little
weird
here,
because
again,
event.webcast
is
more
of
an
offer
and
not
really
a
channel.
And
then
how
do
we
get
to
the
campaign
performance
by
offer?
A
A
And
then
I
would
exclude
those
from
this
next
analysis
because
you
already
know
those
are
technicals
and
for
the
rest,
we
want
to
know
where
it
comes
from
because
of
that
anomaly
in
tracking.
So
I
would
there
I'll
drag
visible
marketing
channel
path
up
here.
Well
I'll,
I
guess
return
all
the
different
columns
as
normal
first.
That
might
be
easier,
so
you
you
say
reset
to
default
and
it
will
reset
to
the
original,
just
kind
of
like
raw
table
format.
A
A
And
then
you
would
drag
the
same
kpis
into
the
values
column,
so
inquiries
make
sure
the
sum
of
inquiries,
mql
sum
of
mqls
and
then
sao
sum
of
linear
seo,
and
then
you
would
then
sort
this
by
the
sum
of
inquiries.
Because
there's
a
lot
in
there
and
usually
you
know,
I
will
just
pick
the
top
10
top
generating
inquiries.
One
two,
three,
four,
five,
six,
seven,
eight
yeah
so
top
ten
stop
generating
inquiries
offers,
and
you
can
also
pick.
A
A
And
then,
like
this
blog
posts
and
then
this
another
blog
post,
also,
that
has
you
know
decent
number
of
linear
saos.
You
may
want
to
include
those
and
then,
as
you
kind
of
go
through
this
also.
A
You
can
then
look
through
it
really
quickly,
also
so
like,
for
example,
this
one
type
demo
intro
fuzzing-
that
can
roll
up
to
the
tech
demos
as
well,
and
then
software
compliance
demo.
Because
of
again
the
way
tech
demos
are
being
tracked
is
a
little
bit
messy
so
for
the
earlier
ones
that
are.
A
It
will
appear
here,
so
you
would
then
add
these
ones
also
under
the
offer
attack
demo
offer
instead
of
outlining
them
one
by
one.
Sorry,
it's
a
little
bit
harder
this
time
to
pull
all
this
data,
but
it
is.
We
are
running
with
a
couple
of
reporting
challenge,
as
you
all
know,
because
of
the
way
the
right
talk,
tracking
challenge,
as
well
as
all
the
different
intricacies,
with
the
kind
of
like
dashboard
having
different
different
data.
So
yeah,
let
me
know
if
you
have
any
questions.
Hopefully
this
helped.