Connect with us

MARKETING

Digital Marketing Data and How to Optimize Like a Champ

Published

on

There’s so much data, from so many different sources, with so many different reporting tools, that you could just drown in reports, attribution, and meetings. With so much noise out there, it’s important that you look at the data in a certain way. There’s important information hidden in the metrics that will help direct your digital marketing strategy.

In this article I’m going to walk you through this technique that I’ve been using for 25 years, called MAA.

Metrics, Analysis, Action

1651544206 499 Digital Marketing Data and How to Optimize Like a Champ

MAA stands for metrics, analysis, action.

Let me show you how powerful it is when you use this technique on any kind of data set you have. It could be SEO data, website data, email data, conversion data, shopping cart data.

The Data Doc is in…

Think of this as if you are a surgeon in the emergency room. You must follow these three steps.

  • Collect vitals.
  • Diagnose.
  • Treat.

First you collect the vitals. It could be heart rate, blood pressure, respiratory rate, x-rays things like that. These are the numbers that clue you in to the cause of the problem.

The second phase is the diagnosis. In this phase you interpret all the vitals that you collected. Based on the data, you make the determination of a heart attack, broken bone, virus, etc. The key point is that the diagnosis is based on the data.

From that diagnosis, you create the treatment plan. The plan might include surgery, medications, a recovery plan, etc. But the list of things to be done to make the patient healthier is based upon the findings and the diagnosis.

The marketing analytics data you collect leads directly to analysis of the problem. That then leads directly to the action. What I will show you in this article is a number of examples from a variety of digital marketing projects. This works whether you’re working on a large or small project.

Data vs Analytics

Lots of people think that they have analytics because they have Google Analytics installed on their website.

But let me tell you a dirty secret.

There are no analytics in Google Analytics. It’s just Google charts. It should be called Google Chart-Maker.

Marketing analytics is figuring out what’s actually going on. It’s the interpretation of the data. Interpreting the data tells you why sales went up or down. It helps you discover why conversion rates went up or down. Analyzing the data answers questions like:

  • Why did people buy or not buy?
  • Why did a competitor take a certain action?
  • Where are we losing customers along the customer journey?
  • Is our content hitting or missing with our customers?

Analytics is more than making charts and collecting data. And action is the next step after marketing analytics.

The way we see it, if you are not taking action based on the analytics, which was based on the data, then whatever you’re doing is random.

Returning to our analogy, not everyone should take the same pill. If you’ve got a broken bone, you shouldn’t take the same medication as someone who has a headache. So the action that you take, the optimization, should be contingent upon the analysis, which should go straight back to the data that you gathered.

Most people make the mistake of just trying to look at lots of data. This Metrics Analysis Action framework is the easiest way to figure out what you really need to do versus what’s noisy.

MAA Framework Case Study: Ecommerce

If you are in ecommerce, lead gen, or any kind of performance marketing, then you’re going to start with the action, mapped back to the analysis, and back to the metrics.

Because the actions are all the things that you could do.

So make a list of the things that you could do.

  • You can play with the website.
  • You can change your budgets.
  • You can change ads.
  • You can optimize creatives.
  • You can work with influencers.
  • You can buy another tool.
  • You can change bids.

Think of all the actions that you could take. Start with the end in mind.

Once you decide on the action, look for the trigger. In other words, when analyzing the data, what diagnosis will cause you to take that prescribed action?

That’s where you have automated rules on Google, Facebook, or Shopify. Wherever you’re looking at data, you can set up these rules.

For example, if your cost per acquisition goes above $50, then turn the ad set off. If someone leaves a positive review on Yelp, then reach out to them to say thank you.

So if a certain thing happens, then here’s the particular action.

Then there’s a limited number of things that you could do, so you don’t have to look at everything. And then if you need to determine if that triggering condition is true, then what data do you need?

Data, Analytics, and Attribution

1651544206 692 Digital Marketing Data and How to Optimize Like a Champ

On the far left of this image, we have plumbing. Plumbing is collecting the data from different tags in tag manager, UTM parameters, pixels that are firing, and other events inside an app.

These are the things that people are doing. For example, opening an email. When that happens, you get plenty of email marketing data. But the data doesn’t mean anything unless you can tie it to a goal.

