In Microsoft Excel and Google Sheets, there are two main ways of summarising data: SUMIFs and pivot tables. SUMIFs allow you to summarise data based on a condition, while pivot tables allow you to summarise data by row and column. In this article, we will look at how to use SUMIFs and pivot tables to organise and analyse campaign data. When it comes to working with data, there are two main ways to summarise it: SUMIFs and pivot tables. Both have their pros and cons, but which is the best tool for the job?
Read MoreExtensions are part and parcel of ad operations. Be it whether you are from buy-side, sell-side or even search and social, these extensions might come in handy in terms enabling you to be more efficient. Don't you love it when you're able save some time on your tasks? Even if it's by a small fraction, a few minutes here and there do multiply. You could have more coffee breaks instead, which is nice to have as a perk-me-up after looking at dozens of Excel files. We will evaluate and review these extensions regardless of role functions. These extensions could be for programmatic buy-side, sell-side operations or even media planners. Search and social specialists may find them useful too. We will elaborate more in detail on each extension covered in this list. We'll look at 3 dimensions: Productivity: in terms of time saving and effort required Usability: ease of use and usefulness Reliability: how reliable would the tool be - whether we can trust the information derived from the extension, or if it breaks easily
Read MoreNaming convention is the backbone of digital marketing. If you're already working in an agency or a brand, chances are your team would already have a naming convention in place.
Read More