Connect with us

SEO

How to Automate Dull SEO Tasks

Published

on

How to Automate Dull SEO Tasks

Some SEO processes involve repetitively clicking things on a screen. Not the best use of your time.

With the right tools, however, you can automate various SEO processes—and free up resources for tasks that need more creative, human input.

In this post, I’ll share two examples of how I automate SEO tasks. 

Example 1. Record and email article assignments to writers

Imagine being able to record and email article assignments to writers in seconds using a simple form like this:

Airtable article assignment form

Let’s look at how to set this up.

1. Set up an Airtable database for your writer and article data

Sign up for Airtable and create a new database with a table called “Writers.” The table should have columns for your writers:

"Writers" table in Airtable

In the same Airtable database, create a separate table called “Articles.” 

Set up columns in this table for your:

  • Article titles.
  • Article outline links.
  • Article due dates.
  • Assigned writer (set this column up as a linked record to your “Writers” table so that Airtable can retrieve data on your writers from it).
"Articles" table in Airtable

You’ll also need to add a lookup field to pull the writer’s email address from the “Writers” table. 

Add Airtable lookup field

2. Create an Airtable article assignment form

Next, create an article assignment form for the “Articles” table. You’ll use this form to add new article assignments to the “Articles” table.

Create Airtable article assignment form

3. Set up a new Zapier automation with a “New Record in Airtable” trigger

When you submit your details on the new article assignment via the Airtable form, Airtable will automatically record the new article assignment in your “Articles” table. So that’s the first step of the article assignment workflow sorted.

Demo of how Airtable automatically records new article assignments when the article assignment form is filled out

Now, we’ll use the Zapier workflow automation tool to automate the next three steps in the workflow—namely:

  1. Create a shared Google Drive submission folder for the article.
  2. Create a Google Doc submission document in the shared Google Drive folder.
  3. Use Gmail to email the writer the article title, outline link, due date, and link to the shared Google Drive submission folder.

Sidenote.

Instead of Zapier, you can also use any other workflow automation tool, such as Make, as long as the tool supports the automation triggers and actions you’ll need.

In Zapier, create a new automated workflow (also known as a “Zap”) with:

  • Airtable as the trigger app.
  • New Record as the trigger event.

With this trigger, your Zap will start running when you add a new record to Airtable (such as by submitting your Airtable article assignment form).

Trigger step: New Record in Airtable

4. Add a “Create Folder in Google Drive” action step to your Zap

Next, add an action step with:

  • Google Drive as the action app.
  • Create Folder as the action event.

For the action step’s “Parent Folder” field, select the Google Drive folder in which the new submission folder should be created.

Also, provide a name for the submission folder in the “Folder Name” field. You can map the article title data from Airtable here to name your submission folder after the article’s title.

Action step: Create Folder in Google Drive

5. Add an “Add File Sharing Preference in Google Drive” action step to your Zap

The Google Drive folder created by your Zap will have its sharing permissions disabled by default, so let’s add an action step to grant folder access to anyone who has the link to the folder.

This action step should have:

  • Google Drive as the action app.
  • Add File Sharing Preference as the action event.

Map the file ID of the Google Drive folder created in the previous action step to the “File Id” field of this action step.

Map file ID of Google Drive folder to "File Id" field

In addition, set the “Sharing Preference” field to “Anyone on the internet who has the link can edit.”

Set "Sharing Preference" field to "Anyone on the internet who has the link can edit"

6. Add a “Create Document from Text in Google Docs” action step to your Zap

Now, let’s set up the Google Doc that the writer will use to submit their draft.

We’ll have the Zap create this submission Google Doc in the shared Google Drive submission folder. And since the Google Drive folder will have general access enabled, anyone with the link to the Google Drive folder—and this includes you—will also automatically get access to the Google Doc.

No more frustration over writers forgetting to grant access to their Google Docs!

So add a new action step to your Zap with:

  • Google Docs as the action app.
  • Create Document from Text as the action event.

Map the article title data from Airtable to the action step’s “Document Name” field, and the folder ID of the shared Google Drive folder to the “Folder” field.

