fbpx
How To Get Your First 1000 Followers On Pinterest

How To Get Your First 1000 Followers On Pinterest

If you are looking for how to get followers on Pinterest or grow your current following on Pinterest, regardless of your account size, you’ve come to the right place. In this blog post, I will guide you through the process used to get more followers on your Pinterest account by sharing actionable insights and strategies that have helped me and countless others succeed on the platform.

 

 

 

By the end of this post, you will understand the importance of studying your niche, learning effective creative techniques, and discovering a powerful new feature within Pinterest.

 

Study The Niche Of Your Followers On Pinterest

This is the first step to get more followers on Pinterest. Understanding your niche is crucial to the development of your Pinterest. Here are two ways to study your niche:

 

Using Pinterest Analyzers

 

Use a tool like Pin Inspector, a paid app, and connect it to your Pinterest account.Pin inspector

 

Enter your niche keywords in the search bar, e.g., “chicken recipes.”Pin Inspector sample

 

Export the data from your Pinterest to a CSV file and copy it to a Google sheet.

Pin Inspector To CSV

 

Calculate the pin-to-follow ratio by dividing the follower count by the total pin count.Pin to Follow Ratio

 

Determine the average pin-to-follow ratio for your niche.

Average pin to follow ratio

Identify the profiles with the highest pin-to-follow ratio. These people post the least amount of content to get the most followers on Pinterest as they are likely to have successful pinning strategies.

Analyze these top profiles to understand what types of creative formats and fonts resonate with your niche’s users.

 

Manual Research

Create a Google sheet with columns for profile, board count, followers, and pin count.

Pinterest Manual Research Blueprint

Manually search for profiles within your niche on Pinterest.

Identify profiles with follower counts similar to your target or current following.

Copy the profile URL and relevant information (board count, followers, pin count) into the Google sheet.

Manual Research Information

Calculate the pin-to-follow ratio for each profile by dividing the follower count by the total pin count.

Use this information to understand the average pin-to-follow ratio for your niche.

Focus on profiles with high pin-to-follow ratios and analyze their pinning strategies.

 

Note: This method takes a considerable amount of time. Hence, using only 5-10 people for your analysis is advisable.

 

  

Best Practices for Creating Engaging Pins For Your Followers On Pinterest

We will examine the art and science of creating intriguing pins that draw viewers in and drive traffic which helps you get more followers on Pinterest. We’ll go through the key components of attractive pins, give tips on creating aesthetically appealing images, and show you how to maximize the visibility of your pins.

 

Pin Types

 

Hack-type videos

Hack videos

These short, visually appealing videos highlight clever life hacks and suggestions that appeal to users looking for innovative and practical solutions. These videos have grown in popularity and effectiveness as an efficient approach to engaging viewers, sparking their curiosity, and providing them with practical information they can apply in their lives.

 

This is accomplished by combining compelling graphics, brief explanations, and a dash of creativity. The potential of hack-type videos can improve your content strategy and capture viewers looking for useful, time-saving solutions.

 

Steps or countdown videos

Steps or Countdown Videos

Steps or countdown videos on Pinterest have grown in popularity as a template for presenting information in an interesting and aesthetically pleasing way. These videos simplify difficult procedures or ideas into a list of steps to follow or a countdown, making it simple for viewers to follow along and quickly understand the main principles.

 

Steps or countdown videos have developed into an efficient tool for content creators and brands to grab viewers’ attention and educate them while providing them an enjoyable and educational viewing experience.

 

Utilize arrows

Arrows Videos

Using arrows in your Pinterest visuals can be a game-changer when grabbing and directing users’ attention. These straightforward yet effective visual cues act as signposts, drawing users’ attention to crucial information, distinguishing characteristics, or calls to action within your pins. By strategically implementing arrows, you can build a direct visual path that guides people through your material. 

 

Arrows can be added to your pins in a variety of ways. For instance, you can use arrows to draw attention to important photos or views of products. This grabs the interest of viewers and entices them to keep exploring. Additionally, arrows can point towards text elements, emphasizing key messages or descriptions you want to convey.

 

Infographics

Infographics

On Pinterest, infographics are a powerful and aesthetically striking way to present complex information in a condensed and easily understandable format. These visual representations combine text, icons, charts, and illustrations to present data, statistics, or step-by-step processes visually appealing and engagingly. 

 

You can quickly and efficiently grab people’s attention and convey important information with infographics in your Pinterest post. You can use infographics to highlight the most crucial details, deconstruct material into visually appealing portions, and clarify complicated topics. 

 

Infographics stand out among the vast content on Pinterest with their aesthetically pleasing layouts and brilliant color schemes, making them highly shareable and raising the possibility of user engagement.

 

Include captions or text

Captions or Text for Followers On Pinterest

Text and captions act as strong hooks to draw viewers and encourage further exploration. They can emphasize important qualities, advantages, or special selling aspects of your goods or services.

 

Captions can be used to compel viewers to take action or visit your website, and they can also pose thought-provoking questions, spark curiosity, or convey a feeling of urgency. Keep captions and phrases brief, understandable, and simple to read when including them.

 

CTAs (Call to Action)

Feel free to include a CTA at the conclusion of your pins to encourage users to follow you for more material in your niche. CTAs should be used barely and strategically.

 

AB Testing

Experiment with different variations of your pins to see which ones perform best. Use tools like Canva to create multiple versions and track their performance.

Remember, these techniques may vary depending on your niche, so it’s essential to study profiles that are famous on Pinterest to discover what works best.

 

Track The Growth Of Your Followers On Pinterest

To check your growth on Pinterest, you’ll need to use a tool like Tailwind, which offers services that help you track your progress starting from the day you sign up with them. They have both paid and free versions. However, I use the paid version because it gives me access to many other tools that I would need to track my growth. 

 

Pinterest Live

Pinterest Live

Pinterest’s new Go Live Beta feature has the potential to be a game-changer for content creators looking to grow their accounts. Hosting live episodes on the Pinterest TV live stream platform can attract a larger audience and experience strong growth. The feature focuses on one live episode at a time, meaning that when people tune in, all eyes are on you. 

 

This heightened visibility can increase engagement, more followers, and potential monetization options. Pinterest accepts applications from all creators, so take advantage of this opportunity to apply and exponentially grow your Pinterest account. Take advantage of the chance to be an early adopter and reap the benefits of the Go Live Beta feature.

 

Conclusion

Growing your Pinterest following requires strategic planning, creative techniques, and continuous testing. By studying your niche, analyzing famous profiles, and implementing effective pinning strategies, you can increase your chances of reaching your first 1000 followers on Pinterest. Remember, followers are not the sole measure of success, but they can contribute to other important metrics like sales, clicks, and impressions.

11 Tips to Improve PERFORMANCE MAX Campaigns [Google Ads]

11 Tips to Improve PERFORMANCE MAX Campaigns [Google Ads]

11 Tips to Improve PERFORMANCE MAX Campaigns [Google Ads]

If you’re running Performance Max campaigns, you understand how tough it can be to get good results. In today’s blog, we will share eleven tips on how to improve your Performance Max campaign and get the best results possible. These tips come from our extensive experiences running multiple successful accounts and spending thousands, if not hundreds of thousands of dollars on Performance Max campaigns. We are eager to share these tips with you, so let’s jump right in!

Tip 1: Be Aware of Campaign URL Expansion

First, check your campaign URL expansion settings by simply coming into your Performance Max campaign and then clicking on the settings. Next, scroll all the way down until you get to the additional settings box from where you can look at your final URL expansion settings.

URL Expansion with Google Performance Max Campaigns

I recommend keeping the URL settings on, but pay keen attention on where the setting is sending traffic to. This is because we have learned from big failures that when the setting is checked on, it can send traffic anywhere on your website. We have had experiences where it is sending people to the Contact page, a Privacy Policy page, or a 404 page, which essentially wastes a ton of ad spend. You may be asking yourself, how do I check to see where the final URL expansion is actually sending traffic to? The answer to that question is that Google doesn’t give you any great way to view that within the platform. The best way is to check your Google Analytics to see which landing pages the Performance Max campaign is sending traffic to. Start by clicking on the Reports tab, followed by the Acquisition tab and then to Traffic Acquisition. In the table, change the primary dimension to session campaigns, and the secondary dimension to landing pages.

Finally, do a search of the campaign on the search bar to see only the data related to the Performance Max. Type in ‘Pmax’ and hit enter to filter the session campaign to only show the ones that contain that keyword. You can then go through and look at the landing page report to see exactly where the Performance Max campaign is directing traffic.

Exclude URLs with Google Performance Max Campaigns

Consistently check on your landing pages weekly, especially when you start a new Performance max campaign. If there are specific pages you don’t want your Performance Max campaign to be showing up on, it’s as simple as clicking on Exclude URLs under the Additional Setting tab of your campaign settings. You can go through it and add either a rule or the specific URL you want excluded.

