![]() ![]() ![]() In this guide, I will walk you through the process of dropping a web query into an Excel file on a Mac. This is not the case in the much-maligned Mac version of Excel (which hasn’t seen an update since 2011), but it is possible! On the Windows version of Excel, dropping a web query into your report takes maybe 3-4 clicks. At the rate I use web queries, I have already saved myself days’ worth of time that can now be spent on higher-priority projects for my clients. ![]() Rather than downloading a new CSV or Excel file, you simply hit the Refresh button in Excel where you have your web query housed, and the data will update. This is especially useful for reports that update on a daily or weekly basis. Web queries give you the ability to build a recurring report in your platform (using Marin for this example) rather than format it as an Excel file or PDF, the report is generated as HTML tables that can be easily imported into Excel. One of these features has become near and dear to my heart: web queries. Aside from being able to manage accounts from multiple publishers in one place, 3 rd-party tools offer plenty of features not available from AdWords or Bing. I am a huge proponent of using 3 rd-party tools to manage SEM campaigns. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |