Spreadsheets, Spreadsheets Everywhere
Name 2 KPIs where LOW is GOOD
CPC, CPA, Bounce Rate
What are the 3 types of media? (NOT media channels like TV or OOH)
Paid, Owned, & Earned
What is Tableau?
Tableau is an interactive visualization software and tool that allows users to see and understand their data. This software performs to transform data from spreadsheets, databases, and the cloud to name a few, into actionable insights through dashboards, allowing for analysis of the data with just a few clicks.
What are the 3Ws?
1. Where I've been
2. Where I am
3. Where I'm going
What is the difference between Paid Social and Organic Social?
Organic Social is community building and content production (ex. viral content)
Paid Social is sponsored content or advertising to boost your reach on social media
Name 3 KPIs where HIGH is GOOD
Conversion Rate, CTR, ROI
What are the 3 sections of the marketing funnel
Awareness, Consideration, & Call To Action
What is SQL?
“Sequel” (Structured Query Language) is a standardized query language used for managing relational databases and performing various operations on the data in the databases.
What are 3 PowerPoint presentation Best Practices that were mentioned during Data Project 1 Presentation feedback?
Ex. Consistent Formatting (font, font size, labels), Sources, Title/Header on every slide, Agenda if relevant, Intuitive Data Visualization
What are the 4 benefits of Paid Social?
Accuracy
Targeted Scale
Targeting and ReTargeting
Sequential Messaging
What are some Excel Best Practices to always follow?
1. Renaming tabs to something appropriate
2. All KPI metrics are correctly formatted
3. Label x-axis, y-axis, rows, columns, chart titles
4. Consistent formatting throughout workbook
What is Data Analytics?
Data Analytics is the process of examining data sets
in order to draw conclusions about the information they contain, often through the aid of specialized systems and software.
What are the 3 main clauses (or commands) used when writing a SQL query
SELECT, FROM, and WHERE
What are the 5 rules of an email?
Subject Line, Salutation, Structure, Signature, Spelling/Grammar
Name the 5 different types of programmatic buying
Open Auction, Private Auction, Preferred Deal, Direct Sales, Programmatic Direct
What does VLOOKUP stand for and what does it do?
VLOOKUP = Vertical Lookup
VLOOKUP is a spreadsheet function that helps you find and output information quickly within a table
What are the 3 major reasons Data Analytics is important?
1. Cost Reduction
2. Faster & Better Decision Making
3. New Products & Services
What is a Google Analytics Primary Dimension vs. Secondary Dimension?
A Primary Dimension is the default dimension applied to a report in GA.
The Secondary Dimension is the second dimension that you apply to a report by clicking 'Secondary Dimension' and selecting from the drop-down menu to filter the data more specifically.
How should every bullet point on your resume tell a story? Hint: (____ → _____ → _____)
Action → Result → Significance (why it mattered to the org, team, or client)
What is Real-Time Bidding?
Real-time bidding refers to the buying and selling of online ad impressions through real-time auctions that occur in the time it takes a webpage to load. Those auctions are often facilitated by ad exchanges or supply-side platforms.
What are Pivot Tables and the names of the 4 sections to categorize fields?
Pivot Tables are a powerful tool to summarize data that transforms rows and columns into a refreshable, customizable, calculated table
4 sections: Filters, Columns, Rows, Values
Name 2 examples of Structured Data and 2 examples of Unstructured Data
Structured Data: Spreadsheets, Phone Numbers (phone book), Databases, Library Catalogues (date, author, place, subject, etc.), Census Records (birth, income, employment, place etc.)
Unstructured Data: E-mail, Messages, Word Documents (txt, docx, etc.), Videos, Photos, Audio Files, Webpages and Many Other Kinds of Business Documents
In Tableau, explain Dimensions vs. Measures and their designated colors
Dimensions (always blue) are the categories of things in your data that you want to compare.
Dimensions Contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data.
Measures (always green) are the different metrics you want to use to compare those things.
Measures Contain numeric, quantitative values that you can measure. You can apply calculations to them and aggregate them.
(positive energy, passionate, authenticity, present, personable)
Substance: What you have to say
(preparation, stories, storytelling, knowledge, resume)
What is a DSP, SSP, DMP?
Demand-Side Platform (DSP): software used to buy advertising inventory in an automated fashion
Supply-Side Platform (SSP): software used to sell advertising inventory in an automated fashion
Data Management Platform (DMP): data warehouse used to analyze and target audiences