How do you tie data to a goal?

Here’s a lifetime value example…

Seeds of Life sells flowers to people who’ve experienced the death of a loved one. The lifetime value (LTV) of a customer is $150. What can they do to increase the LTV?

They might offer a referral bonus, free shipping for orders over a hundred dollars, etc. Their goals, checked against the marketing analytics, will determine the direction of their next marketing campaign.

The important thing is to define the goals and measure them against the data. If the data doesn’t tie to the achievement of a particular goal, then you have to ask, “why are we even collecting that data?”

We’re not searching for a needle in a haystack, here. Although, that’s what most people do with their reporting.

1651544206 745 Digital Marketing Data and How to Optimize Like a Champ

Most people log into Google analytics, or whatever they use to pull in all the data from all the different places. And then they just hunt and peck and wander around and look for interesting things.

They look at the data then filter down to this date for that particular segment and this part of the country. It’s like the lotto, like the power ball where you choose six random balls to try to win the million dollar jackpot.

You want to have your goals before you figure out the plumbing.

Don’t Make the Same Mistakes with Analytics

Large and small companies make the same mistakes. They tend to go after impressions or click through rate or secondary metrics when the primary metric, the business goal, is more important than a diagnostic, secondary metric.

I love looking at cost per mille, or CPM, in advertising. For example, how much are you paying per thousand impressions? What is the trigger or check engine light, to let you know whether the algorithm is penalizing you for having a low click through rate, low quality score, low relevance score, etc.

Analyzing a marketing campaign in this way may show that something else is wrong.

Please don’t make the same mistake thinking that a secondary metric like click through rate, cost per click, quality score, or CPM is more important than the main business metric.

Profit, lifetime value, or cost of acquisition should be the goals that tie to your content and targeting.

Plumbing, Goals, Content, Targeting, Amplification, Optimization…

1651544206 96 Digital Marketing Data and How to Optimize Like a Champ

Here’s an example (above) of a marketing campaign we ran for our friend, Brennan.

At the very top are the financial metrics, specifically profit. There’s some kind of margin with or without cost of goods and services or overhead.

Then we have revenue minus costs.

Revenue is driven by factors like conversion rate, LTV, and how well you use things like recency and frequency to increase revenue.

Then there’s costs: people costs, ad costs, software costs, other kinds of costs.

On the revenue side, units (high price vs low price) multiplied by volume (clicks and/or conversion rate) is your revenue.

On the cost side, let’s say you run all your digital marketing campaigns on a cost per click basis. You can break that down to different fixed and variable costs. So we know if we double the number of clicks we’re buying from Google, we’re going to pay twice as much. Multiply the cost by the number of clicks you get for the overall cost of that campaign.

This decomposition pyramid helps you figure out the data you need to collect using secondary diagnostic metrics.

Start to think about how those different metrics will help you uncover the main issue to focus on right now.

MAA Framework: Case Study

1651544207 798 Digital Marketing Data and How to Optimize Like a Champ

Let’s look at how this actually applies when you’re looking at tabular data.

In this example (above), we’re looking at a lot of information. There are 132 ad sets here. That means we have all this information for 132 projects…

  • Data
  • Campaigns
  • Ads
  • Landing pages
  • Messages

This happens to be a set of Facebook campaigns, but it could easily be any social media platform or other traffic source.

We use a concept called “Top N” to select a manageable number of ad sets to work with. Why? Because it’s intimidating to try and look at ALL of them to diagnose the problem or issue.

You don’t have time to look at every single keyword, creative, or landing page. The idea of Top N is to look at the top, best- or worst-performing ad sets and ignore the rest. This is just another way of using the 80/20 rule or prioritizing your work.

I find that when you use the Top N technique on any large dataset you can quickly zero in on the most important thing.

In this case, we can see that this very first ad spent $10,000 out of $43,000. That means 25% of all of the money being spent is inside that one ad out of the 132 ads total.

1651544207 634 Digital Marketing Data and How to Optimize Like a Champ

Look a little more closely and you’ll see the top five already account for 60% of the total spend.

That’s not uncommon. In lots of cases the top three to five ads will account for about half of your ad spend.

Applying the Top N Method

