the big marketer

How To Use Pivot Tables For PPC Marketing (Google Ads/AdWords)

by

EXCEL FOR PPC ONLINE COURSE

MS Excel For PPC – Analytics & Reporting

This video will show you how to use pivot tables for PPC, specifically Google Ads (AdWords).

Pivot tables can be a great way to analyse large sets of PPC data and make sense out of it. When you download raw data from Google Ads, then a pivot table and by extension, a pivot chart will allow you to visualize the data and spot trends.

Many marketers think pivot tables are scary, but they don’t have to be. Get started and have fun playing with datasets to visualize the data you need.

It can be great to use pivot tables for client and stakeholder engagement to pull stats for campaign performance over time.

Pivot tables for PPC aren’t scary, just get started!

If you liked this video, don’t forget to subscribe and follow me on Twitter & LinkedIn via the below.

And as always, if you have a question, or want me to cover a particular subject or marketing challenge you’re facing, head over to my website https://www.thebigmarketer.co.uk and get in touch. I would love to hear from you!

Website: thebigmarketer.co.uk
Twitter: twitter.com/thebigmarketer
LinkedIn www.linkedin.com/in/darrentaylordigital

Impact of Coronavirus (Covid-19) on Google Ads PPC

by

PPC bid platform Wordstream released a report on the impact of coronavirus (covid-19) on PPC through Google Ads. It’s a really interesting report that puts the impact of the pandemic into perspective.

In this video we are going to take a close look at this data, also look at some of the anecdotal evidence I’ve seen and try to understand what we can expect from PPC in the coming weeks.

What is Wordstream?

PPC bid optimisation, keyword research and analytics platform for small and medium sized businesses. They have analysed 14 billion dollars worht of ad spend and have a ton of data they can aggregate and use to provide insight and trends in PPC

They have used this data before before with their info-graphic on CPC’s by industry, so we know they have enough datapoints to provide meaningful information, so what have they seen as a result of the coronavirus pandemic?

https://www.wordstream.com/blog/ws/2020/03/18/covid-19-google-ads-data

We’ll look at

1. Top level trends
2. Industry’s seeing improvement
3. Industries losing

In terms of specifically where this data comes from, Wordstream state

This report is based on a sample of 15,759 US-based WordStream client accounts in all verticals who were advertising on Google’s Search throughout 2020 thus far. Each industry includes at minimum 30 unique active clients. For indexing purposes, we’ve evaluated weekly account performance since February 24th against the prior six-week average.

If you liked this video, don’t forget to subscribe!

https://www.youtube.com/channel/UCrUO3p9980ePtCBUIlp890w?sub_confirmation=1

I reply to ALL comments so hit me up and I’ll be happy to have a chat 🙂

If you want to get more from marketing, check out my marketing courses!

https://thebigmarketer.com/courses/

And as always, if you have a question, or want me to cover a particular subject or marketing challenge you’re facing, head over to my website www.thebigmarketer.com and get in touch. I would love to hear from you!

Let’s get Social!

Twitter: https://twitter.com/thebigmarketer
Facebook: https://www.facebook.com/thebigmarketer
LinkedIn: https://www.linkedin.com/in/thebigmarketer/
Instagram: https://www.instagram.com/thebigmarketer/

5 really useful Excel formulas for PPC

by

EXCEL FOR PPC ONLINE COURSE

Excel Spreadsheets for PPC and Analytics Reporting

Excel and PPC go hand in hand. So here are 5 Excel formulas for PPC analysis and planning.

If you don’t use Excel for you AdWords campaign analysis and planning then you are missing a trick!

In fact, I have also created an Excel spreadsheet template for PPC campaign planning. You can grab it here: http://thebigmarketer.co.uk/freebie-download-adwords-planning-spreadsheet/

If you liked this video, don’t forget to subscribe and follow me on Twitter, Facebook and LinkedIn via the below.

And as always, if you have a question, or want me to cover a particular subject or marketing challenge you’re facing, head over to my website www.thebigmarketer.co.uk and get in touch. I would love to hear from you!

Website: http://thebigmarketer.co.uk/
Twitter https://twitter.com/thebigmarketer
Facebook https://www.facebook.com/thebigmarketer/
LinkedIn https://www.linkedin.com/in/darrentaylordigital/
Instagram https://www.instagram.com/thebigmarketer/