Connect with us

MARKETING

Excel For Marketers: Make Your PPC Dashboards Dynamic With Data Validation

Published

on

PPC dashboards are great for account managers, but they’re even better if they’re dynamic! What do I mean by dynamic, though?

A dashboard is dynamic when you can easily change inputs and review the corresponding output.

For example, in the dashboard below, I can select any of my campaign labels and the data in the dashboard will adjust according to which label I’ve chosen.

completed dynamic excel dashboard

In this post, I’ll walk you through the necessary steps to create this kind of dynamic dashboard!

What is Data Validation?

First, we need to review data validation in Excel. Data validation only allows data inputs within a specified range in the chosen cells. In the example below, I’ve used data validation to limit this cell to only the list of months in the dropdown menu.

Data validation doesn’t have to be a list. It can be a number of different data types, including:

  • Whole Number
  • Decimal
  • List
  • Date
  • Time
  • Text Length
  • Custom

The benefits of limiting a cell to a specific set of values include:

  • It prevents data entry errors
  • It’s less manual and thus more efficient

In this PPC use case, we’re making our dashboard more efficient by enabling the dashboard to change with the campaign label inputs, versus creating one separate dashboard for every campaign label in your paid search account. We’ll use data validation to create a dropdown list of all labels in our PPC account. Finally, we’ll set up the dashboard data so that it’s dynamically pulled from the raw data sheet based on which label you’ve chosen from the data validation dropdown list.

How To Set Up Data Validation

For this example, we want to set up data validation in the Label cell.

dashboard for ppc account

First, go to your raw data sheet, which contains the data you exported from your PPC campaigns. Determine which data field you want your dashboard to be based on. In this example, we want the dashboard data to dynamically change based on the Label of the campaign. We highlight that column in our raw data and copy it.

ppc data highlight labels

On another worksheet, paste that column and title it “LabelList”. Then, with the labels still highlighted, remove the duplicates with the Remove Duplicates button on the Data tab.

Once you’ve removed the duplicates and have a concise list of labels, you should name the list. This isn’t required, but it helps eliminate potential mistakes later on. Highlight your list, including the header, and then use the Create From Selection button in the Formulas tab. Create the list name based on the top row, where the header is located.

Once you have a list, you’re ready to add data validation to your dashboard. Click the cell where you want to place your dropdown list.

Then, go to the Data tab and select “Data Validation”. The pop-up below should appear.

data validation helper in excel

For Validation criteria, choose List.

data validation options in excel

For Source, use “=LabelList”.

data validation source in excel

And that’s it! You should now have a dropdown that’s based on your LabelList.

excel dashboard with data validation

From there, you need to connect the PPC metric cells to the raw data and the new data validation cell. In my raw data, I’ve used Excel’s Create From Selection feature to name every field that I exported from my PPC account. That’s why in the formula below, you’ll see “Label” and “Impr.”. Those are the named ranges I created for my labels and impressions column in my raw data. With those, you can easily write the formula below to tell Excel to sum the respective metric from the raw data IF the label column contains whatever label you’ve selected in E4.

excel dashboard with dynamic data

And voila! You now have a dynamic PPC dashboard.

If you want to take your dashboards one step further, you can link either your Excel workbook or maybe your Google sheet to the actual data source, like Google Ads. You can create triggers that pull Google data into your workbook on a regular basis so that your dashboard is always using the most updated data.

I hope this post helps you get one step closer to automating your dashboards and PPC reporting! Data validation has been a huge time-saver for me and my team, so I believe you can benefit too.

If you want more hands-on Excel tips, I’ll be running an Excel workshop at Hero Conf Austin this year. You can get more information on that workshop here.

PPChero.com

MARKETING

3 Smart Bidding Strategies To Help You Get the Most Out of Your Google Ads

Published

on

3 Smart Bidding Strategies To Help You Get the Most Out of Your Google Ads

Now that we’ve officially settled into the new year, it’s important to reiterate that among the most effective ways to promote your business are Google Ads. Not only do Google Ads increase your brand visibility, but they also make it easier for you to sell your services and products while generating more traffic to your website.

The thing about Google Ads, though, is that setting up (and running) a Google Ads campaign isn’t easy – in fact, it’s pretty beginner-unfriendly and time-consuming. And yet, statistically speaking, no platform does what Google Ads can do when it comes to audience engagement and outreach. Therefore, it will be beneficial to learn about and adopt some smart bidding strategies that can help you get the most out of your Google Ads.

To that end, let’s check out a few different bidding strategies you can put behind your Google Ads campaigns, how these strategies can maximize the results of your Google Ads, and the biggest benefits of each strategy.

Smart bidding in Google Ads: what does it mean, anyway?

Before we cover the bidding strategies that can get the most out of your Google Ads, let’s define what smart bidding means. Basically, it lets Google Ads optimize your bids for you. That doesn’t mean that Google replaces you when you leverage smart bidding, but it does let you free up time otherwise spent on keeping track of the when, how, and how much when bidding on keywords.

