CBPO

Tag: Know

SQL for Marketing Analysis – All Google Analytics Analysts Should Know

July 23, 2019 No Comments

Marketers and Marketing Analysts generally depend on the tools or IT department to help them pull the data for marketing purposes. There comes a time when they can’t just wait around for IT to help them data pulls and manipulations.  They have to know how to do it on their own. This course is for those marketers who would like to know how to use SQL to conduct their marketing analysis.

The course uses MYSQL to show how SQL works but all the leanings and syntax are applicable to other databases as well.  Sign up for SQL for Marketers and Marketing Analysts

SQLForMarketersCoverImage


Google Analytics Premium


What Every Startup Needs to Know Before They Select a PPC Marketing Agency

July 10, 2019 No Comments

As someone who has been fortunate enough to be a part both the Startup and Digital Agency World, it pains me to witness the many recurring mistakes that are happening by bringing these two worlds together. The Agency wants the business and the Startup wants the best and smartest people to “grow their baby”. It all sounds like a “no-brainer’ right? Well, this perfect situation can sometimes be clouded by one of the most bastardized words in the client-agency relationship – Expectations. In this post, I will highlight some of the misconceptions that could, at the very least, help the next Startup as they prepare to show their product/service to the world.

How to Play the Digital Agency Game:

Don’t get me wrong. There are many highly reputable Marketing Agencies in the world that do not fit this description. On the other hand, there are some other Agencies that work on a different playing field that is not financially supportive of Startups. Most agencies take a 15% commission of Ad Spend regardless of performance or the companies financial situation. These agencies often provide a “Production Line” level level of service that question the actual time spend which leads to the overall client performance. Beware of agencies that promise GOLD and deliver pennies.

What Startups really need from an Agency:

  • 100% transparency of where and how their money is being spent.
  • Daily Direct communication with the Strategist/Marketer.
  • Less than 24 hour turn-around times for typical updates.
  • Level of ongoing Education on how the digital advertising world works.

Big Agency Regurgitation

I have witnessed many horror stories over the years from prospects/clients from either a performance or client relationship with a previous agency. The one thing that all of them had in common was the lack of achievable expectations. Situations such as poor communication, lackluster performance and just an overall bad experience have not only left a bitter taste in their mouth but also question the entire agency experience. Moreover, this feeling of being “burned” has motivated their thinking to bring the marketing “in-house” as the only alternative to reaching success. This is not a good thing….

Conference Intoxication

As a big fan of conferences, they often open your eyes to a whole new world of innovation, prosperity and vision for business owners and that’s a great thing. However, it can sometimes backfire to the point of confusion and anxiety of what to focus on first. It is very easy for Entrepreneurs to get “over-excited” about the latest bells and whistles in software, automation and analytics. They are told that once they have these tools in their toolbox, they can turn their business into a fortune 100 company instantly.

Unfortunately, a reality check is needed to bring everyone down from this “high” and re-focus on the core issue at hand which is identifying, engaging and converting with their core audiences within a sensible budget. Remember, investing in Shiny Objects make you vulnerable, not successful.

The Misunderstanding of Monetization

In some instances, both advertisers and agencies, often forget to track every interaction point and that little oversight can be an unfortunate mistake. This assumed “low-hanging” fruit for tracking things other than traditional eCommerce/Lead Gen Forms such as (below) can completely skew overall performance and future optimization which could be devastating to startups as they hunger for continual growth.

  • Contact Forms
  • Email Newsletter Signups
  • Live Chats
  • Phone Calls
  • Pageviews of a particular page can lead to

Mistrust of the Case Study

Case Studies are a great source for understanding the successes of a particular experience that allow the reader to adapt to new ideas and strategies. However, you need to be careful not put to put too much emphasis on the successes of these studies because of the substantiated factors which often lead inaccuracy. Here are some examples:

  • Geography (Some of these studies reference a specific GEO area and not the wider population)
  • Singular view and opinion. Often, these studies are done by a small group of people which may have biased opinions based on data collected.
  • Case Studies are often used as a “Toot your own horn” strategy to generate more business. (Google is pretty good at that)

Don’t Bet the Farm

I can understand the anxieties of Startups where they want to launch their business with a big bang. However, spending too much too fast (especially in the PPC marketing world) can completely ruin their chances for steady sustainable growth. It’s imperative to start testing “right out of the gate” as well as identifying the quick wins and losses. Moreover, you will need to develop strategies to generate relevent traffic and awareness through alternative methods such as Social Media, SEO and quite frankly “word of mouth”. To prove this theory, just a take a look at these screenshots from SpyFu’s Monthly Trend function.

