My AI content machine in Google Sheets (Part 1 of 2)

80% of my LinkedIn content is now created by one of four AI agents.

In this article, I explain what these agents are doing.

First things first: If you're looking to create content from scratch, these agents won't be helpful.

Their main purpose is to repurpose existing content.

I have created more than 400 LinkedIn posts over the last 2 years and one key thing I learned is that the best strategy to create impactful content is to double down on a few ideas and repurpose them instead of always trying to create new content. 

Now, 80% of my content is repurposed, and 20% is based on brand-new ideas.

With that being said, let's dive into the use cases first and then explore what's under the hood and how you can build it, too (spoiler alert: if you're data savvy you can easily build it yourself).

THE USE CASES - 4 AI Agents

AI Agent 1: Shorten a longer piece of content

I used to write really looooong LinkedIn posts with really looooong and complicated sentences.

Over time I noticed that shorter posts with shorter sentences and a rhythmic writing style (alternating short sentences, medium-long sentences, and bullet-point lists) work best.

Therefore, this agent takes an old, long post and transforms it into a shorter piece with shorter sentences while keeping the message and tonality to sound like me and not like AI.

Here is an example:

Long, complex Input post:

At Rocket Internet, we once wasted hundreds of hours of work on recommendation engines.
Here’s what we learned. 👇
Back in 2013, during my time at Rocket Internet, we wanted to increase Basket Sizes and Revenues for Lazada (now part of Alibaba) by implementing an AI-based Recommendation Engine. 🤖
Countless vendors and internal data scientists spent weeks gathering data, cleaning data, and testing various machine-learning approaches.
The results were very disappointing as none of the approaches seemed to have an impact.
Then, two changes made all the difference:
1. Changing the target metric
2. Eliminating AI and Machine Learning
Let’s have a quick look at different types of recommendation engines:
• Recommend Substitute Products: This is the “if you liked The Barbie Movie then you will also like Terminator 2” type of recommendation.
• Recommend Complementary Products: This is the “you are buying a Samsung Galaxy, why are you not also buying this matching phone case, charger, and screen protection” type of recommendation.
So, here’s what we did:
Changing the Target Metric:
We used to measure the success of the recommendations by comparing revenue per visit in a test vs a control group. Revenue per visit was not the right metric as recommendations have an impact across sessions, so we changed it to gross margin per visitor.
Eliminating AI and Machine Learning:
We realized two things:
1. Machines require relatively little data to come up with good recommendations for substitute products but they do require a lot of data to come up with good recommendations for complimentary products. In other words: A machine needs a lot of training data to know which charger will work with that Samsung Galaxy. We did not have enough data.
2. 50% of Revenues were generated by just 1000 Products.
The second point meant that it was totally feasible to take AI out of the equation and let a human find the perfect complementary products for those 1000 Bestsellers.
All we had to do was keep that Bestseller list updated and write a simple logic that sorted the products chosen by humans using simple business rules (e.g. prefer high-margin items, or items that needed to be cleared from the warehouse).
The result: a 12% increase in Gross Margin per Visitor!
Without any AI and machine learning.
Do you have examples where out-of-the-box thinking beats AI?

-----

Short and concise new post:

Hundreds of hours wasted on AI recommendations.

We found success without AI.

At Rocket Internet, we tried AI to boost revenue with a recommendation engine. 

Results were disappointing. 

Two changes made all the difference:

  • Changed the target metric to gross margin per visitor.
  • Eliminated AI for product recommendations.

Here's what worked:

  • Humans selected complementary products for 1000 bestsellers.
  • Simple logic sorted products based on business rules.

Result: 12% increase in gross margin per visitor.

Sometimes, human intuition beats AI.

P.S.: Join leading data experts and receive tips, strategies, and resources about how to make your CEO and stakeholders love you: https://dataactionmentor.com/signup-free-newsletter/?utm_source=linkedin&utm_medium=social&utm_campaign=post_human_intuition_beats_ai

Note how the agent also creates links including utm parameters independently.

AI Agent 2: Transform a specific content into any template from a list

Another key learning from two years on LinkedIn is this: the message and content of a post are less important than the structure of a post. 

In other words:

- By far the most important thing of a post is the first line. This line hooks attention.

- The second line is the second most important thing. This line makes the reader expand the post and continue reading

- The third most important thing is the rhythm and structure of the body of the post

What I noticed is that all of these can be codified into re-usable templates.

Almost any message can be transported by using various, codified templates.

Here is an example of a template:

The biggest mistake I made as {{Role}}: 

{{Mistake}}. 

{{Add Context}}. Instead, {{Action}}. 

• {{Action}} 

• {{Action}} 

• {{Action}} 

• {{Action}} 

• {{Action}} 

{{Drive Home Points / Summarize Points}}. 

{{Optional: Additional Contextual Line / Summary}}. 

{{Winning Outcome when following the advice}}.

This agent receives one specific LinkedIn post as input, then chooses a fitting target template and creates a new post using the target template and the message and takeaways from the input post.

AI Agent 3: Transform any content piece from a list into a specific template

This agent is similar to Agent 2.

But this time the input is not only one specific post but a whole database of posts. 

It will pick content from the database of posts and transform it into a specific template.

I use this agent if I find a new template that performed well for other creators and want to create a post in the same structure, using my content.

So, agent 2 chooses a template for a specific message, while agent 3 chooses a message for a specific template.

Agent 4: Keep the length and information density of the original post but make sure that sentences are short and well-structured

This agent is similar to Agent 1 but it will only optimize the sentence structure instead of shortening it.

Those are all the agents that I am currently using.

I have started developing agents that will create posts from scratch based on my POVs, my backstories, and other building blocks and I am also working on agents that use a database of old posts as input and create long-form content out of it.

That's it for today.

Watch out for the next episode in one week where I will share a step-by-step guide on how to build these agents.

Whenever you need me, here's how I can help you:

​Data Action Mentor Masterclass​: Create massive business impact with your data team. 

This class is built for ambitious data professionals and data leaders. I spent 17 years building data teams for high-growth companies such as Rocket Internet, Zalando, Takeaway.com, Lazada (acquired by Alibaba), and many more. In this class, I am sharing all my lessons, failures, and successes so that you can make your stakeholders and CEO happy and accelerate your data career.  

Impactful Data Teams for Scale-ups

I build data infrastructure and data teams with immediate business impact for global b2c scale-ups and grown-ups in e-commerce, insurance, fintech, and consumer subscription. My proven approach has helped dozens of scale-ups. I build the infrastructure at a fixed price and then empower the business to move rapidly from data to action. If you know a consumer internet scaleup that needs an impactful data team, hit me up!

Data Audits

I run Data Audits to support you in transforming your data team into a strong business partner. You will get a tailor-made list with action items that will help you create massive business impact with your data team.

Knowledge Base

I am committed to adding actionable, free content to our Data Action Mentor knowledge base to help you on your journey to create massive business impact with your data team