Welcome to My Blog

9to5Toys Lunch Break: $50 iTunes Gift Card $40, Retina MacBook Pro 256GB $1,200, Solar Bluetooth Speaker $40, more

Keep up with the best gear and deals on the web by signing up for the 9to5Toys Newsletter. Also, be sure to check us out on: Twitter, RSS Feed, Facebook, Google+ and Safari push notifications.

TODAY’S CAN’T MISS DEALS:

itunes-gift-card-21

Get a $50 iTunes Gift Card for $40 delivered via email from PayPal (20% savings)

macbook-pro-retina-mf840lla

Apple 13-inch Retina MacBook Pro (newest version) 2.7GHz/8GB/256GB $1,200 shipped (Reg. $1,499)

eton-solar-speaker

Amazon Gold Box – Eton Rugged solar-powered Bluetooth charging speaker: $40 Prime shipped (Orig. $77)

camera-plus-ios

App Store Free App of the Week: Camera Plus w/ AirSnap goes free for the first time in months (Reg. $2)

Grand Theft Auto iOS Sale: Liberty City Stories $3, China Town Wars $3, San Andreas $4, more

Star Wars Mac Games 50% off Sale: Jedi Academy $5, KOTOR $10, The Force Unleashed $10, more

MORE NEW GEAR FROM TODAY:

lifeproof-fre-iphone-case

LifeProof iPhone 6/s FRĒ waterproof case (multiple colors): $40 Prime shipped (Orig. $80)

MORE DEALS STILL ALIVE:

ravpower-iphone-6s-battery-case

Charge your iPhone 6/s on-the-go w/ this RAVPower 3000mAh 2A MFi Battery Case for $24 Prime shipped (Reg. $36)

Anker 3-ft reinforced Lightning cable (multiple colors): $8 Prime shipped (Reg. $10)

NEW PRODUCTS & MORE:

nerf-terracotta-blaster-drone

NERF’s upcoming Terrascout RC Drone Blaster is going to be a menace in your home

Filed under: Tips and Tricks Tagged: 9to5Toys, Amazon, app deals, Apple TV, Best Buy, Daily Deals, free apps, Gold Box, iTunes Gift Card, MacBook Pro, video games

Concept imagines a simplistic iTunes/Apple Music redesign for Mac [Gallery]

If you haven’t heard, iTunes and Apple Music are about to get a refresh from Apple that will hopefully fix a lot of our ongoing issues with the apps while also introducing some fresh visuals. This isn’t that redesign, but a concept from graphic designer Thadeu Brandão showing how Apple could revamp iTunes on the desktop while integrating Apple Music and simultaneously getting rid of much of the clutter in the current design.

more…

Filed under: Apple Music Tagged: 12.4, Apple Music, concept, iTunes, redesign, refresh, render, UI

Apple Music Feature Request: Give the iOS app Smart Playlist functionality via Siri

I addressed one big issue with Apple Music last week – and was very surprised to see from the poll results just how widespread the issue was. But while discussing that issue, we happened across a Reddit thread that I thought contained a really great idea: give the iOS app Smart Playlist functionality via Siri.

I may complain a lot about the bloated nature of iTunes, a single app that tries to do way too many different things, but I do really like it as a pure music player. One of the features I love is Smart Playlists, which you can use to do all kinds of funky things.

For example, maybe you have some music you really love but haven’t listened to for a while? Create a Smart Playlist where Rating is 5 and Last Played is not in the last year. Been listening to the same stuff too much lately? Create a playlist where Last Played is not in the past month. Feeling nostalgic? A playlist where Year is a particular year …

more…

Filed under: Apple Music, Feature Request Tagged: Apple Music, iOS Music app, iTunes, iTunes Smart Playlists, Music app, Smart Playlists

T-Mobile announces deal to let customers roam in Cuba starting this summer

T-Mobile today announced a deal with Cuban carrier Empresa De Telecomunicaciones De Cuba, S.A. (ETECSA) that will see its customers get access to voice, text and data while traveling to Cuba as well as lower rates on calls to landlines and wireless phones in the country from the US. more…

