Translate

Showing posts with label carat. Show all posts
Showing posts with label carat. Show all posts

Sunday, June 22, 2014

My New Employer

As I mentioned in my last update and at the end of my inSIDious short story I have recently been taken on at another media agency for the next 10-12 months. This year will be fully-paid I'm glad to say and -having met my line manager on Friday- I'm certainly looking forward to starting, and not just because of the perks!

MEC is a media-buying agency owned by GroupM, who are in-turn owned by Wire & Plastic Products (WPP,) the largest advertising, marketing and PR group in the world. We're prominent across the UK and Europe, having recently won new business interests from both the RAF and Comparethemarket.com, totalling over £100M worth of budgets. The Manchester office sits over the canal that runs through Deansgate, a snaking white bridge running over the waters next to the office area providing a calm and remote feel to the place, while the nearby luxury restaurant and bar provide a country aesthetic in the midst of concrete, where employees often go to enjoy beer or two in the sunshine that seldom glows over Manchester.


MEC: One of the world's most prominent media agencies


I'm working in analytics again, the A&I dept as it's called (Analytics & Insight,) where the trading desks are split in a way slightly different to Carat, though I haven't actually seen any of it in action yet. Interestingly though, the A&I team consists of both comms planners from a previous team and data managers from the original core, due to the new team being formed rather recently in order to capitalise on the growth of data and data trends/current market prominence. In all honesty I'm actually very excited that I was picked to tread this particular route at Carat (one of the reasons as to why I was hired, though my line manager comes from a logistics background, so it's still very diverse) because in recent years, the growth of data in marketing has seen increasing demand for 'data scientists' and people dedicated to managing and interpreting data, so I guess the future looks bright for full-time employment if the trend continues.

There's a very good reason why MEC has been voted into the Times Top 100 Companies to Work For too. Not only does it have high rankings for employee wellbeing, leadership and just under half the staff on £35000+ a year, but it's also got a host of other benefits in exchange for hard work. We get pushed into developing ourselves through an Inspiration Fund, small cash amounts to put towards a goal that would develop us as people and better employees. For example, current employees have claimed the cash incentive to contribute to foreign language lessons, skydiving and musical pursuits, and not only that, but at the bottom of email signatures there will be a statement along the lines of "X makes Y thrive," so everyone will know what your project is, encouraging each other like a family to succeed. We also get early finishes on Fridays and even earlier finishes (2 hours early instead of 1) on summer Fridays i.e. July and August, because -as I'm sure you can imagine- it gets quite unbearable in offices from time to time, certainly true if Carat was anything to go by. But aside from the extra cash, early finishes etc. there's also a vocational piece of work. Everyone gets to choose a project, a piece of individual research to be carried out over 90 days alongside regular workloads, designed to stretch our skills and bring in fresh ideas outside of what we normally do, or for markets that we don't currently work within. A brilliant way of gaining new business I think, the projects better preparing us for when we have to pitch ourselves to a prospective client and show our knowledge and skill.

Thank you for reading this piece and hopefully I will keep you posted as time goes on, but I doubt I'll be able to post a summary of every day I work! I'll see what I can do/post in the future but until then

Take Care!


I love these agency logo lists! 

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, April 1, 2014

Carat Media Internship: Journal Entry #23

Admittedly this post is slightly late as I've been rather busy recently. Last week was very enjoyable albeit a little similar to the week before. I was involved with our DSPs using pixels again, but this time I only looked for the age of the average converting customer as opposed to examining more than one market. Apparently the digital executives manning the Irish desk were quite pleased last week I'm glad to report, so I guess I did right after all, despite my initial doubts. After completing around 9 different campaigns spread across three of our clients I moved onto a new task, using an online maps tool to discover postcode radii.

Pixels

I used the radius tool to focus on London and proceeded to select a radius of around 30Km I think. From here I examined the numbers appearing against the areas, showing population size, which I then cross-referenced with official statistics to discern the areas outside of London with the highest populations. These areas were then placed onto a simple list in Excel and sent off to my colleague, who used the list to select towns and cities from within another DSP. This was again an interesting experience, which taught me a little about the most populated areas of the country and their history as I browsed government reports and Wikipedia, making the task a rather fun one to complete.

My final task for the day was to complete another site list removal, examining campaigns for three more clients. Here I removed the obvious sites, those with unusual URLs, dead links, irrelevant pages and again, these were placed into a removal list within our DSP, which should hopefully funnel out options for targeting sites with our ads. After all, the more bad sites we remove, the less of them there will be and easier it will become to engage our audience.

Thanks for reading this post and I think that this week will be my last session on the internship, which is sad to say the least. The exams are beginning to loom and the year will come to a close in time. So I am afraid to say that the next post on this internship will be my last and before I go I will say that it has been a massive experience for me. Before arriving at Carat I had next to no knowledge of so much, whether that be Excel, digital analytics, databases etc. and after working here for some six months I can definitely say that, even though I am sure I have only scratched the surface, it feels like I've gained an entire repository of knowledge. It's been great fun and so we charge ahead into the final week, next week . . .

Monday, March 24, 2014

Carat Media Internship: Journal Entry #22

During this week I had to complete some administrative stuff for the unit itself, which involved a video that I had to have checked (for client confidentiality purposes.) After all this was done I was set a few different tasks which made the day quite a varied one!

The first task was a presentation that needed producing for an airport client: A keywords campaign. I had a few different line items to analyse so what I did was I used Excel to split the data as usual but instead of analysing and annotating the spreadsheets I produced graphs showing the top decile (best 10 keywords) and produced a table showing the top three contrasted with the worst three for conversions and clicks. This was finally accompanied by a commentary on overall performance for each strategy with recommendations for the future. It was an interesting task I thought.


A Decile Analysis

My next assignment was to a DSP task where I analysed a campaign for audience characteristics using what is called a "Pixel," which tracks users so that -in our case- the client could know exactly which group of people were clicking and what their income was -for example, and match this with age, gender or any other sub-group that you could care to mention. However, not all of these categories have information within them, as they may still be building up a picture which -ideally- will occur as time goes by and the data available grows. In my case, the data available to me was limited in one or two areas but I was still able to discover some interesting things about our audience, which was intriguing.

This was my final task for the day, but between tasks I participated in another meeting, in which I listened to what the good people at one of our search retargeting data partnerships had to say in their pitch to Carat, extolling the values of search retargeting technology for us as an ad agency. The presentation was very interesting, the process of retargeting ads to approximated consumer groups via cookie-tracking pixels innovative and displayed effectively through a simple, grid-like infographic showing how data informs the process, the pixel is placed within a publisher's website and how that pixel garners more engagement as the prospecting blends with the contextual (which was also demonstrated via an amended "conversion funnel," like the one below.) 

Conversion Funnel

As you can see above, search retargeting generally fits around the middle of the scale between discovering customers and driving awareness and moving in for the sell to generate conversions and business. During the meeting I also came across a strategy that I hadn't heard of: Yes, I'd heard about Prospecting and yes I'd heard about Remarketing and finally yes, I'd heard about Contextual. But today I learnt of another strategy: Conquesting. This is basically the intense competition between one company's display ads against a competitor's editorial content e.g. an ad for Ford against an actual article about Vauxhall. It's quite popular at the minute apparently, though it does radiate with '80s-style tactics and language that came with the whole "guerrilla marketing" revolution, when marketing directors and execs started reading books about war tactics as well as Jay Conrad Levinson's classic on the subject. But putting that aside, the meeting was most enjoyable and very informative.

Thank you for reading and see you next week!

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 10, 2014

Carat Media Internship: Journal Entry #20

This week revolved around a couple of long tasks, the first of which involved using PowerPoint for an evaluation of a Branding campaign that covered two clients, very similar to what I did last week in fact, except that this week there were no technical difficulties and as a result I finished both after some five hours of solid work. The presentations involved not only an analysis of site transparency, but also primarily of the creative size, the media exchange and the day-parts. Using all of these facets of the campaign performance I was able to identify some very strong pointers to campaign success, meaning a greater intelligence as a result. The slides will -I imagine- be sent upstairs to the team who reorganise the slides to make them presentable to the clients.

Presentation Slides

During the day I also attended a meeting with the rest of the team focusing on CRO. CRO (or Conversion Rate Optimisation) is the process concerned with increasing conversion rates via creating numerous landing pages on a client's website. From here, after running numerous tests with layout and creative etc. we can determine the best converters without spending unnecessary amounts on rounding up more clicks to aid conversions. It all looked very exciting I thought and in the near future we will be implementing such a service I was told, so hopefully we'll continue to offer a great service to our clients.

The second task for the day came right at the end as an addendum of sorts, considering that there were only twenty minutes left. I was asked to use MediaMath to pull some Geo Insights data on a client and using the pulled spreadsheet, I was able to sort the data to show the top three locations in the UK; naturally, London was the best performer as I and my colleague expected, with other major cities following as runner-ups. This ultimately concluded the day and hopefully next I'll be looking into some more DSP insights and since the unit is coming to a close, I will have to begin thinking about filming a short video on my placement, showing what I do every day and justifying taking the place if it was offered again; quite a bit to fit into a single minute I think!

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!

Monday, February 17, 2014

Carat Media Internship: Journal Entry #17

There's quite a lot to get through today so I'll just start right now. I attended an AMNET Team meeting where we discussed the benefits of using what is known as search retargeting, a kind of retargeting based upon the movements of individual consumers through their conversion path, the decisions made as they go remembered by cookies so that they can be segmented into possible consumer groups such as interest-specific, sub-culture-based etc. so that the end result delivers a personal creative in the ad space to hopefully drive them to clicking and -hopefully- converting as well. It was a very interesting meeting with a leaflet handed out to illustrate the benefits and in general was an inspiring event, that kick-started the day and injected life into me, which is why I think I got through so much.


 A New Strategy!


My main tasks for the day however were focused on more spendchecks and site transparency reports for our clients, filling in the previous days' spend and then using those to ascertain the main performing sites and then to specify the ones dragging the campaign performance down. Using these facts I was able to write up suggestions for the campaign in the future like I have done previously. There were actually some surprising results in the exchanges that weren't driving performance, and in certain -very popular sites- that, although drove very high levels of impressions (and therefore had low CPMs) they didn't drive any clicks or conversions which either lead to underspending or overspending on too few clicks or conversions e.g. some CPAs went over £100. In the end these were rooted out and so with a little luck and further trial and error, we'll ideally strike that golden balance we seek and find the sites that are best for us, combining them with exchanges that position them optimally.

This pretty much sums up the day, but it feels like I did more. I reality it was just the same few tasks completed for a few different clients, with some 4-5 site transparencies completed along with a couple of spend checks, which are becoming easier I am glad to say. The main benefit of these last two or three weeks however is not so much in the completion of reporting tasks but in interacting with our DSPs, with a colleague showing me how to plan strategy via the relevant tool, which was very enlightening in how we select groups of people from preset lists and place undesirable websites into either the basic exclusion list, that gets continually updated if particular URLs deliver poor results across multiple exchanges, and the blacklist, which stores bad sites such as the porn sites and -I imagine- sites associated with unsavoury political groups like terrorist organisations etc. All in all, I hope that you found this informative and I hope you'll come back next week.


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. 

Tuesday, February 4, 2014

Carat Media Internship: Journal Entry #15

As I promised in the last post, I said that I'd reveal what work I've been carrying out at Carat this week, so here it is: I've been designing some more presentation slides, which was great fun and also completing a couple more spend checks, something that I have tried and failed in completing before. I think I am starting to get to grips with it and I did get to use our DSP in a little more depth, so there's experience mounting there.

Chronologically however, I started off in designing a presentation slide for a YouTube campaign, from which I worked out (both with a calculator and Excel) the various metrics pertaining to campaign success i.e. CPC, CTR, Conversions and Cost per View (CPV,) something with which I haven't worked before. Using this I made some pretty cool slides on how we performed and hopefully, these will aid the guys upstairs who deal with getting that type of info out to clients.

This was accompanied by a write-up on Word that detailed my opinions on campaign success, which was well-received I thought. In any case, this lead to my enlistment on another task involving PowerPoint, helping to design a presentation for the benefits to clients of using social media as a marketing tool. I did this through essentially copying boxes and images on other slides and adjusting them accordingly, both to save time as well as to ensure that the whole project ran uniformly throughout all of the slides, the consistency being a quality I was particularly pleased with in the end.



A Slide on LinkedIn Benefits



A Slide on FB Custom Audiences


After all of this I moved to completing a spend check for a couple of different clients, the spreadsheet requiring me to insert the data from our DSP into it to show correct CPC and other cost rates. Though I completed two different sheets, there were some campaigns for which I couldn't find the data and so could not complete the task in full as a result. I sent the sheets off at the end of the day and hopefully next week when I go through them I will show some progress and -hopefully again- what I have done will be correct when I receive feedback. If not then I will have to look into some kind of "baby-steps advice," though having searched Google for "spend checks," there doesn't seem to be much aid in the results, as if no-one's ever called them that before, which gives me reason to believe that elsewhere they're called something different, but I'll have to see. Hopefully I have overestimated my ineptitude and the checks completed last week will be fine. And so we shall see . . .  

Thanks for reading. 

Tuesday, January 28, 2014

Carat Media Internship: Journal Entry #14

So as I stated in my last post, I completed the tasks left dangling over into this week (the report analyses,) in addition to completing more keyword lists for a couple of shopping centres, listing their stores and opening times, relevant brands as well as their seasonal opening hours, which gave a good 6-7 words in each Ad Group designated to a specific store as was demanded. I did the same for a financial advice/investment company, targeting keywords towards their products and services such as ISAs, financial advice and loans, but you've heard all this before, so I won't go into too much detail.

The above tasks took up the whole day, each keyword list gaining over 500 rows of words each and the prior week's reports taking over half an hour to finish, but as of next week the story may change because I've been asked about working elsewhere for a while, within the AMNET subsidiary but on other projects, which I am currently deciding upon. You will see what I choose next week and ideally I'll have more to write about then, so until next time, have a nice day!

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! 

Monday, January 6, 2014

Update: University Blog Post

Hi guys I just wanted to leave you with this link that lets you see my blog post that I wrote a couple of months ago:

http://diginnmmu.com/opinion/how-to-make-your-mark-in-the-job-market-743

I hope that you find it useful!

Monday, December 23, 2013

Carat Media Internship: Journal Entry #12

The finale of the autumn term has arrived at Carat Manchester, though it was something of an anti-climax considering that I finished the day earlier than usual. Aside from a few festive decorations and a mini golf set, the office was largely unchanged. I conducted another keyword list for the subject of Astrology of all things in addition to a Site Transparency report for a client. This was followed by a Placement report for three different clients and after all that, it was decided that I was allowed to leave early! In total I completed about 4 hours of work if you exclude the lunch hour, a nice treat before break up. But the biggest surprise came before leaving when I was presented with a small box of Lindt chocolates as a Christmas bonus, so thanks for that guys!

Aside from this there really isn't anything to be said about the day, apart from the state of some workers (it was the Christmas party the night before, so people were still a little rough!) that came as a shock given that it was right in the middle of the week; I'd always thought of work's parties being held at weekends, but apparently not. In all however, the day was short and sweet, a nice wrap-up (no pun intended) of things before Christmas and with that, I will see you next time in the New Year.

Merry Christmas!

Monday, December 16, 2013

Carat Media Internship: Journal Entry #11

And so the journey continues into the penultimate week before I break up for Christmas! The campaign from last week, on which I advised on strategy, performed quite well I was told, so I'm quite pleased about that.

This week was rather exciting too, for I worked with PowerPoint, designing slides for a client to sell AMNET's Facebook analytics abilities as effectively as I could, which gave me a great experience with the software in placing images, changing colours and hues, and writing as concisely as I could, which I took a liking to pretty much instantly.

I used infographics to demonstrate some key points such as Facebook's reach (targeting the message to the client's geo-targeting strategy seeing as they wanted to target Yorkshire specifically,) as well as one that I pulled from eConsultancy that showed the audience demographics:



I thought it all went quite smoothly. I also helped in advising a colleague on her slides by proofreading for typos and wording inconsistencies: for example -because you work in a particular field, jargon becomes a second language almost, which outsiders don't understand- and so I had to -on occasion- ask what certain phrases meant, so together we re-worded some parts of the presentation in order to make it more client-friendly; we don't want our message to go over their heads after all! I don't think the presentation has been completed yet, but the deadline approaches and I hope it contributes to our successes; we've seen quite a few recently between gaining the Premiere Foods contract and being bought out by Dentsu back in July, let's hope it continues! 

After the presentation, I conducted some more stuff on Excel, completing a Keyword, Placement and Ad Group report for a client and recommending a strategic direction for each, stating good and bad results for CPC, CTR and CPA and reasons as to why this was so. For example, I deduced that since the campaign performed well on the keyword for "Help to buy," that the reason why it was successful was due to the political implications with George Osbourne's "Help to Buy" scheme designed to help people onto the housing ladder in the United Kingdom via part-subsidised lending packages bestowed to prospective first-time buyers. This obviously holds certain implications for as to the average age of those clicking them, which could aid the campaign further in the coming weeks.

Finally, as a task before leaving I tried (and failed) in attempting my first ever Spend check. Spend checks are basically accounts that show conversions, clicks and spend etc. of any of our campaigns and the budget remaining at any given time. Because platforms such as Facebook are unreliable as far as determining costs are concerned, we have to manually input and check the numbers via the other DSPs in order to show the true amount and if it corresponds -as it should- then there would be no need to change anything, and we can just copy and paste the data into the Excel template. If however, there are discrepancies, then we must make the changes in order to make the budgeting fully transparent. These are also used to check the amount of cash that you have remaining for any particular campaign, and if there isn't enough you will have to alter the budgets allocated to each strategy or advert in order to stay within budget so that the campaign runs its course.

