Senior Digital Marketing Specialist | Avast
Daniel works for Avast where he's managing worldwide Search campaigns & taking care of all advertising data. Two years ago, he discovered Power Query in Excel and has started to use this business intelligence tool for automating routine PPC tasks, bulk campaign management & reporting. Soon, he realised that Power Query is an absolute PPC Search powerhouse no one's using. In his free time, Daniel publishes articles about Power Query on his blog ExcelinPPC.com
You want to start learning something absolutely new and become early adopter
You want to learn how to save hundreds of hours per year on common PPC Search tasks
You are tired of copy’n’paste operations in Excel/AdWords Editor
You want to learn how to create various keyword combinations on scale with ease
You are tired of freezing in standard Excel when working with large datasets.
You want to become an Excel go-to person in your team
During real exercise on YOUR PC, you will learn how to create an automated refreshable template for creating new ready-to-upload campaigns, ad groups, keywords & ads in the Power Query extension in Excel. Demo is here.
You should know how to open Excel :-) You should also know that functions like IF and VLOOKUP exist in Excel. (You don’t have to be able to use them). You should also know how to bulk upload e. g. new keywords to AdWords Editor.
You need to bring your PC to the workshop. Power Query is not supported on Mac. The solution is to use Parallels with Windows version of Excel or to connect to a virtual machine running Windows Excel. Users with Excel 2013 & 2010: You need to download and install Power Query. Don’t worry. It’s for free. It’s an official Microsoft product. Start here. Users with Excel 2016: You don’t need to anything, Power Query (aka “Get & Transform”) is already integrated.