🔍 Get ready for XLOOKUPs in Excel | Google wants to know what TV shows you like

Creating voice search-friendly content with query analysis

Sep 06, 2019 Good morning, search marketers, Excel users, rejoice. VLOOKUPs in Excel are incredibly useful for data analysis — and so, so frustrating if you don't use them regularly. I could probably take a four-day vacation with the hours I've accrued over the years troubleshooting VLOOKUP formulas. Well there's good news: XLOOKUP. This new formula function is rolling out to Office 365 Insider users now. (You may be eligible to sign up from the Account page under the File menu in Excel.)  XLOOKUP is designed to address many of the limitations of VLOOKUP. It can search sheets both vertically and horizontally and requires just three inputs: lookup value, lookup array and return array. No more counting out the alphabet to figure out which column number you want to reference or appending FALSE to get exact matches. And those are just two benefits of XLOOKUP versus VLOOKUP. I'm looking forward to giving it a try. Maybe it'll free up some time to get caught up on TV… Yesterday, Google updated the way it presents movies and TV shows in mobile search results. The new interface demonstrates ways in which Google is thinking about personalization — and data collection. Search for something like "good tv shows," and you'll see "Top picks for you" with a carousel and option to rate movies and TV shows with a thumbs up or down, giving Google more data about your preferences. That data could be used to inform individual and audience preferences when taken in aggregate.  Read on for a Pro Tip on creating voice search-friendly content and more.  Ginny Marvin Editor-In-Chief   Pro Tip   Understand query types and use everyday language for voice search "As virtual assistants get smarter with every voice search, queries are becoming more conversational in nature. It's a good idea to keep your sentences relatively short and not go out of control with your vocabulary," explains Kristopher Jones of LSEO. "People use voice search like they talk in everyday life, so go for 'reliable' over 'steadfast.' Also note, a query beginning with 'what' shows someone who is looking for information, while a person with a 'where' query is probably closer to acting on their intent. Use this information to your advantage when generating content for voice searches." Learn More »   How to become a professional digital marketer (or become an even better one) In this fast-growing era, digital marketers are expected to be skilled in a variety of areas, including analytics, creative direction, sales, digital media and more. Here's how to keep your skills sharp and gain new ones. Read More »   Search Shorts   Google search algorithm update may be rolling out? Google Search algorithm update chatter. We are seeing chatter within the SEO community, as well as from some tracking tools. All are showing signs of a Google search algorithm update. This is currently unconfirmed by Google.  Distance-based businesses in GMB. Google announced that the remaining distance-based service area businesses will be given a nearby area name instead.  Google recrawls at different rates. John Mueller from Google said, "We don't recrawl all sites & parts of sites equally quickly, so sometimes we can get to most URLs within a few days, other times it takes a few months."   What we're reading   We've curated our picks from across the web so you can retire your feed reader Are Brands "Cowardly" for Buying Competitors' Brand Keywords on Google!? – aimClear Blog Baidu is Reshaping Smart Speaker and Voice Assistant Market Share in China – Voicebot Giving Lens New Reading Capabilities in Google Go – Google AI Blog Google Explain Why Some M-Dot Sites In Google Desktop Search May Be Unstable – Search Engine Roundtable Google, Industry Try to Water Down First U.S. Data-Privacy Law – Bloomberg How to fix different types of ecommerce expired content – Builtvisible How You Should Actually Be Testing Google's Responsive Search Ads – Metric Theory PPC & KPI Monitoring: How to Diagnose Lost Search Impression Share Rank & Top Impression Share Changes – Adalysis Understanding Factors that Affect Click Through Rate – DealerOn YouTube to pay $170 million in FTC child privacy settlement – CNBC   Join Us   SMX East: Bigger & Better Than Ever! Join us for the largest gathering of search marketers on the East Coast - Search Engine Land's SMX East, November 13-14, 2019. You'll unlock an absolute firehose of content: 70+ unique sessions covering the topics that matter most – SEO, SEM, voice search, attribution, analytics, content, video, mobile, local, and beyond – plus exclusive community networking, delicious meals, free WiFi, and more. we guarantee it. View rates and register today!   https://searchengineland.com/ Want to advertise? This email was sent to hamoulemouedda.shopingdznow@blogger.com. Unsubscribe We respect your privacy. This email was sent by: Search Engine Land - a Third Door Media, Inc. publication with headquarters at 279 Newtown Tpke. Redding, CT 06896 USA © 2006-2019 Third Door Media. All Rights Reserved.

 

فيسبوك

تويتر

جوجل بلس

بينتيريست

منشور من طرف :

أضف تعليق

الجمعة، 6 سبتمبر 2019