marketing @tableau visualizing our big, messy content audit · search engine optimization...

53

Upload: others

Post on 09-Jul-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 2: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Welcome

Page 3: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Marketing @Tableau:

Visualizing our big, messy content audit

# T C 1 8 # T C C o n t e n t Au d i t

Jay Ricciardi

Search Engine Optimization Specialist

Tableau

Page 4: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Agenda

1. Realize when to stop using spreadsheets

2. Tell a better story

3. Make a living audit

4. Q&A

5. Wrap up

Page 5: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Most content audits suck because they’re not

visually friendly

Page 6: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 7: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Why

Page 8: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

the

Page 9: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

hell

Page 10: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

aren’t

Page 11: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

we

Page 12: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

visualizing

Page 13: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

our

Page 14: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

content audits?

Page 15: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

We need to see and understand our content

Page 16: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Spreadsheets will always have a place in audits.

But they have limits.

Page 17: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 18: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 19: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Good audits already use a visualization best practice

Page 20: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Color!

Page 21: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Discovery at a glance

Page 22: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 23: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Color alone dramatically improves an eye-sore audit

Page 24: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Simple vizzes tell stories that spreadsheets can’t

Page 25: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 26: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 27: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 28: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Plug in whatever metrics you’d like to explore

Page 29: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 30: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 31: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 32: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 33: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Performing audits frequently is frustrating

and highly silo’d

Page 34: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

“Right now, how do our marketers find the best content for their campaigns?”— more than one leader in Marketing

Page 35: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Connect to live data for a single living audit

Page 36: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Here’s how we built it1. ETL site data into a data warehouse

2. Add and include relevant tags

3. Create a governed single source of truth

4. Dashboard the hell out of it

Page 37: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Here’s what it took1. Silo busting & prioritization

2. Unified taxonomy

3. Interviews (internal customer UX/CX)

4. Under-the-hood web ework

Page 38: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Custom tags• Persona• Funnel Stage• Content Type• Target Industry• Language• Gated (Y/N)• Internal Audit Date*

Page 39: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 40: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 41: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Custom tags• Persona• Funnel Stage• Content Type• Target Industry• Language• Gated (Y/N)• Internal Audit Date*

Page 42: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Tableau Server/Online unlock new interactions

Page 43: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Audits need to facilitate discussion and action

Page 44: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Stakeholders open audit spreadsheet once, scroll

Page 45: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

[gif of endless scrolling spreadsheet]

Page 46: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Audits need to facilitate discussion and action

Page 47: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story
Page 48: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

A living content audit can do work for you

Page 49: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Our new priorities• Refine the living audit instead of re-auditing

• Automate action item identification

• Consolidate Q&A and enable discovery

• 100% mission critical adoption

Page 50: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Q&A

Page 51: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Please complete the

session survey from the

Session Details screen

in your TC18 app

Page 52: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story

Thank you!

#TC18

Email: [email protected]

LinkedIn: /in/jay-ricciardi/

Twitter: @JayRicciardi

Page 53: Marketing @Tableau Visualizing our big, messy content audit · Search Engine Optimization Specialist Tableau. Agenda 1. Realize when to stop using spreadsheets 2. Tell a better story