The reason as to why I failed was because I just found the whole layout confusing and it was at the end of the day, so maybe I'll try again next week when I'm fresh in the morning. I actually finished early this week since we had a small pre-Christmas celebration where the others gave presents around from under our tree in a "Secret Santa" fashion. Mulled wine was drank (from mugs!) and generally people unwrapped gifts with joyous cheer (there were some very cool presents, like an infographics book with trivia, or a 3D artistic sculpture from the Gadget Shop, as well as a white chocolate Snowman!) A fun day in all with a great twist away from the norm.

And so we proceed to the finale before Christmas, let's hope it's exciting . . .



Nine Days to go!

Monday, December 9, 2013

Carat Media Internship: Journal Entry #10

As we reach double digits for my time spent within Carat, the holiday approaches! We've been putting some Christmas campaigns together recently as I'm sure you're aware, putting keywords into practice for those searching for gifts etc. I didn't complete anything of that sort this week but a rather more complicated task.

As I've detailed in previous weeks, I have so far completed Site Transparency reports, Keyword reports and Ad Performance reports amongst others; this time I reported for two clients on overall performance for the last two months. That's pretty much all of those separate reports combined into one behemoth file! Needless to say, the report contained several pieces of data for several different metrics, all of which formed a six-figure cell total.

When you first stare into something so large and you have so much stuff to analyse it's impossible to organise it into just 1 pivot table; I found that I needed at least 3 or 4 since the idea behind the task was to re-evaluate the strategy because in many respects the campaign was failing to get through to a core audience, though there were pockets of times and days when business was good, as well as certain creatives that outperformed others, which I then found were affected, in turn, by the exchange through which they travelled and when I pulled all this together, I started to see a bigger picture. And that's basically the whole point of the task, to discover who was clicking, when, on what days, and as you find a desired audience, you look at what media best sends the message to these people along a valuable exchange.