ppc startups

Outside Opinion Overload

Yes, it’s important to get as much feedback as possible when launching a new company. However, getting advice from people who think they know certain aspects of online marketing because they read an article or attended a conference, can be a slippery slope. Taking advice and/or criticism from someone “on the outside” that completely contradicts the vision of both your business partners and hired experts can be harmful to the business. This 3rd party opinion is often made without any understanding of what it takes to implement as well as its expected outcome. Whether it’s strategies about Landing Pages, Brand vs. Non-Brand, or even simple things such as Promotions and Offers can have a negative effect on revenue if not discussed by everyone on the team.

Solution: Soak up all of the feedback you can get, discuss with your team and agree to label these new ideas as “TEST” Campaigns and analyze the heck out of them.

Forecast Projection Failures

How many times have you seen someone simply create excel formulas which magically forecast the future of online marketing revenue based on a single monetary amount. (For example, if we increase our budget from $ 10,000 to $ 100,000 we will generate an additional $ 1 million dollars.) Yeah, I wish that were all true. However, that is not the case. The math may sound great to a Venture Capitalist/Investor, but it’s just not realistic.

  • Take in account the following scenarios:
  • Market Saturation Levels
  • Seasonality Highs/Lows
  • Potential Technical issues
  • Search Engine Algorithm changes
  • Increased Competitor landscape

“Off the Mark” Target Audiences

Hate to say this, but I have witnessed startup companies that thought they new their audiences and it wasn’t until they over-spent their PPC dollars and countless Landing Page A/B test to come to that realization. Selling a product or service requires more than just a few hours of typical market research. When it comes to online marketing, either hire a PPC Consultant or purchase PPC Competitive Research Software such as SpyFu.com to see some of these invaluable competitor information:

  • Monthly Budget Trends
  • PPC and SEO Keywords
  • Top Text Ads
  • Their own PPC and SEO Competitors
  • Review monthly and seasonality trends
  • Compare up to (3) three competitors and see which terms they are all bidding on.

Here’s an example:

PPC Competitive Analysis

In Conclusion

Whether you are building a Startup company or growing an existing one, the agency experience should be a positive one. However, dealing with the “dog eat dog” agency world when it comes to trust, expectations and continual growth is unfortunate and should never happen. I hope this blog post, at the very least, has provided some insight into preventing these situations as well as learning from them. Finding the right agency partner is just as important as finding the right target audience.


PPC Marketing Consultant | Google Ads Agency


We still don’t know how much of Libra Facebook owns

July 7, 2019 No Comments

The $ 10 million entry fee to join the Facebook-developed cryptocurrency’s Libra Association is merely a minimum. Members who’ll verify transactions can opt to invest more in exchange for more Libra Investment Tokens that will earn them dividends from the interest earned by the Libra Reserve after it pays for infrastructure and operations costs. If regulators allow it to launch after today requesting a halt of development, and the cryptocurrency grows popular with tons of people cashing in local currencies for Libra, the Reserve that holds those assets could grow huge and generate meaningful returns via interest — especially for members willing to sink a ton of money in early.

But therein lies potential disalignment of incentives.

If you’re confused, read our guide to everything about Libra

Each Libra Association member only gets one vote on the council, including Facebook . But if Facebook puts in $ 500 million and another member like eBay antes up just the $ 10 million minimum, Facebook has a much bigger incentive to get people cashing into Libra and holding onto the cryptocurrency so the Reserve earns interest on those dollars or other fiat, rather than just getting people to transact with it regardless of whether they hold on to Libra permanently. That could lead Facebook (and its Calibra subsidiary representing it) to push governance decisions that would disproportionately benefit it.

Ahead of the Libra announcement two weeks ago, Facebook’s head of blockchain and now Calibra David Marcus told me, “The reserve earns interest on some of those treasuries. It’s a small amount and it’s variable, but if the reserve becomes big it could become a substantial way to fund the association but also return capital to investors.”