Tip 2: Pay Attention to Your Audience Insights

The Insight tab is somewhat of a newer addition that Google has introduced and it is very helpful. If you go to your Performance Max campaign and then into insights, you can scroll down to see the audiences that are bringing in the conversions, the clicks and then the impressions. This is crucial because you want to make sure that whatever audience is bringing in the most conversions is the one that is also getting the most in clicks and impressions.

Google Performance Max Campaigns Audience Insights

You need to go into your audiences and exclude any audience that is not currently converting the way it should be. In order to do that, go to the Asset Groups tab, click on the Audience Signal and then click on edit icon on the Audience Signal section. From there, you can scroll down and remove the market audience.

Keep in mind that Google will still target people outside of these interests and detailed demographics. In a scenario where there is an audience you want to remove that is currently taking up a lot of the click share or impression share, there is unfortunately no way for you to manually remove it if it is not already in your audiences. You will just have to wait to make those adjustments after Performance Max highlights them.

Tip 3: Look at Your Asset Performance

Go into your Asset Details, check which ones have low performance and replace those images or videos. A bonus tip along with that is to make sure that you do have a video inside of your Performance Max campaign. If you don’t, Google is going to automatically create a video for you using images from your website or images that you provided for the Performance Max. Obviously, that is not going to be an ideal video scenario. Therefore, if possible, try to add a video inside the Performance Max to have some control over the video used.

Tip 4: Break Out Your Product Listing Groups by Specific Products

This step allows you to track performance and consequently pause low performing products. You can achieve this with Performance Max under Listing Groups by clicking on the pencil edit icon next to All Products to add a subdivision. This will allow you to then go through and add subdivisions for each of the items by Item ID, Brand, Condition, or Category, among other options.

Products Listings in Google Performance Max Campaigns

Depending on how your feed is set up, you can opt for Item ID to view data on how much you’re spending on each individual product and how much your conversion value over cost is, that is, your row ads and the cost per conversion. Sort your products by ‘conversion value/cost’ and pause any products that have lower row ads by clicking on the green button adjacent to it.

Tip 5: Optimize Your Product Feed

This goes back to even smart shopping campaigns or standard shopping campaigns. Make sure you’re fixing any disapproved products or warnings inside of your merchant center. You can organize your campaigns with custom labels, making sure to update product titles, descriptions and images while testing different things as well.

Tip 6: Clean Up Your Conversion Actions

Go into your Tools and Settings and click on Conversions. Next, go through it to make sure that all of the conversions that are currently set are ones that should be primary actions. If they should be secondary actions, ensure that the algorithm isn’t using them to optimize the accounts. If you have multiple primary actions, be sure that you are only optimizing towards the most important goal inside your Performance Max.

To do that, go over to your Campaign Settings and on to the Goals section. If you have multiple primary goals in your account level, be sure to switch it over to a specific goal setting for website purchases, leads, or your most important objective for Performance Max.

Tip 7: Utilize Ad Schedules in your Performance Max Campaigns

In your Performance Max campaign, if you go to Overview, you will see that Google will generate top bidding signals to give you an idea of the days and times that your campaign is bidding higher or lower.

If you want to be even more aggressive, you can opt not to show ads during times when your campaign is bidding lower by setting up a complete custom ad schedule that caters to your specific needs under the Ad Schedule tab.

Tip 8: Create Separate Performance Max Campaigns For Products with Varying Levels of Margin or Price

If you have an account that has products with varying degrees of margins, go ahead and create separate performance max campaigns for those levels of margin or price. For instance, one product may have a 50% margin but the other has a 20% margin. In other cases, products may have big swings in price, say one costs $100 while the other costs $10,000. The reasoning behind this is that the way Google targets a person who is going to spend $10,000 versus $100 or a $1,000 is going to be drastically different.

Tip 9:  Take Advantage of New Customer Bidding in Performance Max Campaigns

New Customer Bidding in Google Performance Max Campaigns

If you go to the Settings of your Performance Max and click on Customer Acquisition, you will see that you can bid higher for net new customers. If you click on this option, it means that you recognize that a brand new customer is probably going to be of more value to your business in the long run because you can obtain their email and upsell to them. You are therefore willing to pay an additional amount for that new customer. It will then prompt you to import a list of all customers.

Tip 10: Testing Different Bidding Strategies

