Translate

Showing posts with label internship. Show all posts
Showing posts with label internship. Show all posts

Wednesday, April 9, 2014

Carat Media Internship: Final Journal Entry

We have finally reached the end. After 24 weeks of 8-hour Thursdays I can say that I have racked up an average total of 192 hours of working in one of Britain's most reputable media agencies. Such an opportunity of course does not come around every day, which is why I am hugely thankful to all concerned at Carat Media.

My final week can be summed up as being almost like any other: I completed more site transparency reports for a couple of clients; I completed a strategic overview for a client examining two campaigns: the URL and media exchange, in addition to their most popular day parts, which proved useful for us, as I managed to discern the optimum time of day for each exchange within specific strategies; this ultimately aided us greatly in ensuring that under-performing exchanges were dropped, which I advised in my supporting commentary. This was all topped off by a presentation showing keyword performance alongside my own recommendations for action, a graph from which can be seen below:


There was however a new task I was previously unaccustomed to, one that was quite simple yet rewarding all the same: A competitor report. This was basically a task of observation, where I would exhaustively examine all the relevant pages within a list of websites on which our client was advertising (for pets in our case) and see who was advertising in our space, provided they were a direct competitor. From here I would simply note the website, the tab in which they appeared and finally the name of the advertiser/advert, with a small note on the proposition. This allows us to not only see exactly who our main competitors are, but also allows us to spot common tactics in copywriting/creative etc. The table is shown below:



I think that that should suffice for the tasks this week. Now I think it's time to move onto a final farewell, at least -I hope- for the time being, as I leave this position to revise for examinations and complete the remainder of my second university year. But before I click the all-terminating "Publish" button, I will look back at the internship and pick my personal, Top 5 Weeks, which I enjoyed the most for potentially any reason. Let's begin!


Despite the fact that there were only two tasks (one of which being a keyword list,) it was a very enjoyable one that I remember vividly and fondly. By cramped, aching fingers from typing, or by my unwavering gaze as I raced against the clock, the Exchange Removal task was one that -for an odd reason, I think- I enjoyed so much, that I wanted to complete the task before the end of the day without failure and -in the closest nick of time!- I did. It was quite a triumph.


I chose this week because of two reasons. The first reason is because I completed a full strategic evaluation of two clients consisting of day parts, site transparencies, exchange evaluations, the lot; so -as you'd imagine- there was a great deal to organise and it provided an invaluable lesson on managing spreadsheets for readability that I will never forget. It was pretty much the week where I finally formulated a consistent way of organising my Excel work and since then I have continued to do the same, even outside of Carat! The second reason however is far more social. Since it took so long to download the sheet I talked for a while to the colleague who gave me the task and during this conversation, realised we had a few things in common, (namely an interest in Sci-fi) which lead to him lending me the book Starship Troopers by Robert A. Heinlein, for which I am very grateful (it was one of my favourite books last year!)


This week was pivotal because I finally overcame my fear and frustration with spendchecks! The infernal bane of accountancy was no match it seems for my patience and the helpful aid of some of my colleagues, in vanquishing this demon of what turned out to be quite a simple task of recording figures.


Art was never really a strong suit of mine, but that didn't stop me in creating a pretty awesome-looking presentation! I still think my placing images over an iPhone to create a fairly life-like layout of apps, is one of my more genius creations and one which seemed to go quite well at that. Of course it wasn't entirely perfect but nevertheless, it was a job well done!


This week saw me complete an evaluation of a YouTube campaign for which I had to use a calculator to work out some of the sums and put it all into a presentation. It was a little different than usual, where I used CPV metrics for about the only time in the whole internship duration, which of course made it all a little more varied. A very enjoyable week in all where I got quite a few things completed, if the file for that week's anything to go by.