Filed under: iOS, iOS Devices Tagged: $0.60 per minute, cuba, Empresa De Telecomunicaciones De Cuba, international, Roaming, stateside talk, T-Mobile, Travel

How-To: Automatically change your Mac’s display resolution when running specific apps [Video]

I normally run my 15″ MacBook Pro at default resolution, which equates to a useable space of 1440-by-900. While this default resolution is great for reading and writing, I’ve found that it’s not always so good for editing with timeline-based apps, such as Final Cut Pro X.

Generally speaking, it’s better to have more resolution for timeline-based apps, because the timelines can be so long and expansive. A larger field of view gives content creators more flexibility and room to work with on the canvas.

Wouldn’t it be nice if your Mac automatically adjusted to a higher resolution when running a certain app, and automatically switched back to default resolution when closing said app? In this post, we’ll show you how to wield SwitcherResX, a utility geared towards managing your Mac’s screen resolution, in such a way that makes that possible. more…

Filed under:
How-To
, Mac Tagged: Display resolution, guide, how to, Mac, Mac OS X, SwitcherResX, Tips and Tricks, tutorial, video

How to Use Facebook Live: A Complete Guide

facebook-live-guide.jpeg

In their continued effort to promote video content in the News Feed, Facebook recently launched Facebook Live, a live video streaming service that lets anyone broadcast live videos from their mobile device straight to their Facebook News Feed.

Why are marketers getting so excited about Facebook Live? Because it’s an awesome way for them to use the power of live video to communicate their brand stories and build authentic, intimate relationships with fans and followers. 

However, for such a simple concept, Facebook Live has a lot of little nuances that marketers will need to learn if they want to get the most out of the platform. This guide is meant to help you learn the best tricks and tricks that can make a big, big difference in how many people see your live broadcast, how they engage with it, and how it performs.

In this post, we’ll walk through how to broadcast on Facebook Live, how to analyze your live video’s performance, and the top tips and tricks for getting the most out of the platform. (Click here to skip down to the tips.)

How to Broadcast on Facebook Live

Historically, you’ve only been able to broadcast live videos from iOS or Android mobile devices. However, Facebook recently announced that the Live Video publishing tool for Pages now lets you use your existing video software or hardware to create professional-looking live video content. We’ll cover that in a later post, but for now, let’s focus on broadcasting from your mobile device.

So to get started, get out your mobile device and open up the Facebook app.

Step 1: Go to your own Facebook profile and open up the status bar by clicking facebook-write-status-update.jpg, as if you’re going to write a new post.

Step 2: Tap the “Live” icon, which looks like a human silhouette.

update-status-facebook-live-icon.png

Step 3: Give Facebook access to your camera and microphone when prompted.

You’ll stop receiving these prompts after the first time you use it.

Step 4: Press the blue “Continue” button on the introductory page.

Don’t worry — pressing “Continue” won’t start the recording. The next few steps will be preparing your live video before you go live.

continue-go-live.png

Step 5: Choose your privacy setting.

If you’re posting for a brand, you’ll probably want to make it public. But if you’re new to Facebook Live and want to test it out first, or want to see what something will look like, then switch the privacy setting to “Only Me.” You can find the “Only Me” option by clicking “More” and scrolling all the way to the bottom.

change-privacy-settings.png public-privacy-setting.png

Step 6: Write a compelling description.

As with Periscope, you give your broadcast a description, which will show up on people’s News Feeds like a status update above the video. To get people to tune in, write an attention-grabbing headline and help them understand what your broadcast is about. Check out the example below from The White House’s live broadcast.

write-caption.png white-house-facebook-live-description.jpg

Image Credit: Facebook

Step 7: Set up your camera view.

Before you click “Go Live,” be sure your camera’s pointing in the direction you want it to. The background of your setup screen will show you what your camera sees. If you want to change the camera view to selfie or vice versa, simply click the rotating arrows icon in the upper right-hand corner of your screen.

set-up-camera-view.png

Note: The video will be a square, so it doesn’t matter whether you hold your mobile device vertically or horizontally.

Step 8: Click the blue “Go Live” button to start broadcasting.

Once you click it, Facebook will give you a countdown — “3, 2, 1 …” — and then you’ll be live. As soon as you start streaming, your live video will appear in your News Feed — and others’ News Feeds — just like any other post. (Note that Facebook does currently rank Live videos higher than other videos.)