You’ll also need to include some default text in the Google Doc, such as “Write your article here!”

Action step: Create Document from Text in Google Docs

7. Add a “Send Email in Gmail” action step to your Zap

Finally, we’ll get the Zap to use your Gmail account to email the writer the article title, outline link, due date, and link to the shared Google Drive submission folder.

Add a last action step to your Zap with:

  • Gmail as the action app.
  • Send Email as the action event.

Map the writer’s email address from Airtable to the “To” field for this action step. Also, map the article title, outline link, due date, and Google Drive submission folder link in the email body.

I also recommend adding your own email address to either the “Cc” or “Bcc” field so you get a copy of the automated email (and can confirm it’s been sent).

Sample text for automated article assignment email

Once you’re happy with your Zap, hit the Publish button to activate your automation!

Example 2. Finding and verifying prospects’ email addresses for link building outreach

Finding email addresses for link building outreach can be a massive pain.

After all, most prospects don’t advertise their email addresses publicly. And even if you’ve managed to dig up their email addresses (or guess them using trial and error), there’s no guarantee they work.

But using Ahrefs’ Content Explorer, you can generate a huge Google Sheets list of link building prospects that looks like this:

List of prospects in Google Sheets

Then as you fill out the “Approve?” column for each prospect with data—such as “Yes” or “Approved”—a Zapier automation will automatically do all these for you:

  1. Find the prospect’s email address using the Hunter email lookup tool
  2. Add the email address to your Google Sheet list of prospects
  3. Verify the email address using the NeverBounce email verification tool
  4. Add the verified email address to the Woodpecker.io email outreach tool so you can start sending customized outreach emails

Here’s how to set this up.

1. Get your list of prospects

Launch Ahrefs’ Content Explorer and search for link prospects. 

For example, if you recently published a marketing survey with unique insights and statistics, you may want to look for marketing statistics pages to pitch. To do this, simply run an “In title” search for “marketing statistics.”

Report of webpages with "marketing statistics" in their title, via Ahrefs' Content Explorer

Next, filter your results to show only webpages that are:

  • In English (unless you’re targeting webpages in another language).
  • Live, as it’d be weird to reach out and say, “Hey, I found you through [this webpage that no longer exists].”
  • On websites with a Domain Rating (DR) of 20 to 80 because you want to prioritize pursuing backlinks from authoritative websites but also that your chances of getting backlinks from super high-authority websites are quite low.
Filtering for live, English webpages on sites with a DR between 20 and 80, via Ahrefs' Content Explorer

Add a last filter to show only one page per domain (since you want to reach out to only one prospect per website).

Ahrefs' Content Explorer "One page per domain" setting

Click the Export button to export your list of prospects in a CSV file.

2. Clean up your list of prospects

As mentioned, we’ll be using Hunter to help us find our prospects’ email addresses.

Hunter uses the first names, last names, and domains of prospects to find email addresses, so we’ll clean up our list of prospects to provide Hunter with the exact data it needs.

Import your CSV list of prospects in Google Sheets and delete all columns in it except for:

  • Content Title
  • Content URL
  • Author

Also, some of the prospects in the CSV don’t have author names, so it’s worth removing these rows from the CSV. To do this, just filter for rows with empty author names and delete them.

Next, use the SPLIT formula to split the author names into their first and last names based on the space between their names.

Using the =SPLIT() formula in Google Sheets to split author names based on the space between the first and last names

Finally, add two new columns to the sheet:

  1. Approve?: Adding data to this column will trigger the Zapier automation we’ll be setting up next!
  2. Email Address: This column will store the prospect’s email address (if found).
Adding of two new "Approve?" and "Email address" columns to Google Sheets

3. Set up a new Zapier automation with a “New or Updated Spreadsheet Row in Google Sheets” trigger

In Zapier, create a new Zap with:

  • Google Sheets as the trigger app.
  • New or Updated Spreadsheet Row as the trigger event.

Map the action step’s “Trigger Column” field to your Google Sheet’s “Approve?” column.

