Blog

Google Sheets offers many data visualization tools within its platform, with one of the most popular ones being the histogram.

Read more to learn what exactly a histogram is, what it’s used for, and how to make one on Google Sheets.
What is a histogram and what is it used for?
A histogram is a graphical representation showing the distribution of data points that have been grouped into specific ranges or categories.
Say you have a blog and you have blog posts ranging from 1 to 500 words, 500 to 1,000 words, and 1,000 to 2,000 words. You want to analyze which bucket gets the most organic traffic. You can use a histogram to accomplish this.
While a histogram looks like a bar chart, the two are not interchangeable. A histogram displays the frequency distribution of variables within a data set. A bar graph, however, serves as a comparison between separate variables.
Now that you know how to use it, let’s go over how to make one.
How to Make a Histogram on Google Sheets

Select your data set.
Click on “Insert” then select “Chart.”
Click the drop-down menu in “Chart Type” then scroll down to the “Other” section.
Review your histogram.
Edit your chart by clicking on the three dots and then clicking on “Edit chart.”

Use the chart editor to get the most out of your histogram. You can edit:

The chart style by showing item dividers or changing bucket size for instance.
The titles
The series
The legend
The axis (both horizontal and vertical)
The gridlines

There you have it – another helpful visualization tool you can use to understand your data. 

Press releases remain a critical link in the communications chain. According to Cision’s 2021 Global State of the Media Report, 78% of journalists say they prefer press releases and news announcements to other content types.

The problem? Writing a press release is simple — writing a good press release is no easy task. In this piece, we’ll break down 14 common bad press release characteristics and offer suggestions to help your team avoid press release mistakes.

