I was recently asked to write a piece on Analytics at an intermediate level but this also ties into a stage we have arrived at with some Google AdWords training I’m doing so I’ll explain how analytics can pick up where AdWords left off and also how you can use Custom Reporting to monitor other offline and online marketing efforts.

If you are using AdWords for Business to Business advertising one issue is that data drops off at a certain point as you have no checkout and no price or profit attributed to a click which effectively means no calculation of the Return On Investment. This drop off can be picked up using Analytical software and in particular I shall talk about how we can do this with Google Analytics. The main point to note is that with an end action we can track an entire visitors journey from pre-entry to exit or call to action. With a checkout and a piece of code this purchase price is reported back to your Google Account. The replacement in a B2B case is a call to action and this might be in the form of an email link, request for proposal, click to download etc. As long as the visitor has something to click on then they can be tracked. The long winded process of tracking user journeys if you were using a limited stats package would be to look at the keyword that provided the visitor, tie in the key information that allows you to identify them at different stages of the journey and estimate whether they called to action. With Google Analytics Custom Reporting you are able to do far more. I would recommend using this to track individual marketing efforts and Goals to concentrate on more specific calls to action such as a click on an email link or download. Let’s take your social media efforts for example. You could set up a custom report that tracked all of your social media traffic, the site penetration of each and time on site ie. did they actually stay and read something.

Here’s a step by step guide to such a report,

In the example below I set up a new report, the first Metric I am concerned with is the Pages/Visits, to keep the dimension simple I chose Page Title as I will know exactly the page I am looking at. Once I have established the pages visited I would like to know site penetration so I add Page Views, I next want to establish whether they actually found this page interesting so I add Time On Page, finally I am concerned with where the user left the site so I add Exits.

After creating your report I just want to show you a little hidden extra that gives you a better overview of your traffic. When you look at the report you should see something like this.

This is fine for a top level overview but if you’re keen to delve deeper, click on the Pivot View above the top right hand corner of the table. You will be presented with a chart cross referencing traffic sources, the different Metrics are still available and you can change these with a simple dropdown menu.

You could take this one stage further and apply it to your offline marketing efforts, this is a bit of an eCommerce trick but why not publish an advert in a magazine with a unique URL, a unique landing page that could only be found had the person read the advert.

Many people still search one or two keywords and trawl through endless list of results in a search engine. Beyond the provided filter tools there are many tips and tricks to finding what you want quicker. Ever see the keyword you searched in the summary but arrive at page with 20 feet of scrolling. Hit Control F and search that page for that word and be there in seconds. Use and image search and come across sites that you wouldn’t usually have found.

The bulk of this post is about the little tips and tricks when actually entering text into the search bar.

Phrase search (“”) Use exclamation marks to make more than one keyword a phrase, the results shown will be results where these two words appear next to each other.

Site Search Site search is great for finding something you know appeared on a particular site. Often this search delivers better results that some website own search. Jus type site:thewebsite.com and then the keywords to only search one site.

Filetype Search As per site search but the results are specifically files with the file extension you specify, for example chocolate sweets filetype:pdf

Exclude a keyword (-) No brainer!

Wildcard Search (*) This constitutes anything and then your search term. If you only remember some of what you want to search use the wildcard, for example * sweets results in all types of search with a word then sweets.

Exact Search (+) Means that both your words must appear in the results, for example chocolate + sweets.

Our next destination was Cedar Point, Sandusky, Ohio. A theme park that boasted the tallest and fastest roller coaster in the world. The theme park was impressive compared to the one sin England. It had every type of roller coaster and the park was in a great setting on a peninsula with marina’s, hotels and campsites all around. The park was so big you couldn’t do it all in one day. Our only mission was to ride the big one though, the millennium force. We went in after Sarah and Richard had sorted it so we could get in for free but the cameras weren’t allowed in the park, fortunately the first drop was near a road next to the perimeter of the park so the crew drove down on one of the buses and we queued armed with a mobile phone and the digital cameras. The queue was massive but we all messed about to pass the time and I think to avoid the fact that this was a fucking big roller coaster, Phil kept ringing on the mobile to check where we were in the line, cos if it was going to take to long we would have to go but every time we thought we were near the front more of the stalls opened up so every time he asked we told him we were about 10 mins away. He rang every ten minutes and we took it in turns telling him the person before didn’t know what they were talking about but now we were ten minutes away. We finally got to the front and our minds were beginning to change as we saw the roller coaster up close, we had to put the cameras in a locker cos there was a big chance we wouldn’t hold onto them, (apparently). On the way up I admit it I had definitely changed my mind, it was a slow ascent and at the top you could see the curve of the earth on the horizon. We went over the top and everyone started to shout ARHHHHH as you do but then when took a breath I realised I was still falling and there really wasn’t much point in still shouting as there was still quite a drop to go. I have to say it was one of the best rushes of my life going on that thing but there was no time to do it again, we got some ice cream cos that’s what you do in theme parks apparently. Went back to the bus to get on our way to a naturist campsite where a porn festival was being held in Rose lawn near Indiana.

More 80 Raves

“Around the world in 80 Raves” Chapter One – The proposal
“Around the world in 80 Raves” Chapter Two – Ready for the off!

“Around the world in 80 Raves” Chapter Three – Miami

“Around the world in 80 Raves” Chapter Four – Daytona Beach
“Around the world in 80 Raves” Chapter Five – Myrtle Beach
“Around the world in 80 Raves” Chapter Six – Atlanta
“Around the world in 80 Raves” Chapter Seven – Woodstock

“Around the world in 80 Raves” Chapter Eight – New York
“Around the world in 80 Raves” Chapter Nine – Niagra
“Around the world in 80 Raves” Chapter Ten – Detroit
“Around the world in 80 Raves” Chapter Eleven – Sandusky

I have had a lot of requests for the best way and a simple solution for outputting a Powerpoint presentation to video and what are the limitations in doing so. A few suggestions I had heard in the past was using Picasa, Accoolsoft PPT or Slideshare, I didn’t have much luck with Picassa or Slideshare so I won’t write about them. Accoolsoft on the other hand produced some very nice results and even allowed you maintain transitions, animations with slides and to embed videos in the presentation.

Usually I would do this in the edit suite, PNG a deck of slides and time the transitions to a voice over, sometimes this is not necassary it merely needs to change slide every 5 or so seconds.

Doesn’t like fade to blacks on the video
Doesn’t like the when clicked option when embedding a video into a slide.
Doesn’t like embedded videos when things are deep on a drive.

Procedure

Homepage for the Acoolsoft PPT to Video software, Click add in the bottom left hand corner of the page.

Navigate to the PPT file you wish to convert to video

The PPT is added to the Que click Next to continue

Select the format for the video output file. Quicktime (.mov) is a generic format that will playback in quicktime free player.

Many other formats are available and the paid version of the software opens this up further.

You can also refine the settings for the output video as below.


Resolution = Frame size for the video
Encoder = Video codec
Frame rate = frames per second
Bitrate = increased bitrate improves quality but also increases file size.

Set the transition time between the slides

Advanced settings allows you to alter layout and add background music.

Select the location for the output video and click Start