I like to start by doing Top N on spend, because that’s where I can identify a “bleeder” (a high-spend ad with very low return).

Then I look at what drove the most revenue or had the highest number of conversions. Because then I can find where the winners are.

Then I look at clicks, leads, or other metrics that are important to the business.

Using this method, I kill the losing ads and amplify the winning ads.

Let’s say you were to sort just by conversions or revenue. If you do that, then you could have an ad that’s wasting lots of money that doesn’t make it into the top four or five for your most important metrics.

So I use Top N for three or four metrics in succession. Each time it reorders the ad sets or ads or creatives or whatever it is that you’re looking at.

You can use this method to determine ad performance in just three minutes.

Find and Fix the Issue

If something’s out of whack, it could require a big change or it could be something wrong with the tracking.

It could be iOS 14, or the pixel wasn’t on that landing page. It could be the data didn’t come through and it’s delayed. There’s all kinds of things that could play into why numbers aren’t adding up.

A lot of people freak out when sales are way down. Understandable. But many times it’s because of some silly issue. So before you pull the fire alarm, just think, does that really make sense?

I like this particular ad here.

1651544207 573 Digital Marketing Data and How to Optimize Like a Champ

There’s no way we spent this amount of money with no return. So we know there’s an issue. And we know with social media platforms like TikTok, Twitter, and Facebook, their systems often will not show data.

We know that because of the iOS 14 update, impressions and clicks are reported on different frequencies. So you might see a bunch of spend show up before the conversions show up or vice versa.

Make sure it’s statistically significant. Also make sure that you have enough data, so you don’t jump to any conclusions.

We’ve seen these systems spiral out of control. For example, let’s say you decide to reduce the bid amount on a marketing channel when the ROI falls below a certain amount. That seems logical. But if you’re only looking at revenue, not conversions, you might kill off a marketing campaign that was actually working quite well.

Imagine if it all boiled down to a hiccup in the data that caused the downward spiral. Not good. So be careful about that.

Now, if you see that a metric is out of whack and the data looks good, then ask yourself why that campaign isn’t performing as well.

Data and Instinct for the Win

1651544207 346 Digital Marketing Data and How to Optimize Like a Champ

Don’t let everything you do be completely automated and dependent upon rules. A successful marketing strategy requires a human touch.

Don’t set so many rules that the software automatically terminates your ads.

Instead, take a moment to look at how far out of bounds the ad performance is. It could be that you launched a new campaign and you’re doing an AB test or some kind of split test. The winner stays on and continues to win, even when other ads are losing, because you’re trying to find another winner to take its place.

If the cost per acquisition is high, then you can break that down using the metrics decomposition pyramid.

For example, the cost per acquisition will double if:

  • the conversion rate is cut in half and the cost per click is the same
  • the cost per click doubles and the conversion rate is the same

The cost per acquisition remains the same if either factor doubles while the other one is cut in half.

Always look at your marketing analytics when the cost per conversion goes up. Determine whether it’s because of the cost per click or the conversion rate.

When you run ads using objective-based bidding you don’t have to worry as much about cost per click, click through rate, or conversion rate because the artificial intelligence behind the ad platform is going to seek your target metric.

If the target metric is out of whack, you can decompose it into the underlying metrics.

That’s true for organic traffic. But it’s not as true for paid traffic because the systems are getting smarter and can optimize for the objective you set. Either way you should still look.

Balancing Metrics

This method gets you to look at metrics that matter according to our business goals. It gets you to think about and analyze why the data might be good or bad. And it gets you to outline the actions you’re going to take when goals aren’t being met. Over time you’ll find that the same pairing of metrics change alongside each other. So let’s talk about what these balancing metrics are.

One company we were working with was spending a hundred thousand dollars a month on advertising. When they were unhappy with the return, the analyst on the project adjusted the Google ad campaign. All of a sudden the cost per conversion dropped from $20 per lead to $7 per lead.

But I wanted to know how and why it dropped so dramatically. I found out that this person went into the Google ads campaign and turned off all the campaigns except for the brand search terms. Of course it was going to convert super well!

But the balancing metric was volume. When the analyst “fixed” the cost per conversion, the number of leads dropped from 5,000 leads a month to maybe a thousand leads a month.

