Analyse your WooCommerce data with ChatGPT

Learn how to use ChatGPT and PixelYourSite to understand your WooCommerce sale sources and more

Get valuable insights about UTMs, traffic sources, landing pages

Enrich your WooCommerce data

PixelYourSite will track key info like the traffic source, landing pages, UTMs and add them to your WooCommerce orders.

Add product cost (optional)

WooCommerce Cost of Goods lets you add the cost for your products and will calculate the profit for each order.

Export ChatGPT file

PixelYourSite Professional will export a complex file with all the data.

ChatGPT will analyse your data

ChatGPT Code Interpreter (paid version) will analyse your WooCommerce data.

ChatGPT prompt examples you can use to analyse your WooCommerce data:

Start with a preparing prompt:

Hello, data analyst! I have an online marketing dataset that I’d like you to analyze. Please provide clear insights, generate relevant visualizations, and offer actionable recommendations based on the data. Ensure all visuals are downloadable for my use. Let’s get started!

ChatGPT general prompt:

Analyze the data and create 10 useful reports for a marketing agency, using visuals as much as possible. Let me download each visual. 

ChatGPT prompt to generate Google Analytics monetization style reports:

Create reports similar to Google Analytics Monetisation. Let me download each visual.

Ask ChatGPT to find something interesting in your data:

Analyze the provided dataset, focusing on sales, campaigns, customer behavior, and time patterns. Identify and explain the five most insightful observations that can help in optimizing marketing strategies and customer engagement. Please include any patterns, anomalies, or unique characteristics that stand out in the data.

Ask ChatGPT for advice based on the data:

Based on the analysis of the provided dataset, please identify key insights related to campaigns, landing pages, customer behavior, sales patterns, and advertising channels. For each insight, provide specific actionable recommendations that could be implemented to optimize marketing strategies, enhance customer engagement, and increase sales. Ensure that the advice is tailored to the unique characteristics and patterns observed in the data.

Ask ChatGPT specific questions. Here are some examples:

What is the best-performing campaign?

What landing page generated the most sales?

What is the email of my best customer?

At what hour most sales occurred? Use event_time.

ChatGPT prompts to understand product performance:

1. Product-Specific Campaign Analysis:

a. Which UTM campaigns were most successful in promoting specific products or product categories? b. How did individual products perform across different UTM campaigns?

2. UTM Source & Medium Effectiveness for Products:

a. What were the most effective UTM sources for selling specific products or categories? b. How did the performance of different products vary across UTM sources and mediums?

3. Product & Content Relationship:

a. Which UTM contents and terms were most associated with the sales of specific products?

4. Product Sales & Geographic Insights:

a. How did specific UTM campaigns perform in selling products across different regions or countries?

ChatGPT prompts to understand traffic source performance:

  1. Traffic Source Effectiveness: a. How do different traffic sources perform in terms of sales, cost, and profit?

  2. Traffic Source and Geographic Insights: a. How do traffic sources perform across different regions or countries?

  3. Traffic Source and Landing Page Performance: a. How do different traffic sources perform with various landing pages?

ChatGPT prompts to understand the relation between orders total, product cost, and profit:

These are some useful prompts if you use our WooCommerce Cost of Goods plugin:

Total is under total_sales, landing pages are under landing_page.

1. UTM Campaign and Product Cost:

a. How does the total cost of products vary across different UTM campaigns?

2. Profit Analysis by UTM Campaign:

a. What are the profit margins for different UTM campaigns?

3. Landing Page and Product Cost Analysis:

a. How do different landing pages perform in terms of product cost and profit?

4. Traffic Source and Product Cost:

a. How is the total cost of products distributed across different traffic sources (UTM sources)?