Understanding this tip is highly essential and is the underlying strategy of bidding. Going through and testing different bidding strategies, whether it be your Target Row Ads or doing a max conversions can really have a big impact on the account.

Whenever we launch a brand new Performance Max campaign, we often leave the target Row Ads at blank for the first couple of weeks to allow the algorithm to start learning, and then adjust it from that point. However, don’t be afraid to go through and switch your conversion value bidding strategy to conversions or to play around with the strategies. Just be sure to keep track of what is working and what is not.

Tip 11: Click on More Asset Types when Creating your Performance Max Campaigns

More Asset types in Google Performance Max Campaigns

Expand the hidden ‘More Asset Types’ section when creating your campaigns and add all the different provided extensions. Utilizing these options can really improve the click through rate and conversions of your campaigns.

What’s Next for Performance Max Campaigns?

Of course, not all these tips are going to be applicable to every single business. However, if they are applicable to your business, be sure to go through and do each of them. Our final bonus tip goes to those who have a Google rep assigned to their Google Ads account, and thus may not apply to everybody. If you do, give your negative keyword list to your Google rep and request them to upload it to your Performance Max campaign. While you can’t do this yet inside your account, Google reps on the back end can add negative keywords. However, Google is working on adding this feature soon.

How To Prevent Competitors & Bots From Clicking On Your Ads

How To Prevent Competitors & Bots From Clicking On Your Ads

How to Stop Competitors & Bots from Clicking on Your Ads (Click Fraud)

What’s up everybody, it’s Corbin here from ZoCo marketing. Today, I’m going to be answering one of the most common questions I get asked when I’m helping people run Google ads. How do I prevent competitors from clicking on my Google ads? Or how do I prevent bots from clicking on my ads?

The sad reality is that click fraud is out there and it can waste your ads spend. Google has made some really good steps forward to help prevent this from happening, but they do not exclude 100% of those frauds and a lot of fraud traffic can slip through the cracks. 

How to Identify Bot Traffic

To check if your campaigns and/or ads are getting a lot of bot traffic, open your Google ads and go to your Campaigns. Locate the columns and select Modify Columns for Campaigns.

Search for “invalid” and you’re going to find something here called invalid clicks, select Apply. This will give you an idea of what percentage of clicks going to your ads have been identified by Google as bot clicks.

 

Fortunately, Google does not charge you for these invalid clicks. They automatically filter those out, which is awesome but it still is not enough. I wish that I could say that this covers all your bases, but unfortunately, you still get a lot of competitors and a lot of other bots that Google just hasn’t identified. Nevertheless, whenever you open your campaigns and see a lot of invalid clicks this means you probably have a problem with click fraud.

How to stop Click Fraud?

All right, how do we actually prevent click fraud from happening? How do we prevent competitors from seeing our ads and from clicking on them and ultimately save money? Now, there are three different solutions. The first two are kind of hacky, more manual process processes and the last one is a fully automated solution. 

1. Exclude location

Go to your campaigns, from the Google ads drop-down, select the more+ button and click on locations. This will essentially allow you to exclude locations. Ideally, you want to find the city or Zip code where your competitor’s office is located and exclude that location from showing. Excluding a whole city can exclude potential customers from the excluded area.  So, if you do know the zip code, I do recommend going that granular. If you don’t know where your competitor is located try Googling what city your competitor’s location is in, that typically works

 

The major con to excluding location is that you obviously will miss out on potential customers that live in that area. They won’t be able to see your ads. The pro to this hacky process is that your ads will not go to your competitors that live in the excluded area.

2. IP Exclusion

From your campaign dashboard, go to settings, then additional settings. Here, you can exclude specific IP addresses. If somehow you managed to get your competitors’ IP address, you could include it there. Additionally, if you recognize other IP addresses that are constantly clicking your ads, you could manually add the IP addresses to the exclusion list.

The con of this process is that it is extremely manual and difficult. For example, you could exclude 100 IP addresses in a day then a month later new ones pop up. This is why an automated process is recommended.

3. ClickCease

ClickCease is an automated software that helps in preventing click fraud. I use it one my own accounts and it has personally saved me thousands of dollars. It is very simple to set up and is the easiest way to prevent click fraud. ClickCease allows you to operate several accounts and gives you a breakdown of each account showing you money saved that would have gone to your competitors or bots. You could use this saving towards real potential customers that you want to see your ads. Below you can see a screenshot of how much ClickCease has saved me this month alone (Over $1800).

 

