Benefits of Outsourcing PPC from London To Leeds

About half of our clients are based in London and are choosing to work with a PPC specialist agency in Leeds. Why are they not choosing to work with an agency in London?

Of course, there must be many London businesses working with London based agencies too but I’m curious to find out why some choose not to.

Let’s look at some of the benefits to try and investigate why this might be happening.

PROXIMITY IS LESS OF A FACTOR

There was a time when proximity was key, and some might argue that it still matters, but this is becoming less significant in our current world of technology.

Long distance relationships can work. Communication is paramount but being physically closer does not always guarantee better communication.

Nowadays, companies have access to more tech-savvy ways of communicating, such as Skype and Google Hangouts where callers can see each other and even share screens.

Online group working tools, such as Basecamp and Slack, make collaboration much easier.

  

Saving shared documents on the cloud allows everybody on the project to easily find and access the latest versions. No more fishing around in emails to find that important spreadsheet that might now be outdated.

Selecting the right partner for your business is more important than just choosing the closest option.

GREAT TRANSPORT NETWORK

The opportunity to meet in person still needs to be available, especially at the beginning of the relationship when you are getting to know each other.

Leeds has two routes to reach London, the M1 motorway and the A1, both of which join onto the M25 motorway around London. It also has the M62 motorway running across it from East to West.

The train journey from Leeds to London Kings Cross is currently approx 2 hours 12 minutes. Plans for the 250mph HS2 line expect to cut this journey time to only 1 hour 22 minutes.

There is also Leeds & Bradford Airport, which we use to visit our clients in Southampton or when we attend exclusive Google events in Dublin, Berlin or even New York. Our Google and Bing reps can visit us from Dublin to Leeds in less than an hour’s flight time.

COST SAVINGS

The costs of operating a business outside of London can be cheaper in many ways, meaning that any savings can be passed on to our clients. Two of the biggest outgoings in a business are usually office space and staff salaries.

Ernst & Young reported a 70% rise in London commercial property rents across 2010 and 2015 whilst research from Colliers International indicates that the average prime rent per square foot in London is currently £67.50 per week compared to £30.00 per week in Leeds.

Central Leeds Office Rents

It is well documented that the cost of living in London is higher than for other parts of the UK. On the 31st October 2016, the Living Wage for London increased to £9.75 per hour and £8.45 per hour for the rest of the UK. This leads to greater salary demands in London.

Numbeo currently reports that you would need £3550 per month to maintain the same standard of living that you can achieve with £2200 per month in Leeds. See here to compare the cost of living between London and Leeds.

Of course, management fees vary from agency to agency and are dependent on many other factors too but, if comparing like-for-like, a Leeds agency could offer equivalent PPC services as our London counterparts with lower office and salary costs, which could lead to cheaper management fees and better value for money.

TALENT IS ALREADY HERE

Leeds is excellent for graduate recruitment. The Leeds City Region Enterprise Partnership explains that we have the highest concentration of higher education institutions in the UK outside of London.

There are currently over 100,000 students in Leeds, with many deciding to stay in the area after graduating, providing no shortage of potential talent for businesses to pick from.

The University of Leeds recently ranked number 14 in the Guardian University League Tables and was also named University of the Year 2017 by The Times and The Sunday Times’ Good University Guide.

Google chose to position their UK AdWords JumpStart Team in Leeds. Back in 2007, I was lucky enough to be involved in that pilot project led by Google, offering AdWords support to new advertisers. The project was incredibly successful and later rolled out across Europe, USA & Asia.

This department has since grown from 12 people in a small room to having hundreds of people being trained to be AdWords experts. As employees come and go, due to normal attrition, their knowledge disseminates and increases the standard of PPC across the region.

Leeds has a fantastic digital community and supportive business community who are passionate about sharing knowledge. Here are a few of the key events for the calendar:

  • Buy Yorkshire – an annual business conference that has seen some of the biggest brands and speakers take the stage
  • Leeds Digital Festival – the North’s largest digital festival, 2017 had 115 events, 58 venues, over 400 speakers, 10,000 attendees
  • WordPress Leeds – free monthly evening meetup for Bloggers, Journalists, Designers, Developers and anyone interested in Blogging and Digital Publishing
  • Leeds Business Week – 100 events & seminars across 1 week in Leeds