Trigger step: New or Updated Spreadsheet Row in Google Sheets

With this setup, you’ll trigger your Zap whenever you add new data—such as “Yes” or “Approved”—to the “Approve?” column for any prospect row.

Adding of the word "Yes?" to the "Approve?" column in the Google Sheets list of prospects

4. Add a “Find Email in Hunter” action step to your Zap

Next, add a new action step with:

  • Hunter as the action app.
  • Find Email as the action event.

Map the “Content URL,” “First Name,” and “Last Name” columns in your Google Sheet to the “Domain or Company,” “First Name,” and “Last Name” fields for this action step, respectively.

Action step: Find Email in Hunter

5. Add an “Update Spreadsheet Row in Google Sheets” action step to your Zap

The next action step will update your Google Sheet with a prospect’s email address if Hunter finds it. Use:

  • Google Sheets as the action app.
  • Update Spreadsheet Row as the action event.

Map the Row Number of the updated row in the trigger step to this action step’s “Row” field.

Map the row number to the "Row" field

Also, map the email address that Hunter found in the previous action step to the “Email Address” field of this action step.

Map email address to the "Email Address" field

Sidenote.

This email address does not exist. It is for demo purposes only.

6. Add a Filter action that lets the Zap continue only if Hunter has found an email address

Next, set up a Filter action that lets the Zap proceed only if the email address data found by Hunter contains the “@” symbol.

That’s because all email addresses have the “@” symbol. If Hunter happens to find an email address value that doesn’t include this symbol, we won’t want to waste time verifying it.

Filter action: Only continue if email address contains "@"

7. Add a “Verify Email Address in NeverBounce” action step to your Zap

Now, we’ll use NeverBounce to verify the validity of the email addresses that Hunter found. Add a new action step with:

  • NeverBounce as the action app.
  • Verify Email Address as the action event.

Map the email address that Hunter found to this action step’s “Email Address to Verify” field:

Action step: Verify Email Address in NeverBounce

8. Add a Filter action that lets the Zap continue only if NeverBounce returns a “Valid” or “Catchall” status for the email address

When NeverBounce verifies an email address, it will return one of four status text codes: Valid, Catchall, Invalid, and Unknown. Email addresses marked with the “Valid” and “Catchall” NeverBounce status codes have the highest likelihood of being valid.

So we’ll add a Filter action that lets the Zap proceed only if an email address’s NeverBounce status text code matches either “Valid” or “Catchall” exactly.

Filter action: Only continue if NeverBounce status text code is "Valid" or "Catchall"

9. Add a “Create/Update Prospect in Woodpecker.co” action step to your Zap

Finally, we’ll set up the Zap to add the verified email address to Woodpecker.co.

Create a last action step with:

  • Woodpecker.co as the action app.
  • Create/Update Prospect as the action event.

Map the verified email address to the action step’s “Email” field, and your prospect’s first and last name (as obtained from Google Sheets) to the “First Name” and “Last Name” fields, respectively.

Action step: Create/Update Prospect in Woodpecker.co

Hit the Publish button to turn your Zap on.

Now, when you fill out the “Approve?” column for prospects in your Google Sheet, your Zap will automatically do the heavy lifting of finding and verifying their email addresses using Hunter and NeverBounce and adding the verified email addresses to Woodpecker.co.

You can then customize your link building outreach emails in Woodpecker.co for each verified email address and, hopefully, snag yourself some backlinks!

Final thoughts

SEO automation takes some initial setup, but it’s amazing to watch your processes run automatically after that. It’s almost like magic.

And apart from the SEO processes we’ve shared here, there are probably plenty others you can automate.

Think of the apps you regularly use for SEO work. If you can connect these apps using Zapier or some other workflow automation tool, automating the workflows they support is likely more than possible.

Got questions? Ping me on Twitter.



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

SEO

TikTok CEO To Testify In Hearing On Data Privacy And Online Harm Reduction

Published

on

TikTok CEO To Testify In Hearing On Data Privacy And Online Harm Reduction

TikTok CEO Shou Chew will testify in a hearing before the U.S. House Committee on Energy and Commerce this Thursday, March 23, at 10:00 a.m. ET.