Clicking into the actual domain gives you even more data about what’s going on with your ads. You’ll notice that it shows you how many IP addresses are automatically blocked-something you don’t have to go through manually as demonstrated in the previous solution. 

 

If you scroll down, it shows the campaigns that are bringing in the fraudulent clicks and also shows the fraud type like over threshold, fraudulent devices, or high bounce rates. This will give you an idea as to why such clicks have been blocked.

 

 From your domain settings, you can manage detection rules that would be ideal for you. You could set the number of clicks per minute. These customizations can limit the number of clicks from your competitors.

 

 

Typically, I like to leave it in the default settings. Every once in a while, ClickCease is smart enough to send a recommendation whenever it notices an abnormality in your ads and recommends adjustments. This is proactive and saves you as much money as possible. 

You can get ClickCease by clicking this link here, Upon setting up your domain, you will be given a code that would walk you through the three-minute process of setting up your accounts. 

Hopefully, this will save you a lot of money in the click fraud and helps answer those questions or concerns that you may have.

 

Google Ads For Lead Generation Checklist: Step by Step Guide

Google Ads For Lead Generation Checklist: Step by Step Guide

Steps To Generating Leads With Google

Are you looking for a guide on how to create a Google Ads account for lead generation? Look no further! In this blog post, we will walk you through the steps to get your account set up and running. We will also provide you with a free checklist that will help you track your progress and ensure that your account is set up correctly.

Creating a Google Ads account is simple and only takes a few minutes. However, there are a few key steps that you need to follow in order to ensure that your account is set up correctly for lead generation. Here are the steps that you need to take:

Step One: Set Budget & Goals

The first step in setting up your Google Ads account is to determine your budget and advertising goals. How much are you willing to spend on lead generation each month? What is your target cost per lead? Once you have answered these questions, you can begin setting up your account. If you are looking for an easy way to calculate how much you should be spending based on specific factors like your average order value, your close rate, etc. I have created an easy-to-use calculator that allows you to quickly understand how much you should be spending based on your specific business metrics.

Step Two: Build your keyword list

Now that you have your budget and goals in place, it’s time to start building your keyword list. What keywords are relevant to your business? What terms do potential customers use when searching for products or services like yours? You can use Google’s Keyword Planner tool to help you generate a list of relevant keywords. If you are looking for a full tutorial on how to use Google’s keyword planner you can check out this video right here.

google keyword planner

Step Three: Decide Your Campaign structure

The next step is to decide on your campaign structure. There are multiple types of campaigns that you can choose from: Search, Display, and Shopping, Video, Etc. Search campaigns are the most common type of lead generation campaign and are typically the best performing. In a search campaign, you bid on keywords that potential customers use when searching for products or services like yours on Google. When someone searches for one of your keywords, your ad may appear next to the search results.

When creating a search campaign there are three levels Campaigns, ad groups and ads. You will want to create separate ad groups for each product or service that you offer. In each ad group, you will create ads that target the keywords in that particular group.

google campaign structure

Step Four: Create Your Ads

Now it’s time to start creating your ads! There are a few different ad formats that you can choose from, but we recommend starting with responsive text ads. These ads are easy to set up and can be quickly optimized for performance.

To create a responsive text ad, simply log into your Google Ads account and click on the “Ads & Extensions” tab. From there, click on the + icon to create a new ad. Select “Responsive Text Ad” from the drop-down menu and enter your ad copy. Be sure to include a call-to-action in your ad, as this will help encourage potential customers to click through to your website.

Step Five: Monitor & Optimize Your Campaign

Once you have created your ads, it’s important to monitor their performance and make adjustments as needed. Are your ads receiving a high click-through rate? Are you generating quality leads? If not, you may need to adjust your keyword bids, ad copy, or targeting options.

You can also use Google Analytics to track the performance of your lead generation campaigns. By linking Google Analytics and Google Ads, you can see how many leads are generated from your ads and track the conversion rate of those leads.

To learn more about lead generation with Google Ads, be sure to check out our free checklist below. This handy tool will help you track your progress and ensure that your account is set up correctly.

By following these simple steps, you can create a Google Ads account that is optimized and ready to bring in leads. Be sure to monitor your campaign performance and make adjustments as needed to ensure that you are generating quality leads. And don’t forget to download our free Google Ads account checklist for lead generation below!

Do you have any questions about setting up a Google Ads account for lead generation? Leave a comment below and we’ll be happy to help!

  • 25 + point checklist with links to guides and helpful tools.
  • Available in Notion and Google Sheets
Marketing Math Template

