How We Used Business Intelligence to Save up to 33% on A Google Ads Budget for One of Our Clients in 30 Minutes

How We Used Business Intelligence to Save up to 33% on A Google Ads Budget for One of Our Clients in 30 Minutes

How We Used Business Intelligence to Save up to 33% on A Google Ads Budget for One of Our Clients in 30 Minutes

Written By

On

You may have heard the buzz words, read the blogs, or even watched a few videos, but it’s time to make it official. Data strategy is one of the hottest trends within the digital marketing world. In fact, companies that drive their marketing efforts using data as the roadmap are six times more likely to be profitable year over year. At &Marketing, we call this process Business Intelligence & Analytics, and we can use it not only to sharpen your marketing efforts, but also to save money and time as you grow your business. 

The digital age has brought with it a wealth of data that equips us to make better and smarter marketing decisions and optimize our strategies, but that is only step one. Step two is learning how to collect and align all of that data to uncover scalable insights that apply to overall business goals faster and more easily. The ability to take hundreds of thousands of data points and analyze them in understandable, meaningful ways in minutes without using tedious Excel spreadsheets, codes, and VLOOKUPS is the future or marketing and business growth trajectory. 

One of these ways includes leveraging data in order to find wasteful spending within paid search campaigns. Even if you have limited data points to draw from, you can still uncover valuable marketing and business insights. Small data can speak just as loudly as big data does, if you only know how to listen. Sound too good to be true? Find out below how we uncovered 33% of wasted spend within a real Google Ads paid search campaign in just thirty minutes. 

Aggregate and Align: Two Approaches

We uncovered a third of wasted paid search spend by collecting and organizing Google Ads and organic data together to determine where our client was spending unnecessary dollars on ineffective keywords. This is a process that can and should be performed regularly, but the traditional method is manual, tedious, and time-consuming. 

With the old way, you would start by looking at PPC (pay per click) search terms one by one and determining impact and relevance. Next, you would need to export those out into a spreadsheet and combine that with your organic data in a separate sheet and make sure all columns are aligned (and now I am yawning because I’m exhausted just thinking about it!). There is a better and more effective way.  

But first, a small disclaimer.

We found significant inefficiencies within this Google Ads  account. Unless an account uses all exact match types for keywords (which is rare), there will always be some inefficiencies within a PPC account. The idea is to minimize this as much as possible and determine what percentage of wasted dollars you are comfortable with spending month over month. 

So How Can You Uncover Such Discrepancies in Only 30 Minutes?

Here’s a step by step approach for mirroring the method we used for slashing overspend on Google Ads in just 30 minutes and three steps.

Step 1

Export all PPC keywords and search terms. You will need the term, impressions, clicks, conversions, and cost from paid search, along with your exported organic data from Google Search Console. For this step, you only need the keywords, impressions, clicks, and average position. 

(Pro tip: you can also export that data from a tool like SEMRush and use that in addition to or in replacement of Google Search Console). 

Step 2

Now, instead of merging two spreadsheets together and trying to align them, turn to a different tool: Power BI. With Power BI, you can easily upload your exports and create relationships between common columns. In this case, the specific column is your keyword. 

(Pro tip: When importing your PPC data, you can edit your spreadsheet within Power BI to remove characters like “ “ or + that are commonly used for phrase match and qualifiers within paid search) 

Example of Bad Communication

Once you have your spreadsheets uploaded and relationships created, you can then build out a responsive dashboard like the one below. Here we added filters to show only the keywords that have anywhere between 1-3 clicks, as most irrelevant search terms are only clicked once. You may be thinking that one click here at $1.83 and another click there at $2.47, aren’t much. But we also created scorecards to show us the number of keywords and the overall cost that all of those add up to. For example, for this client it was 235 terms with 0 conversions and a cost of $2,659.29. Yes, some of those terms are relevant and we’ll add them to our keywords. But how many aren’t? Additionally, it’s much easier to sort through 235 terms, rather than thousands.

Unfortunately, we can’t show you the actual keywords we found that were relevant or irrelevant in this specific example, because it’s our clients’ data. But we can reveal that we were able to identify irrelevant search terms that were tied to:

  • Other companies

  • Question phrases (ex: “what are” or “what does”) 

  • Website searches

Step 3

From here you can export the table with these irrelevant search terms as a spreadsheet and easily import them into Google Ads as negative keywords. With this information, you can now identify the common themes among your negative terms. 

For example, a client of ours had irrelevant searches for “livestock.” Not only did we negate those search phrases, but we also negated  the term “livestock,” ensuring our ads never show again for farm animals. You can also create a monthly calculator to measure what percentage of your Google Ads budget is wasted spend. Again, there is no universal benchmark for this percentage, but I think we can all agree that 33% is way too much.

