17 Free Photoshop Templates for Google Display Ads

Posted by on Dec 3, 2015 in Advertising, Search | 7 Comments
17 Free Photoshop Templates for Google Display Ads

Create Compelling AdWords Display Image Ads

Designing creative image ads is one of the of the most fun parts of being a digital advertiser. It’s where you get to apply the visual side of your brain, creating engaging content that will drive click-throughs.

However, our display ads have been under attack by ad blocking software, and there’s no end in sight.

In fact, according to a study by PageFair, 45 million monthly active users in the United States use ad blockers. Those active users represent a 48% increase in usage between Q2 2014 & Q2 2015.

The stats above should motivate you to create compelling display ads for your audience so you can keep their attention.

Here are a few fundamentals to achieving best results with your display ads.

1. Use the Z-Pattern in your layout design

If you are advertising to viewers in the U.S. or other western countries, most people will read from left to right, top to bottom. In design, this is known as the Z-Pattern. Place your value proposition on the top left side of the ad, and your call-to-action on the bottom right. You have very little time to capture the attention of your audience and viewers will quickly glance to the areas they expect to find the most relevant information.

2. Use the Rule of Thirds

Everyone thinks of Leonardo da Vinci when discussing the Rule of Thirds. And it’s true he used it often in his drawings and paintings. There’s a reason that this technique is used by visual artists and that hasn’t changed in today’s digital world.

Evenly divide your ad horizontally and vertically with four lines. The four points where these lines intersect are your points of interest. Arrange essential elements so they touch one of these points to make your ad copy more engaging.

3. Write a Compelling Call to Action (CTA)

Do not just write “click here.” Let your viewer know why they should click on your ad. For example, if you are selling winter jackets & you show an ad with different color selections, a good CTA may say, “Choose My Color.”

Also, use a contrasting color for the CTA button, so it stands out from the rest of your ad.

The Free Templates

We’ve created a free Adobe Photoshop PSD template that includes 17 popular Google Ad sizes that you can freely use for your ad creations!

Enter an email address where we can send you the download link.

The 17 Google Display Ad Sizes in the Template:

  • Vertical Banner (120×240)
  • Skyscraper (120×600)
  • Wide Skyscraper (160×600)
  • Small Rectangle (180×150)
  • Small Square (200×200)
  • Vertical Rectangle (240×400)
  • Square (250×250)
  • Medium Rectangle* (300×250)
  • Half Page* (300×600)
  • Portrait (300×1050)
  • Mobile Leaderboard (320×50)
  • Large Mobile Banner* (320×100)
  • Large Rectangle* (336×280)
  • Banner (468×60)
  • Leaderboard* (728×90)
  • Large Leaderboard (970×90)
  • Billboard (970×250)

*Top performing ad sizes according to Google

Free Google Display Ad Templates Preview


When exporting the file, make sure the image size is no larger than 150 KB. Google will reject anything larger. The file types accepted are JPEG, SWF, GIF, and PNG.

Ready to become a better marketer? Launch and manage your web and social display campaigns using AdStage. Your 14-day free trial is waiting.

How to Create Gmail Ads in AdWords

Posted by on Oct 2, 2015 in Advertising | 10 Comments
How to Create Gmail Ads in AdWords

Google recently announced that native Gmail ads are now available for all advertisers in AdWords. Previously in beta, Gmail ads are highlighted text ads with an accompanied logo, that appear on the Promotions tab. If clicked upon, the ad expands to a full page layout, with a lot of realty.

Gmail Ads - Promotions tab

Below is a step-by-step guide on how to setup Gmail ads in AdWords.

Create a Display Campaign

If you’re able to dedicate a modest budget to testing Gmail ads, I suggest creating a dedicated Display Network only campaign. Next, select your marketing objective for the campaign. Marketing objectives allow advertisers to align their campaign settings towards with desired goals, such as a form fill. Performance, ROAS driven marketers should choose from a “drive action” objective.

Google Display - Marketing Objectives

Finish up selecting all your ideal campaign settings.

Select Your Placements

Gmail ads are selected in the ad group’s placements section. To reveal placement options, scroll down to the “choose how to target your ads” section, and select “use a different targeting method”.

Google Display - Placements Setting