14 Rookie Press Release Mistakes to Avoid
While there’s no such thing as the “perfect” press release, your team can get closer to the mark by avoiding common errors. Here’s a look at 14 of the most common rookie mistakes — and how to reduce your chance of making them.
1. Forgetting to Add Links
Press releases are not just for the press. Releases will likely be published on your website, and your team might also submit releases to wire services. The result? Press releases now live in a digital world — and they need links that drive readers to other relevant content. For marketing teams still using the traditional model of press release production, however, it’s easy to miss out on links.
The result is a release that might have great content but doesn’t go anywhere, meaning your team can miss out on potential conversion opportunities.
The Solution: Ensure all press releases are reviewed prior to publishing. If there’s no obvious place for a link, revise the release to include it.
2. Not Optimizing for Search Engines
Not only should you have links to your company website, you should also craft the “link text” (or “anchor text”) of some of these links so that they contain relevant keywords for SEO (Search Engine Optimization) purposes. For example, if you are in the internet marketing software business, you would have a link in your press release somewhere such that the text of the link has internet marketing in it. On a related note, the page that you are linking to should have matching keywords in its page title and meta description.
The Solution: Check your press releases for SEO relevance using tools capable of measuring the impact of your content and offering suggestions before you publish.
3. Putting Your First Link Too Late
Try to get at least one link in the first third of your content. The reason for this is that when releases get picked up by aggregators or services, they often only include just the first paragraph or two, and the rest gets automatically placed into a subsequent page with a “read more” button.
The result? You might have two or three great links in your content that never see the light of day because readers are only skimming the first few lines of your press release.
The Solution: If you can’t find a place for links in the top third of your content, opt for a rewrite rather than running the risk of burying the link after the jump.
4. Not Including Contact Information
No contact information in your press release — including a phone number and email address — means interested parties have to do the work of looking up your company details and following through. While the effort here isn’t substantial, it’s often enough that potential contacts will simply forget about finding your number or will connect with companies that make their contact information more obvious.
The Solution: Make sure every release includes at least two ways for customers to get in touch — and make sure both still work. There’s nothing worse than sending out an email address that bounces back messages because it’s no longer active.
5. Leaving Out the “About Our Company” Section
Sure, most people aren’t going to read all the way through to the bottom of your press release. But those that do are primed to connect with your company, if you can provide the last little push into action.
This is where the “About Our Company” section comes in. It doesn’t have to be complicated, just a small blurb about what you do and why you do it, but it’s worth including in every press release.
The Solution: Create an About Our Company section that’s clear, concise, and to the point. Then, regularly review it to ensure it’s up-to-date.
7. Ignoring the “Why”
Why should readers care about your press release? What’s newsworthy or interesting about your announcement? While it’s critical to communicate key information, the message also matters: Dry, dull, and boring press releases may get published — but they won’t get read.
The Solution: Lead with a compelling headline and first paragraph. Even if your release gets more detailed as it goes, capturing user attention up-front increases the chance that readers will actually reach the end.
8. Using Uninspiring Quotes
While it’s great to have quotes from executives or team leaders at your company, it’s worth steering clear of quotes from executives or team leaders that talk about how “excited” or “proud” they are about the information in your release. Why? Because these quotes don’t add any value. Of course staff at your company are interested in your announcement, but that doesn’t offer any insight for journalists or readers.
The result is a press release that looks like a carbon copy of similar content and won’t get much traction.
The Solution: Where possible, talk to the people involved with the project or product you’re announcing and get quotes about why it matters to the target audience — what pain points can it address? How does it transform existing processes?
9. Over-Emphasizing Your Brand
Your press release is about your brand — but it shouldn’t be all about your brand. If all you do is talk about how great your company is and how much work you’ve done, you’re not giving readers any reason to keep reading. Instead, they’re left wondering how much of what you’re saying is true and how much is hyperbole.
The Solution: Press releases are about walking the line between promoting your brand and highlighting the impact of your newest project, service, or research. A good rule of thumb? Make sure the headline and first paragraph are about what you’ve done, not how great you are.
10. Under-Supporting Press Release Promotion
Press releases are part of larger marketing campaigns. As a result, it’s easy to spend big on other efforts such as social media and search ads, and under-support press releases. This creates a gap in your marketing efforts that reduces the newsworthy impact of your announcement.
In practice, this limits the reach of your campaign and can frustrate efforts to generate market interest.
The Solution: Start with strategy. Sit down with your team before new campaigns get up and running to ensure there’s a plan for press releases that includes specific budget allotments and targeted news sources.
11. Opting for Style Over Substance
Creating a great headline and compelling first paragraph is a great way to get readers interested — but you’ll lose them in the next section of your press release if you can’t back up initial style with substance.
Consider a press release about a new product that claims to solve specific issues for your target audience. If you spend the first two paragraphs talking about the potential positive impact but don’t back it up with data, quotes, or other evidence, your press release won’t land.
The Solution: Start with solid data. Talk to your product teams and evaluate your market to see where your new solution fits and then find specific data that showcases your results.
12. Forgetting to Ask for Permission
Quotes are a great way to connect with your audience and increase the impact of your press release. The caveat? Always get permission. Internally, this is typically no issue, but if you’re using quotes from a third-party source, even if they’re directly and positively talking about your product, make sure to get express written permission.
If you don’t — and the source doesn’t want their quote used — you could end up doing serious damage to your reputation.
The Solution: Create a clear permissions process that involves identifying great quotes, reaching out to sources, and getting express permission in writing to ensure you’re on solid source ground.
13. Rushing the Release
Timing is everything when it comes to press releases. While it’s tempting to get your release out as soon as possible, if your release goes out before the rest of your campaign is ready, you may find yourself turning away potential customers until your product or service is actually ready for launch.
Best case scenario? You play catch-up and customers stick around. Worst case? They take their business elsewhere.
The Solution: Create a marketing timeline for new campaigns that specifically calls out press release dates and aligns them with other campaign efforts.
14. Trading Accuracy for Speed
The more quickly you can capitalize on emerging trends and customer sentiment, the better. The challenge? Trading press release accuracy for speed. If your release goes out on time but is riddled with spelling or grammar errors, it won’t have the same impact and could convince customers to take their business elsewhere.
The Solution: Put every release through at least two rounds of edits and evaluation to minimize mistakes.
Don’t Stress — Impress By Avoiding Common Mistakes
A bad press release can sink your marketing campaign. Improve your impact and cultivate a strong brand presence with your audience by avoiding these 14 common mistakes. 
Editor’s note: This post was originally published in May 2022 and has been updated for comprehensiveness.