go-live-1.png

Your broadcast can be up to 90 minutes long. Keep in mind that the longer you broadcast, the more people who are scrolling through their News Feeds on Facebook will stumble upon your post.

Step 9: Interact with viewers and commenters.

To keep your viewers engaged, encourage them to interact with your live video (which will help your ranking in others’ News Feeds). You can also interact with them both by speaking directly at them in your video and, if you want, by having someone else respond to comments from a desktop computer elsewhere.

Where can you see these comments? While you’re broadcasting, you’ll see the time elapsed on the top left along with the number of viewers, and comments will show up live on the bottom of your feed. They’ll appear in reverse chronological order, like on Twitter, so keep in mind that the earlier ones may be farther down.

Facebook_Live_Comments.png

Image Credit: Facebook Newsroom

Note: You can also block viewers during a live broadcast by tapping the profile picture next to a viewer’s comment and then tapping “Block.” You can unblock someone you’ve previously blocked, too.

Step 10: Click “Finish” to end the broadcast.

Once you do this, the video will stay on your Timeline or Page like any other video post. 

Step 11: Save the video to your camera roll.

Once you finish your broadcast, you’ll be met with a screen similar to the one I’ve screenshotted below. Be sure to toggle the option to save the video to your camera roll so you have a copy of the original for safekeeping.

congrats-finished-live-video.png

Step 12: You’re done!

Voilà! You can always go back to the post on your Timeline or Page and edit the description, change the privacy settings, or delete the video, just like you would any other post.

edit-facebook-live-post.png

How to Analyze Your Live Video’s Performance

The performance analytics available for Facebook Live videos are similar to that of normal videos on Facebook, with some cool additions.

  • For Pre-recorded videos: Facebook lets you analyze minutes viewed, unique viewers, video views, 10-second views, and average % completion.
  • For Facebook Live videos: Facebook let you analyze all the metrics listed above, plus peak live viewers, people reached, reactions, comments, and shares.

facebook-live-video-details.png

In addition to all these static numbers, you can click in to each metric to see how it changed over time when the video was live. For example, if we click in to “Peak Live Viewers,” we’ll see this interactive graph of video viewers over time:

facebook-live-analytics-1.png

You can see graphs over time like the one above for any of the metrics I mentioned.

How to Access These Analytics on a Business Page

Step 1: Go to your Page and click the “Insights” tab.

insights-tab.png

Step 2: Choose “Videos” from the menu on the left-hand side of your screen.

Step 3: Scroll down and click “Video Library” to open up all of your videos and their analytics in a new window.

In the “Video Library” window, videos recorded with Facebook Live will be indicated by that human silhouette icon, as shown below.

facebook-video-library.png

Step 4: Click the video you want to see the analytics for to open it.

Again, you can click into any of the metrics to see a graph of those numbers over time when the video was live.

Now that you’ve got the steps down, let’s get into some tips and tricks.

11 Tips & Tricks for Getting the Most Out of Facebook Live

There are a lot of little things you can do to squeeze the most out of your Facebook Live videos. Before we get into them, check out the example below of a great Facebook Live video from Refinery29. This was the first video of a five-part live video series called “Chasing Daylight,” showcasing a typical night out for women in five different cities around the world. I’ll be referring to this video in some of my tips.

Warning: Some NSFW language.

1) Test out live video using the “Only Me” privacy setting.

If you want to mess around with live broadcasting without actually sharing it with anyone else, you can change the privacy setting so you’re the only one who can see it — just like with any other Facebook post.

To switch the privacy setting to “Only Me,” follow steps 1–5 in the instructions above.

change-privacy-settings.png public-privacy-setting.png

2) Space out live videos with other Facebook posts.

Here’s a tip from HubSpot’s social media manager Chelsea Hunersen. Because Facebook ranks Live videos higher than other videos and other types of posts, Hunersen recommends spacing out your Facebook Live videos with other Facebook content you post.

“Wait at least two hours before or after you post a Facebook live video,” she says. “Otherwise, your Facebook Live video may cannibalize additional traffic.”

