Hands On Training

Marketing Analytics in Spreadsheets

Name: Marketing Analytics in Spreadsheets
Brand: Careervira
Price: 97 SGD
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Spreadsheets are an essential tool for marketing professionals. Spreadsheets are essential tools for marketing professionals. But how can you ensure that they remain accurate and clean, especially when multiple people add data to them? Marketing analysts have powerful tools such as regular expressions, validation of data and other tools. Clean data is only half the battle. After we learn how to clean the data, we will create charts to show it. To explore the types of data that digital marketing will encounter, we will use a dataset. Data validation will be used to identify errors in metrics and create charts to analyze campaign performance. Regular expressions can also be used to build charts to analyse campaign metrics. We will then use all of the information we have to create a dynamic dashboard.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

Prerequisites/Requirements

Intermediate Spreadsheets

What You Will Learn

Learn how to ensure clean data entry and build dynamic dashboards to display your marketing data

Throughout the course, we will explore a dataset that includes the kind of information you will encounter in the world of digital marketing

We will spot errors in metrics using data validation, use regular expressions to aggregate campaign metrics, build charts to analyze campaign performance, and use everything we've learned to build a dynamic dashboard!

Course Content

Expand all sections

Module 1: Data Validation for Clean Data Entry

Module 2: Regular Expressions

Module 3: Visualize the Data with Charts

Module 4: Build a Paid Search Campaign Dashboard

Course Instructors

Luke Pajer

Digital Marketing Specialist

Luke is a part of the Digital Marketing Services team at Beacon - a digital marketing agency located in Greensboro, North Carolina. His passion for spreadsheets and data science with python developed...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%