PPC Hero https://www.ppchero.com Fri, 02 Aug 2024 11:28:11 +0000 en-US hourly 1 https://wordpress.org/?v=6.7.1 https://www.ppchero.com/wp-content/uploads/2024/09/cropped-ppchero-icon-32x32.png PPC Hero https://www.ppchero.com 32 32 How To Get More Out Of Excel Solver https://www.ppchero.com/how-to-get-more-out-of-excel-solver/ Thu, 04 Mar 2021 13:15:27 +0000 http://ppchero.com/how-to-get-more-out-of-excel-solver/ Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.

<p>The post How To Get More Out Of Excel Solver first appeared on PPC Hero.</p>

]]> How to Automate Excel Solver https://www.ppchero.com/how-to-automate-excel-solver/ Thu, 21 Jan 2021 13:15:00 +0000 http://ppchero.com/how-to-automate-excel-solver/ In this article we’ll go in depth from start to finish covering the concepts and methods step by step. By the end you’ll be able to automate any of your own personal models and scale your analysis.

<p>The post How to Automate Excel Solver first appeared on PPC Hero.</p>

]]> How to Validate Marketing Tags and Pixels https://www.ppchero.com/how-to-validate-marketing-tags-and-pixels/ Wed, 19 Aug 2020 12:15:00 +0000 http://ppchero.com/how-to-validate-marketing-tags-and-pixels/ In this article, a Director of Analytics covers how to check which tags exist on a site, which information is sent, and proper tag setup.

<p>The post How to Validate Marketing Tags and Pixels first appeared on PPC Hero.</p>

]]> Accounting for Future Performance in Paid Media https://www.ppchero.com/accounting-for-future-performance-in-paid-media/ Tue, 28 Apr 2020 12:15:00 +0000 http://ppchero.com/accounting-for-future-performance-in-paid-media/ Changing circumstances can force you to confront the future. Planning ahead is essential and can better prepare you for what comes next.

<p>The post Accounting for Future Performance in Paid Media first appeared on PPC Hero.</p>

]]> Taking Advantage of MCC Scripts for Multi-Account PPC Efficiency https://www.ppchero.com/working-with-mcc-scripts/ Mon, 27 Jan 2020 13:15:00 +0000 http://ppchero.com/working-with-mcc-scripts/ Working at the account level can be restrictive. MCC level scripts provide a solution for handling many accounts to scale further and work more efficiently.

<p>The post Taking Advantage of MCC Scripts for Multi-Account PPC Efficiency first appeared on PPC Hero.</p>

]]> Index Match: The Better Alternative to Vlookup https://www.ppchero.com/index-match-the-better-alternative-to-vlookup/ Wed, 18 Sep 2019 13:00:11 +0000 http://ppchero.com/index-match-the-better-alternative-to-vlookup/ VLOOKUP is one of those functions that makes Excel great. VLOOKUP has its issues though. Don't worry there is an alternative, INDEX MATCH. Not only does it replicate the functionality but has its own perks and bonuses. By the end of this article you’ll be able to put it into practice and reap the rewards.

<p>The post Index Match: The Better Alternative to Vlookup first appeared on PPC Hero.</p>

]]> Robust Reporting with Google Sheets Query Function https://www.ppchero.com/robust-reporting-with-google-sheets-query-function/ Tue, 13 Aug 2019 12:15:47 +0000 http://ppchero.com/robust-reporting-with-google-sheets-query-function/ The reporting steps and examples in this article will assist in automating your own complex report and creating dynamic tables to save your time and sanity.

<p>The post Robust Reporting with Google Sheets Query Function first appeared on PPC Hero.</p>

]]> Upgrade Your Data, Upgrade Your Analysis https://www.ppchero.com/upgrade-your-data-analysis/ Wed, 20 Mar 2019 12:15:52 +0000 http://ppchero.com/upgrade-your-data-analysis/ It’s easy to hit a rut in your analysis. Problems become stale, questions feel like they will never be resolved, and there isn’t anything left to find in the data. This is where adding extra data sources or facets can help.

<p>The post Upgrade Your Data, Upgrade Your Analysis first appeared on PPC Hero.</p>

]]> Getting a Little Help with Your Bids – ECPC vs CPA Bidding https://www.ppchero.com/getting-a-little-help-with-your-bids-ecpc-versus-cpa-bidding/ Thu, 31 Jan 2019 20:34:05 +0000 http://ppchero.com/getting-a-little-help-with-your-bids-ecpc-versus-cpa-bidding/ Beyond standard CPC bidding, Google Ads lets you choose two advanced options, enhanced cost-per-click and CPA bidding. This post serves as a primer to the bidding types.

<p>The post Getting a Little Help with Your Bids – ECPC vs CPA Bidding first appeared on PPC Hero.</p>

]]> Starter Projects for New Coders https://www.ppchero.com/starter-projects-for-new-coders/ Wed, 23 Jan 2019 13:45:08 +0000 http://ppchero.com/starter-projects-for-new-coders/ Knowing what to do can be one of the biggest challenges for new coders. In a previous article we covered choosing a language. Now you’ve made your way around tutorials on variables, loops, and functions but how can you apply it to your job?

<p>The post Starter Projects for New Coders first appeared on PPC Hero.</p>

]]>