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

Using Pivot-Tables to analyse Google Ads data

Remove ads while supporting the Unscripted philosophy...become an INSIDER.

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,799
47,241
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.









 

Don't like ads? Remove them while supporting the forum. Subscribe.

ZF Lee

Platinum Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Jul 27, 2016
2,423
4,276
1,026
22
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.









Not sure how well they are being tracked?

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

#businessanalytics101
 
  • Thread starter
  • Moderator
  • #3

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,799
47,241
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

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,799
47,241
4,306
Ireland
  • Thread starter
  • Moderator
  • #6

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,799
47,241
4,306
Ireland

Sponsored Offers

  • Sticky
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
I thought I would post up the first video from the newest 2021 program content... Just a...
  • Sticky
MARKETPLACE Kill Bigger Incubator
I have not offered one of these in a while, but it looks like I have time to take on an...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Hi Andreas, It is per month, with the first month being half. This is a great question, I...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Hi Lex, I looked at several options including Kajabi and settled on the Divi theme on Wordpress...
  • Sticky
MARKETPLACE Grow Your Business With a Book (An Unorthodox Marketing Strategy That Built One of the Largest...
Are you looking for a new, lesser-known but potentially very lucrative source of leads to your...
  • Sticky
FEATURED! Introducing... WEALTH EXPO$ED, A Short Story By MJ DeMarco
The story is BASED UPON a true story. The details aren't entirely accurate or from a distinct...



Forum Sponsor

Grow an online business:
- Start immediately!
- Master business skills!
- 100+ Fastlane students enrolled!
Review & Details >

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom