A comprehensive analysis of global online retail performance, customer behaviour, and revenue drivers — presented to the CEO & CMO.
Good [morning/afternoon]. Thank you for your time today. I'm here to walk you through a data-driven analysis of our online retail performance — specifically addressing the four strategic questions you raised. My goal is to give you clear, actionable insights you can use immediately.
Before diving into the findings, I want to briefly walk you through the data preparation process, because good analysis starts with clean data.
We worked with an online retail transactional dataset spanning January through July 2011, covering invoices, stock codes, quantities, unit prices, customer IDs, and country of purchase.
During the data cleaning phase, I removed records with negative quantities — these represented returns and cancellations which would have skewed our sales figures. I also excluded transactions with null customer IDs, as these couldn't be attributed to tracked buyer behaviour. Unit prices of zero were likewise filtered out to avoid distorting revenue calculations.
For the geographic analysis, United Kingdom transactions were excluded from the international comparisons, as the UK represents the home market and operates under different commercial dynamics — allowing us to focus on international expansion opportunities. The result is a clean, reliable dataset that forms the foundation of everything I'll present today.
The first question was: "Which countries have strong online retail buying behaviour?" To answer this, I looked at both sales quantity and sales revenue across all international markets.
Looking at the Top 5 Countries by Quantity Sold, the results are clear. Netherlands leads significantly with over 73,000 units sold, followed by EIRE at approximately 58,700, Germany at 48,900, France at 41,000, and Australia at 40,900. These five countries represent our strongest international markets in terms of pure purchase volume.
Equally important is the flip side — the Bottom 5 countries by sales quantity: Saudi Arabia, USA, Bahrain, Czech Republic, and Brazil. These countries show very low purchase volumes — in some cases fewer than 100–360 units over the entire period. This tells us these are currently underperforming markets and likely not worth heavy investment without further investigation.
Netherlands and EIRE are your strongest international online retail markets by volume. These are the markets that genuinely understand and engage with online buying — a strong signal for where to prioritise marketing spend and inventory planning.
The second question asked us to identify the countries driving the most revenue — excluding the UK. This is slightly different from just volume, because a country might buy many low-value items or fewer high-value ones.
The revenue picture tells an interesting story. EIRE leads with £124,720, followed by Netherlands at £104,228, Germany at £95,392, France at £73,990, and Australia at £60,312. Notably, EIRE — which ranked second in quantity — actually leads in revenue, suggesting its customers are purchasing higher-value products.
The Pareto analysis is particularly valuable for strategic decisions. The curve shows that just 5 countries — EIRE, Netherlands, Germany, France, and Australia — contribute approximately 80% of total international revenue. The remaining 30+ countries collectively account for the rest. This is a classic 80/20 pattern, and it has direct implications for where we should focus resources.
The median revenue box plot further confirms that while individual country revenues vary widely, the median transaction values cluster in a relatively tight band — suggesting consistent basket sizes across most markets, with outliers at the top end driven by EIRE and Netherlands.
Focus international expansion investment on EIRE, Netherlands, and Germany — they deliver both volume and value. Countries like Singapore, Belgium, and Finland show moderate revenue with growth potential and merit consideration for targeted campaigns.
This is one of the most strategically important findings today. The CMO asked specifically which of the three top markets has shown growth momentum in the last three months — May, June, and July 2011.
Looking at the sales trend charts across all three metrics — quantity sold, revenue, and invoice count — a clear story emerges. EIRE shows a strong and consistent upward trajectory from April onwards. Its revenue line climbs steeply through May and July, reaching nearly £47,000 in July — its highest point in the dataset. Its invoice count also rises significantly, meaning more transactions, not just larger ones.
By contrast, Netherlands shows a declining trend from its strong January start, falling sharply in the latter months. Germany remains relatively stable but does not show the same growth trajectory as EIRE. The Tableau dashboard confirms this pattern across revenue, quantity, and order count simultaneously.
This means EIRE is the market that has genuinely picked up momentum in the last three months of our data. If the CMO is considering where to deploy a campaign or increase marketing investment, EIRE presents both the strongest baseline and the strongest growth signal.
EIRE is your growth market. It leads in revenue, it's accelerating in volume, and it's generating more repeat invoices. Netherlands, despite strong volume, is showing signs of saturation or declining engagement and may benefit from a retention-focused strategy.
The fourth question digs into customer purchasing behaviour — specifically, how many times are customers buying, and what's the latency between their first and second purchase?
The purchase frequency histogram tells a stark story. The overwhelming majority of customers — over 1,300 — make only 1 purchase in the observed period. The number drops sharply to about 560 for two purchases, and continues to decline steeply from there. This right-skewed distribution is very typical of online retail, but it flags a critical challenge: we are not converting enough one-time buyers into repeat customers.
To understand the customer base holistically, we segmented all customers using RFM analysis — that's Recency, Frequency, and Monetary value. Seven distinct segments emerged. The largest group is Look-Out Buyers — nearly 2,000 customers who are recent but infrequent. Big Spenders have high monetary value but low frequency, while Best Customers are small in number but extremely high-value — high frequency, high spend, and recent activity.
The RFM table shows Best Customers have an average spend of £7,447 compared to just £117 for Occasional Buyers. This segmentation is directly actionable — different segments need different communication strategies, different offers, and different retention tactics.
To summarise the four key findings from our analysis:
First, Netherlands and EIRE lead in online retail buying behaviour by purchase volume internationally. Second, EIRE, Netherlands, Germany, Asc;, France, and Australia drive approximately 80% of international revenue — a clear indication of where to focus. Third, EIRE is the standout growth market in the last three months, with increasing revenue, volume, and invoice frequency. And fourth, customer retention is our biggest commercial opportunity — with a high one-time buyer rate and only Asc; of returning customers spending more on their second order.
The data is telling a consistent story: we have a strong core market in EIRE that's growing, and a Asc; that, if addressed, could unlock significant incremental revenue without acquiring a single new customer.
I'm happy to go deeper on any of these areas, or discuss specific next steps. Thank you.
Approximate timing: Opening (45s) + Q1 (60s) + Q2 (70 Asc;) + Q3 (70s) + Q4 (75s) + Close (40s) = ~6 min 0 sec. Speak at a relaxed, executive pace. You can tighten each section by Asc; to hit exactly 5 minutes. Avoid reading verbatim — use this as speaking notes and speak naturally.