Leeds was also the first location chosen to set up a Google Digital Garage in 2015. This was part of another Google initiative designed to deliver digital skills training face-to-face to 200,000 small businesses in the UK.

FINAL THOUGHTS

We are proud to be a Leeds based business and I hope that I have made an argument compelling enough for consideration.

The next time your PPC contract is up for renewal, don’t rule us out. We will be happy to discuss your requirements and show you what we can do!

Written by William Cheng PPC Director at Circus PPC Agency

Innovative Video Advertising Examples & Tips

Video advertising is no longer a new concept. We know that the reach can be massive. Google reports that every month more than 1 billion people watch more than 6 billion hours of YouTube.

We know we should all be using it but the question I most frequently get asked by clients is: What makes a good video for a video advertising campaign?

So, here is a collection of some of the most innovative video campaigns that we’ve seen.

CREATE UNSKIPPABLE COMPELLING CONTENT

The first 5 seconds of the video is all you have to capture the attention of the viewer before they get the option to skip your ad.

GEICO created a series of really innovative videos where the commercial message was delivered within the first 5 seconds. They were fun and created curiosity.

PICK UP ON CURRENT TRENDS

A great way to engage with viewers is to create content that is incredibly current and topical.

IKEA created a video making fun of the behaviour where people post pictures of their food on Instagram before eating it.

Ralph Lauren created a video to engage with sports fans during the time of the Rio Olympics 2016.

CATER YOUR VIDEO CONTENT FOR YOUR TARGET AUDIENCE

Remember, you are creating content to engage with the people who you want to love your brand. Understand who they are and what they want to see. Tailor the style and tone of the video to those tastes.

Diesel created videos that were designed to target millennials and had clear references to Tinder and social networks.

Johnson & Johnson discovered that new parents use Google and YouTube to understand how to clean their child so they create a series of video tutorials to engage them.

https://youtu.be/IIrcebdVU5I

CREATE A VIDEO SERIES

GlaxoSmithKline created a fun video series targeting families by incorporating a cartoon character to promote Aquafresh toothpaste. Having multiple ads meant that GSK could target a user multiple times without their ads getting boring and improve brand recall.

https://youtu.be/2SkSctdVYGk

https://youtu.be/VT2j8P5iRik

https://youtu.be/C-aBz99SUxg

https://youtu.be/ZtsNpqdMLAk

USE VIDEO TO DESCRIBE YOUR PRODUCT

The medium of video allows you to deliver your message in an imaginative and intelligent way.

Sonos created a video that demonstrated the frustrating problems, in real-world relatable situations, that their new product can then solve.

https://youtu.be/iR8KFXaE1sw

Bose presented their new headphones with a video that focuses on their main feature and cleverly suggests how it would feel to own them.

https://youtu.be/YjNt_8qeLD8

GET EMOTIONAL

Finding the perfect narrative for your target audience is also crucial. Persuasion sometimes has to be subtle and not simply yelling at people to buy your product or service.

Amplifon promotes its hearing aid by telling a story about how they found a way to change the attitudes of people who refused to get their hearing checked.

Guinness promoted its brand through an emotional creative in order to gain more engagement from users.

https://youtu.be/xwndLOKQTDs

USE YOUTUBERS

YouTubers who have a large subscription base can instantly place your product in front of those followers and their endorsement can be very persuasive. Ensure that you choose YouTubers who resonate with the target demographic that you are looking for.

Swarovski collaborated with Karlie Kloss (ex Victoria’s Secret) who has a channel with 500K subscribers to develop a closer connection with millennials

https://youtu.be/vLxP6UrFxSI

La Roche-Posay used beauty bloggers and YouTubers to make a review of their products

https://youtu.be/1j348kSJnfE

ADAPT TV ADS FOR YOUTUBE

Someone watching adverts on TV is more passive than someone selecting specific videos to watch on YouTube. Because of this, you may wish to adapt your TV ads for your YouTube audience.

Ribena edited their TV ad by adding a dedicated segment to talk directly to viewers on YouTube.

Ribena TV Ad:

Ribena YouTube Ad:

https://youtu.be/K8cZfaPKkTM

Mountain Dew re-cut their TV ad to make the first part more engaging on YouTube to discourage people from skipping the full ad. They also manage to show their product immediately and with high-energy compared to the slower build up on the TV ad.

Mountain Dew TV Ad:

https://youtu.be/tS4eMYq_n6o

Mountain Dew YouTube Ad:

https://youtu.be/FSOcYkUH51w

360 DEGREE VIDEO

This is truly awe-inspiring the first time you see it. Viewers can change their viewing angle 360 degrees around the video allowing them to independently explore the surroundings.

Chanel created a 360 video of a man diving off the edge of a cliff into water. The slow motion and epic feel is enhanced by the ability to view it from different angles.

Toyota filmed a summer road trip in 360 video where you can move around the scenery. They also placed hidden text for you to find by looking around, which encourages interaction.

https://youtu.be/XURhMmDos48

Dewar’s created a 360 video tour of their distillery giving you a real feel for where and how their Scotch whiskey is made. This one is a very long format, over 4 minutes long, and is designed to tell the story behind their brand.

These are only a few examples of fantastic video advertising and hopefully will give you plenty of ideas about how you want to show off your brand.

If you would like help promoting your videos on YouTube or help managing your PPC campaigns on AdWords & Bing then please get in touch to see how we can help.

Written by William Cheng PPC Director at Circus PPC Agency

Automated Imports: Schedule Imports From AdWords To Bing

Bing Ads have recently launched Automated Imports which allows you to automatically import your Google AdWords campaigns into Bing Ads. This can be scheduled to run daily, weekly or monthly.

AdWords to Bing Campaign Imports

Every time we add new campaigns, keywords or ads into AdWords, we then have to also apply those same changes to our Bing Ads account.

Bing Ads already had an Import Campaigns feature so we didn’t have to build the new campaigns from scratch, however, we still had to manually run the import every time.

The new Automated Imports feature is a supercharged version of this and a brilliant time saver so that you can have more time to focus on optimisation.

Below is a step-by-step guide on how to set this up:

Import From Google AdWords

First, sign in to your Google AdWords account.

Bing Ads Automated Imports from Google AdWords

Then, choose to import all existing and new campaigns from your AdWords account or just specific campaigns from that account.

Bing Ads Choose AdWords Campaigns to Import

Check Your Import Preferences

  1. Choose the Bing Ads account where you want to import.
  2. Decide what to import: new campaigns or changes to existing campaigns.
  3. Clean up your campaigns by deleting items that have been removed from Google.
  4. Make adjustments to bids, budgets, URLs and any tracking templates.
  5. Link your ad extensions and/or Bing Merchant Center to your Bing Ads accounts.

Bing Ads Automated Imports Choose Preferences

Schedule Your Imports

Choose when you want to import your AdWords data into your Bing Ads account.

Bing Ads Schedule Your Imports

Choose How Often To Import

Option 1: Once

Bing Ads Schedule Your Imports Once

Option 2: Daily

Bing Ads Schedule Your Imports Daily

Option 3: Weekly

Bing Ads Schedule Your Imports Weekly

Option 4: Monthly

Bing Ads Schedule Your Imports Monthly

Review Your Import Summary

The Import Summary confirms that your import has been scheduled, when it will run and how often it will sync.

Bing Ads Review Your Import Summary

Manage Your Scheduled Imports

You can view and edit your currently scheduled imports and also pause, enable and delete them at any time.

Bing Ads Manage Your Scheduled Imports

Review Your Import History

You can examine all your automated and ad-hoc imports and also download an error file of imports that may have failed.

Review Your Import History

If you would like help managing your PPC campaigns on AdWords & Bing then please get in touch for a free account review.

Written by William Cheng PPC Director at Circus PPC Agency

GOOGLE PREMIER PARTNER AWARDS 2016

Being recognised as one of the top PPC agencies in Europe is a great honour, especially when it comes from Google themselves.

Google set out to find the most innovative and client focused agency partners and Circus PPC were delighted to be shortlisted in the first ever Premier Partner Awards event.

 premier partner logos