3) Keep reintroducing yourself.

When you first start the video, take a minute to introduce yourself and what the video’s about. But keep in mind that when you first start live streaming, you may have zero people watching. Even a few seconds in, you could only have a handful of viewers. As people find your video on their News Feeds, they’ll join in — but that means you’ll want to reintroduce yourself a second, third, and even a fourth time to catch people up.

For example, in the Refinery29 video above, the host Lucie Fink introduces herself three times in the first few minutes, and several more times after that.

One second in:

Hello, Facebook Live! Hey! Lucie Fink here. I don’t know if we have anyone on the broadcast yet, so I’m going to wait about one minute to see who joins us.”

One minute in:

Hello to the 309 viewers in here right now. I’m Lucie Fink from Refinery29. Just to recap what’s happening right now, this is Episode One of Refinery29’s new global initiative, ‘Chasing Daylight.'”

A few minutes in:

Just to give a quick recap on who I am, in case you guys don’t know — I’m Lucie Fink. I work at Refinery 29. Today, I’m doing this whole new series, and this is essentially giving you guys a glimpse into the lives of women all over the world.”

15 minutes in:

So now that we have 3.5 thousand people in this broadcast, let me just start from the top because some of you might not know what is happening. I’m Lucie Fink from Refinery29, and you might know me from some videos, you might not. Either way, it is nice to meet you. Today, we are starting a new video series on Refinery’s Facebook Live platform. It’s called ‘Chasing Daylight,’ and it’s gonna be on every night this week.”

25 minutes in:

That’s what I think is so cool about ‘Chasing Daylight.’ For the people who are new and don’t really get why I’m sitting on my toilet, the answer is, I am Lucie Fink, and I am Episode One, the New York version of ‘Chasing Daylight,’ which is Refinery29’s new live Facebook series that’s starting right now.”

4) Make the video visually engaging.

Although all videos on Facebook autoplay in people’s News Feeds, they’re on mute until the viewer manually turns the volume on. That means you have to be visually engaging — not just at the very beginning of your broadcast (although that’ll be important for when folks view the video later), but throughout the video as more and more people join in.

The more visually engaging you can be, the more you can entice people to stick around. That means keeping the camera moving and not just sitting in one place — something Lucie did really well in that Refinery29 video.

Not only will you get more viewers this way, but you’ll also get your broadcast ranked higher in other people’s News Feeds. Why? Because Facebook started monitoring signals of video engagement — like turning on the audio, switching to full-screen mode, or enabling high definition — interpreting that as users enjoying the video. As a result, they’ve tweaked the algorithm so videos that are engaged with in these ways will appear higher up on the feed.

5) Make it spontaneous.

What makes a live video special? The spontaneous, interactive nature of it.

“People love the ability to interact,” says Hunersen. “They love the novelty of viewing someone in a live moment when anything could happen. It’s the new reality TV.”

A big part of what makes Refinery29’s live video so great is how much Lucie and her friends embrace the “live,” spontaneous nature of it. For example, at one point, Lucie calls on her friends to reenact a scene from the Broadway show Hamilton. It was scrappy, unrehearsed, and really funny. Her other friends were laughing at her. It reminded me of a fun night with my own friends. “This is literally what we do at the office,” Lucie said about the performance through laughs.

Later in the video, someone commented asking Lucie and her friends to tell a joke. They scrambled. “I’m not funny!” said one of Lucie’s friends. But after a few moments, you can hear Lucie say, “Oh, we have a joke! Go ahead, Deb.”

“Dating in New York.”

There was a pause, then everyone burst out laughing: “OHHHH!”

These moments are what make live video special, and they’re exactly what differentiates it from scripted, edited, or otherwise pre-recorded videos. Embrace the platform. Banter is always, always good.

6) Encourage viewers to Like and share the video.

One of the primary ways Facebook’s algorithm ranks a post is by how many people Like and share it. The more people who Like and share your live broadcast, the more it’ll show up in people’s News Feeds.

But when people are watching a video, they may be more distracted from Liking and sharing it than they would a text or photo post. (That’s something the folks at Facebook noticed about video content early on, which is why they began monitoring other video engagement signals as well, like turning on the volume.)