The key takeaway here is that if you optimize one metric blindly, you can fool yourself into thinking everything is better when in reality another metric took a nosedive.

Analyzing Like a Scientist, but NOT a Rocket Scientist

1651544207 515 Digital Marketing Data and How to Optimize Like a Champ

Metrics don’t matter, unless there’s a clear analysis that can come from the information. Remember, you’re seeking a diagnosis.

Think like a surgeon or scientist. Start with a hypothesis. If a certain thing happens, what will you do to correct it and what outcome do you expect? If there’s no potential action based on some metric, there’s no need to gather the metrics.

I see companies spend most of their efforts collecting data. No one even knows why they’re using the data. Be strategic and ask, “what are we doing with this data? Is there some meaningful action we’re going to take?”

Maybe there’s another metric that would measure the goal better.

The point of analytics is to figure out whether something is worthwhile. Most of the data you thought was important, doesn’t even matter.

I’ll give you one example. Our client was a large company, but this works for small companies, too.

We were working with an airline, taking one database and matching it against another. They wanted to know things like whether a customer that goes skiing has kids and what their income was.

They wanted predictive models to uncover which customers would be most likely to sign up for their credit card or buy flowers or upgrade or travel to new destinations.

We went all in on the idea that more data is better. After all the time and money spent on sophisticated data models, what we found was that the best predictor of people flying more was past purchase behavior. Not a surprise, right?

In this case, purchase behavior predicted purchase behavior. And the fact that they drove a station wagon, or liked to eat Haagen-Dazs ice cream, might be interesting but it had very little impact on their flying behavior.

Moral of the story, you might find that the most obvious thing is the best place to start optimizing in your business as well. Start thinking about what kind of “if-then” logic you can implement. And don’t dismiss the really simple idea just because it’s simple.

The MAA Framework is Not Just for Advertising

Collecting data allows you to put if-then sequences in place across your business. In Google and Facebook you can set up automated rules using if-then logic. For example, one might be for conversions. If conversions fall below a certain number, then an automated action would be taken or an alert might be sent to whoever’s in charge of that area to let them know there is something that needs their attention.

1651544207 249 Digital Marketing Data and How to Optimize Like a Champ
1651544208 953 Digital Marketing Data and How to Optimize Like a Champ

Here is a table of common if-then scenarios we’ve come across. Start small by looking at just a few of these things.

You’ll find a lot of value when you look at the patterns. For example, look at posts with the highest engagement versus posts with the lowest engagement. What can you learn? What do the high-engagement posts have in common? Is there a cross-over with the low-engagement posts?

Don’t spend all your time messing around inside the tools. Even Google’s head of analytics said that 90% of every dollar you spend on analytics should be on people and 10% should be on the tools.

We see a lot of businesses do the opposite. They spend 90% on tools and 10% on people. The hard truth is, the most sophisticated tools are useless without someone who knows how to make sense of the numbers.

To ensure success, set the framework in place. Make it clear that everyone is accountable for the results.

Summary

I hope the metrics, analysis, action framework I’ve just introduced you to encourages you. Data and analytics aren’t really that technical. You don’t have to collect a ton of data, build regression models, or feed your AI any recipes.

Customers buy this over that. It’s not math. It’s not huge databases. It’s not engineering.

The MAA framework is all about understanding the numbers in the context of business performance and goals. Tracking metrics should always begin with the business strategy in mind. 


What Does it Take to be the Head of Marketing

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

MARKETING

Take back your ROI by owning your data

Published

on

Treasure Data 800x450

Treasure Data 800x450

Other brands can copy your style, tone and strategy — but they can’t copy your data.

Your data is your competitive advantage in an environment where enterprises are working to grab market share by designing can’t-miss, always-on customer experiences. Your marketing tech stack enables those experiences. 

Join ActionIQ and Snowplow to learn the value of composing your stack – decoupling the data collection and activation layers to drive more intelligent targeting.

Register and attend “Maximizing Marketing ROI With a Composable Stack: Separating Reality from Fallacy,” presented by Snowplow and ActionIQ.


Click here to view more MarTech webinars.


About the author

Cynthia RamsaranCynthia Ramsaran