In my final conclusion I would like to round off this post by extolling the virtues of Carat as a company and of these programs as a whole. The AMNET subsidiary of Carat Media, its parent Aegis and in turn its parent Dentsu, are a vibrant and wholesome organisation. Symbiotic, one could say, with the business world and by extension the rest of society, Carat provides a brilliant glimpse into the marketing world of so many clients, so much so that it bestows awesome knowledge. Yes, one could work in-house for one of our top clients but -and despite the fact I've never worked in one- I would say that it provides a narrower view than does an agency held in such high regard as Carat. This is mainly -I think- due to the scope, the breadth of companies that you work for, which all serve to make the days over-flow with experience, which over time amounts to wisdom in knowing what affects one sector as opposed to another, or what one client demands when compared to another, or finally, when one strategic technique works instead of another, in a given scenario. This would be less common in an in-house environment where work is focused on your product and your service and in the instance that you do look into these things for competitors; it is only in regards to how to compete. In an agency this of course is absent from the equation. You will manage the account of one client and then another, making changes as you go without any competitive regard beyond keeping both of them. This is why I think I will always prefer working in an agency to in-house, (or maybe it's my Tomi Clothing experience talking!) because it is varied and provides a breadth of work, combined with considerable depth for the clients we serve.

More importantly however are the virtues of working on small internships like these because -like networking - it can open doors. Since my time here I have been able to gain interviews with companies that I thought far too out of reach and references that can be relied upon to extoll my own virtues to future employers. Yes, I know there is an ongoing debate regarding the ethics of the internship scheme and there are some dubious ones out there. But in good measure, and as part of a well-thought-out, high-quality course, ones like that at Carat Media can really help the student itching to gain the work experience, often needed to dismantle the Catch-22 of not having work experience. 

It has been a fantastic time in all and I'm only sorry to have seen it pass so quickly.

Thanks for reading!

Tuesday, March 18, 2014

Carat Media Internship: Journal Entry #21

Last week was an eventful one at Carat to say the least, as I carried out a new set of tasks revolving around Sitelists. The day primarily focused on spreadsheets that showed all of our website placements from which I had to decide which ones to exclude. After analysing every site in every strategy, I had to compile a Sitelist Removal list that was later inserted into Doubleclick. As long and arduous as it may sound, analysing the sites wasn't all too bad, mainly because the only sites that I had to analyse were the ones with irrelevant URL names, e.g. in a campaign for a camping site I found sites for boating and island purchasing!

Once I'd completed the site lists I showed them to a colleague who placed them into an Exclude list on the DSP in order to remove funding from adverts there in future revisions. He explained the difference between the include and exclude functions and when they would likely be used. For example, if one were engaging in a prospecting campaign, then once many ads had been distributed to as many sites as possible to drum up business, the trial and error method of revision would be applied afterwards. This of course will mean excluding grossly under-performing sites, but for other campaign types (such as retargeting ones,) an include-lead approach may be more efficient because you know where the customers have been before and will want to include a possibly narrower site list. A very enjoyable experience that bestowed upon me new understanding of Doubleclick, which should hopefully benefit my future work.

Now moving on a second set of sheets, were produced for the same client: Day-Part analyses for keyword lists tailored to national campaigns, tackling both Scotland and Northern Ireland. These keyword lists were basically split into the various line items we were running for our client, with each list separated into hourly performance. After organising the tables I discovered the key performance for our client to be across many hours, with some lists performing in the mornings and some in the evenings. This was of course noted in the analysis.

Dayparts

My final task also revolved around keywords for a ticket site, for which I had to discern the performers from the under-performers and list them as before. This was again followed by exclusion on a basis of CPCs, click numbers and CPAs to discern the few that were performing, which in all made the day a rather successful one.

 Keyword Groups

Monday, March 3, 2014

Carat Media Internship: Journal Entry #19

Last week I completed a sizeable analysis of a campaign, which involved multiple spreadsheets, detailing the site transparency of our client, specifically for mobile devices and their operating systems. I made numerous discoveries along the way, everything from audience type deduced from the app engagement to the popularity of phones amongst such groups, in addition to whether they were more or less likely to convert via analysing the app type e.g. popular gaming apps such as Words with Friends would be more likely to result in accidental clicks due to the nature of the game whereas other, less fast-paced and emotionally-charged apps such as those offering individual utilities like unit converters or -as we found- torches, would likely drive more genuine activity. It was valuable experience, but took up a large bulk of the day meaning that there's little to say without repetition. Ultimately this analysis took up eight spreadsheets, for four months from November 2013 to February this year, with each month analysed across two sheets, one for OS, the other for device.

Placements for the Campaign

