Marketing and ChatGPT

Posted by Christopher Farm on January 18, 2023 · 1 min read

The advertising industry is constantly evolving, and the use of ChatGPT with data warehousing will change the learning curve for digital marketers. The new tech is set to revolutionize the way advertisers make decisions, providing them with easy access to data-driven insights through natural language queries.

As an example, imagine a mobile marketer wants to know which sites (advertised on) drove an in app purchase in the last 90 days. They would simply ask ChatGPT: ‘Which site ids generated a purchase in the last 90 days?’

ChatGPT would then generate the following SQL query to retrieve this information from the data warehouse:

SELECT site_id FROM events
WHERE event_type = 'purchase' AND created_at >= (NOW() - INTERVAL 90 DAY);

This query would select the “site_id” column from the “events” table where the “event_type” column is “purchase” and the “created_at” column is greater than or equal to the current date minus 90 days.

This is a simple example that describes ChatGPT’s ability to quickly provide SQL for marketers who don’t know how to write it. Advertisers will be able to make more informed decisions based on actual data without an analyst, lowering wait times, increasing iteration speed, and increasing productivity.