In Refinery29’s video, you’ll notice Lucie explicitly asks viewers to Like and share the video many times throughout. Here are a few examples:

  • “If you like this broadcast and share it right now, you guys will be part of this brand new series that’s starting right now on Refinery29.”
  • “If you guys share this broadcast, you’ll be part of history. And what’s better than being part of history?”
  • “Thumbs up if you like Hamilton!” 
  • “Thank you guys for all these Likes. My screen is absurdly blue right now because I’m getting tons of thumbs up.”
  • “Share this with your best girlfriend who you think is strong and powerful.”

I like the last example the best because she’s asking viewers to share it with a specific type of person — in this case, a best girlfriend. This might prompt viewers to think, “Hey, she’s right, my friend Stacy might like this!” and then share it with that specific friend.

7) Engage with commenters, and call them out by name.

The number of comments on your broadcast is another way to get Facebook to give it a higher relevancy score, making it more likely to show up on people’s News Feeds. So encourage your viewers to comment, and engage with people who are commenting by answering their questions and calling them out by name. Not only will it get more people to comment, but it’s also a fun way to include your viewers in the live experience, which could make them stick around longer.

“Your audience will be thrilled to hear you mention their name and answer their questions when you are live,” says Hunersen.

In the Refinery29 video, Lucie was constantly engaging with viewers and commenters. At one point, for example, she said, “We’re so excited to see you guys! Do you have any questions for someone who lives in New York City?” Then, she read a few of the comments that came in and responded to them — using commenters’ first names.

At another point in the video, she started talking about which outfits she might wear to go out. Her friend, who was holding the phone at the time, said to viewers, “You guys, comment if you like what Lucie’s picking out.” As Lucie began taking shirts and skirts out of her closet to show, her friend read off comments and she responded. At the end of the exercise, she chose her outfit based on commenters’ feedback.

8) Have someone else watching and responding to comments on from a desktop computer.

When you’re the one holding the camera for a Facebook Live video, it’s really hard to see the comments popping up on the mobile screen. If the comments are coming in fast, it’s especially easy to lose sight of them as they disappear below the fold. Plus, you’re probably occupied by recording and entertaining viewers.

Because of this, it’s always a good idea to have an additional person logged in to the primary account to monitor the comments on a desktop computer. That way, they can take care of responding so the person recording the video can concentrate on creating a great experience.

9) Ask viewers to subscribe to live notifications.

In addition to asking for Likes, shares, and comments, ask viewers to subscribe to live notifications. To do that, all viewers have to do is click the small, downward-facing arrow in the top right-hand corner of the live video post, and choose “Turn On Notifications.”

You can also ask them to Like your brand on Facebook, which will make it more likely that they’ll be notified of your next live broadcast. Lucie does this in the Refinery29 video. 

10) Broadcast for at least 10 minutes.

As soon as you begin recording your live video, you’ll start slowly but surely showing up in people’s News Feeds. The longer you broadcast — especially as Likes, comments, and shares start coming in — the more likely people are to discover your video and share it with their friends.

Because timing is such an important factor for engagement in these live videos, we recommend that you go live for at least 10 minutes, although you can stay live for up to 90 minutes for a given video.

11) Say goodbye before you wrap up.

Before you end your live broadcast, be sure to finish with a closing line, like “Thanks for watching!” or “I’ll be going live again soon.”

Lucie from Refinery29 checked a few other engagement requests off the list at the end of her broadcast:

So, we are about to sign off. It’s been such an amazing first episode of ‘Chasing Daylight.’ . . . Don’t forget to share this to your friends right now so you can always find this series and go back to it. . . . We’re so happy that you tuned in to our episode in New York. . . . Goodnight from New York City!”

12) Add a link to the description later.

Once you’ve finished the live broadcast, you can always go back and edit the description, change the privacy settings, or delete the video, just like you would any other post.

Here’s where you can add a trackable link to the description in the post, which can direct future viewers to your live video series page, the site of whatever campaign you’re using the video to promote, or somewhere else. (Learn how to create a trackable link here.)

To edit the description of a video: Find the video on your Timeline or Page and click the downward-facing arrow in the top right-hand corner of the post. Choose “Edit Post” from the dropdown menu, and edit the description accordingly.

