My Blog My Blog

How to Use vlookup in Google Sheets

Google Sheets
May 11, 2023/by
How to Use vlookup in Google Sheets vlookup is a powerful tool that allows users to search for specific data in a large dataset. Whether you're a business owner or simply someone who works with data, mastering the vlookup function can save you time and help you make more informed decisions. You might be a complete beginner to vlookup. Or perhaps you’re more familiar with Excel and want to know how to execute this formula in Google Sheets. Either way, you’ll find step-by-step instructions and useful tips below to make sure you’re using the vlookup function correctly and retrieving accurate results from your dataset. Table of Contents What does vlookup do in Google Sheets? The Benefits of Using vlookup in Google Sheets How to Use vlookup in Google Sheets Vlookup Example Best Practices for Using vlookup What does vlookup do in Google Sheets? Vlookup is a function in Google Sheets that searches for a specific value in the leftmost column of a table or range and returns a corresponding value from a specified column within that range. The syntax for the vlookup function is as follows: Vlookup(search_key, range, index, ) search_key is the value that you want to search for. range is the table or range that you want to search in. index is the column number (starting from 1) of the value you want to retrieve. is_sorted is...
Read Full Story

How E.l.f. Saw A 49% Increase in Sales by Focusing On Gen Z

Marketing News
May 10, 2023/by
How E.l.f. Saw A 49% Increase in Sales by Focusing On Gen Z Welcome to HubSpot Marketing News! Tap in for campaign deep dives, the latest marketing industry news, and tried-and-true insights from HubSpot’s media team. Is there anything more satisfying than getting a great deal on a more affordable version of a popular product? Fans of the beauty company e.l.f. don’t seem to think so. Founded in 2004, e.l.f. (an acronym for eyes, lips, and face) was created to offer high-quality cosmetics at a low cost. At the time of its launch, most of e.l.f.’s products cost between $1 to $3. In its first decade, the company experienced a period of steady growth, expanding its product line, opening its own retail spaces, and finding some success in digital marketing. But by 2018, e.l.f. was experiencing a plateau in sales, and closed its standing retail stores, priming the brand for a marketing pivot. E.l.f.’s shift to TikTok In 2019, the hashtag #elfcosmetics had over 3 million views on TikTok before e.l.f. even had its own presence on the platform. With this in mind, the company shifted its marketing strategy to focus on TikTok’s user base (which was overwhelmingly Gen Z), leveraging short-form video and user-generated content in its #EyesLipsFace campaign. Alongside Brooklyn-based agency Movers + Shakers, e.l.f. commissioned an original song that was catchy enough to go viral and encouraged TikTok users to feature the song and the...
Read Full Story

50 AI Prompt Examples for Marketers to Use in 2023

Artificial Intelligence
May 10, 2023/by
50 AI Prompt Examples for Marketers to Use in 2023 As artificial intelligence advances, more businesses are interested in AI-powered solutions to improve their marketing efforts. One of the keys to making the most of the tech in marketing is to write effective AI prompts to generate the desired outcomes. Marketers need to know how to communicate their goals effectively to AI systems. It's a new skill that requires an understanding of how to write clear, concise, and effective instructions that a machine can understand. In this article, we'll share AI prompts marketers can use to optimize their generated results and better meet their marketing needs. If you're short on time, jump to the topic you need. AI Prompts for Lead Generation AI Prompts for Drafting Social Media Posts AI Prompts to Create Podcast or Video Content AI Prompts for Content Promotion AI Prompts for Repurposing Outdated Content AI Prompts for Marketers Marketers can use AI for more than one purpose. They can use it to brainstorm entire processes or series if done correctly. So as you find inspiration for your own AI prompts, feel free to try them out in HubSpot's content assistant. Join the waitlist for HubSpot's content assistant today This content assistant tool natively integrates with the HubSpot products you know and love, allowing you to toggle between manual and AI content creation to generate copy for blogs, emails, and more. Now let's get into the different prompts...
Read Full Story

AI Ethics: How Marketers & Advertisers Should Navigate Them

Artificial Intelligence
May 10, 2023/by
AI Ethics: How Marketers & Advertisers Should Navigate Them Artificial intelligence is being introduced to more users every day — using it to shuffle through music, write strategic plans, make images or art, and improve our lives and business. But many people don't entirely trust it. Lack of transparency and discrepancies in results could prevent the tech from improving, and the implementation of an AI ethical framework can reform that. In this post, we'll discuss AI ethics and how ethical decision-making can improve the technology. But if you're in a pinch, jump to the information you need. What are AI ethics? Why are AI ethics important? Biggest AI Ethical Concerns Benefits of Ethical AI It's a system that AI developers should have in place to serve people better while minimizing negative consequences. Technology can only be as efficient as it's built to be and should follow a universal guideline to benefit its user base. Why are AI ethics important? The use of ethics in AI is essential to prevent the misuse of technology. Without an ethical framework behind it, artificial intelligence can result in privacy invasion, unequal bias, and other risks many may not even consider when beginning to use it. Let's break down some of the biggest ethical focuses in AI that developers should prioritize as it evolves. Biggest AI Ethical Concerns AI is just like any other technological advancement in need of guidelines. Many professionals...
Read Full Story

How Marketing Leaders are Navigating Recession [New Data]

marketing budget
May 9, 2023/by
How Marketing Leaders are Navigating Recession In the last six months, economic trend surveys we've conducted revealed that 37% of marketers are reporting budget cuts – likely due to our changing economy. As a marketer, knowing where your leadership team might need to cut can help you prepare to pivot to strategies with less resourcing. And, if you lead a team, you're likely wondering how marketing leaders are navigating this time to make the best decisions for your staff and business in uncertain times. To help you navigate reducing your marketing budget in 2023, we used tools like Glimpse to survey more than 500 marketing leaders on their top strategies for cutting costs. We also asked them which channels they plan to pull back on first, so you can get an idea of what to expect. How Marketing Leaders Are Already Pivoting Our full report, the Marketing Leader’s Playbook, revealed 80% of leaders have already taken steps to plan or prepare for a recession - so let’s dive right in and see what we can learn. How Marketing Leaders Are Cutting Costs in 2023 Marketing leaders say leaning into earned media, leveraging automation or AI, looking for emerging marketing opportunities, using organic marketing channels, and optimizing your media mix are the top strategies for cutting costs, so let’s take a look at each in more detail below. 1. Tapping Into Earned Media over Paid Media Tapping into earned media is a great (and free) opportunity to...
Read Full Story

The Top Channels for Influencer Marketing in 2023 [New Data]

Influencer Marketing
May 9, 2023/by
The Top Channels for Influencer Marketing in 2023 Finding the right influencer for a brand campaign can feel like dating. You want someone who shares your values, aligns with your goals, and will make a great impression on your friends and family — or followers, in your brand's case. The same can be said if you're an influencer looking for a brand that will take your career to the next level. Whether you're a brand or an influencer, this article will help you find the perfect match by showing you the top channels for influencer marketing. Discover the best social media channels for your next influencer marketing campaign and what platforms to use to find a brand or creator to collaborate with. Best Channels for Influencers Influencer Platforms for Creators 10 Best Influencer Platforms Best Channels for Influencers Below are the channels marketers leverage the most in influencer marketing and where influencers achieve the highest ROI for the companies they work with. 1. Instagram According to our survey, 72% of marketers listed Instagram among the social media platforms on which they work with influencers and creators. Most marketers surveyed (30%) also said Instagram is the platform they get the biggest ROI when working with influencers and creators. Furthermore, most marketers (32%) said Instagram is the easiest platform to work with influencers. 2. YouTube 58% of our survey's marketers listed YouTube as a platform they leverage when working with creators and influencers. 20% of marketers said YouTube yields the...
Read Full Story

15 AI SEO Tools and How to Use AI in 2023 [New Data]

Artificial Intelligence
May 9, 2023/by
15 AI SEO Tools and How to Use AI in 2023 Optimizing your content to rank high in search engines can be tedious, especially when there are many factors to consider. Page load times, keywords, content quality, and videos are all things that can affect SEO. Fortunately, AI SEO tools are available to streamline SEO optimization and boost your website's rankings. In this article, we'll explore the various AI tools available to you, but first, let's dive into how marketers use AI and the definition of AI SEO. How Marketers Use AI What is AI SEO? 15 AI SEO Tools Marketers Should Know How Marketers Use AI We surveyed more than 1,350 marketers to learn how they use AI. Here are some statistics we found: The majority of the marketers we surveyed (48%) reported using generative AI to conduct research. 45% of marketers use generative AI for content creation. When creating marketing content, most marketers surveyed (22%) said they use AI to generate ideas. 70% of marketers said generative AI is important to their content marketing strategy. So, what do these statistics tell us? Essentially, AI plays a prominent role in the workflow of many marketers. If you want to stay competitive as SEO continues to change the marketing landscape, then it's time to consider how AI can help your brand. One way to leverage AI is in SEO. Many AI SEO tools can analyze your website's performance...
Read Full Story

How to Use SumIf in Google Sheets

Google Sheets
May 4, 2023/by
How to Use SumIf in Google Sheets When you’re managing spreadsheets, even a relatively small amount of data can become difficult to manage pretty quickly. But tools like Google Sheets have many functions that help you work with data more efficiently. A common challenge is figuring out how many instances you have of specific values within a large spreadsheet. That’s where the SumIf function in Google Sheets comes into play. Using this function, you can add up numbers in a spreadsheet based on certain conditions. Using a SumIf function in Google Sheets effectively can take some practice, especially in more complex situations. So here are step-by-step instructions and examples of using SumIf in Google Sheets to help you on your way. Table of Contents: What does SumIf do in Google Sheets? The Benefits of Using SumIf in Google Sheets How to Use SumIf in Google Sheets SumIf in Google Sheets Example Best Practices for Using SumIf What does SumIf do in Google Sheets? In Google Sheets, the SumIf function adds up the values in a range of cells that meet certain criteria. It allows you to add numbers in a specific range based on a given condition, such as values that meet a specified condition, fall within a certain range, or match a particular text string. The syntax of the SumIf function in Google Sheets is as follows: =SUMIF(range, criteria, ) Range: The range of cells that you want...
Read Full Story

Lemon8 Is Currently the Fastest-Growing Social Media Platform: What Marketers Need to Know

Marketing News
May 3, 2023/by
Lemon8 Is Currently the Fastest-Growing Social Media Platform: What Marketers Need to Know Welcome to HubSpot Marketing News! Tap in for campaign deep dives, the latest marketing industry news, and tried-and-true insights from HubSpot’s media team. A new social media platform is in town, and it’s quickly picking up steam. Lemon8 is owned by ByteDance, the China-based parent company that owns TikTok, and it’s had a buzzy debut in the U.S. It was originally launched in Japan in 2020 and became available in the U.S. and UK in February 2023. In the past month, it’s become the second most-downloaded lifestyle app in the U.S. behind Pinterest. Speaking of Pinterest… Lemon8 is described as a Pinterest-Instagram hybrid. At its core, Lemon8 is a photo-sharing app designed to inspire users. While users and creators have been vocal about their frustrations with Instagram and its unpredictable algorithm over the past couple of years, are people looking for the next Pinterest when they could still use the original? By the end of 2022, over 450 million active users were on Pinterest. Not too shabby, though the user base is significantly smaller than the likes of YouTube (2.6 billion users), Instagram (2.3 billion users), and TikTok (1.6 billion users). Though Pinterest has a smaller user base than other social channels, its users are generally happy with the platform. In fact, 80% of Pinterest users feel positive when using it. Nine out of 10 Pinterest users refer to it as a “social media oasis,” and only three...
Read Full Story