The bidding market is simply too big – and changing too rapidly – for any one person to keep constant tabs on it. There are more than 5.5 billion searches that Google handles every day, and most of those searches are subject to behind-the-scenes auctions that determine which ads display based on certain searches, all in a particular order.

That’s where smart bidding strategies come in: they’re a type of automated bidding strategy to generate more conversions and bring in more money, increasing your profits and cash flow. Smart bidding is your way of letting Google Ads know what your goals are (a greater number of conversions, a goal cost per conversion, more revenue, or a better ROAS), after which Google checks what it’s got on file for your current conversion data and then applies that data to the signals it gets from its auctions.

Types of smart bidding strategies

Now that you know what smart bidding in Google Ads is and why it’s important, let’s cover the best smart bidding strategies you can use to your advantage.

Maximize your conversions

The goal of this strategy is pretty straightforward: maximize your conversions and get the most out of your budget’s allocation toward said conversions. Your conversions, be they a form submission, a customer transaction, or a simple phone call, are something valuable that you want to track and, of course, maximize.

The bottom line here is simply generating the greatest possible number of conversions for your budget. This strategy can potentially become costly, so remember to keep an eye on your cost-per-click and how well your spending is staying inside your budget.

If you want to be extra vigilant about keeping conversion costs in a comfy range, you can define a CPA goal for your maximize conversions strategy (assuming you’ve got this feature available).

Target cost per acquisition

The purpose behind this strategy is to meet or surpass your cost-per-acquisition objective that’s tied to your daily budget. When it comes to this strategy, it’s important to determine what your cost-per-acquisition goal is for the strategy you’re pursuing.

In most cases, your target cost per acquisition goal will be similar to the 30-day average you’ve set for your Google Ads campaign. Even if this isn’t going to be your end-all-be-all CPA goal, you’ll want to use this as a starting point.

You’ll have lots of success by simply leveraging target cost per acquisition on a campaign-by-campaign basis, but you can take this one step further by creating a single tCPA bid strategy that you share between every single one of your campaigns. This makes the most sense when running campaigns with identical CPA objectives. That’s because you’ll be engaging with a bidding strategy that’s fortified with a lot of aggregate data from which Google’s algorithm can draw, subsequently endowing all of your campaigns with some much-needed experience.

Maximize clicks

As its name implies, this strategy centers around ad optimization to gain as many clicks as possible based on your budget. We recommend using the maximize clicks strategy if you’re trying to drive more traffic to your website. The best part? Getting this strategy off the ground is about as easy as it gets.

All you need to do to get started with maximizing clicks is settle on a maximum cost-per-click that you then earmark. Once that’s done, you can decide how much money you want to shell out every time you pay for a bid. You don’t actually even need to specify an amount per bid since Google will modify your bids for you to maximize your clicks automatically.

Picture this: you’ve got a website you’re running and want to drive more traffic to it. You decide to set your maximum bid per click at $2.5. Google looks at your ad, adjusts it to $3, and automatically starts driving more clicks per ad (and more traffic to your site), all without ever going over the budget you set for your Google Ads campaign.

Conclusion

If you’ve been using manual bidding until now, you probably can’t help but admit that you spend way too much time wrangling with it. There are plenty of other things you’d rather be – and should be – spending your time on. Plus, bids change so quickly that trying to keep up with them manually isn’t even worth it anymore.

Thankfully, you’ve now got a better grasp on automated and smart bidding after having read through this article, and you’re aware of some important options you have when it comes to strategies for automated bidding. Now’s a good time to explore even more Google Ads bidding strategies and see which ones make the most sense when it comes to your unique and long-term business objectives. Settle on a strategy and then give it a whirl – you’ll only know whether a strategy is right for you after you’ve tested it time and time again. Good luck!

Source link

Continue Reading

MARKETING

Is Twitter Still a Thing for Content Marketers in 2023?

Published

on

Is Twitter Still a Thing for Content Marketers in 2023?

The world survived the first three months of Elon Musk’s Twitter takeover.

But what are marketers doing now? Did your brand follow the shift Dennis Shiao made for his personal brand? As he recently shared, he switched his primary platform from Twitter to LinkedIn after the 2022 ownership change. (He still uses Twitter but posts less frequently.)

Are those brands that altered their strategy after the new ownership maintaining that plan? What impact do Twitter’s service changes (think Twitter Blue subscriptions) have?

We took those questions to the marketing community. No big surprise? Most still use Twitter. But from there, their responses vary from doing nothing to moving away from the platform.

Lowest points

At the beginning of the Elon era, more than 500 big-name advertisers stopped buying from the platform. Some (like Amazon and Apple) resumed their buys before the end of 2022. Brand accounts’ organic activity seems similar.