GOOGLE ACCELERATE CONFERENCE

We were invited to Google Headquarters in Dublin for a full day of plenary sessions from high-level Googlers and industry experts who discussed key digital trends and better ways of viewing the data.

stand out from the crowd

Web psychologist, Nathalie Nahia, discussed how to create engaging ad headlines that appeal to our primal, emotional and rational brains.

web physcology

Helen Tynan, Google’s Director of People Ops, gave us insight into the methodology of their recruitment process in order to find the best talent and the way they create a forward-thinking culture to get the best out of them.

hiring attributes

All the talks were really engaging and helped reconfirm the things we were already doing right and gave us plenty of ideas to move forward with.

PREMIER PARTNER AWARDS CEREMONY

In the evening, the black tie dinner and awards ceremony was held at the Mansion House, which has been the official residence of the Lord Mayor of Dublin since 1715.

premier partner awards

There was a tangible buzz about the place and you could really feel the difference being a Premier Partner made. These were the best PPC agencies in EMEA (Europe, Middle East, Africa), Google’s finest. Everybody we met had such a passion and dedication to making the industry great.

Unfortunately, we were up against some tough competition and didn’t bring home any of the top prizes but just being in that room and being recognised for the hard work we do for our clients was a huge honour.

We want to give a huge thanks to Google and massive congratulations to the winners. We made some great friends and we cannot wait to see everyone again next year.

Written by William Cheng PPC Director at Circus PPC Agency

BEST SMALL PPC AGENCY – UK SEARCH AWARDS 2016

Circus PPC Agency are delighted to announce that we have been shortlisted for Best Small PPC Agency at the UK Search Awards 2016.

uk serach shortlistWe have found that the demand for a dedicated pure PPC specialist company has grown massively over the last few years and are honoured to receive this recognition from the industry.

Of course there will always be a place for full service digital marketing agencies but we strongly believe that if you want the best results in a particular field you have to work with people who are dedicated specialists.

Over the last 12 months, search engine marketing has changed so much and we ourselves have grown too.

We have done great work with our existing clients – see our case studies here.

We have gained new clients, such as Etyres and Direct Blinds, and continue to work together through their challenges with great success.

We upgraded from being a Google Partner to a Google Premier Partner and were proud winners in Google’s Ready To Rock Awards.

Not only do we work very closely with our Google reps in Dublin but have also developed a great relationship with our Bing Ads reps and were kindly awarded a Bonanza Box Prize for our hard work with them.

We have grown the team internally as well as establishing valuable partnerships with other digital marketing companies who wish to outsource their PPC to an expert agency.

The UK Search Awards categories will be judged by an international panel of respected experts and the winners will be announced at The Bloomsbury Big Top in London on Wednesday 30th November 2016.

We know we have some stiff competition but we are looking forward to taking the whole team down to celebrate the awards evening and raising a glass together with all the other nominees.

Written by William Cheng PPC Director at Circus PPC Agency

Better PPC with Google Attribution Modelling

In search engine marketing Last Click attribution has always been the default and this is especially true in Google AdWords and Bing Ads pay-per-click advertising. However, this way of viewing your data does not always give you the full picture and can potentially be misguiding your online strategy and how you optimise your campaigns.

This can happen in a number of ways:

Scenario 1

Have you ever looked at the Keyword Report in your AdWords account and seen 20% of your keywords driving the conversions and the other 80% just spending money but without ever converting?
Naturally, you might think that 80% of your keywords are only wasting your marketing budget and so you turn them off but once you’ve done this, you see that the 20% of keywords that were performing well are suddenly not doing so good.

Scenario 2

Or, have you ever compared your Device Performance and saw that Mobile traffic is driving large volumes of traffic but conversion rates are dramatically lower than desktops & laptop computers? Armed with this information you make the decision to opt out of Mobile but suddenly your desktop & laptop conversion rates also fall.

Scenario 3

A lot of people might argue that advertising on the Display Networks is only good for branding and not very strong for direct response marketing. However, when you turn off the Display campaigns, your Search figures also drop.
Let’s try to explain what is happening and what you can do about it, keep reading.

GOOGLE ATTRIBUTION MODELLING

The customer journey has multiple touchpoints along the way, however, with Last Click attribution, only the final touchpoint gets the credit for the conversion or sale.
Attribution modelling

The image below shows the search journey where the term “nexus 9 tablet” appears to be driving all the conversions but actually “great tech gifts” started that journey and “highly rated tablets” kept it going.
Attribution modelling

When only using Last Click attribution, end of funnel keywords often receive inflated credit for conversions & sales resulting in over allocation of budget to these keywords and higher CPA whilst limiting exposure to your potential market.
Attribution modelling

Advertisers might miss out on an opportunity to leverage a much larger market:
Attribution modelling

Bidding on keywords that initiate or assist conversions should result in a more efficient budget allocation, capture a larger share of the market and achieve optimal CPA.
Attribution modelling

Google’s new Attribution Modelling enables advertiser to reallocate conversion credit using alternate models. Below shows how the credit would be split across a Position-Based model.
Attribution modelling

Here is a full list of Attribution Models available:
• Last Click
• First Click
• Linear
• Position-Based
• Time Decay
• Data-Driven
Attribution modelling

Google believes that the Data-Driven Attribution Model is the best one to choose because it uses sophisticated algorithms to evaluate all the different paths in your account (both converting and non-converting) to determine which touchpoints are the most influential.

However, this only works if you have enough data for the algorithms to analyse, say at least 20,000 clicks and 800 conversions in the last 30 days.

For everyone else, here are some tips and considerations for choosing which Attribution Model best fits your business:

• Always use Data-Driven attribution if you have enough data
• Avoid using Last Click and First Click models as they will almost never be a good fit
• Consider whether you have a an aggressive or conservative growth strategy as the model you use will surely impact your optimisation
• What is your market position? Are you the market leader or new to the market?
• Do you have many competitors or only a few?
• Is your path to conversion short or does it have long consideration times?
• Is your primary goal to grow your customer base or maintain the relationship with your current customers?

Contact Circus PPC today to discuss which Attribution Model would be best suited to your business and how to implement it in your AdWords account.

Written by William Cheng PPC Director at Circus PPC Agency

EXPANDED TEXT ADS – BETA TESTING ACTUAL RESULTS

At the end of May 2016, Google announced that a new change was coming that would see Text Ads increase to more characters and double headlines, giving us massively more impact on desktop and mobile devices.

ETA Example1

No date has been set for full release yet but we have been involved in the beta testing since April so wanted to share with you some of the actual results we’ve had so far.

WHAT ARE EXPANDED TEXT ADS?

Traditional Text Ads have a format of:

  • 25 characters for the Headline
  • 35 characters for Description line 1
  • 35 characters for Description line 2
  • 35 characters for Display URL

ETA Example2

Expanded Text Ads give us:

  • 30 characters for Headline 1
  • 30 characters for Headline 2
  • 80 characters for Description line
  • Display URL is automatically extracted from the Final URL – (still bugs with this, see below)
  • 15 characters for each of the 2 Display URL paths

ETA Example3

Here is a live example of one of our Expanded Text Ads and, along with our Ad Extensions, makes the ad look huge!

ETA Example4

NOT 100% READY YET

As it is still in beta there will still be some glitches. One we found was that if your domain is in the format of www.example.uk.com then Expanded Text Ads will incorrectly show your domain as www.uk.com as it believes “example” is a subdomain. This then causes a mismatch error between the Display URL and Final URL. Google assures us that they are looking into this and there will be a fix before the full release.

ACTUAL STATS

Here is a sample of comparable stats from our beta testing so far:

ANALYSIS

As you can see there is uplift in CTR across all but one of the accounts and some differences are staggering with over 2000% increase!

For the one that did not have better CTR, it still saw a much improved Conversion Rate and CPA (Cost-Per-Acquisition).

Only 2 of the accounts did not achieve a better CPA, however, the value differences were only very small when comparing against the gains seen in the other accounts.

Some accounts saw a drop in Conversion Rate but a still managed to achieve a lower CPA due to lower Average CPC.

CONCLUSION

The signs are all very promising so far. In general, the majority of the accounts have improved stats and especially the key metrics. The other accounts may just need the ads tweaking and with further bid optimisation we would expect them to also improve in time.

Of course, at the moment, the advantage is that the Expanded Text Ads have more real estate on the SERPs than the current traditional Text Ads. Once this is out of beta and rolled out across all accounts, the benefits will be diluted as everybody will be back on a level playing field.

If you want to be at the front of the queue for new Google betas and work with a Google Award-winning Agency then please get in touch.

Written by William Cheng PPC Director at Circus PPC Agency

Why Your PPC Strategy Should Include Bing Ads

As a specialist PPC agency we find a lot of our clients are very open to the idea of running PPC ads on Bing. If it works on Google AdWords then surely it will work on Bing Ads and most of the time we get better ROI and lower CPCs.

The biggest problem has always been with the search volume but last week we met up with the Bing Ads team at the Bing Ads Connect Manchester event and here are some interesting points that we learnt:

bing manchester

BING’S MARKET SHARE

  • The Bing Network has 18.1% of the market share of desktop searches in the UK according to comScore (Dec 2015)
  • In the UK it has 765 million monthly searches from 29 million unique searchers

BING HAS SOME POWERFUL FRIENDS

  • Bing powers the web results for Apple products such as Siri and Spotlight Search
  • Bing is the default search on Amazon Kindle devices
  • Uber uses Bing’s mapping technology
  • Bing utilises data from Yelp, Twitter, Foursquare and TripAdvisor to enhance search results

bing new friends

BING’S NETWORK IS GROWING

Bing’s Syndication Network continues to grow in the UK and includes:

  • AOL
  • Gumtree
  • Yahoo
  • Eco Asia
  • Savoo
  • Infospace

bings growth

BING HAS THE EDGE WITH WINDOWS 10

Bing is deeply integrated throughout Microsoft products and Windows 10. It is the default search engine for their new Microsoft Edge browser.

  • There are over 200 million devices running Windows 10
  • 32% of Bing UK searches on PC and Tablet are from Windows 10 which is a 40% increase (from Oct 2015 to Jan 2016)
  • 30% more Bing queries with Windows 10 than prior versions
  • 90% of Microsoft Edge users retain Bing as their default search engine
  • Microsoft are aiming to have Windows 10 on 1 billion devices by 2018

bing and windows 10

BING & CORTANA

Bing is the default search engine for Cortana and, if you’re not already using digital assistants and voice search, it is tipped to be the next big thing.

bing and cortana

BINGING IT ALL TOGETHER

Bing is fighting back and has massive plans for growth. Although Google still has the largest search market share, it makes sense to also have that extra 18.1% of traffic on Bing, especially if it is likely to perform more efficiently with better ROI and lower CPC. Importing campaigns across from AdWords to Bing Ads is now a nearly seamless process and with only a few differences that you need to be aware of such as the UTM tagging, UET tracking, bid modifiers on tablet devices, etc.

Our Bing Ads account manager, Laoise (pronounced lee-sha), came over from Dublin last week to meet some of the team in our Leeds office and to discuss the new product features that have recently been launched and also some exciting ones that are coming soon!

bing circus meeting

If you require expert PPC management of your Google AdWords or Bing Ads accounts then please get in touch for a free audit and we’ll help you determine the best PPC strategy for your business goals.

Written by William Cheng PPC Director at Circus PPC Agency

Advanced Excel Hacks: AdWords Hour of Day of Week Report for Better Ad Scheduling

Google AdWords already gives us the Day of Week report so we can see which days perform the best and worst. This allows us to modify bids accordingly for different days. It also already provides us with an Hour of Day report so we can see the best and worst times of day so, again, we can adjust Ad Scheduling and bids to take advantage of this. The problem is that each report on its own does not give you the full picture:

Example 1: Day of Week report tells me that Friday has the best conversion rate:

Day Of Week Report

Example 2: Hour of Day report tells me that the best conversion rate is between 7am to 8am:

Based on these reports what can I do to improve performance?

  • Should I increase exposure on Fridays?
  • Should I increase exposure during the time period 7am to 8am?
  • Should I increase exposure during 7am to 8am on Fridays?

The answer to the above is not necessarily!

At first, these suggestions might seem logical, after all, this is what the data implies but let’s think about it, the Day of Week Report is actually independent of the Hour of Day report. To gain true insight we need to combine the data to create an Hour of Day of Week report so this is where Excel comes in. This is a favourite of mine and a good one for AdWords Excel enthusiasts.

DOWNLOAD THE DATA FROM ADWORDS

There are different screens you can download your data from. The following steps describe the screenshot below:

  1. Within AdWords, go to Dimensions tab
  2. View the Day of Week report
  3. Click the Download report button
  4. Click on the link +Add segment
  5. Navigate to Time then select Hour of Day
  6. Click Download button

Running Google Report

APPLY PIVOT TABLE TO THE DATA

Now that you have downloaded the report in Excel:

  1. Apply a pivot table to the data
  2. Drag the Day of Week field into the Row Labels area
  3. Drag the Hour of Day field into the Column Labels area
  4. Drag the chosen metric you wish to analyse into the Values area (the screenshot below shows conversions)

Pivot Tabe

This will give you the result below which now shows you the stats for each hour of each day of week.

Daily Ad-schedule

ANALYSE ACTIONABLE DATA

I recommend applying Conditional Formatting Colour Scales to the main data and to the Grand Totals help you spot the trends more easily, such as below:

Daily Ad-schedule

Some insights we can gain from this view above is that:

  • Although there are a good number of conversions during 10am to 1pm, this only applies on weekdays and not weekends
  • Thursdays is one of the best days for conversions but the most popular times are earlier in the day

However, this is only one view of one metric. With a little more Excel data manipulation you can combine different tables to create a report that looks like this:

The above report shows us a bigger picture of what is going on so that we can take appropriate action. Here are just a few suggestions:

  • Reduce exposure during 8am to 9am on most days as it is costing the most wasted spend
  • Reduce exposure during 1pm to 2pm on Mon-Tue and during 2pm to 3pm on Wed-Sun
  • Increase exposure during 4pm to 5pm on Wed-Sun as it has good conversion rates and lower CPA
  • Increase exposure during 7am to 8am on Mon & Wed-Thu as it has very strong conversion rate

BENEFITS

You will gain more insight of when you are driving conversions and when you are wasting budget.

You can be more accurate with Ad Scheduling to improve your results.

You can show off your in-depth analysis to you clients/manager/MD who will love the detail.

TOP TIPS

For comparable data, choose a date range that runs through equal days for each week (eg. Mon-Sun).

Choose a date range that you know is reliable (eg. not over the Christmas period, Black Friday, etc. if your results are likely to be skewed by these events).

If you have enough data then it might be worthwhile doing this separately for each campaign to match the trend patterns as closely as possible.

Written by William Cheng PPC Director at Circus PPC Agency

GOOGLE’S DIGITAL GARAGE: GET HELP WITH YOUR DIGITAL SKILLS

As part of Google’s pledge to help 200,000 British businesses with their digital skills by 2016, the UK’s first Digital Garage opened its doors in Leeds earlier this year.

The Digital Garage is the place where you can come to get the digital know-how you need to make the most of the web, reach new customers and grow your business. It’s a pop up space based at the Leeds Dock which opened in March this year as part of a six month pilot initiative.

leeds-google-garage

We’re pleased to say that our very own William Cheng is a Google Technician at the Digital Garage workshops, delivering SME consultancy to businesses and entrepreneurs. Businesses can book in to a one-to-one mentoring session with a consultant like Will.

Free Training Seminars

Businesses can book onto free training seminars. There are two that run twice a week, every week, but at different times to accommodate varying schedules:

  • Tell Your Story Online
  • Reach New Customers Online

You can also book into Pizza at the Garage, which is a monthly networking event with free pizza and beer.

One-to-One Mentoring

In this forty minute appointment, businesses can discuss all things digital with a consultant. Topics you cover could include: how to have a better online presence, website advice, Google Places, SEO, PPC, social media, conversion optimisation, performance tracking, analytics, webinars, etc. You might want general advice or training or have a specific issue you’re struggling with.

To book onto a seminar or to arrange a one-to-one, visit https://digitalgarage.withgoogle.com

William Cheng | Account Director | Circus PPC Agency