Friday, 20 July 2018

18 Webinar Hosting Tips to Guarantee Nobody Misses Your Next Webinar

Here at HubSpot, we know a thing or two about webinars. We’ve set the Guinness World Record for largest online marketing seminar, hosted webinars with partners such as Facebook, LinkedIn and Unbounce, and we’re able to host and promote in-house because of the modern marketing team we've built.

No matter how great the content of your webinar is, though, it doesn't mean much if there's nobody there to hear it. So what do you do to ensure people actually, you know ... show up?

Turns out, there are at least 18 things you can do to get people aware of, excited about, and attending your next webinar. Here's a guide to making your next webinar a rousing success.

Download our free webinar checklist here to make sure your next webinar or webcast is a success.

What Is a Webinar/Webcast?

A webinar (also known as a webcast) is a live, online seminar or workshop that's delivered over the internet. A host -- that's you -- organizes the event and invites attendees. The beauty of a virtual event? The host and the attendees can be located anywhere in the world.

The most successful webinars are ...

Educational.

Education is one of the most powerful tools you can use to make change happen. Webinars need to have some type of educational component to it -- whether you're educating your audience about a product, a service, a new piece of content, how to use a tool, and so on. 

Clearly communicated.

Webinars are great ways to scale your communication. Provide value to your audience by communicating your message clearly. This includes how you organize the content of the webinar, how you present it verbally, and how you present it visually in your PowerPoint deck.

Entertaining.

Finally, a great webinar needs to be entertaining. Otherwise, your attendees might as well think of your webinar as 40 minutes to catch up on email. After all, that verbal component is what makes webinars so unique: There are few other mediums where you can deliver content that lets your personality shine through to such an extent.

It's really easy to create webinar content with only your end goals in mind -- that point you want to get across, or those things you want to talk about -- but that won't keep your audience engaged. Think carefully about who your audience is while crafting your webinar content. At the end of the day, your webinar is about building connections and relationships with your audience so they trust you that much more.

18 Webinar Hosting Tips That Get People to Show Up

1. Pick a killer topic.

It's really, really hard to get people to attend your webinar if your topic stinks. Try to select a topic that's broad enough to attract a large audience, yet targeted enough to provide actionable advice that attendees can implement the second they hop off your webinar.

For a webinar with Unbounce, for example, we decided that we wanted conversion rate optimization to be the overarching theme (because what marketer doesn’t want to optimize?), but with a focus on landing page copy and design.

When titling your webinar landing page, do some SEO research to see which keywords you want to rank for. Use that same title for subsequent blog posts and SlideShares, and you'll end up with a slew of assets to back up that keyword ranking.

2. Set a registration goal.

Having a goal will inspire you to hit it, and help you measure success. In order for us to break the Guinness World Record for webinar attendees, for example, we hit about 31,100 registrants. You should track performance on at least a weekly basis to see whether your marketing efforts are moving the needle. That way, if you need to dial up your promotion due to low initial registration numbers, you'll know what to do to fix it. 

Note: Just because people register for your webinar does not mean they will attend your webinar. Which brings us to our next tip ...

3. Set an attendee goal.

Webinars typically get 36% of pre-registrants to attend the live event. To determine how many registrants you need, you should think ahead to how many actual attendees you want.

Continuing with our Guinness World Record example in the previous tip, we knew we needed just over a third of our webinar registrants to show up to break the most-attended webinar world record. So, with a little backwards math with the 36% figure above, shooting for more than 31,000 registrants yielded 10,899 attendees -- just under 36% percent of our registrant number -- which is what we needed to break the record.

You will see the word “remind” quite a bit in the rest of this post. That's because getting people to attend your webinar requires lots and lots (and lots) of registrant reminders. People often sign up for webinars weeks in advance, so it's critical that you're making an effort to keep your webinar top-of-mind during that time.

4. Give attendees something special.

Try to think of things that will get people excited, feeling special, talking with colleagues, and remembering their experience on your webinar in the future. Excited registrants turn into excited attendees.

At HubSpot, we’ve given away tickets to events, free marketing assessments, and ad spend coupons to Facebook and LinkedIn. We’ve also inspired the audience by asking them to be a part of something huge, like breaking a world record.

Another example of a contest you could run? Ask them to tweet something related to the webinar a week in advance, and pick the winner at the beginning of the webinar. At HubSpot, we held a #WorkRemote hashtag challenge to support our webinar on working remote effectively, and we built this landing page to explain the rules and how a winner would be picked. (Note: Be sure to work with your legal team when planning any challenge or contest.)

You could note in the promotional and reminder emails that "attendees are getting a special 25% discount on X," and include that discount code in the final slide of your webinar.

5. Choose the right day of week.

Don't host your webinar during the weekend. Okay, you probably knew that one. But did you also know that it's best to host your webinars on Tuesday, Wednesday, or Thursday?

Monday and Friday always seem to get filled up with “catch-up” and “last-minute emergency” happenings around the office. In WhatCounts poll, the data suggested that their audience preferred Wednesday or Thursday for webinars -- and we tend to agree. 

6. Choose the right time of day.

HubSpot typically runs webinars at 1 p.m. EST or 2 p.m. EST, because it's the most convenient time for the largest chunk of our audience. But if you have a huge audience in ... I don't know ... Jakarta, you might want to reevaluate your timing. Right? Right.

However, like any variable in marketing, the best time (and day) will depend on your audience. Which time zone(s) do they live in? Do they work nine-to-five jobs, or are their daytime schedules more open? To maximize attendance, experiment with different days and times, compare attendance rates and conversion rates, and tweak your timing accordingly.

If you're just starting out or have no clue what time works best, you can always ask. Include a field on your registration form that asks attendees to confirm the time slots that work best for them, and schedule your webinar based on that feedback.

7. Create an informative landing page.

Be clear. Be honest. Set expectations. Take a look at the landing page we created for our webinar with Rajan Kapoor of Dropbox (which you can view on-demand here):

hubspot-dropbox-webinar.png

On this landing page, we’ve clearly outlined a few things:

  • Who? Introduce presenters on the landing page, with brief bios that explain who they are and why they matter. (Well, why they matter for this webinar, at least.)
  • What? Include an explanation of what the webinar is about and some of the topics it will cover. Bullet points are best. Pick a dedicated hashtag for your webinar and include it, too.
  • When? Seemingly obvious, but ensure you provide a date and time so people can mark their calendars.
  • Where? Clearly explain when and how the webinar will be accessible. Typically, webinars are accessible via links, and can be joined 30 minutes prior to the start time.
  • Why? Explain the value of your webinar. What will people be able to do after they leave your webinar that they weren’t able to prior to attending?

8. Send a thank-you email and registration confirmation.

Sending a thank-you email isn't just good manners -- it also gives you a chance to confirm your attendees' registration (so they know that their form submission worked) and, you know, remind them about your webinar. Some people will delete it. Some people will save the email in their inbox, serving as a periodic reminder of your webinar. Some people will take the details in the email and input it on their calendar. If any of your registrants fall into those last two groups of people, you're sittin' pretty.

We recommend including a call-to-action to "Add this webinar to your calendar" as the #1 CTA in both your thank-you and follow-up emails. (More on this later.)

9. Send value-building reminder emails.

Send these two weeks in advance, and one week in advance on your webinar. They not only serve to remind registrants about the webinar's date and time, but rebuild the value that you established with them on your registration landing page. Many of your registrants may have not only forgotten that they registered for your webinar ... they may have forgotten why they registered in the first place.

Include relevant blog posts or previous ebooks or webinars that cover similar topics. You might frame this as content your team has recently updated, which they can learn more about in the webinar. Include the webinar's hashtag and tell people to tweet if they have any questions.

10. Send two final reminder emails.

People forget. Things come up. Last-minute reminder emails -- specifically, one the day before, and one the day of -- give people enough time to finagle attendance around meetings and other items on their to-do list, but also not too much time that they'll forget about the webinar. It's only a day (or less!) away, after all. Again, include the webinar's hashtag and tell people to tweet if they have any questions.

11. Market your webinar using social media.

You know what's awesome about social media? It's much more difficult to oversaturate your social audience than your email audience. And there's a really, really good chance much of your email audience is connected with you socially, too. That affords you the opportunity to use social media to remind your audience about your webinar.

If you're using a social media publishing schedule, you can pepper in updates for every social channel that remind your audience you have an upcoming webinar. Increase the number of reminder updates as the date approaches, particularly the day before and day of. Make sure you pick a dedicated hashtag for your webinar and include it on the landing page, in your emails, and everywhere else you're promoting it.

12. Market your webinar through your speakers.

Of course you'll be promoting your webinar, but what about the presenters? You know, the ones with a different audience than yours right at their fingertips? Are they leveraging their personal connections, social accounts, and email lists to make sure they have a giant audience? If they're not, they sure-as-shootin' should.

13. Don't be afraid of paid media.

If you’re looking to drive more attendees to your webinar and have the budget, a little paid media to supplement your organic efforts can always help. For instance, you might run a PPC ad on Google for a search term that aligns with your webinar content in order to get the word out and drive attendance.

By bidding on a long-tail term such as “aligning sales and marketing” you can also keep your PPC costs low, promoting your webinar in a cost effective way. Just make sure your paid media team and organic team are aligned, so your company is organically publishing terms like "aligning sales and marketing" while you bid on the same term, resulting in total dominance in the SERPs for that keyword phrase.

For more detailed tips, download our free guide to social media advertising.

14. Blog about your webinar.

Use your blog (and other blogs if you have the relationships) to promote your webinar and the topic it covers. Create a "launch blog post" for your webinar indicating the excitement of new content/data in the webinar. Obviously, you'll want to provide links to the registration landing page within the blog post, too -- including a webinar-specific CTA to include at the end of your post, like we did in the post below:

Blog post promoting a webinar

You can also get your audience warmed up to the topic of the webinar by creating blog content that discusses that topic at different angles. Include the webinar CTA in these posts as well, but be sure to swap it out with a different CTA once the webinar is over.

Bonus: If you start writing posts about the webinar topic far enough in advance, you can use the questions readers ask in the comments section to beef up your presentation, too.

15. Set calendar reminders.

Some uber-organized people will put your webinar right on their calendar, but there are tools out there that let you take it a step further. 

My colleague Christine White, manager of marketing acquisition here at HubSpot, uses AddEvent and WorldTimeBuddy to create add-to-calendar CTAs.

16. Partner up.

If you want more people to attend your webinar, you can always consider working with another brand. But while additional attendees is one benefit, it shouldn’t be the main focus of partnering up -- relevancy, however, should be.

HubSpot has partnered with numerous partners specifically for co-marketing purposes because we believe that two well-aligned brands have the power to be truly amazing together -- much more amazing than they can be apart. It's also helpful for your audience if they can hear another perspective once in a while, particularly when that perspective comes from a specialist's point of view.

Tweet about partner webinar

17. Leverage your homepage.

Your homepage is likely one of the most visited pages on your website. So why wouldn’t you leverage your homepage real estate to promote upcoming webinars?

It's a great way to show people that your entire company is behind the webinar and sees the value in it for site visitors. Don’t hide behind your webinars; get them out in public and show people that your company believes in the initiative. (HubSpot customers: Learn how to create smart CTAs for your homepage here.)

Homepage CTA on HubSpot promoting webinar

18. Use the best video conferencing tools to ensure a smooth video experience

If an industry expert reveals the secret to success, but their technology wasn't good enough to record it, did they make an impact?

The content of your webinar might be unparalleled industry insight, but it isn't nearly as valuable if your attendees can't easily access and listen to the event. Picking the right video conferencing tool puts your webinar on the platform it deserves so people are encouraged to join in and listen to you.

What are some reliable webinar hosting services to choose from? Glad you asked ...

Loom

Loom is a video recording software, compatible with Mac, Windows, and Chromebook computers. The tool offers a convenient desktop app and can record your screen activity in real time. Loom is particularly useful for pre-recorded webinars, slide presentations, and single-hosted experiences.

Google Hangouts

If you have a Gmail account, you're probably familiar with Google Hangouts. This simple video conferencing tool pops out of your Gmail account and can invite attendees to a group call using their email addresses. It supports live webinars with multiple guests.

Zoom

Zoom is a cloud-based conferencing tool that offers live and on-demand video services. You can use a Zoom account to add a video chat option to group events listed on your online calendar.

GoToWebinar

GoToWebinar helps you create branded webinars with automated email invitations leading up to the event. It also makes it easy to follow up with attendees after the webinar, while reporting on who attended and who didn't.

Customers buy from the companies they can trust, and broadcasting your industry expertise via webinar is one of the key ways of doing that. To learn more about how inbound marketing can help you delight your customers, take our free certification course below.  

free webinar checklist



from Marketing https://blog.hubspot.com/blog/tabid/6307/bid/33540/18-ways-to-guarantee-nobody-misses-your-next-webinar.aspx

Our Fearless 50 on Being Fearless

Just last week, we had the pleasure of announcing the entirety of the inaugural class of the Fearless 50. We are excited to share their stories in their own words—what drives them to be fearless, including key takeaways that you can learn from as well.

Kimi Corrigan, Director of Marketing Operations at Duo Security, Emily Poulton, Marketing Manager at the Adecco Group, and Satu Ståhlstedt, Marketing Automation and Digital Marketing Specialist at Fujitsu, sent us their advice to marketers looking to be fearless in their own way. Their tactics range from the simple, like learning to enjoy the ride, to the difficult, like learning to accept failure as a part of growth.

Move Past Your Fear of Being Fearless

Kimi Corrigan, Director of Marketing Operations at Duo Security, shares her thoughts on what being fearless means to her, both inside and outside of her marketing role.

“Being fearless is an intimidating concept. The notion is a little different for everyone, but a common interpretation is that you must be bold, confident and have all the answers. I used to think I needed to operate that way, but now I know that for me, being fearless is recognizing the problems, fears and worry about what could go wrong and facing it all head on,” said Kimi.

One of the most common fears many of us face is the fear of failure. Kimi shares what it feels like to look at the fear of failure a bit differently, saying, “To be willing to fail, and fail fast, can sometimes be crippling. But I have learned with forced habit to take that leap every day and to take my team along with me. It’s bold to risk failure for yourself, but it’s fearless to risk it on behalf of your company and those who you lead. But the rewards are sweeter, bolder and bigger.”

Kimi also offers up this great pro tip: “Shove aside the imposter syndrome feels, put in the work, learn how to shake it off when things don’t go according to plan and never forget to celebrate the victories and milestones.”

Stand Out and Be Fearless

Standing out in the crowd is one of the most fearless things a person can do, and Emily Poulton, Marketing Manager at The Adecco Group, is no stranger to it. She believes demand generation is one of the most difficult marketing roles in which to be fearless, but taking that approach has been crucial to her success.

“The demand generation space can be pretty tough, not only for those just starting their marketing journey, but also for those who have been in the game for a while, because demand-gen marketing is all about people—generating someone’s interest in your content, attracting a person to your website, creating an environment where people can communicate with you and engage with your brand. If your job is to ensure your content stands out and gets to the right person, you need to be able to put yourself in their shoes. Don’t create a campaign for a target audience, a user or a lead, but for a human, a person, a tech-savvy and busy marketer.”

Emily mentions the importance of standing out and being willing to ask the tough questions to push the envelope, saying, “With so many emerging technologies, new trends, and where you are marketing to someone like you, it’s hard to stand out and create the demand for the products/services your sales team is asking marketing for. But the good news is, these trends bring new technologies and ideas for marketing professionals to evolve their campaigns from tried and tested whitepaper downloads, to bespoke user journeys. Try out the new digital tools and channels, apply them to your campaigns, try them for offline too. Be the first in your team/company/industry/country to try something new.

Don’t be afraid to be innovative, don’t be afraid to challenge your “we always do it this way” campaigns, don’t be afraid to ask, “Would I click on this?” Don’t be afraid to make the case and explain the “whys” to your manager/team. Be a fearless marketer.”

The Not-So-Smooth Road to Being Fearless

The concept of turbulence is not just related to air travel—the world of technology is a bumpy ride, changing every day, leading marketers to scramble for the best solution to the challenge they are facing. Satu St√•hlstedt, Marketing Automation and Digital Marketing Specialist at Fujitsu, believes that turbulence can actually give the marketer the opportunity to thrive and innovate in new and exciting ways.
“The 2010s are a riveting time in history to be working in marketing. Every day in the office is an adventure, abundant with new marketing technologies, social media tools, content and meme trends, and even legislative changes. While this ever-present turbulence might fill some with fear, I feel it’s an opportunity to thrive and to revolutionize the way marketing has been done before.

We’ve been given tools to offer highly personalized and automated marketing experiences to our customers every single time they engage with us during their lifecycle. The possibilities are endless. So much so, that many of us may feel overwhelmed.

The key thing is not being afraid to try new things, to always improve on yesterday and to understand that failure is part of success. What will never (hopefully) be out of fashion is the human-to-human approach. As automated as things become, we must always strive to involve a touch of humanity to whatever we are doing with our customers. Digital technologies and marketing automation will only enhance the humanity of marketing.

That being said, AI, VR, and AR still have not seen a proper dawn in marketing and I, for one, cannot wait until it does!”

We all share a common thread as part of the Marketing Nation community—being fearless in the pursuit of marketing excellence. We hope these anecdotes from members of the Fearless 50 are inspirational and educational to those who are just starting out in the world of marketing and reinvigorate the excitement of those who have been in the industry for years. Be willing to fail and learn from it, assert yourself and ask the tough questions, and enjoy the ride that being a Fearless Marketer affords us.

Thank you to Kimi, Emily, and Satu for sharing their insights into what being fearless means to them and we are looking forward to sharing more stories of bold and brave marketing as the year presses on.

How do you embrace being fearless in your role each and every day? Are you inspired by the ideas shared above by our Fearless 50? Let us know in the comments!

The post Our Fearless 50 on Being Fearless appeared first on Marketo Marketing Blog - Best Practices and Thought Leadership.



from Marketo Marketing Blog https://blog.marketo.com/2018/07/our-fearless-50-on-being-fearless.html

The 7 Most Useful Google Sheets Formulas

Lately, the best part of my day has been figuring out the cool new things I can do in Google Sheets -- which, yes, definitely means I need to get out more, but also means I can share my favorite formulas with you.

Learn how to run effective marketing campaigns using Google.

How to Use Formulas for Google Sheets

  1. Double-click on the cell you want to enter the formula in. (If you want the formula for the entire row, this will probably be the first or second row in a column.)
  2. Type the equal (=) sign.
  3. Enter your formula. Depending on the data, Google Sheets might suggest a formula and/or range for you.

V-LOOKUP Google Sheets Formula

V-lookups, are by far, the most useful formula in your tool-kit when you’re working with large amounts of data. The V-lookup formula looks for a data point -- like, say, a blog post title or URL -- in one sheet, and returns a relevant piece of information for that data point -- like monthly views or conversion rate in another sheet.

For example, if I want to see how much traffic a specific set of blog posts got, I’ll export a list from Google Analytics, then put that list in another tab and use the V-LOOKUP function to pull views by URL into the first tab.

The only caveat: The data point must exist in both cells, and it must in the first column of the second sheet.

Formula:

=VLOOKUP(search_criterion, array, index, sort_order)

Let’s walk through an example, which should make this a bit easier to understand.

In the first sheet, I have a list of blog posts, including their titles, URLs and monthly traffic. In the second sheet, I have a report from Google Analytics with average page load time by URL. I want to see if there’s any correlation between page speed and performance.

An example:

=VLOOKUP(A2,’GA Avg. Load Time’’!$1:$1000,2,FALSE)

IFERROR Google Sheets Formula

Any time you’re using a formula where more than 10% of the return values lead to errors, your spreadsheet starts to look really messy (see the above screenshot!).

To give you an idea, maybe you have two columns: one for page views and another for CTA clicks. You want to see the highest-converting pages, so you create a third column for page views divided by CTA clicks (or =B2/C2).

About one-third of your pages, however, don’t have any CTAs -- so they haven’t gotten any clicks. This will show up as #VALUE! on your sheet, since you can’t divide by zero.

Using the IFERROR formula lets you replace the VALUE! Status with another value. I typically use a space (“ “) so the sheet is as clean as possible.

Here’s the formula:

=IFERROR(original_formula, value_if_error)

So for the above situation, my formula would be:

=IFERROR((B2/C2, “ “)

COUNTIF Google Sheets Formula

The COUNTIF formula tells you how many how many cells in a given range meet the criteria you’ve specified. With this up your sleeve, you’ll never have to manually count cells again.

Formula:

=COUNTIF(range, criterion)

Let’s say I’m curious how many blog posts received more than 1,000 views for this time period -- I’d enter:

=COUNTIF(C2:C500,“>1000”)

Or maybe I want to see how many blog posts were written by Caroline Forsey. If the author was in Column D, my formula would be:

=COUNTIF(D2:D500, “Caroline Forsey”)

LEN Google Sheets Function

Have you noticed Google Analytics cuts off the “http://” or “https://” from every URL? This posed a major issue for me when I wanted to combine data from HubSpot and GA -- the V-Lookup function wouldn’t work because the URLs weren’t identical (“https://blog.hubspot.com/marketing versus “blog.hubspot.com/marketing).

Luckily, there’s no need to manually change every URL. The LEN function lets you adapt the length of any string.

=LEFT(text,LEN(text)-n)

=RIGHT(text,LEN(text)-n)

So, let’s say the full URL is in column I. To remove the “https://” string and make it identical to the URL in the Google Analytics tab, I’d use:

=RIGHT(I2, LEN(I2)-8)

If you wanted to remove the last characters in a cell, you’d simply change RIGHT to LEFT.

Array Formula for Google Sheets

Rarely do you need to apply a formula to a single cell -- you’re usually using it across a row or column. If you copy and paste a formula into a new cell, Google Sheets will automatically change it o reference the right cells; for example, if I enter =A2+B2 in cell C2, then drag the formula down to C3, the formula will become =A3+B3.

But there are a few drawbacks to this. First, if you’re working with a lot of data, having hundreds or thousands of formulas can make Google Sheets a lot slower. Second, if you change the formula -- maybe now you want to see =A2*B2 instead -- you have to make that change across every formula. Again, that’s time-consuming and requires a lot of processing power. And finally, the formula doesn’t automatically apply to new rows or columns.

An array formula solves these issues. It’s one formula, with one calculation, but the results are sorted into multiple rows or columns. Not only is this more efficient, but any changes will automatically apply to all your data.

ARRAYFORMULA(array_formula)

Let’s suppose I want to see how much non-paid traffic we’d gotten in March and April. That requires subtracting paid traffic from total (column D from column C) and then adding the totals together. Two separate formulas.

Or, I could use an array formula:

=ARRAYFORMULA(SUM(C2:C5-D2:D5)

The second part, SUM(C2:C5-D2:D5), should look somewhat familiar. It’s a traditional addition formula -- but it’s applied to a range (cells C2 through C5 and D2 through D5) instead of individual cells.

The first part, =ARRAYFORMULA, tells Google Sheets we’re applying this formula to a range.

I could also use an array formula to look at the non-paid traffic specifically from updates (not new content) in March and April.

Here’s what that would look like:

=ARRAYFORMULA(SUM(C2,C4-D2,D4))

IMPORTRANGE Google Sheets Formula

I use to spend a ton of time (and processing power) manually copying huge amounts of data from one spreadsheet to another. Then I learned about this handy formula, which imports data from a separate Google Sheets spreadsheet.

Suppose our resident historical optimization expert Braden Becker sent me a spreadsheet of the content he updated last month. I want to add that data to a master spreadsheet of all the content (both new and historically optimized) we published. I’d use this formula:

IMPORTRANGE(spreadsheet_url, range_string)

Which would look like:

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "Update Performance!A2:D100")

How to Split Text in Google Sheets

Splitting text can be incredibly useful when you’re dealing with different versions of the same URLs.

To give you an idea, let’s suppose I’ve created a spreadsheet with every URL that received at least 300 views in January and February. I want to compare the two months to see which blog posts got more views over time, fewer, or around the same.

The problem is, if I do a V-LOOKUP between the two tabs, Google Sheets won’t recognize these as the same URLs:

https://blog.hubspot.com/sales/songs-for-maximum-motivation (regular URL)

https://blog.hubspot.com/sales/songs-for-maximum-motivation?utm_medium=paid_EN&utm_content=songs-for-maximum-motivation&utm_source=getpocket.com&utm_campaign=PocketPromotion (tracking URL)

https://blog.hubspot.com/marketing/create-infographics-with-free-powerpoint-templates (regular URL)

https://blog.hubspot.com/marketing/create-infographics-with-free-powerpoint-templates?utm_medium=paid_EN&utm_content=create-infographics-with-free-powerpoint-templates&utm_source=getpocket.com&utm_campaign=PocketPromotion (tracking URL)

It would be awesome if I could get delete everything after the question mark in the tracking URLs so they matched the original ones.

That’s where the split text formula comes in.

=SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Text: The text you want to divide (can be a string of characters, such as https://blog.hubspot.com/marketing/create-infographics-with-free-powerpoint-templates?utm_medium=paid_EN&utm_content=create-infographics-with-free-powerpoint-templates&utm_source=getpocket.com&utm_campaign=PocketPromotion, or a cell, like A2)

Delimiter: The characters you want to split the text around.

Split_by_each: Google Sheets considers each character in the delimiter to be separate. That means if you split your text by “utm”, it will split everything around the characters “u”,”t”, and “m”. Include FALSE in your formula to turn this setting off.

In the example above, here’s the formula I’d use to split the first part of the URL from the UTM code:

=SPLIT(A2,“?”)

The first part is now in Column B, and the UTM code is in Column C. I can simply delete everything in Column C, and run the V-LOOKUP on the URLs in Column B.

Alternatively, you can use Google Sheet’s “Split text to columns” feature. Highlight the range of data you want to split, then select “Data” > “Split text to columns.”

Now choose the character you want to delimit by: a colon, semicolon, period, space, or custom character. You can also opt for Google Sheets to figure out which character you want to split by (which it’s smart enough to do if your data is entered uniformly, e.g. every cell follows the same format) by choosing the first option, “detect automatically.”

I hope these Google Sheets formulas are helpful. If you have any other favorites, let me know on Twitter: @ajavuu.

How to Run a Marketing Campaign with GSuite

from Marketing https://blog.hubspot.com/marketing/google-sheets-formulas

How to Buy Bitcoin Stock

Bitcoin and similar cryptocurrencies behave like the stock market. The more people who buy shares of Bitcoin, the higher the currency's price. The fewer people who buy Bitcoin, the lower its price.

However, the source of Bitcoin's value -- and how you buy into it -- is very different than an investment in the shares of a public company.

Click here to download our free guide to digital marketing fundamentals.

What Is Bitcoin?

Bitcoin (often denoted "₿") is a digital currency that allows you to conduct business and exchange resources securely, but without going through a bank or central payment entity to perform the transaction. Bitcoin can be sold, traded for a product, or bought into like a stock (which this article will teach you how to do).

Think of Bitcoin like a bartering token, only there's a limited supply of these digital tokens worldwide. Banks and national economies don't generate Bitcoin -- software mines it using a technology called blockchain. Learn more about this concept in the video below.

With Bitcoin being a limited resource, you'd think its value would always be off the charts, but this cryptocurrency is extremely volatile. People can adopt Bitcoin as a means of exchange for many reasons, and as Bitcoin's usage evolves, so will the reasons people choose to buy into it. Just this week, Bitcoin's price increased by more than $1000, reaching $7,450 per ₿1 at the time of writing this article (yikes).

How to Buy Bitcoin Stock

Whether you're looking to invest in Bitcoin for a big sell later, or spend it on various items and assets, there's a universal process you'll have to go through to buy stock in it. Let's dive into that process.

1. Download a Wallet

By "wallet," we don't mean the leather one in your pocket, or even credit card reader apps like Google Wallet. A Bitcoin wallet is an online storage place for all your digital currency. It doesn't just hold your Bitcoin, though. Bitcoin wallets also store your personal "key" -- a unique identifier assigned to every Bitcoin owner, consisting of a long string of letters and numbers that keeps your Bitcoin secure. This is essentially your Bitcoin password.

Your first step in buying Bitcoin is to download a Bitcoin wallet and connect your credit or debit card to it. There are more than a dozen Bitcoin wallets you can download, both to your desktop and as an app on your mobile device. Here are the wallets that work with the most devices and operating systems:

Coinbase, the first wallet app on the above list, also offers a "Bitcoin exchange" where you'll register to buy your first share of Bitcoin. We'll talk more about exchanges in the second step below.

2. Register With a Bitcoin Exchange

If there are national stock exchanges like NASDAQ, does that mean there's also a Bitcoin exchange? Yep. Bitcoin trades on a variety of online exchanges around the world, and to start buying and selling Bitcoin, you'll have to register with one of them. Have your email address and credit or debit card information ready.

Don't worry, all of your exchange options recognize the same Bitcoin trading price. Each exchange just caters to a different country or continent, and therefore offers an exchange rate that corresponds with the currency you'll use to buy Bitcoin. For example, while Korean exchanges sell Bitcoin for won (Korea's main currency), U.K.-based exchanges sell Bitcoin for pounds.

Here are some international Bitcoin exchanges you can register with (these exchanges trade Bitcoin for most currencies across the globe):

Although there are Bitcoin exchanges that specialize in just one country, you might find it easiest to register with an exchange that also supplies you with a Bitcoin wallet so you're not submitting your bank information to two separate services. Coinbase is one of those options. After downloading the Coinbase wallet, you can move right over to its exchange to buy your Bitcoin stock and fill your wallet.

Now, let's talk about how to make your first crypto-purchase.

3. Select a Buy-In Amount

Once you've selected the exchange where you want to buy your Bitcoin, navigate to the exchange's "Buy" section and select your buy-in amount. You'll tether your Bitcoin wallet to this purchase a "bit" differently (pun intended) depending on the exchange you use to buy your Bitcoin.

Nervous? Don't be -- you can buy less than 1 if you want to. Bitcoin exchanges sell cryptocurrencies down to several decimal places, so if Bitcoin is trading at $7,450 per 1, you can invest $1 and receive .00013 Bitcoin. Then, as Bitcoin's trading price increases, so does the value of the Bitcoin you bought.

4. Browse a Crypto Marketplace

With your Bitcoin in hand (or rather, in wallet), you can do one of two things with your purchase:

Spend Bitcoin in a Marketplace

Bitcoin has its very own ecommerce marketplaces where you can trade Bitcoin for products. Products include those that are shippable to your door -- such as jewelry -- and those you can download to your computer, such as Microsoft Office. Remember, no banks are involved in these transactions. The market simply verifies your Bitcoin's individual blockchain and completes the purchase.

Common Bitcoin marketplaces where you can spend Bitcoin include Bitify, Glyde, and even a Reddit community called BitMarket. Keep in mind you can also sell your own products for Bitcoin, making these marketplaces an easy way to build up your Bitcoin investment.

Buy and Wait

Of course, like any good investor, the key to making money on Bitcoin is to buy in and leave it alone. Cryptocurrencies' trading prices can fluctuate hundreds of dollars in a single morning, and watching Bitcoin's value peak and dip every day can drive you nuts.

Bitcoin investors often say that the money you put into Bitcoin should be money you're willing to lose. With that in mind, the best way to enjoy your investment is to let it sit, try selling personal items that could grow your Bitcoin account, and check the Bitcoin price once in a (long) while.

Free Download Beginner’s Guide to Digital Marketing



from Marketing https://blog.hubspot.com/marketing/how-to-buy-bitcoin-stock

How to Unblock Someone on Facebook and Messenger [FAQ]

When you block someone on Facebook, they won't be able to see anything you post on your profile, tag you in any form of content, invite you to any events or groups, message you, or add you as a friend.

But what happens if you accidentally block someone, or decide you want to unblock someone?

This quick guide will walk you through the process of unblocking someone on Facebook or within the Facebook Messenger app.

Make sense of the Facebook Business Page Timeline using this free guide.

It's important to note that when you block someone on Facebook, you will also automatically unfriend them. Unblocking them will not automatically add them as a friend again -- you will need to send them a separate friend request after you unblock them if you wish to be their friend again.

Got it? Let's jump in.

How to Unblock Someone on Facebook

1. On Facebook, click the down-arrow icon in the top right and then select “Settings”.

 

2. On the left side of your Settings page, click “Blocking”.

 

3. Find the “Block users” section, and click the blue “Unblock” link beside the name of the person you want to unblock.

 

4. Click “Confirm” to officially unblock that person.

How to Unblock Someone on Facebook Messenger

  1. In the Messenger app, click on your photo icon at the top left corner.

 

2. Scroll down and click “Account Settings”.

 

3. Click “Blocking”.

 

4. If you type a name in the text box, you can click the “Block” button to block them. Below the text box, there’s a list of previously blocked people. To unblock someone, click the “Unblock” button beside their name.

5. Click the blue “Unblock” button to unblock that person.

 

HubSpot Academy Social Media Certification Course



from Marketing https://blog.hubspot.com/marketing/unblock-someone-facebook

Lowes Introduces Artificial Intelligence in its Stores

Imagine what would be on a carpenters mind when a carpenter is trying to make something and isn’t able to find his tools in his toolbox or just a small nail in the box, while his customers are waiting and thinking how their outdoor deck look after a renovation. What could be more comforting then knowing that technology can help sort out such troubles and make the work of the people a lot more simpler than before.

Technology has helped almost everyone to make lives simpler and tasks much more easier. This is why, Lowes is asking artificial technology for a huge favour which can be a really big helping hand for the customers and its employees. Home renovations would probably be the last thing that would come to a person’s mind when talking about an IT development, but Lowes has managed to merge the two.

They have managed to get the best of the both worlds by adding software and hardware for an home improvement brand. All thanks to the managed IT solutions, that they have come up with something so unique and helpful for their customers and employees. Lowes has been involved in a lot of projects before as well, but now they are all set to launch the in-store robot for assistance, that is known as the LoweBot. Apart from that many other technology based services are in the pipeline and are being introduced to help the employees of the organisation.

What are the IT services in Lowes?

LoweBot is an autonomous in store robot, that is used to answer customer queries and help to navigate the customers through the store. It also helped to keep a track of the inventories and kept a real time sales report, which could be later used to help manage or make sales projects and reports.

Now Lowes is trying to make use of technology in the store as much as possible. Like they are trying to make technology that can help them to spot holes in inventories and empty out the space in the shelves. The company has also released A text-based customer service, which can make out the customer concern based on the text. Lowes believes in making things simpler for the employees so that they can devote more of their time on the customer’s needs and what they want.

The team is working on many other such projects with managed IT solutions, that are being in designed in the Lowes Innovations Labs. The team is working on a virtual reality visualisation and an app based VR store, which is going to be first of its kind. The customers will be able to see how the products and new projects that they are planning would look in their homes, even before actually installing it or getting the work done. This would give them a fair idea if they should go for a particular service or not.

The best example of such experiments would be the company’s Holoroom test drive which is a full fledged VR experience. It allows the customers to text the high power products in a real life, virtual way. They believe that their store are living labs, where they can easily text their prototypes and get an appropriate feedback from the outside world.

Apart from this, it becomes so difficult to check the topmost shelf product and its details, but not anymore. Lowes has come up with small cameras that are deployed on these shelves. People can now easily check the product, it’s details like pricing or any other instructions.

What is new way for customer service?

The Lowes team is now working on finding the best way possible to provide instant answers to customer queries and problems. The team is designing a chat based platform for their customer service department. Lowes says, that they understand that the majority of their customers use texting as a form of communication, so their team thought of making it a part of their routine as well, to make it easier for the customers to explain their concerns.

Now the customers can text Lowes and get whatever help that they may need from Lowes and its team. This is another example of how Lowes believes in technology to help reduce the burden. As per Forbes insight retail, only 3% of companies have fully established artificial intelligence while the 26% reports that it has become an integral part of business and the rest 64% considers themselves being slow in making technology happen.



from Ageloire Agency http://www.ageloire.com/lowes-introduces-artificial-intelligence-in-its-stores/

Thursday, 19 July 2018

How to Pick the Perfect Color Combination for Your Data Visualization

Choosing any color scheme -- whether for graphics, websites, brands, etc. -- is a challenge in and of itself. That choice of colors sets the mood for anything and everything you create.

When it comes to data visualization, color is especially important. The color scheme sets the tone of the imagery and each color serves to represent a unique piece of information.

The colors you use in your data visualizations represent more than just one idea. The color scheme you choose has the power to display the type of data you're showing, its relationship, the differences between categories, and more.

This post will take you through the process of choosing the perfect color combination for your next data visualization -- from understanding your data to finding the right color tool.

How to Pick the Perfect Color Combination for Your Data Visualization

Is Your Data Sequential or Qualitative?

The first step when choosing a color scheme for your data visualization is understanding the data that you’re working with. There are three main categories that matter when choosing color schemes for data: sequential, diverging, and qualitative color schemes.

Sequential color schemes are those schemes that are used to organize quantitative data from high to low using a gradient effect. With quantitative data, you typically want to show a progression rather than a contrast. Using a gradient-based color scheme allows you to show this progression without causing any confusion.

Color_Gradiant_Data.png

Diverging color schemes allow you to highlight the middle range/extremes of quantitative data by using two contrasting hues on the extremes and a lighter tinted mixture to highlight the middle range.

Diverging_Color_Schemes.png

Qualitative color schemes are used to highlight -- you guessed it -- qualitative categories. With qualitative data, you typically want to create a lot of contrast, which means using different hues to represent each of your data points.

Qualitative_Color_Schemes.png

Note: The images above are from Color Brewer 2.0 -- a data visualization color tool designed for working with data mapping. Check it out for your next data map visualization or for grabbing pre-made color schemes to use based on the sequential, diverging, and qualitative models.

How Many Unique Hues Do You Need to Use?

Now that you’ve determined which kind of display you want to use, it’s time to determine the number of hues you need to use.

Your hues are the unique colors (like red or blue) in their purest form (without any tinting or shading). Using unique hues is what creates contrast. In data visualization, creating contrast is highly important because it tells the viewer that the contrasting colors are comparative data points. Contrasting colors suggest that the data points are categorical, not correlated, showing you the difference between them rather than the relationship of progression.

Keep in mind that it's possible to use both a sequential and qualitative color scheme in the same visualization. And if this is the case, you’ll need to build a scheme that uses both gradients and unique hues.

The Role of Brightness in Color Selection

One very important tip for creating and finding color schemes for you data visualizations concerns understanding and utilizing the brilliance of colors for a purpose.

In the two pie charts below, notice the brightness of the colors used. On the left pie chart, you can see that there are four main hues used and four tints of each hue. This might signify a relationship between the hue and the tints, or it may just be used to draw attention to some sections of the data over the others.

Pie Charts Brightness

On the right pie chart, all of the eight hues used have the same brightness. None have more white or black added them to create a shade or a tint, which ultimately creates a balanced, contrasting aesthetic.

Shading and brightness is incredibly important to consider when creating data visualizations because it can be easy to skew the interpretation of your data by drawing attention to some data points over others.

For qualitative data, unless you’re trying to point out one specific data point’s significance, try to use equally bright hues with contrasting colors to display your data.

For sequential quantitative data, shading is important because you’re likely using a gradient. Gradients are made up of different shades and tints of a hue to show the progression of one hue from light to dark -- much like the progression of the data from high to low.

What Tools Can You Use to Find the Perfect Color Combination?

When it comes to finding the perfect color scheme for your data visualizations, I highly recommend finding a scheme that’s already out there. This isn't to say that you don't need to have a strong grasp on basics of color selection, though -- even existing color schemes will need to be customized to the data you're using. In other words, it's still important that you know your stuff.

Let's check out a few tools that'll help you get started ...

1) Colorpicker for Data

A fairly simple tool, Colorpicker let’s you hold one color in place while you drag the other locator around to find a multi-hued, gradient-based color scheme. Although this tool is limited in nature, I like that it gives you the option to visualize your color scheme on a map to show you what the scheme looks like in practice.

Color_Picker_Tool.png

2) Color Hunt

If you’re just looking for premade color schemes to browse through, Color Hunt is the tool for you. This website is devoted to just color schemes, allowing you to easily gain inspiration and uncover HEX codes.

A caveat, however, is that each of the schemes are limited to four colors. If you’re data visualization requires more hues than four, this may not be the tool for you.

Color_Hunt_Tool.png

3) Designspiration.net

One of my personal favorite sites for design work, be it data visualization or otherwise, is Designspiration.net. Not only does Designspiration give you thousands of graphics to look through for inspiration, but it also allows you to sort through designs by color.

This is a great tool to use for your data visualization (even if the representations aren’t data-based) because it shows you what colors look like in contrast to one another. The color-sort tool also gives you the HEX codes ready to access, making it really easy to put together a combination that suits your needs.

Design_Inspiration_Tool.png

4) FlatUIColorpicker.com

As a part of Designmodo’s Free User Interface toolkit, they created a tool to help you uncover colors to use in your design process. Although these colors aren’t necessarily part of premade schemes, they are really great for showing you bright, vibrant colors used for user interface design. You can easily browse through their color lists and create your own color schemes using the color picker.

Adobe_Color_CC.png

5) Adobe Color CC

A classic tool for designers using Adobe products, Adobe Color CC allows you to create your own color schemes using the mathematical model-based color schemes (monochromatic, analogous, triadic, complementary, etc.). Adobe Color CC also has a great browser section you can use to find premade color schemes.

What If You Still Can't Find What You Need?

What if you decide you’re really looking for a color scheme that isn’t already out there? What do you do?

Creating a color scheme for data visualizations from scratch can be especially difficult because the colors you use have to either show vast contrast or natural progressions.

A great way to find inspiration for these types of color schemes is to draw on your surroundings. This could be a colorful photo, a mural, a sunset, or anything in nature --- you name it. If you look around to find color schemes that appeal to you in your physical surroundings, you can use this to create a color scheme for the virtual.

If you have a good eye, you may even be able to create a color scheme this way by trial and error. However, it's more likely that you’ll need to use a tool like Adobe Capture CC or Chroma by Softpress to snap a picture and grab the colors from the picture to use in your designs.

Chroma_by_Softpress.png

When creating data visualizations, the most important part of choosing the right color scheme comes down to understanding your data.

With so many different tools and premade color schemes out there, the hardest part isn’t actually finding the right colors; it’s knowing how to use those colors to display the information in the best way possible.

Now that you know how to find your color schemes, go put your newfound knowledge to work.

free guide to data visualization

from Marketing https://blog.hubspot.com/marketing/color-combination-data-visualization