As CEO, Chew is responsible for TikTok’s business operations and strategic decisions.

The “TikTok: How Congress Can Safeguard American Data Privacy and Protect Children from Online Harms” hearing will be streamed live on the Energy and Commerce Committee’s website.

According to written testimony submitted by Chew, the hearing will focus on TikTok’s alleged commitment to transparency, teen safety, consumer privacy, and data security.

It also appears to broach the topic of misconceptions about the platform, such as its connection to the Chinese government through its parent company, ByteDance.

Chew shared a special message with TikTok yesterday from Washington, D.C., to thank 150 million users, five million businesses, and 7,000 employees in the U.S. for helping build the TikTok community.

@tiktokOur CEO, Shou Chew, shares a special message on behalf of the entire TikTok team to thank our community of 150 million Americans ahead of his congressional hearing later this week.♬ original sound – TikTok

The video has received over 85k comments from users, many describing how TikTok has allowed them to interact with people worldwide and find unbiased news, new perspectives, educational content, inspiration, and joy.

TikTok Updates Guidelines And Offers More Educational Content

TikTok has been making significant changes to its platform to address many of these concerns before this hearing to evade a total U.S. ban on the platform.

Below is an overview of some efforts by TikTok to rehab its perception before the hearing.

Updated Community Guidelines – TikTok updated community guidelines and shared its Community Principles to demonstrate commitment to keeping the platform safe and inclusive for all users.

For You Feed Refresh – TikTok recommends content to users based on their engagement with content and creators. For users who feel that recommendations no longer align with their interests, TikTok introduced the ability to refresh the For You Page, allowing them to receive fresh recommendations as if they started a new account.

STEM Feed – To improve the quality of educational content on TikTok, it will introduce a STEM feed for content focused on Science, Technology, Engineering, and Mathematics. Unlike the content that appears when users search the #STEM hashtag, TikTok says that Common Sense Networks and Poynter will review STEM feed content to ensure it is safe for younger audiences and factually accurate.

This could make it more like the version of TikTok in China – Douyin – that promotes educational content to younger audiences over entertaining content.

Series Monetization – To encourage creators to create in-depth, informative content, TikTok introduced a new monetization program for Series content. Series allows creators to earn income by putting up to 80 videos with up to 20 minutes in length, each behind a paywall.

More Congressional Efforts To Restrict TikTok

The TikTok hearing tomorrow isn’t the only Congressional effort to limit or ban technologies like TikTok.

Earlier this month, Sen. Mark Warner (D-VA) introduced the RESTRICT Act (Restricting the Emergence of Security Threats that Risk Information and Communications Technology), which would create a formal process for the government to review and mitigate risks of technology originating in countries like China, Cuba, Iran, North Korea, Russia, and Venezuela.

Organizations like the Tech Oversight Project have pointed out that Congress should look beyond TikTok and investigate similar risks to national security and younger audiences posed by other Big Tech platforms like Amazon, Apple, Google, and Meta.

We will follow tomorrow’s hearing closely – be sure to come back for our coverage to determine how this will affect users and predict what will happen next.


Featured Image: Alex Verrone/Shutterstock



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

How Is It Different From GPT-3.5?

Published

on

How Is It Different From GPT-3.5?

GPT-4, the latest version of ChatGPT, OpenAI’s language model, is a breakthrough in artificial intelligence (AI) technology that has revolutionized how we communicate with machines.

ChatGPT’s multimodal capabilities enable it to process text, images, and videos, making it an incredibly versatile tool for marketers, businesses, and individuals alike.

What Is GPT-4?

GPT-4 is 10 times more advanced than its predecessor, GPT-3.5. This enhancement enables the model to better understand context and distinguish nuances, resulting in more accurate and coherent responses.

Furthermore, GPT-4 has a maximum token limit of 32,000 (equivalent to 25,000 words), which is a significant increase from GPT-3.5’s 4,000 tokens (equivalent to 3,125 words).

