Digital Marketing - Study Notes:
Using bulk sheets
It's possible to create and modify campaigns within tools such as Google Ads and Meta Business Suite. However, it can be slow and frustrating to do this, especially when you have a lot of new keywords to add or updates to make.
To speed up the process, many platforms such as Google Ads, Google Ads Editor, and Meta – as well as CRMs such as HubSpot – allow you to add new campaign data or modify existing data via a CSV upload. These CSV uploads are sometimes referred to as bulk sheet uploads.
Generally, it's much quicker to use bulk sheets to add or change hundreds or thousands of ad groups, keywords, ads, CRM records, and other campaign elements than if you were making these adjustments manually.
Each platform has its own CSV upload template, so it's important to use the right template for each platform. In some cases, IDs are associated with elements in the bulk sheet, so make sure you check if this is the case with the platform you’re updating.
As a digital marketing specialist, you should aim to use bulk uploads whenever possible instead of undertaking time-consuming manual updates. This activity can level-up your skills, make you more efficient, and speed up your actions.
Using ASAP Utilities
A very popular Excel plugin for digital marketing is called ASAP Utilities. It's only available for the Windows version of Excel. So, it will only work on an Apple Mac if it has Windows installed on it.
ASAP Utilities provides you with a range of supplementary macro tools that can save you lots of time and make your work in Excel easier and faster. As digital marketers, we need to regularly update our reports and carry out bulk sheet uploads to platforms such as Google Ads, Meta, and so on. ASAP Utilities can speed up these processes.
It can also increase your effectiveness as a digital marketer by identifying and limiting any errors in your reports and bulk sheet uploads. In this way, it helps ensure the quality of your uploads and campaigns.
There is a free three-month trial version of the plugin available.
Back to TopChristopher Coomer
Chris is a results-driven VP of data, analytics, and business intelligence driving data management, analytics strategies, and technical architecture to scale optimized enterprise operations. As a trusted advisor and strategic business partner, Chris develops meaningful data insights and infrastructures through business intelligence and data analytics strategies to optimize business functions and drive impactful ROIs. Chris is also an enthusiastic and passionate educator in the field of data and analytics and marketing at The University of Tampa.
Cathal Melinn
Cathal Melinn is a well-known Digital Marketing Director, commercial analyst, and eommerce specialist with over 15 years’ experience.
Cathal is a respected international conference speaker, course lecturer, and digital trainer. He specializes in driving complete understanding from students across a number of digital marketing disciplines including: paid and organic search (PPC and SEO), analytics, strategy and planning, social media, reporting, and optimization. Cathal works with digital professionals in over 80 countries and teaches at all levels of experience from beginner to advanced.
Alongside his training and course work, Cathal runs his own digital marketing agency and is considered an analytics and revenue-generating guru - at enterprise level. He has extensive local and international experience working with top B2B and B2C brands across multiple industries.
Over his career, Cathal has worked client-side too, with digital marketing agencies and media owners, for brands including HSBC, Amazon, Apple, Red Bull, Dell, Vodafone, Compare the Market, Aer Lingus, and Expedia.
He can be reached on LinkedIn here.
Clark Boyd
Clark Boyd is CEO and founder of marketing simulations company Novela. He is also a digital strategy consultant, author, and trainer. Over the last 12 years, he has devised and implemented international marketing strategies for brands including American Express, Adidas, and General Motors.
Today, Clark works with business schools at the University of Cambridge, Imperial College London, and Columbia University to design and deliver their executive-education courses on data analytics and digital marketing.
Clark is a certified Google trainer and runs Google workshops across Europe and the Middle East. This year, he has delivered keynote speeches at leadership events in Latin America, Europe, and the US. You can find him on X (formerly Twitter), LinkedIn, and Slideshare. He writes regularly on Medium and you can subscribe to his email newsletter, hi, tech.