While the task wasn't too difficult or hard to organise, it was time-consuming, which is why I'll move on to my afternoon task involving PowerPoint. Essentially, I was required to use a DSP to discover the data surrounding our Branding Campaign that spanned two clients and to write the successes and failures into a presentation. Normally I'd use Excel to examine the data in spreadsheet format, but seeing as there was no need to actually pull it from the DSP, only to use it for research, it was much easier to use the display alone, which really helped and it offered quite the opportunity to learn more functions of this particular program. In any case, after writing our overall CPCs for each line item for the first client (by which point there was less than half an hour remaining,) I unfortunately couldn't move onto our second client since either the Internet, or possibly the DSP, went down, which ended the day rather abruptly.

Our Line Items

But the day was quite stretching in summary and provided an interesting span of tasks, for which I'm glad, the ending being quite unfortunate. But hopefully with some luck, next week should run much more smoothly and it is then that I will resume this blog. Thanks for reading.

Monday, February 24, 2014

Carat Media Internship: Journal Entry #18

This week was more of the same initially, completing spend checks for a few campaigns, some government-based, others being those of private companies, but I was glad to see that they were all pacing quite well in general. Using these completed spend checks I went on to carry out some more site transparency reports and later I actually pulled the spend check from a Google-based DSP, which was a new experience. It was quite frustrating initially to be honest as I kept on trying to pull a spend check, but because Google requires you to tick boxes in order to show spend and the other metrics, in addition to selecting a time range i.e. "last 30 days" etc., this created some problems and so I ended up only pulling the data I needed on the third attempt, because I kept forgetting to tick all the relevant boxes, sometimes wondering which ones to tick. But it's still a lesson learned I guess and I did get what I needed without help in the end, so overall: Success!

One of My Better Presentations 

This was followed up with aiding in the design of another presentation focused on the engineering sector, highlighting the benefits of the social media platforms, obviously tailored to their requirements etc. I must also say here that I am really starting to get to grips with using PowerPoint creatively, which is a great deal better than just putting together the kinds of presentations I did at school, that pale in comparison quite frankly. In any case the presentation came out fine, I was asked for feedback before the end of the day actually, with the only criticisms being in certain misplacements of text boxes etc. that unbalanced the layout from time to time, problems that could be solved in next to no time, which was quite pleasing.

How You Can Target via Mobile Devices; 
(I gathered each image separately)

Finally, I aided another colleague in taking notes on LinkedIn as a potential platform, though I got no further than he did in discovering anything particularly new or exciting, it was still an experience (it reminded me of when I used to work for Tomi Clothing actually) and I did learn something about how LinkedIn do business with media buyers, their rates and costs etc., so hopefully such information will come in handy at some point in the future. 

Aside from this there isn't much else to say and so with this conclusion I will see you next week and hope that yours goes well in the meantime; I will hopefully be engaging with the DSPs that I have little experience of currently, so let's see how I fare!

Thursday, February 13, 2014

Carat Media Internship: Journal Entry #16

* For this time last week.

Work was pretty varied this week. I completed some more PowerPoint work and also carried out some more spend checks and I am pleased to say that I think I am finally getting the hang of it (I even altered the budget in the DSP this time!)

But the first thing I did during the day -after struggling with connecting to Google and LinkedIn to complete some work- was to join in a meeting about display advertising -a basics session in which we examined the progress made by both AMNET (which stands for Aegis Media Network, I learned,) as well as the wider industry. There were people from external organisations present who wished to use our services, with the meeting geared to such an end. It was very interesting, learning about how display advertising has developed this year, especially when considering mobile devices (due to take over desktops later this year) and the growth of the platform relative to search. This was accompanied by a historical underpinning of online marketing and advertising agencies, beginning in the late 1990s with portals controlled by companies such as AOL and MSN to the mid-2000s with third-party ad agencies and the present-future position of integrated agencies that offer clients the breadth of services, refusing to distribute client information, offering greater transparency as a result. It was all very informative and whilst I am detailing such a subject, I should also point out a good piece of news this week: That Carat has successfully gained Mastercard's advertising contract, winning $200 Mn of business as a result, a very exciting development.

But moving on I returned to the office and began work on a PowerPoint, a "Ratecard" to be exact, which is basically a document -based on The Guardian's template- that details the types of targeting available on certain platforms, namely Facebook & Twitter seeing as LinkedIn was unavailable for some bizarre reason.