“We spent 6 months making GPT-4 safer and more aligned. GPT-4 is 82% less likely to respond to requests for disallowed content and 40% more likely to produce factual responses than GPT-3.5 on our internal evaluations.” – OpenAI

GPT-3.5 Vs. GPT-4 – What’s Different?

GPT-4 offers several improvements over its predecessor, some of which include:

1. Linguistic Finesse

While GPT-3.5 is quite capable of generating human-like text, GPT-4 has an even greater ability to understand and generate different dialects and respond to emotions expressed in the text.

For example, GPT-4 can recognize and respond sensitively to a user expressing sadness or frustration, making the interaction feel more personal and genuine.

Screenshot from OpenAI, March 2023

One of the most impressive aspects of GPT-4 is its ability to work with dialects, which are regional or cultural variations of a language.

Dialects can be extremely difficult for language models to understand, as they often have unique vocabulary, grammar, and pronunciation that may not be present in the standard language.

However, GPT-4 has been specifically designed to overcome these challenges and can accurately generate and interpret text in various dialects.

2. Information Synthesis

GPT-4 can answer complex questions by synthesizing information from multiple sources, whereas GPT-3.5 may struggle to connect the dots.

For example, when asked about the link between the decline of bee populations and the impact on global agriculture, GPT-4 can provide a more comprehensive and nuanced answer, citing different studies and sources.

ChatGPT 4 article exampleScreenshot from OpenAI, March 2023

Unlike its predecessor, GPT-4 now includes a feature that allows it to properly cite sources when generating text.

This means that when the model generates content, it cites the sources it has used, making it easier for readers to verify the accuracy of the information presented.

3. Creativity And Coherence

While GPT-3.5 can generate creative content, GPT-4 goes a step further by producing stories, poems, or essays with improved coherence and creativity.

For example, GPT-4 can produce a short story with a well-developed plot and character development, whereas GPT-3.5 might struggle to maintain consistency and coherence in the narrative.

ChatGPT 4 creative exampleScreenshot from OpenAI, March 2023
ChatGPT 4 creative writingScreenshot from OpenAI, March 2023

4. Complex Problem-Solving

GPT-4 demonstrates a strong ability to solve complex mathematical and scientific problems beyond the capabilities of GPT-3.5.

For example, GPT-4 can solve advanced calculus problems or simulate chemical reactions more effectively than its predecessor.

ChatGPT 4 complex physics problemScreenshot from OpenAI, March 2023
ChatGPT 4 equations of motionScreenshot from OpenAI, March 2023

GPT-4 has significantly improved its ability to understand and process complex mathematical and scientific concepts. Its mathematical skills include the ability to solve complex equations and perform various mathematical operations such as calculus, algebra, and geometry.

In addition, GPT-4 is also capable of handling scientific subjects such as physics, chemistry, biology, and astronomy.

Its advanced processing power and language modeling capabilities allow it to analyze complex scientific texts and provide insights and explanations easily.

As the technology continues to evolve, it is likely that GPT-4 will continue to expand its capabilities and become even more adept at a wider range of subjects and tasks.

5. Programming Power

GPT-4’s programming capabilities have taken social media by storm with its ability to generate code snippets or debug existing code more efficiently than GPT-3.5, making it a valuable resource for software developers.

With the help of GPT-4, weeks of work can be condensed into a few short hours, allowing extraordinary results to be achieved in record time. You can test these prompts:

  • “Write code to train X with dataset Y.”
  • “I’m getting this error. Fix it.”
  • “Now improve the performance.”
  • “Now wrap it in a GUI.”

6. Image And Graphics Understanding

Unlike GPT-3.5, which focuses primarily on text, GPT-4 can analyze and comment on images and graphics.

For example, GPT-4 can describe the content of a photo, identify trends in a graph, or even generate captions for images, making it a powerful tool for education and content creation.

ChatGPT problem solving with dataScreenshot from OpenAI, March 2023

Imagine this technology integrated with Google Analytics or Matomo. You could get highly accurate analytics for all your dashboards in a few minutes.

7. Reduction Of Inappropriate Or Biased Responses