Imagine doing this for two clients!


Once I completed this task I wrote up my findings and suggestions for the campaign direction in a Word document. We'll see how that performed next week, so fingers crossed! In essence the whole process is just a constant trial and error, using judgement and intuition about why certain things are happening, and what you can do to affect that world from behind a DSP in as positive a way as possible for your client. Sometimes I imagine it gets pretty stressful, especially if nothing's working or there's not much time to get a campaign off the ground, which is where a client might start getting agitated with you. But given that there are many options to chose from, all at the click of a few buttons, chances are, there will exist somewhere in the ether the solution to your problem; you've just got to find it!

Saturday, November 30, 2013

Carat Media Internship: Journal Entry #9

This week saw me complete two long tasks: The first was yet another keywords report, a great list compiled for a phone company's website, targeting their Christmas deals as well as the generic brand names, contract durations and associated details, which slowly built out from specific lists to cover every facet of the four major categories, thereby creating the week's keyword list: This task took me to lunch, during which I finally boiled the kettle for myself and a colleague, as you should when in the office as an unwritten rule of courtesy!

After the break I was assigned a brand new task: An Exchange Report. These are basically spreadsheets (a prewritten template at Carat) into which data is placed from our chosen DSP. The DSP contains for several of our clients, the exchanges through which we buy our media and as I'm sure you can imagine, some of them outperform others; some are so bad that they have to be deleted. And that's where I come in!