Cynthia Ramsaran is director of custom content at Third Door Media, publishers of Search Engine Land and MarTech. A multi-channel storyteller with over two decades of editorial/content marketing experience, Cynthia’s expertise spans the marketing, technology, finance, manufacturing and gaming industries. She was a writer/producer for CNBC.com and produced thought leadership for KPMG. Cynthia hails from Queens, NY and earned her Bachelor’s and MBA from St. John’s University.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

Revolutionizing Auto Retail: The Game-Changing Partnership Between Amazon and Hyundai

Published

on

Revolutionizing Auto Retail: The Game-Changing Partnership Between Amazon and Hyundai

Revolutionizing Auto Retail The Game Changing Partnership Between Amazon and Hyundai

In a groundbreaking alliance, Amazon and Hyundai have joined forces to reshape the automotive landscape, promising a revolutionary shift in how we buy, drive, and experience cars.

Imagine browsing for your dream car on Amazon, with the option to seamlessly purchase, pick up, or have it delivered—all within the familiar confines of the world’s largest online marketplace. Buckle up as we explore the potential impact of this monumental partnership and the transformation it heralds for the future of auto retail.

Driving Change Through Amazon’s Auto Revolution

Consider “Josh”, a tech-savvy professional with an affinity for efficiency. Faced with the tedious process of purchasing a new car, he stumbled upon Amazon’s automotive section. Intrigued by the prospect of a one-stop shopping experience, Josh decided to explore the Amazon-Hyundai collaboration.

The result?

A hassle-free online car purchase, personalized to his preferences, and delivered to his doorstep. Josh’s story is just a glimpse into the real-world impact of this game-changing partnership.

Bridging the Gap Between Convenience and Complexity

Traditional car buying is often marred by complexities, from navigating dealership lots to negotiating prices. The disconnect between the convenience consumers seek and the cumbersome process they endure has long been a pain point in the automotive industry. The need for a streamlined, customer-centric solution has never been more pressing.

1701235578 44 Revolutionizing Auto Retail The Game Changing Partnership Between Amazon and Hyundai1701235578 44 Revolutionizing Auto Retail The Game Changing Partnership Between Amazon and Hyundai

Ecommerce Partnership Reshaping Auto Retail Dynamics

Enter Amazon and Hyundai’s new strategic partnership coming in 2024—an innovative solution poised to redefine the car-buying experience. The trio of key developments—Amazon becoming a virtual showroom, Hyundai embracing AWS for a digital makeover, and the integration of Alexa into next-gen vehicles—addresses the pain points with a holistic approach.

In 2024, auto dealers for the first time will be able to sell vehicles in Amazon’s U.S. store, and Hyundai will be the first brand available for customers to purchase.

Amazon and Hyundai launch a broad, strategic partnership—including vehicle sales on Amazon.com in 2024 – Amazon Staff

This collaboration promises not just a transaction but a transformation in the way customers interact with, purchase, and engage with their vehicles.

Pedal to the Metal

Seamless Online Purchase:

  • Complete the entire transaction within the trusted Amazon platform.
  • Utilize familiar payment and financing options.
  • Opt for convenient pick-up or doorstep delivery.
Ecommerce CertificationEcommerce Certification

Become A Certified E-Commerce Marketing Master

The Industry’s Most Comprehensive E-Commerce Marketing Certification For The Modern Marketer. Turn Products Into Profit, Browsers Into Buyers, & Past Purchasers Into Life-Long Customers

Click here

Hyundai’s Cloud-First Transformation:

  • Experience a data-driven organization powered by AWS.
  • Benefit from enhanced production optimization, cost reduction, and improved security.

Alexa Integration in Next-Gen Vehicles:

  • Enjoy a hands-free, voice-controlled experience in Hyundai vehicles.
  • Access music, podcasts, reminders, and smart home controls effortlessly.
  • Stay connected with up-to-date traffic and weather information.

Driving into the Future

The Amazon-Hyundai collaboration is not just a partnership; it’s a revolution in motion. As we witness the fusion of e-commerce giant Amazon with automotive prowess of Hyundai, the potential impact on customer behavior is staggering.

The age-old challenges of car buying are met with a forward-thinking, customer-centric solution, paving the way for a new era in auto retail. From the comfort of your home to the driver’s seat, this partnership is set to redefine every step of the journey, promising a future where buying a car is as easy as ordering a package online.

