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

Welcome to the only entrepreneur forum dedicated to building life-changing wealth.

Build a Fastlane business. Earn real financial freedom. Join free.

Join over 80,000 entrepreneurs who have rejected the paradigm of mediocrity and said "NO!" to underpaid jobs, ascetic frugality, and suffocating savings rituals— learn how to build a Fastlane business that pays both freedom and lifestyle affluence.

Free registration at the forum removes this block.

Using Pivot-Tables to analyse Google Ads data

Marketing, social media, advertising

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,689
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
 
Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

ZF Lee

Legendary Contributor
EPIC CONTRIBUTOR
Read Rat-Race Escape!
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
180%
Jul 27, 2016
2,840
5,113
25
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
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,689
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.
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
164%
Oct 30, 2019
496
815
Los Angeles
How did you set up your pivot table like that?
 
Dislike ads? Remove them and support 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
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,689
Ireland

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,689
Ireland

Post New Topic

Please SEARCH before posting.
Please select the BEST category.

Post new topic

Guest post submissions offered HERE.

New Topics

Fastlane Insiders

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

Join Fastlane Insiders.

Top