Within the placements search bar, submit a query for the web address “mail.google.com”. Then select the domain as a placement.

Gmail placement

Refine with Keywords

Only using placement targeting can open your campaigns up to billions of weekly impressions on Gmail. Hone in on your target audience and conserve budget by adding keyword targeting.

Display keywords are utilized slightly different than search keywords. Where search can be exact and intent based, display keywords are broad match only. Display keywords help guide where an an ad will be shown based on the content of the website and previous user browser history. Contextual targeting is powerful for Gmail, as the page content is generated from users’ emails.

Display Network - Keyword Placements

Often, I’ll adopt a similar ad group structure to my existing search campaigns. Taking the best performing broad search keywords and adding them to display ad groups.

Consider Audience Targeting

When Google allowed single sign-on across all their products, it not only created a better user experience, but also provided Google with connected data on their user profiles. Advertisers can use this data to build custom audiences to target.

Custom affinity audiences is an option worth considering.

Custom Affinity Audiences

Create a custom audience, targeting users who visit specific websites or have long-term interests in certain categories.

Display Network - Custom Audiences

You can learn more about custom affinity audiences in this detailed post.


Add Creative

Within an isolated ad group view, visit the ads tab. Pull down the ad tab to reveal “ad gallery”.

Display - Ad Gallery

Choose “Gmail ads” from the gallery options.

Google Display - Ad Gallery

There are 4 types of Gmail ads:

  1. Gmail image template
  2. Gmails single promotion template
  3. Gmail multi-product template
  4. Gmail custom HTML upload

For this walkthrough, let’s explore the Gmail image and single promotion templates.

Gmail Image Template

This option is great for branding, featuring your image across the full page width if a user clicks through.

Image specs

  • Collapsed – 144px by 144px

Gmail Ads - Collapsed Ad

Add your advertiser name, a subject line, and a description. Treat your subject line as if it were an actual email headline – be succinct and to the point. Your description line should follow, by clearly revealing your value proposition.

  • Expanded – 650px by (300px to 1000px)

Google Display - Expanded Ad

Next, let’s explore the benefits of using single promotion templates.

Single Promotion Templates

While a prominent image can be a powerful way to showcase your brand, sometimes it’s not enough to convey your product or service benefits. The promotional template layout includes both a large area for images, and also provides space for a headline and copy.

In addition to the collapsed copy, expanded promotional templates allow for:

  • a large side bar image
  • headline copy
  • body content
  • optional header image

Image specs

  • Side bar – 300px by (200pc to 500px)
  • Header image – 630px by(50px to 200px)

Google Display - Template Expanded Ad

Final Thoughts

With the option to contextually target users by their email content, and lower cost per click averages than Search, Gmail ads provide a promising addition to your AdWords armada. Initial tests have shown click through rates as high as Search, and attractive CPA ranges. Have you tried the new Gmail Ads? We’d love to hear your findings!

#PPCPodcast with David Rothwell

Posted by on Sep 4, 2015 in Advertising, Social | No Comments
#PPCPodcast with David Rothwell

In this week’s PPC Podcast, we’ll be joined by guest speaker, David Rothwell of Rothwell Media. David’s expertise lives in the ecommerce vertical and with the winter holidays approaching in Q4, we’re excited to take a deep dive into Google Shopping Campaign strategy.

Listen in

We are just weeks away from the biggest holiday shopping season of the year. The time has come to start preparing for the occasion. We’re looking forward to getting David’s perspective on the following topics:

  • The standard structure of a Google Shopping Campaign
  • Suggested latency before seeing success with Shopping campaigns
  • How to account for the removal of Promotional Text
  • Recommendations for advertisers that are new to Google Shopping Campaigns
PPC Podcast

Source: https://www.flickr.com/photos/boonlee89/5636095832

As always, we’ll recap the morning’s #ppcchat discussions and discuss the latest news from our “This Week in Ad Tech” blog series.


Join us for the live #ppcpodcast with David Rothwell on Tuesday, September 8, 2015 at 10am Pacific Time.

Listen in

The Top 10 Most Valuable AdWords Features for PPC Managers

Posted by on Aug 10, 2015 in Advertising | 2 Comments
The Top 10 Most Valuable AdWords Features for PPC Managers