Campaign layers: A quick diagram


In the spreadsheet you basically have multiple columns titled by metric, exchange name etc. in order to group your data. In the DSP you can select what metric or campaign aspect that you wish to see and for our task, we selected the CPC/CPA option because we need to know how much our clicks and conversions are costing us. From here, we can see which exchanges are performing well/not-so-well when compared to the average. The averages are calculated by the DSP for each individual strategy, which potentially has any number of exchanges within it (some had 1, others had around 21) and in analysing each piece of data, you can discover the overall effectiveness of the strategy based on how it currently stands regards to each individual exchange, a component of the strategy I guess; and if an exchange is performing badly as a 'damaged' component, you have to notify the architects of the strategy, which is essentially what the sheet is for.

Not the most exciting image I know, but I did make it through all assigned clients in the nick of time, I'm glad to say!







And after all of this, my fingers numb and my eyes stinging slightly from staring into the abyss of Excel for four hours or more, I was glad that I hadn't left earlier: Someone from downstairs came into the office with leaflets for Cafe Nero, a FREE coffee no less! It was strange seeing as I'd bought one on the way to work earlier so I guess I made some cash back the next day, walking back to the university with a Chestnut Latte, which I can highly recommend for the festive season!

See you next week . . .

Wednesday, November 27, 2013