In November, Emplifi research found a 26% dip in organic posting behavior by U.S. and Canadian brands the week following a significant spike in the negative sentiment of an Elon tweet. But that drop in posting wasn’t a one-time thing.

Kyle Wong, chief strategy officer at Emplifi, shares a longer analysis of well-known fast-food brands. When comparing December 2021 to December 2022 activity, the brands posted 74% less, and December was the least active month of 2022.

Fast-food brands posted 74% less on @Twitter in December 2022 than they did in December 2021, according to @emplifi_io analysis via @AnnGynn @CMIContent. Click To Tweet

When Emplifi analyzed brand accounts across industries (2,330 from U.S. and Canada and 6,991 elsewhere in the world), their weekly Twitter activity also fell to low points in November and December. But by the end of the year, their activity was inching up.

“While the percentage of brands posting weekly is on the rise once again, the number is still lower than the consistent posting seen in earlier months,” Kyle says.

Quiet-quitting Twitter

Lacey Reichwald, marketing manager at Aha Media Group, says the company has been quiet-quitting Twitter for two months, simply monitoring and posting the occasional link. “It seems like the turmoil has settled down, but the overall impact of Twitter for brands has not recovered,” she says.

@ahamediagroup quietly quit @Twitter for two months and saw their follower count go up, says Lacey Reichwald via @AnnGynn @CMIContent. Click To Tweet

She points to their firm’s experience as a potential explanation. Though they haven’t been posting, their follower count has gone up, and many of those new follower accounts don’t seem relevant to their topic or botty. At the same time, Aha Media saw engagement and follows from active accounts in the customer segment drop.

Blue bonus

One change at Twitter has piqued some brands’ interest in the platform, says Dan Gray, CEO of Vendry, a platform for helping companies find agency partners to help them scale.

“Now that getting a blue checkmark is as easy as paying a monthly fee, brands are seeing this as an opportunity to build thought leadership quickly,” he says.

Though it remains to be seen if that strategy is viable in the long term, some companies, particularly those in the SaaS and tech space, are reallocating resources to energize their previously dormant accounts.

Automatic verification for @TwitterBlue subscribers led some brands to renew their interest in the platform, says Dan Gray of Vendry via @AnnGynn @CMIContent. Click To Tweet

These reenergized accounts also are seeing an increase in followers, though Dan says it’s difficult to tell if it’s an effect of the blue checkmark or their renewed emphasis on content. “Engagement is definitely up, and clients and agencies have both noted the algorithm seems to be favoring their content more,” he says.

New horizon

Faizan Fahim, marketing manager at Breeze, is focused on the future. They’re producing videos for small screens as part of their Twitter strategy. “We are guessing soon Elon Musk is going to turn Twitter into TikTok/YouTube to create more buzz,” he says. “We would get the first moving advantage in our niche.”

He’s not the only one who thinks video is Twitter’s next bet. Bradley Thompson, director of marketing at DigiHype Media and marketing professor at Conestoga College, thinks video content will be the next big thing. Until then, text remains king.

“The approach is the same, which is a focus on creating and sharing high-quality content relevant to the industry,” Bradley says. “Until Twitter comes out with drastically new features, then marketing and managing brands on Twitter will remain the same.

James Coulter, digital marketing director at Sole Strategies, says, “Twitter definitely still has a space in the game. The question is can they keep it, or will they be phased out in favor of a more reliable platform.”

Interestingly given the thoughts of Faizan and Bradley, James sees businesses turning to video as they limit their reliance on Twitter and diversify their social media platforms. They are now willing to invest in the resource-intensive format given the exploding popularity of TikTok, Instagram Reels, and other short-form video content.

“We’ve seen a really big push on getting vendors to help curate video content with the help of staff. Requesting so much media requires building a new (social media) infrastructure, but once the expectations and deliverables are in place, it quickly becomes engrained in the weekly workflow,” James says.

What now

“We are waiting to see what happens before making any strong decisions,” says Baruch Labunski, CEO at Rank Secure. But they aren’t sitting idly by. “We’ve moved a lot of our social media efforts to other platforms while some of these things iron themselves out.”

What is your brand doing with Twitter? Are you stepping up, stepping out, or standing still? I’d love to know. Please share in the comments.

Want more content marketing tips, insights, and examples? Subscribe to workday or weekly emails from CMI.

HANDPICKED RELATED CONTENT:

Cover image by Joseph Kalinowski/Content Marketing Institute



Source link

Continue Reading

MARKETING

45 Free Content Writing Tools to Love [for Writing, Editing & Content Creation]

Published

on

45 Free Content Writing Tools to Love [for Writing, Editing & Content Creation]

Creating content isn’t always a walk in the park. (In fact, it can sometimes feel more like trying to swim against the current.)

While other parts of business and marketing are becoming increasingly automated, content creation is still a very manual job. (more…)

Continue Reading

Trending

en_USEnglish