This clever app turns your spreadsheets into slick interactive web tools

{ object.primary_image.title }}

Grid gives new life to Excel and Google Sheets, without making you give up the apps you know. It even has the support of one of the spreadsheet’s inventors. A hot trend in tech these days is coming up with the next great “spreadsheet killer”—the dazzling app that’ll make us all abandon Excel and Google Sheets in favor of some newer, sleeker, and more versatile alternative. From Notion and Coda to Airtable and its rivals , there’s no shortage of alluring services trying to remake the tired old spreadsheet and trade it in for something more modern. Read Full Story

Read Full Article on Fast Company

The Simple Guide to Using Pivot Tables to Understand Marketing Data

{ object.primary_image.title }}

Does the word “pivot table” make you want to scream? You aren’t alone. But, if you aren’t using pivot tables, you could be missing out on valuable insights about the effectiveness of your SEO, social media, or content marketing campaigns. Data is the most powerful resource on the planet right now — some are even calling it the “new oil.” But, are you making the most of your marketing data? If you already have a good grasp of the basics of Excel or Google Sheets, then you have a head start. But I’m here to take you beyond the basic functions like SUM, AVG, or adding new rows. You should be using Microsoft Excel to analyze and organize data from your marketing efforts. Why? Because it’s one of the most underutilized marketing assets out there. It’s safe to say that you probably know how to input numbers, words, dollar amounts, …

More

Google Shopping Actions: How to Increase Product Visibility for Free

{ object.primary_image.title }}

Did you know Google Shopping listings are free for most merchants to use? Google has also dropped commissions for its Buy on Google program. This means nearly any retailer can sign up for Google Shopping Actions and link their products without paying the 12% commission Google formerly collected on each sale. Retailers and advertisers have a unique opportunity to get incredible exposure for their products. Almost half of users turn to Google to find or discover new products. This means even small businesses can put themselves in front of millions of new potential customers with just a few clicks. What Is Google Shopping Actions? Google Shopping Actions partners with several retailers to create a shopping experience in direct competition with Amazon. Today, this program allows retailers to upload products that appear in organic search across Google platforms. In turn, shoppers can find, compare, and buy products without ever having to …

More

How to Query the Google Search Console API

{ object.primary_image.title }}

Posted by briangormanh If you’ve been an SEO for even a short time, you’re likely familiar with Google Search Console (GSC). It’s a valuable tool for getting information about your website and its performance in organic search. That said, it does have its limitations. In this article, you’ll learn how to get better-connected data out of Google Search Console as well as increase the size of your exports by 400%. Google Search Console limitations While GSC has a number of sections, we’ll be focusing on the “Performance” report. From the GSC dashboard, there are two ways you can access this report: Once inside the “Performance” report, data for queries and pages can be accessed: This reveals one of the issues with GSC: Query and page data is separated. In other words, if I want to see the queries a specific page is ranking for, I have to first click “Pages,” …

More

SEO Pack: 21 Worksheets, Templates, and Cheat Sheets

{ object.primary_image.title }}

SEO is tough. It’s time-consuming and hard to implement. And, because of that, I have a free SEO training course and even an SEO tool to help you out. But what if you don’t have the time to go through a 21-part training series? Or what if my SEO tool doesn’t give you the step-by-step instructions you need? What other options do you have? Well, today I thought I would make your life easier by sharing 21 of my own SEO and content marketing worksheets and templates to help you get higher rankings in less time and, best of all, with less effort. Marketing definitions Let’s start off with the basics. In marketing, we all use terms that might be a bit confusing. Sure, you probably know what SEO is and what it means , but what about terms like CPC? Or more complicated ones like CAC, BANT, LTV, or …

More

How to Make a Scalable SMS Chatbot Using Twilio, Python, and Google Sheets (with Free Code)

{ object.primary_image.title }}

Posted by R0bin_L0rd Many of us are helping businesses that are facing hard times, or we’re facing hard times ourselves. If you’re working for a company (or client) that's in trouble, the use of SMS chatbots could be a way for you to look outside your normal list of solutions and help them succeed in a completely different way. If you’re a marketer looking for work, adding this to your list of skills could mean you keep things ticking along while many of the usual doors are closed — or that you open new doors. What you’ll get In this post, I give you instructions and code to produce not just one, but a series of text-based chatbots that can be managed by Google Sheets. The example here is set up to work with restaurants, but could be adapted to work with any business that needs to receive orders, check …

More

SEO Forecasting in Google Sheets

{ object.primary_image.title }}

Posted by Tom.Capper Way back in 2015, I published an article giving away a free, simple, forecasting tool, and talking through use cases for forecasting in SEO. It was a quick, effective way to see if a change to your site traffic is some kind of seasonality you can ignore, something to celebrate, or a worrying sign of traffic loss. In short: you could enter in a series of data, and it would plot it out on a graph like the image above. Five years later, I still get people — from former colleagues to complete strangers — asking me about this tool, and more often than not, I’m asked for a version that works directly in spreadsheets. I find this easy to sympathize with: a spreadsheet is more flexible, easier to debug, easier to expand upon, easier to maintain, and a format that people are very familiar with. The …

More

Subscribe to our newsletter

Join our newsletter and never miss out trending marketing news.

HitcountVariables(pk=18406, ajax_url='/api/hit/ajax/', hits='1')