add-link-to-post.png

There you have it!

We hope this has been a helpful guide. We’re curious to see how Facebook develops their live video platform to help brands connect more deeply with fans and followers, and individuals connect more deeply with friends, family, and community.

What other tips do you have for using Facebook Live? Share with us in the comments. 

free guide: how to maximize your facebook reach

Claimed design sketch of iPhone 7 shows identical height & width to iPhone 6s

A claimed design sketch of the iPhone 7 shows identical dimensions to the iPhone 6s. The drawing (shown in full below) shows only the height and width, not the depth, so doesn’t shed any more light on the ‘headphone jack or no headphone jack’ question.

The sketch was posted by French site NWE with an @onleaks watermark, so has decent credentials, though of course neither can be sure that it’s genuine. It’s a very basic sketch that would be very easy to create.

The sketch does show one other small detail …

more…

Filed under: iOS Devices

7 Useful Reporting Hacks to Try in Google Sheets

google-sheets-hacks.jpg

While it might not be as powerful as the industry standard, Microsoft Excel, Google’s online spreadsheet tool, Google Sheets, provides several other advantages. From offering more collaboration capabilities, to having a more attractive price point (re: free), it’s no wonder that more and more marketers are turning to Google Sheets for their reporting.

Whether you’re just getting started with Google Sheets, or you’ve already played around with it a bit, there are several “hacks” you can use to make the reporting process easier. Let’s walk through them.

(Want to uncover some useful Google Doc tricks while you’re at it? Check out this post for 15 Google Doc features you probably didn’t know existed.)

7 Google Sheets Hacks to Make Reporting Much Easier

1) Use keyboard shortcuts.

Want to undo that change you just made in your report? There’s a shortcut for that (Command + Z on a Mac / Control + Z on a PC). Want to quickly find a particular word or figure in your report? There’s a shortcut for that, too (Command + F on a Mac / Control + F on a PC). And the list goes on, and on, and on.

The most important shortcut to remember for Google Sheets, however, is Command + / on a Mac, or Control + / on a PC. That’s the shortcut for pulling up the master list of Google Sheets keyboard shortcuts. In the screenshot below, you can see some of the most popular shortcuts on the list.

google-sheets-shortcuts.png

2) Create a heat map with conditional formatting.

Setting up a heat map in Google Sheets is a great way to make trends and important data points easily identifiable. At its most basic, a heat map can show the highest values in your report in one color, and show the lowest values in a different color. All the values in between, meanwhile, will appear as a mix of both colors.

Confused? Don’t worry, it will all make sense after we walk though the steps. Step 1: Select your data, navigate to the “Format” menu in the top nav, and choose “Conditional formatting.”

conditional-formatting-sheets.png

Next, you’ll want to select the “Color scale” tab from the menu that pops up. Once you do that, Google Sheets will automatically apply some default colors, and you’ll be able to see your heat map.

color-scale-sheets.png

At this point, you could simply hit that blue “Done” button and call it a day. Alternatively, you could spend some time fine-tuning your settings. For example, by clicking those paint bucket icons, you can customize your heat map colors (see example below).

color-scale-custom.png

3) Easily add an image to a cell.

If you need to add a logo, screenshot, or other image to a report in Google Sheets, the standard protocol is to navigate to “Insert” on the top nav, choose “Image,” and then upload an image from your computer. However, there is a much quicker solution available. Here’s how you do it:

First, select the cell you want to insert the image into and type “=image.”

insert-image-cell-sheets.png

Next, add an open parentheses, followed by an open quotation mark, and paste in the URL of the image you want to insert. You’ll then need to close the quotation marks and close the parentheses.

image-url-in-sheets.png

Hit enter, and voilà: your image will appear.

add-image-sheets.png

4) Add international currencies.

If your company does business internationally, being able to work with international currencies in your reports is essential. Fortunately, Google Sheets has got you covered.

To access Google Sheets’ massive A-to-Z list of currencies — from the Afghan Afghani to the Zimbabwean Dollar — you first need to click that “123” icon in the top nav.

123-icon-google-sheets-1.png

From there, head down to “More formats” and select “More currencies.”