Twitter Targeting Matrix

So after completing the two slides I moved onto my old enemy -the spend check! The dreaded spreadsheet started at me with its large green segments like some kind of complicated tax form, I first thought. But it didn't take long for me to get my head around exactly what to do with it: Just look on the DSP, see what the figures say and transfer it to the appropriate column within the sheet. Even the large green areas aren't anything scary, just areas contrasting with the pre-arranged white areas containing formulae to calculate averages and totals seamlessly as you insert the data, it's ingenious! This enabled me to see how much we spent in conjunction with the averages and budget remaining and I discovered as a result, a complication with pacing, which allowed me to make a necessary change to the daily budget in order to allow for better pacing with trends within that particular campaign and strategy, a beautifully-organised and efficient way of conducting things. 

Not So Bad After All: A Typical Spend-Check

After completing a couple of spend checks I finished the day off with a return to some Facebook tasks associated with ascertaining whether or not a creative for a client had passed its expiry date by looking into the ad placements via FB's ad tool on multiple spreadsheets ad looking for patterns in revenue losses i.e. had it lost far too much business over the last four months or so. This was to try and prove to our client to update their creative strategy to hopefully make our own work easier, because after all, if the image lacks appeal in the first place, no amount of strategic placing will deliver the results desired. Sadly, my examination returned inconclusive analysis, the creative dipping only in December, largely -I imagine- to its lack of seasonal appeal or that of its products for that matter, which is of no relevance seeing as the ads have returned to normal spends now. But at least we're delivering usual results as we should be doing, which you can't argue with.

And that concludes this week's tasks, with a variety of work completed and a large amount of experience gained. Next week I should be completing similar tasks which I hope bestow equally-fruitful experiences and chances to shine. 

Thanks for reading. 

Friday, January 24, 2014

Carat Media Internship: Journal Entry #13

* This post is for 16th January; this week's will be ready for either the weekend or next week. Thanks

So here I am again, back from the holidays well-rested to continue my work at Carat Media. The familiar sight of the office greeted me as unchanged, a tranquil familiarity that really settled me back down into beginning the internship once again and while much of it I was already acquainted with, there were some differences.

The first task was very familiar, to complete a keyword list for a client with whom I have become very knowledgable of in my time there, this week's list focusing on birdseed for different species of domesticated birds. Whether it was a Budgerigar, a Cockatiel or merely a farm-variety fowl, I had to create keyword groups from all the different products listed and associate them via the species into which our feathered friends fell. This was done in the first couple of hours without much hassle, the list also using the latest offers as a keyword group (in total, about 400 rows.)

The next task however took me back to week 11 where I helped compete a PowerPoint for a client to advertise our use of Facebook as a viable marketing tool. This task was similar, with the first part focusing on identifying the key benefits to using Facebook, Twitter and LinkedIn as marketing tools, while the latter part of the task revolved around putting it all together into a PowerPoint (3 slides long) in order to demonstrate the advantages as creatively as possible.

I really don't think I'm great at creative execution on PP, 
but hopefully it gets the message across

The slides will be relayed to the guys upstairs later in the week for them to modify and standardise so that they really are worthy of being presented to clients, but the meat of the slides is already there so hopefully it will serve us well in the future.

The final task was a bit of a pain to complete since Excel was running a little slow and in the end I didn't manage to finish it, though I will next week. A client's campaigns needed evaluating; that's the Contextual campaigns and Remarketing campaigns with -obviously- different standards set for each one due to their intentions (Remarketing focusing on customers who have visited the site and is therefore more targeted than the Contextual material, for instance,) which didn't do much to make the task any harder, only a little more time-consuming. Needless to say, the campaigns were of several different categories e.g. the contextual side of the strategy had around five separate campaigns for different product categories, which I sorted easily in Excel through grouping them all together into a single item, which made the task much easier to get to grips with. There were three spreadsheets in total: a Keyword report, an Ad Group report and a Placement report, the main differences between them being in the evaluation of keywords, ad groups and website placements for creatives, respectively. The performance wasn't brilliant but with the tweaks that I've highlighted I hope it can be improved once it's been fully analysed in the coming weeks.

