The Entrepreneur Forum | Financial Freedom | Starting a Business | Motivation | Money | Success

Using Pivot-Tables to analyse Google Ads data

Learn how to build wealth and win financial freedom the Fastlane way!

Say "NO" to mediocre living rife with jobs, ascetic frugality, and suffocating savings rituals— learn how to build a Fastlane business that pays both freedom and lifestyle affluence. Join more than 70,000 entrepreneurs who are making it happen.
Join for FREE Today
Get the books
Remove ads? Join Fastlane INSIDERS
(Registration removes this block)
Marketing, social media, advertising

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,947
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
 
Don't like ads? Remove them while supporting the forum: Subscribe to Fastlane Insiders.

ZF Lee

Platinum Contributor
Read Fastlane!
Read Unscripted!
Speedway Pass
Jul 27, 2016
2,628
4,611
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
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,947
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.
 

sonny_1080

Creating a tool I want to use.
FASTLANE INSIDER
Read Fastlane!
Read Unscripted!
Speedway Pass
Oct 30, 2019
450
696
Los Angeles
How did you set up your pivot table like that?
 
Don't like ads? Remove them while supporting the forum: Subscribe to Fastlane Insiders.

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,947
Ireland

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,947
Ireland

Post New Topic

Please SEARCH before posting.
Please select the BEST category.

Post new topic

New Topics

Fastlane Insiders

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

Join Fastlane Insiders.

Must Read Books...

Explore books recommended by MJ DeMarco and other members of the Fastlane entrepreneurial community.
Fastlane Bookstore
Top