We are teaming up with Hanapin Marketing to host a webinar that will cover The Most Valuable Google AdWords Features For The PPC Account Manager. As you know, AdWords has tons of reports, targeting options, and optimization tools. But how do you allocate your time to make sure you’re getting the most value from these features?

Register for this webinar to learn expert tips like:

  • Using Auction Insights to find competitors to use outrank bidding strategies on
  • How to receive the ideal conversion volume and cost/converted click at positions 1-3 or lower
  • Utilizing Dynamic Search Ads as a keyword mining tool
  • Increasing bids on qualified, previous site visitors

Join us and our AdWords experts who will walk through their top 10 most valuable AdWords features.

Michael McEuen

Michael McEuen, Director of Demand Generation at AdStage

Amanda West-Bookwalter

Amanda West-Bookwalter, Senior Account Manager at Hanapin Marketing

The webinar is on Thursday, August 13, 2015 at 9am Pacific Time. To guarantee a seat in this webinar, register today.

Register Today

Facebook Bulk Ad Creation, Google Analytics Insights, New Metrics, and More Come to AdStage

Posted by on Jul 15, 2015 in PPC News, Search, Social | One Comment
Facebook Bulk Ad Creation, Google Analytics Insights, New Metrics, and More Come to AdStage

This month in AdStage: Create Facebook Ads in bulk, view Google Analytics Insights, measure cost per result on Twitter Ads, and more!

Facebook Bulk Ad Creation

Facebook Bulk Ad Creation

Quickly create and test dozens of Facebook Ads by combining alternate ad text and images in bulk. You can even customize multiple URLs at once for easy tracking. Bulk ad creation is also available for Twitter and LinkedIn Ads. Try it today.

Google Analytics Insights

Google Analytics Insights

You never need to leave the platform to view and analyze your Google Analytics Insights data. Save time comparing your ad spend to conversions by linking your Google Analytics account in AdStage.

Twitter Delivery Optimization and New Metrics

Twitter Optimized Delivery

Let Twitter optimize the delivery of your ads for campaigns with the Website Clicks or Conversions campaign objective. We also support reporting for your campaign objectives with the addition of Results and Cost Per Results metrics. Try it now.

New AdWords Metrics and Final URL Support

AdWords final URLs

We’ve rolled out support for even more Google AdWords metrics. This includes Total Conversion Value, Phone Call Conversions, Search Impression Share, and more. In addition, AdStage supports full campaign creation with Final URL Support on Google AdWords. Try it today.

How To Use SEMrush for PLA Keyword Research

Posted by on Jul 1, 2015 in Advertising | 3 Comments
How To Use SEMrush for PLA Keyword Research

This is a guest post by Marta Dalton, Manager of Web Marketing at ANSYS & Phillip Brooks, Content Marketing Manager at SEMrush.


Google Product Listing Ads (PLAs) are image-based paid advertisements for specific products (or SKUs) that appear in the SERPs triggered by searches for related keywords. The Google Shopping platform allows e-commerce vendors to build a database of hundreds, even thousands, of individual products within their Google Account and target ads based on a myriad of criteria, such as: keyword, demographics and geographic location, season and amount of inventory. As with Google AdWords, an inefficient PLA strategy can be costly for any online business. Moreover, a successful strategy for either platform requires regular re-assessment of performance and goals in order to maximize performance. Successful digital marketing cannot rely upon a “set it and forget it” strategy.

Competitive Analysis

We’re going to show you how to use SEMrush to perform a competitive analysis using our PLA tool that will identify keywords in three capacities:

  • Keywords unique to your domain
  • Keywords unique to your competitor/s domain/s
  • Keywords shared by both your domain/s and that of your competitor/s

Each of these data sets can provide you with different kinds of actionable information. For example, keywords unique to your domain may be indicative of keywords for which you need bid defensively, as this represents an opportunity for your competitors. Alternatively, keywords that are shared by both you and a competitor may demonstrate opportunities for growth for either side. This would allow you to check which ads are appearing for that keyword and which aren’t. This gap analysis shows conversion opportunities you might be missing out upon. Finally keywords that are unique to a competitor could show you which keywords represent an opportunity for you.

I want to stress that this is only a snapshot for a particular timeframe and this kind of analysis should be repeated on a regular basis to ensure your strategy remains viable.