Carat Media Internship: Journal Entry #8

This week I completed yet another keyword analysis (for a sports venture) in my first couple of hours. Thankfully I started to do something a little different and so we can return to a more exciting post!

After my keywords were drawn up, I completed some more Dayparting tasks. One was for a banking and financial services company (their mortgage campaign) and the second was for a company that produces and sells blinds. I used the Sort/Filter option once again to discover what the data said and put the most popular hours and days into a simple table. After this I wrote a strategy document where I recommended a plan of action. For example, the bank only had conversions during the week and lacklustre activity at weekend, which, I decided, was due to people using their free time at weekend to relax when it came to utilitarian pursuits of life, preferring to carry out such tasks during the week -and later at night- when they are in the midst of working for a living, the nature of the product residing within a similar state of mind where such purchases and brands dwell, in the consumer sub-conscious.

More excitingly, I updated the Carat "Best Practice Document" for Dayparting. This involved taking screenshots of pages and describing how to interact with a DSP we use in a step-by-step guide. I also had to delete the old section of the document that described processes on a platform that we no longer use, and had to replace it with a section on how to use DBM instead. This was really beneficial because by writing down how to go through the process, it was like I was teaching myself how to use it and as a result, I feel more confident now in using those platforms.



I then worked alongside another intern on Spendchecks, watching the process. Spendchecks are basically a type of document that tracks expenditure on different things associated with a campaign. In order to "check" the spends, you have to look at what Facebook Ad Manager is telling you and what the platforms are telling you, since Facebook is not completely reliable when it comes to specifying accurate monies etc. so the cross-reference is entirely necessary. I haven't actually carried one out yet, but hopefully in time I'll be sinking my teeth into one!

And that pretty much summarises the day. It's been more varied than the last couple of weeks, which is refreshing though I'm still lost for words when it comes to describing these things as it's getting to the point where I just start saying "today I carried out another Site Transparency/General/Keyword Report... you know, like the one I did in Week 5." This isn't really a criticism of the programme but more my admitting that I'm running out of ideas on how to present the same information of how to do something, in a novel way that's engaging. Alas, I'm not as good a blogger as I thought I was it seems :), though as FDR once said on failure, "...(But) above all, try something."

And I will leave you with that motivational quote from the ex-president (for this week's novelty) and hope it serves you well, along with this week's blog post, and the next one . . . (and the one after that, ad infinitum.)

Regards

Wednesday, November 20, 2013

Carat Media Internship: Journal Entry #7

This week I continued with much of what I did previously. I entered more data into Excel for my previous client as well as another one that deals with large department store clients selling furniture, jewellery, clothing, technology etc. The keywords that I came up with -as you'd expect- were pretty varied though I did find myself becoming repetitive over time.

Within the first half of the day (after about an hour) I joined the others in a meeting in one of the boardrooms to listen to a discussion on keyword build-out best practice. We decided that the ideal way to carry one out for large websites was to find the smallest section number e.g. 4 tabs reading "home," "garden," "outdoors" and "activities," and from here go into each of those as a separate campaign or category. Within each of these you could create an Ad Group by the name of -for example- "living  room" and within each Ad Group you would list your chosen keywords; (you could go even further into each specific product if you wanted, making very specific Ad Groups.) The idea is that you pick anything and everything that you can because, if you think to search for a string of words in hopes of getting a product, chances are that someone else does that too. On average though, we only allow 50 keywords max in any Ad Group, but if you split it down much further, you could potentially end up with many small Ad Groups that have average keyword numbers of only 10 or less. Ultimately it just depends on the client and campaign sometimes.

My second keywords chart was for a client that sells women's haircare products (driers, straighteners etc.) where I entered a fairly modest sum of keywords (around 100.) I really don't want to show the charts because there was no colour-coding of anything this week, so it all just looks pretty bland. But at the same time, if I put images on here it gives me more metatags to play with when it comes to SEO, so here:


Kitten!  


After this, I conducted what was more of a research task than a keywords one, for a wine company. In this sheet I detailed the wine that was being sold, the origin of that wine, whether it was red, white or rose and finally, noted some key textual components as described in the product copy e.g. "drink young;" "full-bodied" etc. This was in aid of a new campaign that sees release fairly soon.

In all today was very enjoyable albeit being quite repetitive; the meeting was a good highpoint (and not just because of the filtered coffee!) where I learnt more about constructing keyword build-outs, and more importantly, how Carat are seeking to standardise how they place the data into Excel, so that every employee speaks the same language if you will, in terms of the column titles and how the data is written down for each platform where synonyms can potentially confuse.

See you next week . . .

Week 6
Week 8