►
Description
This video outlines the step by step process on how to do the first pass at cleaning up the list for Sponsored (external) webcasts prior to passing to MOPs for upload.
Questions? Reach out on the #marketing_programs slack channel tagging @aoetama.
A
A
A
So
what
you
do
with
this
template
there's
and
if
you
want
to
read
more
than
there's
how
it
works
tap,
but
within
this
template
there
is
a
special
tab
for
each
of
us.
We
can
create
one
for
you,
but
if
you
don't
have
one,
you
can
also
use
my
tab.
I'm
gonna
delete
any
data,
that's
in
the
blue
column.
If
there's
any
any
data,
it
is
not
blank
because,
usually
that's
from
a
previous
list,
but
first
you
want
to
make
sure
you
clean
that
list.
The
own
list.
A
A
One
thing
you
want
to
make
sure
is
basically
that
this
blue
column
is
your
original
raw
file.
Make
sure
you
don't
delete
any
columns
in
this
blue,
the
ones
with
the
blue
and
the
blue
air
colors
cause.
Otherwise
it
will
break
the
formula
for
the
green
columns.
These
green
columns
are
columns
that
sound,
basically
black,
being
data
using
then
we'll
clean.
The
do
a
first
pass
clean
on
the
data,
so
yeah
make
sure
you
don't
delete
any
of
them
any
of
the
columns,
not
even
the
green
one.
A
A
Say
this:
is
there
a
thousand
rows
here
make
sure
that
that
is
also
there's
values
all
transposed
all
the
way
to
the
green
columns?
So
sometimes
this
in
the
previous
data,
if
they
like,
there's
no
data
here.
That
means
the
formula
may
not
copy
over
to
the
last
row,
so
you
want
to
make
sure
to
copy
over
the
formula.
The
last
row
by
popping.
A
A
Then
even
pace
format,
only
let's
see
if
you
press
top
the
end,
just
paste
in
my
copy
over
just
a
formula,
and
if
you
are
so
you
wanna
copy
and
paste
values
only
and
formula,
and
then
the
first
thing
you
want
to
check
is
the
well.
You
can
delete
all
the
unnecessary
all
of
the
blank
one
that
wouldn't
have
any
data
in
it.
A
Make
sure
the
email
syntax
is
correct,
so
anything
that
is,
if
you
go
back
to
the
guideline
here
and
on
how
it
works,
it
will
say:
email
sent
back
see
if
this
impacts
of
the
email
is
not
Matt,
meaning
it
includes
and
irrelevant,
and
the
Commodore
UK
or
the
iOS
or
the
common
domains.
They
will
be
listed
as
false,
so
you
need
basic
and
an
email
can
be
updated
to
make
it
ready
for
upload.
A
Sometimes,
even
though
it
is
false,
if
it
looks
aweful
correct,
it's
fine,
that's
just
make
sure
there's
no
misspellings,
so
I
would
do
what
I
would
do
is
I'll
just
filter
for
false
and
just
quickly
take
a
look
at
eyeball
the
email
and
make
sure
it
looks
correct,
even
though
it's
not
cool
calm.
In
this
case
it
looks
like
it's
correct,
so
I'll,
let
it
be.
There's
no
misspellings
or
anything
like
that,
make
sure
there's
no
extra
space.
A
And
if
they're
instantly
delete
the
space
or
correct
the
domain,
if
there's
any
misspellings
looks
like
this
is
correct
and
then
the
next
thing
you
want
to
do
is
you
want
to
check
for
duplicates
and
get
lab
email
addresses,
so
the
way
I
would
check
for
duplicates.
Well,
the
easiest
one:
let's
get
rid
of
get
lab.
Email
addresses.
First.
A
A
A
And
source,
so
the
easy
one
first
source
will
always
be,
or
let's
go
from
member
status.
So
to
get
the
member
status,
you
need
to
do
a
vlookup
based
on
the
attendee
report,
so
the
formula
will
go.
You
look
up
so
you're,
basically
matching
the
email
address
here
against
the
email
address
in
the
attendee
report
to
see
which
ones
are
attended
versus
moshos
before
we
do
that,
we
want
to
make
sure
the
attended
column
is
actually
on
the
right
of
the
email
them
in
a
way
for
it
to
or
for
it
to
under.
No
that.
A
A
A
A
A
And
then
you
want
to
at
the
campaign
ID,
oh
yeah,
you
would
go
to
the
epic
to
get
the
campaign.
Id
there'll
be
a
sales
first
campaign
exception
here
in
the
epic
and
you
can
link.
If
you
have
Salesforce
access,
you
can
link
to
it.
You
can
click,
link,
click,
the
link
and
it
will
take
you
to
the
campaign
page
and
the
ID
is
the
last
few
last
things
that
the
last
characters
and
numbers
combined,
the
last
13
characters
or
13
or
15
I-
think
15.
A
Maybe
as
a
pendant
today
sounds
first
URL,
so
you
would
think
that
it's
sort
of
7-0
one
copy
and
then
you
would
put
it
into
the
campaign
ID
column
and
for
source.
It
will
always
be
webcast,
so
just
put
webcasts,
because
this
is
an
external
webcast,
so
copy
and
paste
it
all
the
way
down
paste
all
the
way
down
copy
that
formula.
All
the
way
down.
I
mean
the
value
all
the
way
down,
and
you
are
good
to
go.
I
think
this
is
basically
the
finalists.
A
A
A
You
wanna
follow
these
instructions
through,
like
removing
and
a
etc
from
title
state,
remove
state
values
for
countries
they
are
not
United
States
in
Canada
and
sure
all
phone
values
are
actual
phone
numbers,
but
since
we
don't
have
all
that
we're
pretty
much
good
because
we
only
have
first
name
last
name,
email
and
country,
so
I
just
checked
all
of
that
not
on
conversation.
That's
okay,
so
like
ready
to
upload
google,
doc
and
tech
marketing
up.
So
what
I
would
do?
Yeah
it's
just
paste
heat
place.