more-currencies-sheets.png

You can now choose a currency from the list and click the blue “Apply” button to set it.

currency-menu-google-sheets.png

5) Set up email notifications.

Want to know when a coworker makes changes to your report? Or are you looking for a way to get daily progress updates from a report a coworker is working on? If you answered ‘yes’ to either of those questions, then this is the hack for you.

To set up email notifications in Google Sheets, first head to “Tools” in the top nav and select “Notification rules.”

notification-rules-google-sheets.png

Next, select what notification rules you want to put in place and click the blue “Save” button. 

set-notification-rules.png

(Note: Notifications can be triggered based on changes made to your spreadsheet as well as form submissions. To add a form to your spreadsheet, simply navigate up to “Tools,” then select “Create a form.”)

6) Validate Emails & URLs

Sorting through and making sense of hundreds (if not thousands) of email addresses and website URLs is no easy feat. And in some cases, this task can get even more complicated when, late in the game, you discover that some of those emails and URLs are invalid.

Once again, Google Sheets has got your back. Using the ISURL and ISEMAIL functions, you can quickly check whether email addresses and URLs are valid or not. For example, if you wanted to check if “hubspot.com” was a valid URL, you could select an empty cell, type in “=ISURL” and then put “hubspot.com” between parentheses like you see in the screenshot below. Even before you hit enter, Google Sheets will return a “TRUE” (valid) or “FALSE” (invalid) message.

is-url-true-google-sheets.png

You can follow the same instructions for the ISEMAIL function, just use an email address instead of a URL. Here’s a screenshot of what that looks like:

is-email-true-google-sheets.png

For a full list of Google Sheets functions, check out this Google support webpage.

7) Unlock a ton of additional features with add-ons.

Did you know that you can sync Google Sheets with your Google Analytics account? Or that you can use Google Sheets to plot data onto a Google Map? These features — and many, many more — don’t come standard with Google Sheets. However, you can easily add them by heading up to “Add-ons” in the top nav and selecting “Get add-ons.”

add-ons-google-sheets.png

From there, you’ll be able to choose from tons of free features. You can use the dropdown at the top left to narrow down the category of add-on your looking for, or you can search for it directly using the search field at the top left. For example, if you wanted to find that maps add-on I mentioned (which is called “Mapping Sheets,” FYI) you could do a search for “maps.”

google-add-ons-menu.png

Know any other tips or tricks for making reporting easier in Google Sheets? Share them below.

free marketing reporting templates

How to Use Facebook Messenger for Business

kh-facebook-messenger-560

Do your customers use Facebook Messenger? Wondering how you can help people find you on Messenger? Recent updates make it easier for businesses to communicate with customers via Messenger’s private, one-to-one messages. In this article you’ll discover how to connect and engage with customers using Facebook Messenger. Note that all app screenshots used in this […]

This post How to Use Facebook Messenger for Business first appeared on .
– Your Guide to the Social Media Jungle

from http://ift.tt/1Tz3txP
via socialmediaexaminer

6 Conversion Experts Answer 20 of Your Most Important CRO Questions [Live Google Hangout]

Blog_header_image_-_resized_1.jpg

Whether you’re new to marketing or decades into your career, conversion rate optimization is an ever-changing topic and necessary asset in your marketing playbook.

Looking to learn more about your audience? Want to manipulate your existing resources to improve their performance? How about growing your business by improving lead flow? Wouldn’t that be nice?

An effective CRO strategy can help you achieve all that — without forcing you to crank out a bunch of new content. 

In this live Google Hangout, these six experts will teach you the most up-to-date CRO strategies and how to use different methods to get results. With your help building the agenda, we’re going to play “20 Questions” with today’s top CRO experts and learn how to start, where to start, and when to stop testing and optimizing your marketing efforts for lead conversion. 

  • When: Wednesday 6/1 @ 2 p.m. ET // 5 p.m. GMT // 9 a.m. PT for one hour
  • Where: Live Google Hangout
  • Hashtag: #CROhangout

Want to learn more about conversion rate optimization? Click here to save your seat for this live event.

Meet the Conversion Experts

Rand Fishkin, Wizard of Moz

Rand Fishkin

