The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

Using Pivot-Tables to analyse Google Ads data

Accelerate wealth. Build a business that pays freedom. Join more than 70,000 entrepreneurs and register for the Fastlane Entrepreneur forum. Remove ads? Join the INSIDERS.

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,952
4,306
Ireland
I spent a couple of hours this morning analysing someone's Google Ads account.

Below are the main slides. There's no surprises... it's what I expected to see anyway. The only caveat is that I'm not sure how well conversions are being tracked.

This just shows the power of being able to download data into Excel and slice-and-dice with pivot-tables.

6E8eoMT.png


EfPm5PF.png


puMaXBZ.png


6OLWapl.png


jKRJBeh.png
 

ZF Lee

Platinum Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Jul 27, 2016
2,523
4,450
1,036
23
Malaysia
I spent a couple of hours this morning analysing someone's Google Ads account.

Below are the main slides. There's no surprises... it's what I expected to see anyway. The only caveat is that I'm not sure how well conversions are being tracked.

This just shows the power of being able to download data into Excel and slice-and-dice with pivot-tables.

6E8eoMT.png


EfPm5PF.png


puMaXBZ.png


6OLWapl.png


jKRJBeh.png
Not sure how well they are being tracked?

Does this call for a test of significance?:blank:

#businessanalytics101
 
  • Thread starter
  • Moderator
  • #3

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,952
4,306
Ireland
Not sure how well they are being tracked?

Does this call for a test of significance?:blank:

#businessanalytics101
They signed up yesterday off the back of that report.

Actions are to implement/verify conversion tracking.

While that’s happening, we’ve already turned off the remarketing campaign and search partners.

Next week I’ll turn off their current campaigns and replace them with geo-modified campaigns (where we insist there is a location in a visitor’s search terms).

We’ll keep doing the right things and have faith the results will follow.
 
  • Thread starter
  • Moderator
  • #5

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,952
4,306
Ireland
  • Thread starter
  • Moderator
  • #6

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,952
4,306
Ireland

Sponsored Offers

  • Sticky
MARKETPLACE NEW: The Best School for Going Fastlane (Now open for summer enrollment)
Hey everyone, I have a big announcement to make about how we are going to be working with...
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
Any update? Hey bud! When I can squeeze out the time to work, it's been going pretty well...
MARKETPLACE Not sure how to start? This free book will teach you how to build a successful web design business
Hi Fox. Starting the book and got through the introduction. Had a conversation with Andy Black...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Chris is super sharp and is aware of many facets of entrepreneurship and can help get your...
Introducing MJ's Personal Unscripted Network, Join Now for FREE!
Any chance to make it available outside of US? It has been available outside of the US on...

Forum Sponsor

Learn Fastlane Business Skills & Get Profitable Within 30 Days...

Get Started Now

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom