Carat Media Internship: Journal Entry #3

* Please note that this was written a couple of weeks ago because it needed managerial approval before i could be posted. Thanks!

Last week proved rather eventful at work. I completed some more tasks for our clients through Facebook, made recommendations and wrote a lot of it down. But this week I moved onto something else! The new task still revolved around using Excel but instead of Facebook, I used Google's Display Network (GDN) to find the info.

Unfortunately I haven't yet used the actual platform but instead manipulated the data to discern some useful information. I used the Filter option within the spreadsheet to select certain data that fell within a certain range e.g. CPCs at £0.25+ only. This was usually in conjunction with another function such as selecting the column for CTRs and setting the filter to have the values in descending order from the highest. When used together, those two functions should leave the top of the table filled with the data ranges containing the highest CTRs only with 25p CPC or more. Combining several filters is how you can really drill right down into the most significant factors and when you discover bad/good data, you can highlight it appropriately.

However, once discovering the data needed, I wrote explanations for why the data was how it was, analysing the source of the traffic and -when looking into the Google Keywords spreadsheet- evaluating the most effective websites in addition to discussing not only the keyword used, but also the Ad Group into which it fell i.e. a keyword of "things to do 2013" would fall into the Ad Group of "things to do," with possibly several options added for as many keywords as were deemed necessary when the campaign was initially set up.

As the weeks go by I find myself going through the Excel sheets with greater speed as the processes become memorised and I jump from place to place, setting the controls appropriately as I go. Not only that, but I find that my analytical skills are improving and as I become more confident with Excel, I try to do things to the sheet that aren't on the list e.g. re-setting the filters in yesterday's case to try and prove a hypothesis about the data that I had, organising the filter through the keyword and Ad Group to see the frequency of failure in a specific campaign that I had doubts of.

 My Professional Development Assignment for the university; I need to prove that I've developed some sound skills and competencies, as well as a mature approach to work behaviour and a good attitude to the job/field.













Sorry if this post is a little short/sparse on info, I didn't want to fall into the trap of repeating myself week in week out and boring you to death! Not only that but yesterday I had to take a slightly longer lunch break because of a university meeting that unfortunately clashed with the work hours. But I did stay a little longer than usual though so I suppose I made up for it!

Week 2
Week 4