Embrace the change, and witness the evolution of auto retail unfold before your eyes.


Revolutionizing Auto Retail The Game Changing Partnership Between Amazon and Hyundai

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

How to Schedule Ad Customizers for Google RSAs [2024]

Published

on

How to Schedule Ad Customizers for Google RSAs [2024]

It’s no wonder that responsive search ads have steadily grown in popularity in recent years. Through Google’s machine learning capabilities, RSAs provide a powerful way to automate the testing of multiple headlines and descriptions to ensure a closer match to user intent. The benefits are clear: RSAs mean broader reach, better engagement, and improved performance metrics.

However, all these benefits come at a significant (but reasonable) cost – they can be extremely difficult to manage, especially when it comes to updating ad copy to promote limited time offers.

I know this firsthand – I work with several ecommerce clients with promotions that constantly change. Not too long ago, I found myself going through the consistently tedious process of updating a client’s RSA headlines and copy. As I was making the changes, I thought to myself: “There must be a better way to update this ad copy. I shouldn’t have to use find and replace so many times while pausing and enabling my ad campaigns.”

After expressing this to my colleague, Jordan Stambaugh, the two of us agreed there must be a better way. But we’d have to make it happen. A few weeks later, we put that idea into action and created a more efficient process for updating RSA ad copy on a scheduled basis. If you want to try this process for yourself, just keep reading.

Responsive Search Ad Customizers 101: Basic Options & Execution

Before diving into the process of scheduling automatic updates for your RSA customizers, it’s essential to understand some key Responsive Search Ad fundamentals.

First, you can customize three main options within RSAs: the Attribute Name, the Data Type, and the Account Value. Each of these plays a vital role in personalizing your ads:

  • Attribute Name: This is essentially the identifier for the customizer. It is how you’ll reference the specific piece of information you’re customizing within the ad. For instance, if you’re running a promotion, you might name an attribute “Promotion.”
  • Data Type: This indicates the kind of data the attribute represents and it determines how the information can be formatted and used within the ad. Common data types include Text (for plain, non-numeric text), Percent (to represent percentage discounts), Price (to denote monetary values), and Number (for any numerical value).
  • Account Value: This is the default value for the attribute that you set at the account level. It acts as a fallback if more specific values aren’t provided at the campaign or ad group level.

For example, if you wanted to promote a 10% off discount using RSAs, you’d use the “Discount” attribute, a data type of “Percent,” and an account value of “10% off.” Then, when someone is searching for products, Google would test automatically inserting a copy regarding a 10% off promotion into your ad.

Once you’ve set up the right customization options, you can start to format your RSAs with customizers.

