What's new

Using Pivot-Tables to analyse Google Ads data

Marketing, social media, advertising

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

Build a Fastlane business. Earn real financial freedom. Live your best life.

Tired of paying for dead communities hosted by absent gurus who don't have time for you?

Imagine having a multi-millionaire mentor by your side EVERY. SINGLE. DAY. Since 2007, MJ DeMarco has been a cornerstone of Fastlane, actively contributing on over 99% of days—99.92% to be exact! With more than 39,000 game-changing posts, he's dedicated to helping entrepreneurs achieve their freedom. Join a thriving community of over 90,000 members and access a vast library of over 1,000,000 posts from entrepreneurs around the globe.

Join Today
Download Books
No Ads? Join Insiders
Forum membership removes this block.
Andy Black

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
LEGACY MEMBER
Joined
May 20, 2014
Messages
20,728
Location
Ireland
Rep Bank
$11,234
User Power: 362%
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? Become a Fastlane member: Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)
Membership Required: Upgrade to Expose Nearly 1,000,000 Posts

Ready to Unleash the Millionaire Entrepreneur in You?

Become a member of the Fastlane Forum, the private community founded by best-selling author and multi-millionaire entrepreneur MJ DeMarco. Since 2007, MJ DeMarco has poured his heart and soul into the Fastlane Forum, helping entrepreneurs reclaim their time, win their financial freedom, and live their best life.

With more than 39,000 posts packed with insights, strategies, and advice, you’re not just a member—you’re stepping into MJ’s inner-circle, a place where you’ll never be left alone.

Become a member and gain immediate access to...

  • Active Community: Ever join a community only to find it DEAD? Not at Fastlane! As you can see from our home page, life-changing content is posted dozens of times daily.
  • Exclusive Insights: Direct access to MJ DeMarco’s daily contributions and wisdom.
  • Powerful Networking Opportunities: Connect with a diverse group of successful entrepreneurs who can offer mentorship, collaboration, and opportunities.
  • Proven Strategies: Learn from the best in the business, with actionable advice and strategies that can accelerate your success.

"You are the average of the five people you surround yourself with the most..."

Who are you surrounding yourself with? Surround yourself with millionaire success. Join Fastlane today!

Join Today
Andy Black said:
O tqipv e duaqmi ug juast vjot nuspoph epemztoph tuniupi't Huuhmi Eft edduapv.

Cimux esi vji neop tmofit. Vjisi't pu tasqsotit... ov't xjev O iyqidvif vu tii epzxez. Vji upmz dewiev ot vjev O'n puv tasi jux ximm dupwistoupt esi cioph vsedlif.

Vjot katv tjuxt vji quxis ug cioph ecmi vu fuxpmuef feve opvu Iydim epf tmodi-epf-fodi xovj qowuv-vecmit.

6I8iuNV.qph


IgQn5QG.qph


qaNeYCB.qph


6UMXeqm.qph


kLSKCij.qph
Click to expand...
Puv tasi jux ximm vjiz esi cioph vsedlif?

Fuit vjot demm gus e vitv ug tohpogodepdi?:cmepl:

#catopittepemzvodt101
 
ZF Lee said:
Puv tasi jux ximm vjiz esi cioph vsedlif?

Fuit vjot demm gus e vitv ug tohpogodepdi?:cmepl:

#catopittepemzvodt101
Click to expand...
Vjiz tohpif aq zitvisfez ugg vji cedl ug vjev siqusv.

Edvoupt esi vu onqminipv/wisogz dupwistoup vsedloph.

Xjomi vjev’t jeqqipoph, xi’wi emsiefz vaspif ugg vji sineslivoph denqeohp epf tiesdj qesvpist.

Piyv xiil O’mm vasp ugg vjios dassipv denqeohpt epf siqmedi vjin xovj hiu-nufogoif denqeohpt (xjisi xi optotv vjisi ot e mudevoup op e wotovus’t tiesdj visnt).

Xi’mm liiq fuoph vji sohjv vjopht epf jewi geovj vji sitamvt xomm gummux.
 
Membership Required: Upgrade to Expose Nearly 1,000,000 Posts

Ready to Unleash the Millionaire Entrepreneur in You?

Become a member of the Fastlane Forum, the private community founded by best-selling author and multi-millionaire entrepreneur MJ DeMarco. Since 2007, MJ DeMarco has poured his heart and soul into the Fastlane Forum, helping entrepreneurs reclaim their time, win their financial freedom, and live their best life.

With more than 39,000 posts packed with insights, strategies, and advice, you’re not just a member—you’re stepping into MJ’s inner-circle, a place where you’ll never be left alone.

Become a member and gain immediate access to...

  • Active Community: Ever join a community only to find it DEAD? Not at Fastlane! As you can see from our home page, life-changing content is posted dozens of times daily.
  • Exclusive Insights: Direct access to MJ DeMarco’s daily contributions and wisdom.
  • Powerful Networking Opportunities: Connect with a diverse group of successful entrepreneurs who can offer mentorship, collaboration, and opportunities.
  • Proven Strategies: Learn from the best in the business, with actionable advice and strategies that can accelerate your success.

"You are the average of the five people you surround yourself with the most..."

Who are you surrounding yourself with? Surround yourself with millionaire success. Join Fastlane today!

Join Today
You must log in or register to reply here.

Similar threads...

Andy Black
Analysing data in Excel using simple text manipulation & pivot-tables
Replies
7
Views
2K
Andy Black
Andy Black
Andy Black
MARKETING Segment your AdWords data!
Replies
0
Views
2K
Andy Black
Andy Black

Navigation Shortcuts

Welcome to an Entrepreneurial Revolution

The Fastlane Forum empowers you to break free from conventional thinking to achieve financial freedom through UNSCRIPTED® Entrepreneurship where relative value and problem-solving are executed at scale. Living Unscripted® isn’t just a business strategy—it’s a way of life.

Follow MJ DeMarco

Fastlane Resources

Get The Books that Change Lives...

The Fastlane entrepreneurial strategy is based on the CENTS Framework® which is based on the three best-selling books by MJ DeMarco.

mj demarco books
Back
Top Bottom