Yet Facebook, for all its talk about transparency with Libra, refused to tell me how much it’s invested into the Libra project as a whole or the Libra Investment Token. That should be a core question raised by Congress when Marcus testifies before the Senate Banking Chair on July 16th and the House Financial Services Committee on July 17th. Facebook did not respond to requests for comment on this article. Congress should also be sure to ask how Libra will avoid a Cambridge Analytica-style crypto disaster given that apps built on the Libra developer platform aren’t subject to review.

The proportion of the total Libra Investment Tokens that Facebook owns in part determines how decentralized Libra really is. If Facebook owns the lion’s share or a majority, that could give it too much financial impetus to bend the rules in its favor even if it only has one vote on the council.

Here’s how. Facebook has led development of Libra to date. In fact, the Libra Association has yet to draw up and ratify a charter or formally admit members. Technically it’s just Facebook’s project right now. “So far we’ve been funding it all,” Marcus told The Information’s Alex Heath. It’s also been coding it all, organizing it all and communicating it all.

As such, for now the project can’t survive without Facebook, and may not be able to for quite a while. That means that if at any time Facebook disagrees so strongly with the Libra Association that it threatens to pull out, it jeopardizes the investment of all the other members. That could coerce them to vote in support of its governance policy suggestions. Facebook thereby wouldn’t need more than one vote to have a much larger influence on the direction of the project.

Today in a Facebook Note (…not a Libra.org blog post), Marcus wrote, “The levels of investments of each of the partners will most likely be public as well when that’s actually live.” But that’s far from a guarantee, and could come too late for regulators to intercede or other members to truly understand the asymmetry.

Meanwhile, Marcus also said that “We’ve been basically lending money to the association that will be at some point repaid back.” That raises another question of how much Facebook has already sunk into the Libra project, how much it expects to be repaid and on what schedule. Members might be more skittish to join if they learn much of their $ 10 million investment might just go to paying back Facebook. 

That’s not to mention the other ways Facebook will earn money from Libra. Marcus wrote today that “If Libra is successful, Facebook will first benefit from it by enabling more commerce across its family of apps. More commerce means ads will be more effective, and advertisers will buy more of them to grow their businesses. Additionally, if we earn people’s trust with the Calibra wallet over time, we will also be in a position to start offering more financial services, and generate other revenue streams for the company.”

The fact that Facebook oversees development and has a massive head start on building its wallet that will be baked into its billion-plus user Messenger and WhatsApp products sure doesn’t hurt its prospects for offering other financial services. It will be first to market, instantly at scale, with an insider’s role in defining the rule book.

I’m not discounting the potential Libra has to aid the unbanked who can’t pay fees for having too little money in their accounts, or make commerce cheaper for small businesses. But if Facebook stands to earn outsized returns directly and indirectly from Libra, while expecting other members to foot its R&D bill, and these numbers aren’t made public soon, it’s reasonable to question how decentralized and altruistic this project really is.


Social – TechCrunch


Your First Google Ads Campaign: Everything You Should Know

May 20, 2019 No Comments

This article goes over the very basics of getting started advertising with Google Ads for someone with little to no experience.

Read more at PPCHero.com
PPC Hero


What we want to know in the We Company (WeWork) S-1

April 30, 2019 No Comments

With news that the We Company (formerly known as WeWork) has officially filed to go public confidentially with the SEC today, there’s a big question on everyone’s mind: Is this the next massive startup win or a house of cards waiting to be toppled by the glare of the public markets?

No company I follow has as much polarized opinion as the We Company. And while the company will have to reveal at least some of its hand in its official S-1, my guess is that the polarization around the company will not be alleviated until well after it goes public, if ever.

The challenge with understanding its business is how much the details of each of its leases, real estate markets and tenants matter to its bottom line. We already know the top line numbers: the company had revenue of $ 1.8 billion in 2018, and a net loss of $ 1.9 billion that year. That led to the received opinion that the company has an extraordinarily weak business. As Crunchbase News editor Alex Wilhelm put it:


Startups – TechCrunch


Facebook Messenger Marketing and Chatbots: What Every PPC Marketer Needs to Know Right Now

February 24, 2019 No Comments

I’ll be upfront. My goal here is to persuade you that you should be using Facebook Messenger marketing and chatbots as part of your marketing strategy. This isn’t a sales pitch. This isn’t an infomercial. This is hard-hitting marketing intel. Whether you’re a PPC specialist, an SEO, a CMO, or just a curious bystander, I […]

Read more at PPCHero.com
PPC Hero


What Every Startup Needs to Know Before They Select a PPC Marketing Agency