Rand Fishkin uses the ludicrous title, Wizard of Moz. He’s founder and former CEO of Moz, board member at presentation software startup Haiku Deck, co-author of a pair of books on SEO, and co-founder of Inbound.org. Rand’s an unsaveable addict of all things content, search, and social.

Larry Kim, Founder & CTO, Wordstream

Larry Kim

Larry Kim founded WordStream in 2007. He bootstrapped the company by providing internet consulting services while funding/managing a team of engineers and marketers to develop and sell software for search engine marketing automation. Today he serves as company CTO and is a contributor to both the product team and marketing teams.  

Oli Gardner, Co-founder, Unbounce

Oli Gardner, Unbounce

Unbounce Co-Founder Oli Gardner has seen more landing pages than anyone on the planet. His disdain for marketers who send campaign traffic to their homepage is legendary. He is a prolific webinar guest and writer, and speaks internationally about Conversion-Centered Design where he is consistently ranked as the top speaker. 

Peep Laja, Founder, ConversionXL

Peep_Laja.jpg

Peep is an entrepreneur and conversion optimization expert with 10+ years of global experience. He has extensive experience across verticals: In the past he’s run a software company in Europe, an SEO agency in Panama, a real estate portal in Dubai, and worked for an international non-profit. 

Pamela Vaughan, Principle Optimization Marketing Manager, HubSpot

Pamela Vaughan

As HubSpot’s principle optimization marketer, Pam currently manages large-scale projects relating to CRO and SEO (with an expertise in blog/content optimization) on the HubSpot marketing team’s new optimization team. Her team’s goal is to optimize and grow traffic and conversions from HubSpot’s various marketing assets. 

Michael Aagard, Senior Conversion Optimizer, Unbounce

Michel Aagard

For seven years, Michael has spent about 60 hours a week testing and optimizing websites to gain a deeper understanding of what really works in Online Marketing and CRO. He’s helped a multitude of clients from all over the world make more money online. In July 2015 he quit his career and joined Unbounce as Senior Conversion Optimizer. 

Moderated by: Meghan Keaney Anderson, VP of Marketing, HubSpot

Meghan Keaney Anderson

As Vice President of Marketing at HubSpot, Meghan leads the content, product marketing, and customer marketing teams. Together with her teams, she’s responsible for the company’s blogs, podcast, and overall content strategy, as well as the company’s product launch and customer demand campaigns.

join a Google Hangout With CRO experts

How to Drive Traffic to Your Website With Pinterest

cv-pinterest-560

Looking for ways to improve your Pinterest marketing? Do you want to make your pins more clickable? To generate leads, conversions, and sales from Pinterest, your pins need to do more than move people to like and repin. In this article you’ll discover how to create pins that encourage people to click through to your […]

This post How to Drive Traffic to Your Website With Pinterest first appeared on .
– Your Guide to the Social Media Jungle

from http://ift.tt/1TyW1CX
via socialmediaexaminer

Review: Audio-Technica’s ATH-M50x closed-back studio monitor headphones live up to the hype

For the last few months I’ve been using my Apple EarPods for nearly every application that requires in-ear audio. I use my EarPods for monitoring while recording voiceovers, for podcasting, and for everyday music listening.

Absurd as it is, the last pair of headphones I’d owned, a pair of Sony MDR-7506’s, ended up developing a short in the cable. I simply never got around to replacing them in a timely manner.

Audio-Technica’s ATH-M50, and the updated ATH-M50x, have received rave reviews from tech sites, bloggers and YouTubers alike. The love that these headphones receive on a regular basis convinced me that the next pair of headphones that I tried needed to be these. Do they live up to the hype? more…

Filed under: Reviews Tagged: audio-technica, Audio-Technica ATH-M50x, EarPods, headphones, Opinion, review, Sound, video

Report: Apple holds private meeting with top podcasters to hear complaints

According to a new report from The New York Times, Apple recently held a closed-door meeting with seven of the top iTunes podcasters to discuss the company’s support for the community. The meeting took place last month at Apple’s Cupertino headquarters and offered a place for the podcasters to express complaints in “frank terms” to Apple employees.

more…

Filed under: AAPL Company Tagged: Apple, Podcasts