Using ChatGPT to generate Marketing Content from Images

I thought I'd share a few examples of how you can use ChatGPT for generating marketing content. In this example a product description and tweets about the product.

In the example below I've created images in Midjourney, an AI image generator, and then asked Chat GPT to write product descriptions and tweets. You can see more examples of Midjourney images on my YouTube channel.

Read more


Visualizing Fertility Rates across the World

Visualizing Fertility Rates across the World

I've seen quite a few blogs and videos discussing declining fertility rates and the resulting population decline across the world, so I thought it would be interesting to explore some World Bank data on the topic. These visualizations are based on the Total Fertility Rate metric within the World Bank's World Development Indicators public data set available in Google BigQuery.

Read more


GDP per Capita within African Regions

GDP per Capita within African Regions

In this blog post I'll explore GDP per capita within the regions of Africa.

Read more


Africa's GDP Growth Over Time

Africa's GDP Growth Over Time

I was interest in exploring some World Bank Indicators data to look at Africa's changing GDP over time. So I used Looker Studio to connect to the dataset in BigQuery and visualized the data.

Read more


Analyzing South African Crime data using ChatGPT

Analyzing South African Crime data using ChatGPT

A few years ago I published a blog post analyzing Crime data from the South African Police Service (SAPS) in a blog post. You can read it here. I thought it might be interesting to run the data from Open AI's ChatGPT and see what it analysis it produces.

Read more


ChatGPT explains Programmatic Advertising

The following post is a collection of answers ChatGPT has provided about Programmatic Advertising. Enjoy!

Read more


Kubrick The Matrix made in 1969 (ChatGPT & Midjourney)

The Matrix made in 1969 (ChatGPT & Midjourney)

I decided to ask ChatGPT who it would cast in a hypothetical version of the Matrix made in 1969, and then asked Midjourney to create images based on those choices!

Read more


Visualizing ESKOM Loadshedding Data

Visualizing ESKOM Loadshedding Data

In this post I'll share some visualizations of ESKOM Loadshedding data created in Looker Studio (Google Data Studio). Load shedding in South Africa is a method used by the country's primary power utility, Eskom, to prevent the national electric grid from total collapse. This becomes necessary when the demand for electricity exceeds available supply.

Read more


Visualizing GA4 Geographic Data with Python

Visualizing GA4 Geographic Data with Python

In this post I just wanted to show a couple of basic examples of how you can display Google Analytics 4 data using Python.

Read more


YouTube Analytics Looker Studio Dashboard Template

YouTube Analytics Looker Studio Dashboard Template

I've made a YouTube Analytics template for Looker Studio that you can download from the ByMarketers website. I used YouTube Analytics data from my own small channel where I've messing around with AI generated images.

Here is the link to view the YouTube Analytics template.

Read more