SEMrush PLA Tool

It stands to reason that if we’re going to be performing competitive analysis, we must first identify just who our competition is. SEMrush has a feature within the tool that can help us do this quickly and efficiently. Our PLA Tool is a relatively recent addition, but it’s rapidly become very popular with our community.

Let’s look at the video game retailer, Gamestop.com With all the news coming out of E3 last week, there should be some pretty healthy levels of traffic going both to their domain as well as the domains of their biggest competitors. Search volume for individual titles/products/SKUs carried by these retailers will also be robust as users search for the best places to buy from.

PLA Research

Within the PLA Research Tool, enter the domain, and select “PLA Competitors” and SEMrush will deliver a list of competing domains sortable by competition level, common keywords and other metrics.

Here we see those results for Gamestop.com:

Gamestop PLA Competitors

SEMrush scales and sorts competitors using two parameters:

One is the number of common keywords–that is, the number of keywords for which both domains/advertisers appear in the same PLA block.

The other factor is the number of uncommon keywords. These factors are designed to ensure that competitors listed fall within the same industry.

For example, one site may have fewer common keywords but be listed as more competitive because it has fewer keywords in total–meaning that the majority of its business competes directly with the site being queried.

With this data we can not only can see what sites are competing with Gamestop, we can also extrapolate the domains competing with its competitors by feeding those domains into SEMrush for further analysis.

Competitive Analysis Using PLA Positions report

Product Listing Ads Positions

  1. Use PLA Positions
  2. Filter by the brand or the product category to ensure the CSV download is both manageable and usable.
    NOTE: in some cases you might want to start with a broad term and filter in Excel, or you might want to focus on a specific sub-category
  3. Hit apply and export to CSV
  4. Check out the URL structure and see if you can extrapolate category and/or item model number from there. Some competitors make it nice and easy, like so:Gamestop URL structures
  5. In this case we can get category and brand from the URL. Copy the “URL” column data to a new column, then use Excel’s “Text to Columns” tool to delineate the data based on how they’re separated (sometimes it’s a hyphen, in this case it’s a slash).URL Text to Columns
  6. Now we’ve got both “manufacturer” and “category” in separate columns–for the most part, anyway. (It seems that “accessories” here doesn’t follow the format, so we can isolate that manufacturer and then just move them over to the right by one column so that “accessories” lines up with the other categories.)Games Categories
  7. With both “manufacturer” and “category” (maybe sub-category and the product too) off by themselves, we can filter and see what keywords are being targeted by this competitor in these areas.

Keyword Positions Chart


Bonus Hack #1

Sometimes the URL’s aren’t that pretty and they’re just words separated by hyphens in no particular order (or the order changes based on SEO or the title). This is where the 80/20 Rule comes into play. We will focus on the categories or products that are most important to us and pull them out using the Find and Replace tool.

Copy the URL to a new field and label it “categories,” “sub-category,” “manufacturer,” etc. Create a heading for whatever data you want to separate out.

In this case, we’ve made a field to show “sub-category” which will extrapolate “Xbox,” Playstation,” “Nintendo,” and their model type. From this, we can pick the top 10-20 items we want to find and use wildcard characters in front of the text to grab them (in this case, we noticed that the syntax uses hyphens so we could search for “xbox-one,” “xbox-360,” “ps4,” etc.)

We can apply this search parameter to the data, which results in the nicely filtered result you can see on the image to the right:

Sub-category filtered results

From here we can copy the URL to a new column to pull out manufacturer and repeat other data from the URL using the same method.

Bonus Hack #2

Now that we have stand-alone fields separated using Bonus Hack #1, add-in the data from the “manufacturers” and “categories” headings of your other competitors (we also added a new column for the “competitor company” name,) we can use Excel’s PivotTable feature to see how many keywords our competitors are using in each category. If our competitors have a lot of PLA keywords in a category that is strategically important, or in which we have a lot of stock, we might want to revisit our strategy for those terms.

PLA Pivot Table

Bonus Hack #3

With this hack, we’re able to pull a manufacturer product code/model number from the URL. We can then see what prices our competitors are charging for the items in question and adjust our pricing and sales promotion strategies accordingly.