February 10, 2019 No Comments

As someone who has been fortunate enough to be a part both the Startup and Digital Agency World, it pains me to witness the many recurring mistakes that are happening by bringing these two worlds together. The Agency wants the business and the Startup wants the best and smartest people to “grow their baby”. It all sounds like a “no-brainer’ right? Well, this perfect situation can sometimes be clouded by one of the most bastardized words in the client-agency relationship – Expectations. In this post, I will highlight some of the misconceptions that could, at the very least, help the next Startup as they prepare to show their product/service to the world.

How to Play the Digital Agency Game:

Don’t get me wrong. There are many highly reputable Marketing Agencies in the world that do not fit this description. On the other hand, there are some other Agencies that work on a different playing field that is not financially supportive of Startups. Most agencies take a 15% commission of Ad Spend regardless of performance or the companies financial situation. These agencies often provide a “Production Line” level level of service that question the actual time spend which leads to the overall client performance. Beware of agencies that promise GOLD and deliver pennies.

What Startups really need from an Agency:

  • 100% transparency of where and how their money is being spent.
  • Daily Direct communication with the Strategist/Marketer.
  • Less than 24 hour turn-around times for typical updates.
  • Level of ongoing Education on how the digital advertising world works.

Big Agency Regurgitation

I have witnessed many horror stories over the years from prospects/clients from either a performance or client relationship with a previous agency. The one thing that all of them had in common was the lack of achievable expectations. Situations such as poor communication, lackluster performance and just an overall bad experience have not only left a bitter taste in their mouth but also question the entire agency experience. Moreover, this feeling of being “burned” has motivated their thinking to bring the marketing “in-house” as the only alternative to reaching success. This is not a good thing….

Conference Intoxication

As a big fan of conferences, they often open your eyes to a whole new world of innovation, prosperity and vision for business owners and that’s a great thing. However, it can sometimes backfire to the point of confusion and anxiety of what to focus on first. It is very easy for Entrepreneurs to get “over-excited” about the latest bells and whistles in software, automation and analytics. They are told that once they have these tools in their toolbox, they can turn their business into a fortune 100 company instantly.

Unfortunately, a reality check is needed to bring everyone down from this “high” and re-focus on the core issue at hand which is identifying, engaging and converting with their core audiences within a sensible budget. Remember, investing in Shiny Objects make you vulnerable, not successful.

The Misunderstanding of Monetization

In some instances, both advertisers and agencies, often forget to track every interaction point and that little oversight can be an unfortunate mistake. This assumed “low-hanging” fruit for tracking things other than traditional eCommerce/Lead Gen Forms such as (below) can completely skew overall performance and future optimization which could be devastating to startups as they hunger for continual growth.

  • Contact Forms
  • Email Newsletter Signups
  • Live Chats
  • Phone Calls
  • Pageviews of a particular page can lead to

Mistrust of the Case Study

Case Studies are a great source for understanding the successes of a particular experience that allow the reader to adapt to new ideas and strategies. However, you need to be careful not put to put too much emphasis on the successes of these studies because of the substantiated factors which often lead inaccuracy. Here are some examples:

  • Geography (Some of these studies reference a specific GEO area and not the wider population)
  • Singular view and opinion. Often, these studies are done by a small group of people which may have biased opinions based on data collected.
  • Case Studies are often used as a “Toot your own horn” strategy to generate more business. (Google is pretty good at that)

Don’t Bet the Farm

I can understand the anxieties of Startups where they want to launch their business with a big bang. However, spending too much too fast (especially in the PPC marketing world) can completely ruin their chances for steady sustainable growth. It’s imperative to start testing “right out of the gate” as well as identifying the quick wins and losses. Moreover, you will need to develop strategies to generate relevent traffic and awareness through alternative methods such as Social Media, SEO and quite frankly “word of mouth”. To prove this theory, just a take a look at these screenshots from SpyFu’s Monthly Trend function.

ppc startups

Outside Opinion Overload

Yes, it’s important to get as much feedback as possible when launching a new company. However, getting advice from people who think they know certain aspects of online marketing because they read an article or attended a conference, can be a slippery slope. Taking advice and/or criticism from someone “on the outside” that completely contradicts the vision of both your business partners and hired experts can be harmful to the business. This 3rd party opinion is often made without any understanding of what it takes to implement as well as its expected outcome. Whether it’s strategies about Landing Pages, Brand vs. Non-Brand, or even simple things such as Promotions and Offers can have a negative effect on revenue if not discussed by everyone on the team.