Without further delay I'll bid you goodbye until next week, where I complete this task and may hopefully engage in brand new ones to test my limits in those areas. Thanks for reading! 

Friday, October 11, 2013

Carat Media internship Journal: Entry #2

And so the adventure continues at Carat Media in my first full work day. Yesterday was much more straight forward in terms of the agenda, with more spreadsheets being analysed for larger companies! I organised the data as I did last week only with less help and in similar or greater numbers. The data was promising for the most part, which was a good thing to write although this week I tackled a different perspective in my reports. This time I examined the best data set for both Reach and CPC/CTR. Using FaceBook's advert management tools I was able to reveal the actual advert used and -in my report- began to compare their respective characteristics in terms of language use and image type, in an attempt to determine what was motivating consumers psychologically, both in the highly-reaching "Company 1" market and the high-click low-cost "Company 2" market. Using some simple logic and research along with the data, I formulated an explanation for why each was successful with their target audiences e.g. one being less upmarket than the other and therefore encouraging potential customers through a first-time buyers 20% discount, due to income segmentation, or the latter appealing to consumers through the strapline specifying a new product collection, and therefore appealing to curiosity.

Interestingly I then worked alongside another employee who demonstrated the ability to use Google Maps to geo-target customers with Facebook display ads within the country. The client was currently opening a series of new stores. Carat's job was to target those within an effective radius to ensure that they would have a strong possibility of attendance. I recall a similar award-winning campaign reported in eConsultancy a few months ago for Vodafone, also conducted by Carat! The technology behind the management of these profiles is so seamless and simple once you've gotten used to it. And spending seven or eight hours in an office getting practice is truly a great way to speed up the process I've found already! 


I've been let off the leash!- 
Some tasks to complete (Above)


The newest task that I performed yesterday however was analysing a Facebook campaign and then re-allocating budgets for it. Through Facebook it's very easy to change the budget during a live advert, which is why at Carat we sometimes -in order to test potential, unknown markets etc- set up several different adverts with small budgets and see how they perform. This was set up several days ago and it was up to me to find the adverts that had performed well regarding CPCs/CTRs and put more money into them and for other, under-performing adverts, to pull the funding from them completely and hit the pause button. In the few hours that I've spent using the Facebook advert manager, I've come to think of it as akin to a mixing desk or music sequencer in a recording studio when recording live audio, having to change controls, lift the gain, add EQ etc. and if -in this case- something isn't working, the figures not dancing to the tune, then pause it and either alter or delete!

Finally, aside from beginning a report on one company's performance in June and October, I used the Facebook Ad Planner to discover the statistics for gender and age in aid of the campaign for an event. I took twelve screenshots showing men and women in the UK in the age ranges of 18-25; 26-35 & 35+ and for each of those gender-age demographics, I selected the niches who liked the event, the figures obviously growing smaller as I became more specific. Hopefully they'll become more useful over the next week!

Looking back at what I've just written it's hard to believe I did so much in about eight hours. The tasks were fun to complete and the atmosphere was vibrant enough to work in for an extended period of time. There were no weird or awkward silences, everyone was always either talking to a colleague (about something work-related usually!) or on the phone to someone in another office. It's been so much more exciting than previous jobs so far, and the work that I'm completing is something that I can say I am truly interested in! Without anything else to say, all I can say is long may it continue!

See you next week . . .   

Tuesday, June 4, 2013

The Intern

As my frantic running around came to an end, I finally secured an internship with one of Europe's most prominent media buyers less than two hours ago: Carat Media. Carat is a subsidiary of the Aegis Group and has over 12,000 employees, operates in over 100 countries, 5 continents or 24 time zones. This experience will be a fantastic opportunity to experience marketing for bigger brands and since the scheme will most likely be rotatory, I will acquire a diverse skill set. Check out their websites if you wish and thanks for reading. Hopefully I'll be writing content, optimising search engines and helping to renovate websites with other team members as well as analysing some data. If you want to get into media buying, this is the agency to look out for considering that they deal in over £2.1B worth of media in the UK alone, making them the second-largest in London and the largest outside of London. Definitely check them out and I hope all's well wherever you are in the world.

http://www.carat.com

http://www.aegismedia.com