Now we just need to make sure we have active PLA’s running on those items and enough stock to meet the increased demand!

Bonus Hack #4

Once we have the data sorted by “category” and “manufacturer,” we can use Excel’s VLOOKUP function to check against our product list to see what we have in these categories that our competitors are NOT advertising on. If VLOOKUP returns “#N/A,” we know we’ve got a winner that they don’t have.

Using the data we’ve already gotten from the PLA Competitor tool, we want to examine PLA Keywords/Product Names that your site shares with competing domains.

We can accomplish this via a side-by-side comparison between our performance on Google Shopping and that of our competition.

Go to SEMrush → Tools → Domain vs. Domain, enter the domain and up to five competitors’ domains into the input fields, select “Keyword Type” option, “PLA” and press “Go.”


Domain vs. Domain Chart

With this data, we can:

  • See whether or not those domains compete in paid search results for your keywords and compare their PLAs’ rankings for each search term.
  • Generate reports for your domain’s unique keywords (excluding common keywords) to see search terms for which you are an uncontested leader.
  • View competitors’ unique keywords to understand the opportunity that you may be missing; and get ideas for improving your product feed in order to appear in paid search results for more queries.

Keyword research

So now we know who our competitors are. It’s time to identify where our opportunities lie. This is where keyword research comes into play.

From the Domain vs. Domain report we ran above, we can look at which keywords we share in common with a given domain, but we can also look at those keywords which are unique to each domain as well. These often represent opportunities that we can target.

We can use filters to pull out the headings that we want to focus upon. Then sort that data by “competitor position” or by “search volume” to find potential add-ins for your PLA’s.

Competitor Positions Chart

PLA Copies Report