Hello, Our team is developing platform that will automate whole cycle of Digital banner creation: from from the statement of technical specifications to the finished design. If you have a need in ad banners for you marketing communications, then please, feel the following google form. The information, that we will get from you will help us to provide great user experience. Also, please fill out the form if you want to get access to the beta version https://forms.gle/daaRUfbowpyKcbGx8 Thanks submitted by /u/kris_kli [link] [comments]

submitted by /u/blkwidow19 [link] [comments]

If you guys are searching for an effective, automated email marketing service, I may have a tool to help you. There’s a software called Keap that helps smaller businesses gain attraction and customers through the use of automated email marketing. This service comes with a bunch of perks to make your life easier. Some of the perks include: -Marketing Automations -Sales Automations -CRM -Payments and invoicing -Reports and analytics If you guys are interested in trying out the service for your business, I’ll leave a link below. Cheers and good luck! 30% off for the next 3 months! submitted by /u/CharacterOld8027 [link] [comments]

Like many business owners, for the first five years of getting my company off ground, “founder” was my entire identity. My video creator platform, Sightworthy, took up all of my energy as we went through an accelerator, considered fundraising and ultimately decided to bootstrap, and grew to a profitable company working on marketing projects with the likes of Nike, Morgan Stanley, GSK, and Madewell. While I had always considered myself a multi-passionate creative, I didn’t feel like I had time to devote to my other passions while also being a successful entrepreneur.But focusing solely on my business was also draining. I found myself regularly working all hours of the day, hustling to get the next sale for Sightworthy, and barreling towards burnout because of it. The fact that I had no creative energy left to do things that lit me up was weighing on me. When the pandemic hit in 2020, I could have used the extra time lockdown gave us all to work more on my business, as so many entrepreneurs did. But, not only did that not seem like the healthiest choice, a new idea had sparked my inspiration. It started as a one-off video featuring my cousin who’s an ER doctor talking about some of the basics of COVID to help stop the spread of misinformation. The video went viral, and other female physicians of color started reaching out to me wanting to share their experiences. I didn’t want to let the opportunity to capture this historic moment go, so I spent the next 14 months crowdfunding and creating my first documentary telling the stories of six South Asian and Black female ER physicians during the pandemic. One thing eventually led to another, and a production company joined on as executive producers to help me make the project bigger than I could have ever imagined. (We’re now talking to film festivals, streaming services, South Asian-led brands, and even medical schools and universities about helping us release and distribute the film.) View this post on Instagram A post shared by @imdoingmyjob Before I knew it, I had this massive side project I was working on while continuing to run Sightworthy at normal capacity—and I loved it. Rather than overwhelming me, my side project reignited my creative spark and love for the work that I do, gave me new energy and ideas to bring back into my client work, and transformed how I think about using my time effectively. And, ultimately, it helped me see possibilities for how I could evolve my business to stay aligned with my “why.”My side project gave me so much value that, as the documentary wound down, I started working on another idea: writing a pilot for a TV series about four South Asian women coming of age in NYC called Lonely Girl. While the first side hustle happened by accident, the second one has been much more intentional—and I had already built the railroad tracks to make it easier to work on a project while I worked on my business. Here are some of the things that have helped me succeed at both in the past few years.I Got My Business to a Stable Place Before Starting Something ElseThe first few years of growing Sightworthy, I couldn’t even imagine having time for a side project. My schedule and attention were completely wrapped up in figuring out who our customer was, how to make a sale, and generally how to do every little piece of my business for the first time. But, by the time the documentary started gaining traction, a few things had changed.For one, my finances were in a really good place. Not only had I built a profitable business, but a few personal investments had done really well. My finances were such that I had enough for myself and my employees in the event that I wanted to scale client work back to focus on other things.But more than that, I had the business systems in place that I wouldn’t have to scale back in order to turn some of my attention elsewhere. We had found product market fit and had impressive case studies and a strong network that made sales a lot easier. I had hired a great team and figured out what work I needed to do and what I could delegate. We had a lot of ongoing client work and processes for collaboration that made each individual project less of a lift.I don’t think it’s necessary to reach profitability before considering spending time on a side project. But for me, it was helpful to have some stability in my business to have the space to come up for air and spend time on other things.I don’t think it’s necessary to reach profitability before considering spending time on a side project. But for me, it was helpful to have some stability in my business to have the space to come up for air and spend time on other things. – Aneri Shah, Founder of Sightworthy & Lonely GirlI Chose a Side Project That Connected to My Larger “Why”Something that really helped me balance my side project with my business was the fact that they were so connected, and both taught me things that could contribute to the success of the other. Obviously, they were both based around video content. The video storytelling work I was doing for the documentary inspired some new best practices for our advertising partners. I also discovered a new potential customer base of folks in the film industry. Meanwhile, all the work I had done when considering fundraising for my business made crowdfunding the documentary feel much less daunting.But, more than that, they are both tied to a larger purpose. Something I’ve long tried to push through my work at Sightworthy is more inclusivity in advertising, with a particular fondness for furthering South Asian representation. Working on the documentary and the TV pilot has given me even more opportunities to tell South Asian stories that I may never get to tell through advertising work alone. That “why” was strong enough that the side project felt like it was contributing positively to every part of my life, in a way that I don’t think would have been true if I just chose something random.I Found Ways to Be More Intentional With My TimeThe most surprising thing about this whole endeavor was how adding more work to my plate ultimately made me more efficient.Before I had another project I cared so deeply about, it felt like I could fill up my entire day with work (and I was definitely headed towards burnout because of it). Once I started working on side projects, I had to get really intentional on how much time I was spending on each. I started working with a coach (the brilliant Amy Lombardo), who helped me rapidly develop new productivity habits like time blocking my days. I would start by blocking off everything I needed to do for the highest revenue generators in my business, since that’s where the money was coming from, and then could see a clear picture of how much time I realistically had for the side project. That helped because I could easily say, “Well, I could be doing all this stuff for my side project, but I actually don’t have time for that, so how do I organize accordingly?”It also pushed me to get leaner and meaner in my business: I used to say yes to every project that came our way, and now we’ve really honed in on the clients that can provide recurring revenue. Of course, all of this was made easier in the early days of the pandemic because my social calendar was completely empty. Since things started opening back up, I have had to “sacrifice” some time for social outings in order to continue work on my side project—but to me it doesn’t really feel like a sacrifice because this work truly feels like an act of service that is giving my life more meaning.I’m Letting My Side Project Evolve My BusinessThis wasn’t the original intention, but as the scale of my side project grew (along with my passion for it), I started thinking seriously about how all the different moving parts and pieces could fit together into a new future for my business.If, instead of helping brands create video in an agile way, my new “why” is centering and celebrating South Asian women through media, how would the business evolve? Would we only work with brands that target that audience? Would we become a production company that helps other people create media centering South Asian stories? Or would I rather sell Sightworthy and put all of my energy into creating my own work under the Lonely Girl umbrella? I don’t know the answer yet, but it’s fun to be able to brainstorm freely since my business is bootstrapped. And, regardless of the direction I choose, I’ve learned so much from my side projects that I think it’s going to pay off forever.Based on this experience, here’s my advice for other founders: A side project can be a side project just for your own fulfillment, and that can be enough. But giving yourself permission to work on a side project can ultimately function as a little microcosm for you to test things for your future business, career, and life.Based on this experience, here’s my advice for other founders: A side project can be a side project just for your own fulfillment, and that can be enough. But giving yourself permission to work on a side project can ultimately function as a little microcosm for you to test things for your future business, career, and life. – Aneri Shah, Founder of Sightworthy & Lonely Girl

Looking for the best way to market your Shopify store? Check out these 9 best strategies and tips and start promoting your store better today.

Our resident data magician dove into Aument’s attribution model for abandoned cart recovery and pop-up notifications. He didn’t spare a single technical detail! submitted by /u/AumentIO [link] [comments]