Not only will this exercise allow you to easily identify irrelevant keywords, but you can also use it to find new keywords that are converting but not in your account. Once you align your organic and PPC data, you can see where (or if) you rank on Google for any of the keywords you are paying for. If you notice you are getting lots of conversions for a paid keyword that is eating up your budget, you should consider a content and organic strategy to improve your organic ranking for that keyword. 

So in just thirty minutes, one exercise can give you multiple ways to optimize your paid search account and enhance your organic and content strategy. 

This particular example is focused on optimizing existing marketing efforts and strategies. But Business Intelligence can also give marketing departments the information to guide companies to answer quintessential business questions, such as: 

  • Which state should I expand to next? 

  • Where should we increase product distribution? 

  • Who are our REAL online competitors? 

  • What is our customer’s digital journey?

  • And more…

Learn more about BI by watching this video from our friends at Seer Interactive.

Wondering if you are wasting money on the wrong keywords in your Google Ads account?

Visit our PPC Inefficiencies Calculator, fill out the form, and we’ll perform a FREE audit to show you how much money you could save. 

About the Author

As a Marketing Director at &Marketing, Paul Ferguson uses his 16 years of B2B marketing experience to help clients develop fully integrated marketing solutions that make impressions and drive results. Whether it be design-oriented campaigns or digital market execution, Paul skillfully creates strategies backed by data, to effectively reach client’s desired audiences. Paul graduated from La Salle University with a Bachelor of Arts in Communication and a double minor in Marketing and Business Administration. Visit Paul’s LinkedIn.

About &Marketing

In today’s fast paced world, many growing businesses are struggling to modernize their marketing approaches because either they don’t have the expertise or the bandwidth to do it themselves.

&Marketing provides seasoned marketing strategy professionals and a nimble execution team to help our clients achieve their goals. Our unique partnership model allows us to augment our client’s existing teams or outsource the entire marketing function in an affordable, flexible, and transparent way.

Case Study: Manufacturing Company

Case Study: Manufacturing Company

Case Study: Manufacturing Company

The US construction industry remains a highly competitive market, creating challenges for competing firms to differentiate themselves. Meanwhile, many of these companies don’t have the internal capacity to learn modern marketing well because of understaffing, lack of knowledge, and complex marketing jargon. On the bright side, over the past year, &Marketing has been able to support the acceleration of a rapidly growing construction firm through a combination of marketing strategy & execution by overcoming these challenges.

Business Challenge Summary

&Marketing’s client partner is a manufacturer that supplies capital equipment to the US construction industry. The client had seen swift growth in the past two years based on the internal team’s industry experience and network, but was concerned about plateauing. The organization wanted to ensure they were standing out in a sea of competitors to continue this growth at a steady pace, so they turned to &Marketing for help with an outsourced solution.

&Marketing’s Solution

&Marketing started work by developing a fundamental understanding of the complexities during the purchasing process in the construction industry. The & team interviewed client team members to gather a greater understanding of ins and outs of the construction business and followed it with a structured market study of current and potential decision-makers (procurement, construction managers, company leadership). &Marketing mapped each decision maker, their selection and purchase criteria (beyond competitive price), and where each gathered information about new products, services, and vendors. Based on this, &Marketing developed a playbook which linked their strategy to a set of execution tactics and aligned the internal leadership team to it.

The &Marketing team focused initial activation efforts on the firm’s website by updating the company’s basic information, adding a dedicated section to display completed projects, recent company events, and employee profiles. This information provided the foundation for a content strategy (including a cohesive executional calendar) to keep the website content fresh. A social media plan (including scheduling software and a campaign to improve internal LinkedIn profiles) distributed this content to reach these key B2B decision makers. Concurrently, &Marketing analyzed data on each post to determine the most effective content pieces.

Finally, &Marketing implemented a Google PPC (pay-per-click) campaign centered around the client’s core services. The campaign focused on generating website leads from individuals searching the web to find similar services.

Results

The client partner’s outsourced digital marketing execution team was able to quickly and affordably complete these marketing tasks, which generated an average of 5+ leads per month, all trackable through website activity. As a result, the client’s website traffic more than tripled, the website bounce rate was less than half, and search volume increased on all major search engines: Google, Yahoo, and Bing. For a firm that didn’t have an existing marketing department, &Marketing’s outsourced solution helped them build a solid case for continued effort and future investment.

Outsourced Digital Marketing

%

Lead Generation (+3-5 Leads Per Week)

%

Increasing Web Traffic (Up 5x Since Updating Site & Began Running Campaigns)

Are you facing challenges of your own in generating leads and meeting your business’ growth goals?

We’d love to learn more about your challenges and how a coordinated marketing approach might help take your organization to the next level.