Solution: Soak up all of the feedback you can get, discuss with your team and agree to label these new ideas as “TEST” Campaigns and analyze the heck out of them.

Forecast Projection Failures

How many times have you seen someone simply create excel formulas which magically forecast the future of online marketing revenue based on a single monetary amount. (For example, if we increase our budget from $ 10,000 to $ 100,000 we will generate an additional $ 1 million dollars.) Yeah, I wish that were all true. However, that is not the case. The math may sound great to a Venture Capitalist/Investor, but it’s just not realistic.

  • Take in account the following scenarios:
  • Market Saturation Levels
  • Seasonality Highs/Lows
  • Potential Technical issues
  • Search Engine Algorithm changes
  • Increased Competitor landscape

“Off the Mark” Target Audiences

Hate to say this, but I have witnessed startup companies that thought they new their audiences and it wasn’t until they over-spent their PPC dollars and countless Landing Page A/B test to come to that realization. Selling a product or service requires more than just a few hours of typical market research. When it comes to online marketing, either hire a PPC Consultant or purchase PPC Competitive Research Software such as SpyFu.com to see some of these invaluable competitor information:

  • Monthly Budget Trends
  • PPC and SEO Keywords
  • Top Text Ads
  • Their own PPC and SEO Competitors
  • Review monthly and seasonality trends
  • Compare up to (3) three competitors and see which terms they are all bidding on.

Here’s an example:

PPC Competitive Analysis

In Conclusion

Whether you are building a Startup company or growing an existing one, the agency experience should be a positive one. However, dealing with the “dog eat dog” agency world when it comes to trust, expectations and continual growth is unfortunate and should never happen. I hope this blog post, at the very least, has provided some insight into preventing these situations as well as learning from them. Finding the right agency partner is just as important as finding the right target audience.


PPC Marketing Agency | Search Marketing Firm | Adwords Certified Consultant


A ton of people don’t know that Facebook owns WhatsApp

October 18, 2018 No Comments

Americans looking to reduce their reliance on products from tech’s most alarmingly megalithic companies might be surprised to learn just how far their reach extends.

Privacy-minded browser company DuckDuckGo conducted a small study to look into that phenomenon and the results were pretty striking.

“… As Facebook usage wanes, messaging apps like WhatsApp are growing in popularity as a ‘more private (and less confrontational) space to communicate,’” DuckDuckGo wrote in the post. “That shift didn’t make much sense to us because both services are owned by the same company, so we tried to find an explanation.”

DuckDuckGo gathered a random sample of 1,297 adult Americans who are “collectively demographically similar to the general population of U.S. adults” (i.e. not just DuckDuckGo diehards) using SurveyMonkey’s audience tools. The survey found that 50.4 percent of those surveyed who had used WhatsApp in the prior six months (247 participants) did not know the company is owned by Facebook.

Similarly, DuckDuckGo found that 56.4 percent of those surveyed who had used Waze in the past six months (291 participants) had no idea that the navigation app is owned by Google. A similar study conducted back in April found the same phenomenon when it came to Facebook/Instagram and Google/YouTube, though for Instagram the effect was even stronger (wow).

If you’re reading TechCrunch it’s probably almost impossible to imagine that average people aren’t tracing the lines between tech’s biggest companies and the products scooped up or built under their wings. And yet, it is so.

Even as companies like Google and Facebook suffer blowback from privacy crises, it’s clear that they can lean on the products they’ve picked up along the way to chart a path forward. If this survey is any indication, half of U.S. consumers will have no idea that they’ve jumped ship from a big tech product into a lifeboat captained by the very same company they sought to escape.

And for the biggest tech companies, it’s at least one reason that keeping satellite products at arm’s length from their respective motherships is advantageous for maintaining trust — especially while aggressive data sharing happens behind the scenes.


Social – TechCrunch


Get To Know Your Customer Better with Detailed Demographics

October 12, 2018 No Comments

Google has added greater ability to see who is searching for your products. Learn about some of the benefits of adding these new lists.

Read more at PPCHero.com
PPC Hero


All The Bing Ads Tracking Updates You Need To Know In One Place

August 22, 2018 No Comments

Get the latest on two important tracking updates happening in Bing Ads!

Read more at PPCHero.com
PPC Hero