GPT-4 implements mechanisms to minimize undesirable results, thereby increasing reliability and ethical responsibility.

For example, GPT-4 is less likely to generate politically biased, offensive, or harmful content, making it a more trustworthy AI companion than GPT-3.5.

Where Can ChatGPT Go Next?

Despite its remarkable advancements, ChatGPT still has room for improvement:

  • Addressing neutrality: Enhancing its ability to discern the context and respond accordingly.
  • Understanding the user: Developing the capacity to understand who is communicating (who, where, and how).
  • External integrations: Expanding its reach through web, API, and robotic integrations.
  • Long-term memory: Improving its ability to recall past interactions and apply that knowledge to future conversations.
  • Reducing hallucination: Minimizing instances where the AI is convinced of false information.

As ChatGPT continues to evolve, it is poised to revolutionize marketing and AI-driven communications.

Its potential applications in content creation, education, customer service, and more are vast, making it an essential tool for businesses and individuals in the digital age.

More Resources:


Featured Image: LALAKA/Shutterstock



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

Should Congress Investigate Big Tech Platforms?

Published

on

Should Congress Investigate Big Tech Platforms?

This week, the House Energy and Commerce Committee will hold a full committee hearing with TikTok CEO Shou Chew to discuss how the platform handles users’ data, its effect on kids, and its relationship with ByteDance, its Chinese parent company.

This hearing is part of an ongoing investigation to determine whether TikTok should be banned in the United States or forced to split from ByteDance.

A ban on TikTok would affect over 150 million Americans who use TikTok for education, entertainment, and income generation.

It would also affect the five million U.S. businesses using TikTok to reach customers.

Is TikTok The Only Risk To National Security?

According to a memo released by the Tech Oversight Project, TikTok is not the only tech platform that poses risks to national security, mental health, and children.

As Congress scrutinizes TikTok, the Tech Oversight Project also strongly urges an investigation of risks posed by tech companies like Amazon, Apple, Meta, and Google.

These platforms have a documented history of serving content harmful to younger audiences and adversarial to U.S. interests. They have also failed on many occasions to protect users’ private data.

Many Big Tech companies have seen TikTok’s success and tried to emulate some of its features to encourage users to spend as much time within their platforms’ ecosystems as possible. Academics, activists, non-governmental organizations, and others have long raised concerns about these platforms’ risks.

To truly reduce Big Rech’s risks to our society, Congress must look beyond TikTok and hold other companies accountable for the same dangers they pose to national security, mental health, and private data.

Risks Posed By Big Tech Companies

The following are examples of the risks Big Tech companies pose to U.S. users.

Amazon

Amazon has made several controversial moves, including a partnership with a state propaganda agency to launch a China books portal and offering AWS services to Chinese companies, including a banned surveillance firm with ties to the military.

Apple

Independent research found that Apple collects detailed information about its users, even when users choose not to allow tracking by apps from the App Store. Over half of the top 200 suppliers for Apple operate factories in China.

Google

The FTC fined Google and YouTube $170 million for collecting children’s data without parental consent. YouTube also changed its algorithm to make it more addictive, increasing users’ time watching videos and consuming ads.

Meta

Facebook allowed Cambridge Analytica to harvest the private data of over 50 million users. It also failed to notify over 530 million users of a data breach that resulted in users’ private data being stolen.

It also allowed Russian interference in the 2016 elections. The influence operation posed as an independent news organization with 13 accounts and two pages, pushing messages critical of right-wing voices and the center-left.

TikTok 

TikTok employees confirmed that its Chinese parent company, ByteDance, is involved in decision-making and has access to TikTok’s user data. While testifying before the Senate Homeland Security Committee, Vanessa Pappas, TikTok COO, would not confirm whether ByteDance would give TikTok user data to the Chinese government.

Conclusion

While the dangers posed by TikTok are undeniable, it’s clear that Congress should also address the risks posed throughout the tech industry. By holding all major offenders accountable, we can create a safe, secure, and responsible digital landscape for everyone.


Featured Image: Koshiro K/Shutterstock



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

en_USEnglish