We can also use the Find and Replace method (from Bonus Hack #1) on the export from the PLA Copies Report to roll up keyword totals by heading (like we did in Bonus Hack #2.)


PLA Copies Report Export

This report is particularly handy for creating a “hot list” of items. If we know we have overstock on a specific set of items (talk to your merchandising or purchasing team to see what you have a lot of and/or what stock is about to be written off because it’s aging) we can see what keywords our competitors are going after for those specific item(s.)

PLA Hot List

Are you using PLAs as part of your overarching digital marketing strategy? If so, what other methods are you using to identify keywords that correspond to products that your site carries?

We’d love to hear about them in the comments!

About the Authors

Marta’s background is an eclectic mix of technology and marketing, and she considers herself fluent in translating “techie” to English and vice-versa.  Her background includes a B.S. in Electrical & Computer Engineering and an MBA, both from Carnegie Mellon University, and a winding path that’s seen her lead digital initiatives under both CIOs and CMOs.

Phillip Brooks is the Content Marketing Manager for SEMrush, the leading competitive intelligence tool for digital marketing. He is a prolific content creator who has worked on campaigns for companies both large and small, including Electronic Arts and Turner Networks.

Inflow Chooses AdStage for Automated PPC Rules and Grows Client Revenue by 23%

Posted by on Jun 24, 2015 in Advertising, Automation, Search, Social | 2 Comments
Inflow Chooses AdStage for Automated PPC Rules and Grows Client Revenue by 23%


inflow logoBased in Denver, Inflow is an inbound agency that provides complete digital marketing services to global clients. One of the world’s largest event management companies chose Inflow to manage its global online advertising efforts across its audiences in Australia, Dubai, Germany, Singapore, United Kingdom and the United States. The paid team is primarily responsible for promoting nearly 1,000 regional conferences annually with Google AdWords, Bing Ads, LinkedIn Ads, Facebook Ads, and Twitter Ads.

Inflow previously used a solution that supported Google AdWords optimization. However, the paid team at Inflow quickly realized that it was far too inefficient to continue using that platform. As more events required promotion, the amount of reporting for each office quickly became extremely time consuming. Because of the magnitude of this account, Inflow needed a solution that would not only centralize all of the client’s ad accounts, but also streamline organization, workflows, and reporting.


adstage case studyInflow selects AdStage to manage, optimize, and report on all of the global ad accounts for its client, the leading event management company. Because the client has a global presence, its six offices each had separate ad accounts on different time zones. Because the native networks did not offer a simple solution to accommodate the time zone variances, the Automated Rules in AdStage made it extremely easy for the team to set-up dayparting on AdWords, LinkedIn, and Twitter.

When measuring the performance of the campaigns in AdStage, Inflow was able to easily create, customize, and schedule reports across all five networks in AdStage. The AdStage Global Dashboard provided the agency a stunning birdseye view of cross-network campaign performance that could be easily customized and instantly saved as a PDF file for the stakeholders to review.


With AdStage, Inflow experienced a significant time savings, which allowed them to focus on growing their client’s account.

adstage for agencies

  • Setting up dayparting with Automated Rules on AdStage saved the agency 5 hours per week from having to manually login to each network, pause, and unpause each campaign. Showing ads only during peak hours led to a 28% increase in conversion rates and a 31% decrease in CPA.
  • The AdStage Global Dashboard was easy to customize and showed cross-network performance, which saved the team 4-6 hours per week of aggregating the reports from 5 different networks across 6 separate offices.
  • With the extra time saved, Inflow was freed up to analyze more campaigns for the numerous events that were being promoted. This ultimately grew client account revenue by 23% in just three months.

“Any time savings we can get is profit for us, especially with reporting. If we can spend 5 hours instead of 8 hours on the same task, this is a win for us.”

— JD Prater, Sr. Paid Search Strategist, Inflow


To learn more about AdStage and start your free trial, visit www.adstage.io.

Nursing Your Paid Search Campaigns Back to Health

Posted by on May 12, 2015 in Advertising | 2 Comments
Nursing Your Paid Search Campaigns Back to Health

These days, the competition for paid search advertising is fierce. If you’re not continuously optimizing your campaigns, it’s difficult to stay at the top. Throwing more money on your bids won’t help – you’re going to need to take some serious care of your campaigns in order to nurse them back to health.

Are you seeing a slow decline in click-through rate (CTR) or a steady increase in cost-per-acquisition (CPA)? Your campaign problems might be the result of several different factors. In the post, you’ll learn what optimization strategies you can apply with AdWords to nurture your paid search campaigns back to health.

Get a Bandage

Review your keyword performance report and search query report from the last 60 days. Pausing keywords that have a high CPA, lots of clicks with zero conversions, or an extremely low CTR (< .10%) and no conversions should lower your cost-per-click to start.



Stop the Bleeding

In your search query report, you can see all the keywords you purchased. If there are irrelevant terms that are costing you cash, stop the bleeding and add these as negative keywords.

Run Some Tests

Always testing your ad copy. With only one ad variant, you’re missing out on the opportunity to test messaging. Two to four active ads per ad group will add some lift to your campaigns. Just don’t forget to pause the losing ad as soon as you have enough data to identify it.

Use Segmentation Therapy

I’ve commonly seen campaigns grouped together for network, device, and location targeting. However, organizing campaigns this way actually makes it very difficult to optimize your ads for the particular device, audience, and network. By creating separate campaigns for devices, networks (search and display), and locations, you can optimize each campaign separately.

Don’t Overmedicate

Having too many keywords in a single ad group could be detrimental to campaign health, as some of those terms could be highly irrelevant. Additionally, if you’re only targeting broad- or phrase-match keywords, your ads could appear for very irrelevant search queries. To fix this issue, try using exact-match keywords, especially if they are able to drive enough volume. For ad groups that have more than 25 keywords, break those out into more smaller ad groups that target a single concept.

Take Preventative Measures

Make sure to include ad extensions whenever relevant. Ad extensions give searchers more information up front, taking up more real estate on the search page. You can use Sitelink Extensions, Call Extensions, Product Extensions, and Location Extensions to increase CTR and conversions.

In the example below, the  ad with extensions occupies a larger space in the search engine results.


Looking for more strategies for nursing your campaigns back to health? Enter your email address below to subscribe to our blog! You’ll receive regular emails that cover best practices and news for your PPC campaigns.

Top 5 Excel Features for PPC

Posted by on Feb 25, 2015 in Advertising | 4 Comments
Top 5 Excel Features for PPC

There’s probably no tool more dear to a digital marketer’s heart than Microsoft Excel. It’s the must-have data analysis program that helps turn raw numbers into actionable insights. Here are five of my favorite Excel features that I’ve learned to love over the years.

5. Table Formatting

Difficulty: Beginner

Table Formatting lets you apply a beautiful table style to your raw PPC data quickly.

Excel Table Formatting

For example, you can use it to convert your plain AdWords campaign performance report to a presentation-ready table.

How to set it up:

  1. Remove any extra title and total rows
  2. In the Table ribbon, select a predefined table style
  3. Your table will now feature clear formatting and filterable headers

Learn more about table formatting for PPC.

4. Macros

Difficulty: Intermediate

Macros let you automate repetitive tasks in Excel by recording your manual actions so you can replay them in future worksheets later with a single keystroke.

record excel macro

For example, you can create a macro that removes title and total rows from your AdWords spreadsheets for easy analysis with pivot tables.

How to set it up:

  1. Download and open an AdWords campaign performance report in Excel
  2. From the Developer ribbon, click Record
    1. Assign a keyboard shortcut (e.g., Opt+Cmd+S)
    2. Store the macro in your Personal Macro Workbook
  3. Begin performing the manual tasks you’d like to repeat automatically in the future
    1. Delete the first row in your table (the AdWords report title)
    2. Delete the last 4 rows in your table (the AdWords total rows)
  4. Click Stop to conclude recording
  5. You can now strip the title and total rows quickly by running this macro

Learn more about Macros for PPC.

3. Text to Columns

Difficulty: Intermediate

Text to Columns lets you parse through the data from one column and distribute it into multiple columns.

excel text to columns

For example, you could use Text to Columns to remove UTM tracking parameters from your destination URLs. This would make it easy for you to analyze landing page performance in a Pivot Table.

How to set it up:

  1. Download and open an AdWords ad performance report in Excel
  2. Select your Destination URL column, and launch Text to Columns (Data > Text to Columns)
    1. Leave your data set to Delimited, and click Next
    2. In the Delimiters section, type “?” into the Other field, and click Next
    3. In the Data preview section, select the new column (with your tracking parameters)
    4. In the Column data format section, select “Do not import column (Skip)” and click Finish
  3. Your Destination URLs no longer contain any of your tracking parameters after the “?” and are ready to be analyzed with a Pivot Table.

Learn more about Text to Columns for PPC.

2. Pivot Tables

Difficulty: Intermediate

Pivot Tables make it easy to summarize, analyze, explore, and present large sets of data. It’s a great way to reformat your raw data into interactive tables.

excel pivot table

For example, you can use a Pivot Table with the Ad Performance Report from AdWords to quickly discover the best-performing headline of your ads.

How to set it up:

  1. Download and open your AdWords ad performance report in Excel
  2. Prepare the table by deleting first row (the report title) and the last 4 rows (the totals)
  3. Highlight the table, and insert the Pivot Table (Data > Pivot Table)
  4. Use the Pivot Table builder to dynamically structure the new table
    • Segment performance by campaign and headline by dragging “Campaign” and “Ad” into the “Row labels” field
    • View relevant performance metrics by dragging “Clicks,” “Impressions,” and “Converted Clicks” into the “Values” field

Learn more about Pivot Tables for PPC.

1. Formulas

Difficulty: Beginner

Finally, we get to the most beloved Excel feature of all: Formulas. Formulas allow you to perform calculations and take actions on data in your worksheet. There’s a myriad of formulas that you can combine to make incredibly powerful spreadsheets.

excel formulas

For example, you can use the simple LEN formula to count the number of characters in a cell. This formula is especially useful when writing ad headlines and descriptions.

How to set it up:

  1. In a cell, type =LEN(
  2. Then type the reference of the cell you’d like to count (e.g., your ad headline in A2)
  3. Now, you’ll have a real-time count of the length of your cell

Learn more easy Excel formulas for PPC.

Share Your Favorites

Did I miss your favorite Excel feature? Share yours in the comments below!

5 Ways to Optimize AdWords Campaigns for Mobile

Posted by on Jan 21, 2015 in Advertising | 5 Comments
5 Ways to Optimize AdWords Campaigns for Mobile

Every year, groups of very smart advertisers are asked to give their prediction for the future of digital advertising. For the past 3-4 years, the answer was an overwhelming “shift to mobile.” So what will the predictions for 2015 be? You guessed it, mobile!  So it should be no secret to anyone in this industry that mobile advertising is becoming increasingly competitive. In this post, I will show you some ways to make sure you set yourself up for success on mobile platforms.

While the focus is primarily on AdWords, many of these tactics should be considered when optimizing other networks, and certainly your message should be consistent across your channels.

1. Mobile Landing Pages

Having a mobile-friendly landing page will do wonders for your conversion rates. It makes the user experience less frustrating and makes finding necessary information easy.

Here are two ways to make your landing page mobile friendly:

  1. Use a mobile responsive website – With a responsive website, your site layout and images will automatically adjust to the screen size of the device it’s displayed on. This typically requires an overhaul of your design, but it’s the optimal method and future-proofs your site.
  2. Create a mobile landing page – With a dedicated mobile landing page, you can create a high-converting page that renders well on mobile, without changing your existing website. You can create one in minutes with tools like Lander or Unbounce.

2. Call Extensions

Call extensions simply add a phone number to your ad to help encourage people to call your business.

Which type to use:

  • Just the phone number – only populates a phone number when clicked; customers are unable to click through to the site.
    • If your website is not mobile friendly, or hard to read.
    • If someone will actually answer the phone.
    • If you do most of your business via phone.
    • If there is value for a person to call; e.g. free consult, place an order or book an appointment.
  • Both phone number and clicks to website – if a person clicks on the ad headline, they will be allowed to go to your website; if they click anywhere else, a number will populate to call.
    • If your website is mobile responsive.
    • If your business is hard to understand and more information is needed.
    • If someone will answer the phone.
    • If your website brings value to your business; e.g. you offer a lot specials, typical questions can be answered on your site and information is easy to find.

3. Mobile Optimized Ads

Creating dedicated ads for mobile devices will make testing much easier, and it will help you segment data so you can make more important decisions.

  • Put your specials first –  People’s attention spans on mobile are very short– they are likely on the go or simply don’t have time to research heavily. So put the meat out first, and let them get the potatoes on their own.
  • Use shorter keywords in ad text – mobile searches tend to be shorter, and we know that Google bolds the ad text if it’s part of the search. With that knowledge, if you couple keyword insertion with some carefully placed keywords in the description, you’ll have a pretty bold ad.
  • Use callout extensions – Callouts are a great way to list specials in a short, easy to find place. Learn how callouts can strengthen your offer here.

4. Mobile Bid Modifiers

You can also use bid modifiers allow you to adjust your bids on mobile devices by a percentage of your desktop bid.

There are several rules of thought here. Mobile ads used to be considered a cheaper click than a desktop bid, but since enhanced campaigns, that no longer seems to be the case. However, I usually just keep bid aounts the same until I can get some data to make a decision. You can find that data by segmenting your campaigns by device:

segment by device

5. Be Aware of the Display Network

Let me be blunt– the display network for mobile devices is terrible. You will likely spend most of your time trying to figure out how to exclude all the Mobile Apps. That said, the cpc’s do seem to be pretty low on the GDN. If you want to try and make it work, I would suggest using very specific targeting and placements.

Bonus Tips

Test Everything

Once you’ve gotten a solid mobile strategy in place, TEST! Just because your website looks great on mobile doesn’t mean it’s conversion friendly, nor does it mean your customers will see it the same as you. Test your specials, ad text, landing pages, etc. Remember that any good test has a control and a variable. Once you choose a winner, iterate and test again.

Mobile Only Campaign Test

Since the launch of enhanced campaigns, mobile campaign customization is virtually impossible. However, I’ve heard of some people placing conversion codes on your mobile landing page; then once you’ve gotten enough conversions, changing your bidding strategy to Conversion Optimizer. Google’s algorithm should recognize that mobile is getting all your conversions and start to shift all your impressions to mobile. You will want to make two conversion codes to track the real conversions if you do this. I have not tried this strategy myself, so proceed at your own will. I did think it was a clever concept, though, so I figured it would be worthwhile to share it with you.


Mobile devices can be a valuable tool for driving customers to businesses. Carefully planning your strategy will help ensure you advertise on mobile more efficiently. Test your strategies, and throw your ego aside, letting the data lead your decisions.

Have other mobile optimization strategies? Please post your comments below!