Marketing Math Template

If your boss or client comes to you and tells you they want to make $10,000 this month in revenue and asked you if it was possible, what would you say? Would you just look at them and say “yeah we can do that”, then rush back to your computer in a panic just hoping you hit the revenue goal by running some ad tests and lowering your CPC? Or do you know exactly what metrics you would need to improve to get that extra $10,000? If you aren’t sure how you would go about answering this question then this marketing math template is just what you need.

In this blog post, we are going to walk you through how to answer this question the right way and how to look at the data to see what metrics you need to hit to reach your revenue goal.

Before we begin there are a few things you will need to know or have an estimate of to answer this question accurately.

  1. What is your average cost per click?
  2. What is your conversion rate?
  3. What Percentage of leads from your Google Ads account are qualified?
  4. Of those qualified leads what percentage got a sale proposal or demo?
  5. What percentage of people who got demos became customers?
  6. What is your average order value?

I know tracking down some of the answers to the question above can be difficult sometimes, but trust me it will be worth it to be able to have the data you need to achieve your revenue goal.

Once you have all of this information you can use this marketing math template to calculate what numbers you will actually need to hit in order to reach your revenue goal.

https://docs.google.com/spreadsheets/d/18OValUuV7tOIfBoEIRWK3tUdSv1yo_5NazdqwpjgksA/edit?usp=sharing

After you have the data you need, play with the numbers by lowering or raising your conversion rates and CPC to see what you can accomplish.

Track Your Google Ads Quality Score

Track Your Google Ads Quality Score

Quality score can be a very frustrating part of running a Google Ads account. Over the years Google has given us some insight into what goes into a quality score, but it still can be very difficult to see if the optimizations you made last month are making are really having that big of an impact on your quality score. Google does not give you a view that lets you see the history of your quality score. They recently came out with the “Quality Score (hist.)”, but this metric still does not allow you to see your quality score based on specific dates. This post will walk you through how you can keep track of your Google Ads quality score to see if your optimizations are actually helping your campaigns.

Quality Score Script

The first thing you will need to do is copy this script by Russell Savage from FreeAdWordsScripts.com. This script stores the Quality Score for any date range via Google spreadsheets. This is a fantastic script, as you can compare the scores between certain date ranges and see where you need to improve

http://www.freeadwordsscripts.com/2013/04/store-account-campaign-and-adgroup.html

Once you have your script you will then need to head over to Google Ads and click on the tools icon in the top right-hand corner. Then click on “scripts” in the drop-down, then click on the blue plus button.


Customizing The Quality Score Script

Once you click the button you will see a section to copy the script to the page. Before you save the script there are a few things you will want to customize in the code.

  • Decimal place – Is the number of decimal places you would like to see. ( I kept the default of 4 places)
  • Date Range – This is how often you want the script to run and collect data. For this setting, I recommend changing it to every 7 days, that way you are collecting quality score data frequently.
  • SpreadSheet Name – You will need to create a new Google Sheets and name it whatever you would like, just as long as you name it the same thing in the script. I choose to name my sheet “Quality Score From Scripts”.

After you have that all updated hit the “run” button at the bottom of the screen.  You can choose to preview the script before you run it, but because this script is just collecting data and putting it in a Google Sheet it will show that no changes have been made to your Google Account. Once you have run the script you will notice that your sheet now has quality score data for your account.

Before you leave Google be sure to set the frequency of your script to match whatever date range you decided to choose on the script. Because I set my script to every 7 days, I simply told Google to run my script every Monday at 10:00 am that way I can start every week looking at how my quality score is doing.

Organize Data With Pivot Table

Now that data is getting fed into your Google Sheet the next thing to do is make that data easy to read. When you first see the data it will look similar to the image below, which makes it a little hard to compare dates and see if your quality score is improving over time.

In order to make the data more useable, I like to organize it with a pivot table. If you are new to pivot tables follow these steps to turn your data into actionable insights.

First – highlight all the data.
Second – click “data” then “pivot tables”
Third – Enter these  settings is the corresponding fields

  • Rows – AdGroup
  • Columns -Date
  • Values – ImpsWeightedQS (Make sure you change “summarized by” to “MEDIAN”)

Fourth – Highlight all the quality score data, click on “insert” then “conditional formatting”. I like to change the color scale to show red to green that way you can clearly see the problem areas. By the time you have completed all these steps, your sheet should look something like this.


 

From here you can identify the areas you need to improve and start to keep track of Google Ads quality score. 🙂