About &Marketing:

&Marketing provides the robust outsourced marketing department growing companies need without the high overhead costs of big agencies or full-time employees. Our variable model empowers businesses to reach their growth goals through access to the guidance and expertise of senior level strategists and a flexible execution team.

Engineering Consultancy – Outsourced Marketing Program

Engineering Consultancy – Outsourced Marketing Program

Engineering Consultancy – Outsourced Marketing Program

Business Challenge Summary

Our client is an engineering consultancy with a vast portfolio of services that range from temporary contractor placement and recruitment to process implementation and one-off engineering projects.

A manager and coordinator comprised the existing marketing team prior to the engagement of &Marketing. They were experienced in public relations and content generation; however, the growing company needed help with other areas of marketing including strategy, productization, web development, marketing automation, graphic design, social media, and analytics.

When the marketing manager resigned unexpectedly, their increasing marketing needs were beyond what one person could reasonably provide, so they turned to &Marketing.

&Marketing’s Solution

&Marketing brought in a team of professionals coordinated by a single point of contact. We took on several roles for this client:

  • Senior level strategy advice
  • Product marketing
  • Web development
  • Marketing automation
  • PR support
  • Trade show and event planning
  • Marketing and sales collateral
  • Regular weekly and monthly reporting
  • Graphic design
  • Content development (such as blogs and news articles)
  • Email marketing and drip campaigns

Most importantly, the existing marketing coordinator was integrated into the &Marketing team throughout our relationship. We provided her with the resources and support she needed to elevate her efforts and achieve their marketing goals.

“&Marketing is both an excellent resource and an amazing team. Because of their range of expertise, I was able to expand my knowledge of marketing, while improving the overall company marketing function. Their collaborative nature made their integration into our company seamless.”

— JESSICA B.

Results

During our time with this engineering company, we made a significant impact by accomplishing the following:

  • Grew the company’s pipeline by more than 10%
  • Managed their website relaunch complete with a new aesthetic and copy rewrite
  • Supported 4 major industry events from pre-planning, speaking engagements, and lead generation at the event, to post-event follow up
  • Developed several focused marketing email automation campaigns that drove high-quality leads
  • Launched 6 major new service lines using &Marketing’s productization framework
  • Launched a major 9-part growth platform for their business, including shaping the offers, messaging, web development and go to market tactics.
  • Revamped content strategy to support key growth platforms to drive significant SEO gains for relevant keywords

Pipeline Growth (Grew the Company's Pipeline by More than 10%)

%

Tradeshow Planning & Execution (Pre-Planning, Lead Generation, Post-Event Follow Up, & More for 4 Major Industry Events)

%

Productization (Launched 6 Major Service Lines Using &Marketing's Productization Framework)

Are you facing challenges of your own in generating leads and meeting your business’ growth goals?

We’d love to learn more about your challenges and how a coordinated marketing approach might help take your organization to the next level.

About &Marketing:

&Marketing provides the robust outsourced marketing department growing companies need without the high overhead costs of big agencies or full-time employees. Our variable model empowers businesses to reach their growth goals through access to the guidance and expertise of senior level strategists and a flexible execution team.

Integrating eCommerce to Grow Revenue

Integrating eCommerce to Grow Revenue

Integrating eCommerce to Grow Revenue

Business Challenge Summary

Joe’s Next Door (https://joesnextdoor.com/) is a gourmet sandwich restaurant located in downtown Carmel, IN. Their delicious, award-winning sandwiches drew the crowds in but they were losing business due to the delay in prep time, which turned off midday patrons who need to grab lunch in a hurry. To overcome this issue of speed, they needed an easy system for customers to order ahead online so they can “pick-up and go.” They turned to &Marketing to help design their eCommerce site and integrate it with their kitchen to create a seamless lunchtime experience for both the hardworking staff and their hungry customers.

eCommerce Site Development

&Marketing designed, developed, and launched a custom eCommerce extension to Joe’s Next Door. With WordPress and WooCommerce, we were able to deliver an online store that functioned fully on both desktop and mobile devices with a simple two-step order and checkout process.

Backend/Kitchen Integration

To make sure that Joe’s ordering system integrated cohesively with their current business process, &Marketing also developed a custom backend system to coordinate with the kitchen crew. The backend system runs on a mounted iPad that notifies the crew of orders, prints out the orders for the line cook, and allows the crew to contact the customer via text message once their order is ready to pick-up. The program also allows the kitchen to open and close the ordering system on a timer that coincides with store hours.

 

User Behavior Management

Beyond the system, &Marketing worked with Joe to plan and outline all steps of the customer ordering experience to increase the efficiency of the order and preparation process. The entire ordering process is now filled with checks at every stage to ensure that messages are received and customers know how to interact with the ordering system and restaurant when they pick up an order.

     

    Results

    Although this system was only recently implemented, early orders have indicated an improvement in synchronization and accuracy, and there have been no technical issues between the ordering, communication with the kitchen, and financial systems. Joe’s Next Door is beginning the new year with confidence, and the management team is anticipating a 20% boost in lunchtime revenue order volume in 2019.

    Are you facing challenges of your own in generating leads and meeting your business’ growth goals?

    We’d love to learn more about your challenges and how a coordinated marketing approach might help take your organization to the next level.

    About &Marketing:

    &Marketing provides the robust outsourced marketing department growing companies need without the high overhead costs of big agencies or full-time employees. Our variable model empowers businesses to reach their growth goals through access to the guidance and expertise of senior level strategists and a flexible execution team.

    Lead Generation, Inside Sales, and eBook in Booming eCommerce Industry

    Lead Generation, Inside Sales, and eBook in Booming eCommerce Industry

    Lead Generation, Inside Sales, and eBook in Booming eCommerce Industry

    Business Challenge Summary

    With digital retail markets becoming increasingly prevalent, bad actors in these online spaces are rising in number. Many organizations don’t realize their products are being resold through online markets like Amazon, or that their brands are being associated with knock-off items and sold without their consent. Even those who do recognize this issue often struggle with effective retaliation.

    &Marketing’s client partner, Gray Falkon (www.grayfalkon.com) is an expert in combating these third-party sellers and has a mission to share their expertise with companies that would most benefit from learning about gray market anti-counterfeiting best practices. Gray Falkon’s approach helps brands of all sizes reduce unauthorized resellers on platforms like Amazon by as much as 50% in just a couple of weeks. They focus on targeting gray market products and unauthorized third-party sellers.

    Gray Falkon needed to build awareness to drive awareness and leads, so they turned to &Marketing to assist with the creation and distribution of new branded content to get their services known by the decision makers who matter.

    What We Did:

    The &Marketing team worked with Gray Falkon to create an inside sales program that would build brand awareness and sales opportunities, based on a five-step action plan:

    • Create a digital counterfeiting-focused eBook, centered around actual industry best practices for preventing gray market activity.
    • Plan an inside sales program to market Gray Falkon directly to 1000 target prospects (decision makers in brand marketing, e-commerce sales, and legal departments) by using the eBook as a free initial offering. This program consisted of a mix of phone calls and emails over a 2-3 week period preceding Thanksgiving, a crucial time for brand owners on Amazon given the proximity to the holiday season.
    • Conduct an outreach initiative to potential Gray Falkon clients, aiming to create consultation opportunities and additional sales leads.
    • Accumulate data and provide regular reports on lead development and sales program progress.

    Results

    During &Marketing’s project with Gray Falkon, our team fulfilled multiple objectives, including:

    • Market & Goal Alignment
    • Branding Assessment & Visual Upgrade
    • Copywriting & Content Creation
    • Creation of Leads via Inside Sales Program
    • Detailed Reporting on Lead Status & Content Reception

    With &Marketing’s assistance, Gray Falkon successfully created a cohesive brand for marketing content. Our team used those enhanced branding elements to create an eBook (including the creative and copywriting) that they have been using since, and the inside sales campaign connected them with 38 high-value leads. Two of these leads closed within one month of the completion of our sales pilot, with others still ongoing.

    As Gray Falkon continues to work with the prospects this sales program generated, they remain an active partner of &Marketing. If you are interested in learning more about Gray Falkon, visit their website at www.grayfalkon.com or review their free eBook which our team helped create.

    I really enjoyed working with the &Marketing team on this project. They really helped us build a program that had an immediate impact at a critical time of the year for our target audience (Thanksgiving for brand owners on Amazon is critical!). Being a small company ourselves, we’re not that well known and have budget constraints.

    &Marketing was able to help us quickly and efficiently professionalize our marketing materials, develop a unique approach for us, and conduct the program cohesively. I’m happy with the results, and even happier to say that we’re seeing high returns for our investment with increased sales”

    - Trajan Bayly, CEO, Gray Falkon

    Market & Goal Alignment

    %

    Branding Assessment & Visual Upgrade

    %

    Copywriting & Content Creation

    %

    Creation of Leads via Inside Sales Program

    Detailed Reporting on Lead Status & Content Reception

    Are you facing challenges of your own in generating leads and meeting your business’ growth goals?

    We’d love to learn more about your challenges and how a coordinated marketing approach might help take your organization to the next level.

    About &Marketing:

    &Marketing provides the robust outsourced marketing department growing companies need without the high overhead costs of big agencies or full-time employees. Our variable model empowers businesses to reach their growth goals through access to the guidance and expertise of senior level strategists and a flexible execution team.