Based on this post: http://mklnd.com/18sFgrE. You'll learn in this video how to create a scrolling chart in Excel. These are exceptional for showing values over a period of years, especially in dashboards where real estate is limited.
Views: 61594 Annielytics
Based on this post: http://www.annielytics.com/?p=1575. If you're an Internet marketer working with competitive analysis data, a common task in data preparation is creating a separate column for domains, which you extract from a list of URLs (e.g., backlinks). I show you how.
Views: 13447 Annielytics
Based on this post: http://www.annielytics.com/?p=8501. Google Analytics doesn't provide a good default channel for social ads. I demonstrate why I think tagging social ads with a medium of cpc is a bad idea and proffer an alternative that will allocate all of your paid social into one, neat custom channel.
Views: 5809 Annielytics
Based on: http://bit.ly/ga-campaign-tagging. The most frequent and damaging mistakes I see in just about every analytics audit I perform are campaign tagging mistakes. This video and guide break it down into simple steps.
Views: 6805 Annielytics
Based on this post: http://www.annielytics.com/?p=1458. Learn how to create a custom report in Google Analytics that shows you traffic over time using the month of year dimension. I also include instructions on how to fix Google's funky month of year formatting, which Excel chokes on.
Views: 24828 Annielytics
Based on this post: http://www.annielytics.com/?p=2303. Sometimes Excel's VLOOKUP function fails to get the job done. This video tutorial explores when and how to use the INDEX MATCH alternative to VLOOKUP.
Views: 128005 Annielytics
My site: http://www.annielytics.com. This video demonstrates how to use the HYPERLINK function in Google Sheets to create live links inside your spreadsheet.
Views: 24175 Annielytics
This was a quick tip I did for the YourTango team on how to manage their inboxes using Boomerang. It's a Gmail plugin that allows you to schedule emails to "boomerang" back into your inbox using various rules. You can also use it to schedule emails to send at a later time or date. You can get the plugin here: http://www.boomeranggmail.com/.
Views: 2540 Annielytics
Based on this post: http://www.annielytics.com/?p=727. Break free from the boundaries of standard reports in Gooogle Analytics with this must-see video! You will learn how to create custom reports and the secrets of determining the dimensions and metrics that work best for your data needs.
Views: 34983 Annielytics
Analytics Edge is a free Google Analytics API tool. Tori Cushing of Annielytics walks-through how to use this tool to import Google Analytics data into a custom reporting dashboard. Annie Cushing uses to create interactive dashboard in the Annielytics Dashboard and API course: http://www.annielytics.com/annielytics-dashboard-course/
Views: 1733 Annielytics
Based on this post: http://www.annielytics.com/?p=4953. Learn how to import live data from one Google Doc to another spreadsheet in Google Sheets using the awesome IMPORTRANGE function. When you update the data in the original spreadsheet it will update automatically wherever you've imported it. And you can apply formatting to this data just as you would with a static spreadsheet. And you will look like a data badass. So there's that as well.
Views: 68756 Annielytics
Based on this post: http://marketingland.com/how-to-create-interactive-charts-in-excel-57816. Learn how to consolidate your marketing data by creating an interactive chart in Excel using form controls, which create cool drop-downs for viewers of your chart to choose from. You can download the file from Dropbox: https://www.dropbox.com/s/0izm8sxd7s42els/interactive-chart.xlsx.
Views: 12119 Annielytics
Based on this post: http://www.annielytics.com/?p=4195. If you want to build dynamic dashboards in Excel that update automatically when you import new data, the SUMIF and SUMIFS functions are important to understand. The SUMIFS function especially works as a multi-criteria VLOOKUP.
Views: 9417 Annielytics
Based on this post: http://mklnd.com/16BxpFV. In this video I'll show marketers how to create an interactive dashboard in Excel where the entire dashboard is controlled by a set of radio buttons (although you could also use a drop-down menu, aka combo box). As you select a new option, every chart in the dashboard updates to show just that segment of data. Ooolalaaa.
Views: 36539 Annielytics
Google Sheets doesn't have a Remove Duplicates option like Excel does (booo!). But you can get around this using the UNIQUE function that Excel doesn't offer (booo!).
Views: 4677 Annielytics
In this video I demonstrate how to analyze your site’s backlinks using a network graph powered by a fusion table. To reduce the intimidation level of working with fusion tables (and they are a bit intimidating at first), I did a signature Annielytics take-you-by-the-hand approach to walking you through how to not only set up a fusion table but also how to massage the data once it’s in there and cull out the insights you can actually take action on.
Views: 6854 Annielytics
Based on this post: http://www.annielytics.com/?p=1031. Pivot tables are critical for datasets that are large or require flexibility. I take you from a raw dataset to a highly customized pivot table and demonstrate lots of cool options as I go.
Views: 19859 Annielytics
Based on this post: http://www.annielytics.com/?p=1563. This video isn't just for marketers. It's for anyone who needs to create charts in Excel. It covers column, bar, line, area, and scatter charts, as well as formatting tips.
Views: 5162 Annielytics
From this post: http://www.annielytics.com/?p=4069. The OFFSET function is terribly volatile and can bring Excel to its knees. This video shows three marketing uses for the INDEX function.
Views: 6653 Annielytics
Based on this post: http://www.annielytics.com/?p=2256. It's essential that all marketers working with data be able to rock VLOOKUPs because it is the best way to marry data sets. This tutorial will show you simple to advanced VLOOKUP techniques.
Views: 4737 Annielytics
You can use Moz's Mozbar the quickly view metadata, such as page title, description, and markup. I'll show you how in this tip of the day I did for the YourTango team.
Views: 3847 Annielytics
Based on this post: http://www.annielytics.com/?p=4168. This tool by Google is a great way to learn more about dimensions in metrics in Google Analytics, whether you use the interface or the API.
Views: 1308 Annielytics
Learn more: http://www.annielytics.com/?p=2357. This video is a sample from my dashboard course, which is a collection of 16 hours of videos, a workbook, two Excel dashboards that just need your data plugged in, an Excel practice file for the data visualization videos, as well as links to 40+ resources to aid in your learning.
Views: 1632 Annielytics
Based on this post: http://www.annielytics.com/?p=6111 Have you ever come across something cool on a site but have CSS skills that are kind of hacked (like mine)? This tip will show you how to replicate any cool formatting you find across the web using Chrome Developer Tools.
Views: 5243 Annielytics
In this video I demonstrate how to find and replace special characters in MIcrosoft Word, like carriage returns, to convert columns of values from Excel into comma-separated lists.
Views: 3412 Annielytics
This video demonstrates how I use Moz's Mozbar Chrome extension to quickly find related content for YourTango's posts. This is a demo for our editorial team, but I share these tips for the benefit of others.
Views: 322 Annielytics
Based on this post: http://www.annielytics.com/?p=1208. In this video I demonstrate how to use Advanced filters in Excel using a real-world client project for a reporting dashboard. I provide instructions for 2013 and 2010 for PC and 2011 for Mac.
Views: 3553 Annielytics
This quick tip for the YourTango team demonstrates how to quickly distill a column of data down to a deduplicated list of unique values, even if the duplicated cells are just blanks.
Views: 14497 Annielytics
Have you ever come across some cooly formatted nugget on the Web and wondered how they did that? Well, you can find out exactly how anything was formatted by using Chrome Developer Tools to not only view the site's CSS but also modify it AND then save the CSS to use on your own site.
Views: 38732 Annielytics
Attaching images is so 2002. Gmail makes it super easy to embed them in your email, so the recipient of your email can view them in context.
Views: 30453 Annielytics
The Mozbar allows you to easily find the backlinks for any page you visit, as well as page and domain-level metrics and social shares to the page. I also demonstrate some practical applications for this data.
Views: 534 Annielytics
Learn how to augment your marketing dashboards with links to reports within your table. I demonstrate two examples using SEMRush (a popular marketing tool) and Google Analytics.
Views: 2466 Annielytics
Based on this post: I demonstrate in this post how to find out your top organic landing pages without sampling. The standard way to find them in Google Analytics results in sampling for larger sites, but this hack gets around that.
Views: 1352 Annielytics
Based on this post: http://www.annielytics.com/?p=757. Annotations are very important in Google Analytics and should be used to document changes made to a site, marketing campaigns, Google updates (like Panda and Penguin), and any other events that might have contributed to spikes or dips in traffic. I show you how to create them in this short video.
Views: 660 Annielytics
Based on this post: http://www.annielytics.com/?p=5223. Google turned up the dial on mobile as a ranking signal in April 2015. The purpose of this video is to demonstrate, in simple terms, how marketers can use the Mobile Emulation Tool in Chrome Developer Tools to preview their site on any mobile device. (I really try to avoid geek speak as much as possible in these demos.)
Views: 4732 Annielytics
Based on this post: http://bit.ly/15voW1a. This video shows you how to reverse engineer your competitors' marketing strategies by rifling through their backlinks using simple Excel pivot tables.
Views: 3151 Annielytics
Based on this post: http://www.annielytics.com/?p=8558. Histograms in Excel are tricky. I show you how to use the FREQUENCY function to create categories for your data and then build a histogram chart. All in plain English. (Because I know how scary Excel is for most marketers!)
Views: 548 Annielytics
Based on this post http://www.annielytics.com/?p=792. This video will demonstrate how to find the links on a page visitors click on most using Google Analytics.
Views: 669 Annielytics
Google Analytics uses URIs instead of URLs by default. But that makes it difficult to marry your data with data from other marketing tools. This video will show you how to create full URLs from Google Analytics content reports, whether your site uses one subdomain or multiple subdomains. This process is called concatenation and could also be accomplished with the CONCATENATE function, but I find it clunky. Although I demonstrate how to do this in Excel, the steps are exactly the same in Google Sheets.
Views: 1073 Annielytics
Based on this post: http://www.annielytics.com/?p=2049. This video will demonstrate three uses of the OFFSET function for marketing data and includes creating named ranges for dynamic charts, dynamic data validation, and formatting Google Analytics data.
Views: 921 Annielytics
Based on: http://bit.ly/site-checklist. Learn how to do a site audit with my DIY template. I took my $20k audit and distilled it down to 156 checkpoints, covering 18 sections, with intro text for each section, step-by-step instructions, 90+ explainer graphics. No stone unturned. Also offered in Spanish. A steal at $195.
Views: 1974 Annielytics