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 . . .