Agencies · Customers · Personality Eda P1778698833
Executive Summary

Executive Summary

Executive summary of customer characteristics and spending patterns

Customers Analyzed
2000
Average Age
55.2
Average Annual Income
52140
Average Total Spending
609.2
Campaign Response Rate (%)
15
Average Campaigns Accepted
0.45
Analysis of 2000 customers reveals average age of 55.2 with median annual income of $52,140. Total spending averaged $609.20 with significant variation across customers. Campaign response rate was 15.0%, with customers accepting an average of 0.45 offers. These segments offer distinct targeting opportunities based on demographics and spending patterns.
Interpretation

Analysis of 2000 customers reveals average age of 55.2 with median annual income of $52,140. Total spending averaged $609.20 with significant variation across customers. Campaign response rate was 15.0%, with customers accepting an average of 0.45 offers. These segments offer distinct targeting opportunities based on demographics and spending patterns.

Overview

Analysis Overview

Overview of the analysis and data represented

Customers Analyzed2000
Average Age55.2
Average Annual Income52140
Average Total Spending609.2
Campaign Response Rate (%)15
Average Campaigns Accepted0.45
Data Preparation

Data Quality & Processing

Data quality and preprocessing information

Customers Analyzed2000
Average Age55.2
Average Annual Income52140
Average Total Spending609.2
Campaign Response Rate (%)15
Average Campaigns Accepted0.45
Data Table

Demographic Summary Statistics

Customer counts, age, income, and spending vary significantly by education and marital status

Education LevelMarital StatusAvg AgeAvg IncomeN CustomersAvg Total SpendingAvg Campaign Acceptance
MasterWidow70.35840211817.51.09
PhDWidow67.85894422771.80.59
MasterSingle53.45267866712.50.5
PhDMarried56.557111179695.40.5
GraduationWidow61.25471230688.10.5
GraduationTogether55.754042255682.30.45
2n CycleDivorced59.34934520654.10.5
PhDDivorced59.85293149644.50.71
PhDTogether58.7556991086380.43
MasterAlone666133116320
GraduationDivorced56.955697104628.70.51
PhDSingle56.45362494626.90.63
GraduationSingle51.8515112256190.5
GraduationMarried53.651046377599.30.4
MasterMarried56.953595124587.50.44
MasterTogether58.65260993569.40.33
MasterDivorced55.949919325530.22
2n CycleSingle50.95290436514.20.44
2n CycleTogether50.94651153496.50.23
2n CycleWidow62455264455.20
2n CycleMarried50.54545572407.40.35
BasicMarried45.7219281589.130.13
GraduationAlone36341761890
BasicTogether52.5216711260.080.5
BasicSingle41.9180251555.670
PhDAlone51358601492
BasicDivorced4895481290
Interpretation

Across 27 demographic segments, average age ranges from 36.0 to 70.3 years. Average total spending ranges from $29 to $818. Higher education and coupled marital statuses show higher average spending patterns. Campaign acceptance varies from 0.00 to 2.00 offers per customer across demographic groups.

Visualization

Customer Age Distribution

Distribution of customer ages reveals age concentration and outlier patterns

Interpretation

Customer ages range from 28 to 131 years. The mean age is 55.2 years (median 54.0), with standard deviation of 12.0 years. The distribution shows tight spread, with most customers concentrated in specific age cohorts relevant for lifecycle marketing targeting.

Visualization

Customer Income Distribution

Income distribution shows customer purchasing power, with ~26% missing values

Interpretation

Among 1983 customers with income data (0.8% missing), mean annual income is $52,140 with median $51,518. The distribution shows relatively balanced income levels, suggesting similar customer segments for premium vs. value positioning.

Visualization

Total Spending Distribution

Concentration of customer spending reveals whale customers and spending variance

Interpretation

Mean spending is $609.20 (median $397.00). The 75th percentile is $1047.25 and 95th percentile is $1779.15, indicating significant whale customers. The right-skewed distribution suggests segmentation opportunities between volume and value customers.

Visualization

Average Spending by Education Level

Spending varies by education attainment

Interpretation

Average spending by education level ranges from $67.95 to $664.29. PhD customers spend the most at $664.29 on average. The substantial (>50%) difference in spending between highest and lowest education groups suggests targeted product positioning opportunities.

Visualization

Average Spending by Marital Status

Marital status groups show distinct spending patterns

Interpretation

Average spending by marital status ranges from $256.67 to $722.96. Widow customers spend the most at $722.96 on average. Household composition differences by marital status drive substantial variation in total spending patterns.

Visualization

Product Category Spending Profile

Average spending by product category reveals purchasing priorities

Interpretation

Wine is the highest-spending category at $306.06 average per customer. Top 3 categories account for the majority of spending, suggesting focus areas for inventory and marketing. The category distribution reflects customer preference patterns and premium product affinity.

Visualization

Income vs Total Spending Relationship

Relationship between customer income and total spending, colored by marital status

Interpretation

The correlation between annual income and total spending is 0.795, indicating a strong relationship. Customers with higher incomes tend to spend substantially more, with marital status showing distinct patterns. This suggests income and household composition both drive spending behavior.

Visualization

Product Category Spending Correlations

Correlation matrix shows which product categories are purchased together

Interpretation

Strong correlations (max 0.581) between certain product categories indicate bundled purchasing patterns. Customers who spend on premium categories like Wine and Meat tend to spend on complementary categories, suggesting cross-sell and bundle opportunities.

Data Table

Top 10 Customers by Total Spending

Profile of highest-value customers and their characteristics

RankCustomer IDAgeIncomeEducationTotal SpendingCampaigns Accepted
157353390638Master25251
253503390638Master25252
317633687679Graduation25244
445805575759Graduation24864
544757569098PhD24400
654536890226Master23521
7101335493790Graduation23494
890105283151Master23464
953867194384Graduation23024
1060247194384Graduation23024
Interpretation

The top 10 customers spend $2415.10 on average, 4.0 times the overall average of $609.20. These customers tend to have specific education and demographic profiles. Targeted retention and upsell strategies for this group can significantly impact revenue.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing