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.

  • Thread starter
  • Moderator
  • #1

Andy Black

Dad, husband, entrepreneur.
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,108
44,878
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,337
4,116
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
OP
OP
Andy Black

Andy Black

Dad, husband, entrepreneur.
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,108
44,878
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
OP
OP
Andy Black

Andy Black

Dad, husband, entrepreneur.
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,108
44,878
4,306
Ireland

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Sponsored Offers

  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Just bought 5 of your Upwork courses. Thanks for making valuable content Lex!
  • Sticky
MARKETPLACE Kill Bigger Incubator
I've just concluded my program with Kyle. The incubator gave me what I wanted. Now, working on a...
  • Sticky
MARKETPLACE Fox's Web Design Guide: Earn $100K this year (Yes, 2020!) and Go Fastlane
Thanks for the detailed response. I see it similar, in the beginning, you have only a small...
  • Sticky
MARKETPLACE Grow Your Business With a Book (An Unorthodox Marketing Strategy That Built One of the Largest...
Thanks for your offer to look at my book. Here's the link to the squeeze page Buy The Prosperous...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
The day I can afford to pay 800 a month to have someone keep me accountable is the day I've won...



Forum Sponsor

sponsor

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