Here’s how:

  • Start by typing in {
  • Click on Ad Customizer then select your attribute
  • Google will populate your attributes that are already uploaded
  • For a simple offer, use the “Default text” attribute as a catch-all. This will ensure your ads run smoothly if Google can’t pull the right messaging from your RSA feed

 

 

How to Schedule Your Ad Customizers with a Feed

Now that we’ve covered the basics, let’s cover how to schedule your ad customizers.

Just follow this three step process:

1. Create the feed

Start by creating two sheets: The Parent sheet, and the Child sheet. The “Parent” sheet will act as the primary data source, while the child sheet will pull data from the parent sheet.

We’ll start by building the parent sheet. After opening the sheet, start by renaming the active tab to “Promotions.” Don’t skip this step, it’s crucial for referencing this range in formulas later on.

In your “Promotions” tab, head to the top row and label columns A, B, and C with the headers of your ad customizer attributes. For example, you might have “BrandSaleHeadline” as your attribute in column A, “text” as the Data Type in column B, and “Shop the Collection” as the Account Value in column C.

Once your headers are in place, move to cell C2. Here, you’ll input the expression =lookup(today(),F:G,E:E). This formula will play a key role in dynamically updating your RSA customizer based on the current date.

Next, go to columns E, F, and G, which will be used to manage your scheduling. In these columns, you’ll list out the different values your chosen attribute might take, alongside their corresponding start and end dates. For example, under the “BrandSaleHeadline” attribute, you might schedule various promotional headlines to appear during different sale periods throughout the year.

Here’s how your sheet might look:

Now look back at the first 3 columns on your sheet. They should look like this:

Now create a second sheet. We’ll call this sheet the Child sheet. It’s going to automatically pull in data from the parent sheet you just created, and will be the one you link to Google Ads later on.

Columns A, B and C will be almost identical to the child sheet, but we will be using a special formula later so we can automatically populate this. So, start by labeling Row 1 Column A “Attribute,” then the next column as “Data type,” then column C as “Account value.” 

Then go to C2 and use this expression to populate the right account value from the parent document: =importrange(“[PARENT DOCUMENT URL HERE]”,”Promotions!C2″)

Your sheet should now look like this:

We recommend adding a date range with default text for any days you’re  not running a promotion. In the example above, we have “Shop Our Collection” appearing as default text.

2. Input attributes

Once you have your feed created, the next step involves inputting your attributes into the Google Ads platform. This can be done either manually or through a bulk upload.

For the manual approach, navigate to “Tools & Settings” in your Google Ads interface, then go to ‘Setup’ followed by “Business Data.” Here, you’ll find an option for “Ad Customizer Attributes.” Click the plus sign to add your attributes. It’s crucial to use the same attribute names that you’ve established in your Parent Google Sheet template to ensure consistency and proper data synchronization.

 

 

Alternatively, if you prefer the bulk upload method, again head to “Tools & Settings.” This time, select “Bulk Actions” and then “Uploads.” For this process, you only need to upload columns A to C from your template. 

Be aware that it might take some time for your uploaded attributes to be reflected in the business data section of Google Ads.

3. Set up an automatic schedule

At this point, you’ve almost finished scheduling your ad customizers. Navigate to Tools & Settings, then Bulk Actions, then Uploads, then click the Schedules tab at the top. Select your Child Google Sheet as the data source, and share your Google Sheet with the appropriate email.

 

 

And there you have it – Google will automatically pull in the data you populated in the sheets into your RSAs.

Common Challenges When Scheduling RSA Ad Customizers

When we test these sheets with our clients in the wild, we’ve uncovered five common challenges. Be on the lookout for these issues – solving them before they happen can save you a lot of trouble down the line.

Not scheduling your upload when the site changes 

The first and most significant hurdle is the mismatch between the scheduled data upload and website content updates. For instance, if the Google Sheet is set to upload at 11 am, but the website changes occur at 3 pm, there’s going to be a discrepancy where the wrong message could be displayed for several hours, or new messaging could appear prematurely. Conversely, if the website updates happen before the scheduled sheet upload, outdated promotions might linger until the new data is imported. Synchronizing these schedules is crucial; it’s best to align them so updates occur simultaneously.

Skipping QA during a message change

Another pitfall is neglecting quality assurance (QA) during message updates. It’s vital to regularly check the business data section to verify that the correct values are in place post-update.

Issues with the IMPORTRANGE function

Then there’s the technical aspect of setting up the IMPORTRANGE function correctly in the Google Sheets template. The ‘child’ template must reliably pull data from the ‘parent’ sheet. If this function isn’t configured correctly, data won’t be imported as needed.

Not sharing access of the Google template for automatic uploads

Pay attention to your access permissions for the Google Sheets template. Google will prompt you with the email address that needs permission to access the ‘child’ sheet for automatic uploads. Overlooking the sharing of your sheet with this address will prevent the system from working.

Having date range gaps in your parent sheet

Lastly, a common oversight is leaving date range gaps in the ‘parent’ sheet. Every single date must be accounted for without overlaps. A practical tip is to have an ‘evergreen’ backup message ready, scheduled to run continuously, ideally through the end of the year, to cover any potential gaps.

Conclusion

Leveraging Google Sheets in conjunction with Google Ads to schedule RSA ad customizers is a game-changer for managing dynamic promotional content. This process not only streamlines your workflows but also ensures that your ads remain relevant and up-to-date, reflecting current promotions without the need for constant manual intervention. 

By adopting this method, you’ll save significant time and effort, allowing you to focus more on strategy and less on the minutiae of ad copy updates. Give it a try and experience a more efficient way to manage your RSAs, keeping your campaigns fresh and engaging with minimal hassle.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending