How do I use the "Visualize Geographic Sales Data" prompt?

Copy the prompt template, fill in the variables (TIME_PERIOD, GEOGRAPHIC_SCOPE, SALES_METRICS, PRODUCT_TYPE, DATA_FORMAT), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Start with a simple choropleth map before adding complex interactive features Use consistent color schemes across all visualizations to avoid confusion Include population density or market size data to normalize sales performance comparisons Test your visualizations with actual stakeholders to ensure clarity and usefulness Consider seasonal patterns when selecting time periods for geographic analysis

data intermediate

Visualize Geographic Sales Data

Generate comprehensive geographic sales visualizations with detailed analysis. Create maps, charts, and insights from your sales data.

Works with: chatgptclaudegemini

Prompt Template

You are a data visualization expert specializing in geographic sales analysis. I need you to create a comprehensive visualization strategy for my sales data across different geographic regions. **Sales Data Context:** - Time Period: [TIME_PERIOD] - Geographic Scope: [GEOGRAPHIC_SCOPE] - Sales Metrics: [SALES_METRICS] - Product/Service Type: [PRODUCT_TYPE] - Data Format: [DATA_FORMAT] **Requirements:** 1. Recommend the most effective visualization types for this geographic sales data (maps, charts, dashboards) 2. Suggest specific tools and technologies for implementation 3. Provide detailed specifications for each visualization including: - Color schemes and legends - Data aggregation levels - Interactive features - Key performance indicators to highlight 4. Design a logical layout that tells a coherent story about sales performance across regions 5. Include recommendations for filtering and drill-down capabilities 6. Suggest complementary charts that support the geographic analysis 7. Provide guidance on handling data quality issues specific to geographic data 8. Recommend best practices for mobile responsiveness and accessibility **Deliverables:** - Detailed visualization specifications - Implementation roadmap with priorities - Data preparation guidelines - Key insights to highlight in the visualizations Focus on creating actionable, business-oriented visualizations that help stakeholders quickly identify geographic trends, opportunities, and performance gaps.

Variables to Customize

[TIME_PERIOD]

The time range of your sales data

Example: Q1-Q4 2023, monthly granularity

[GEOGRAPHIC_SCOPE]

The geographic regions covered in your data

Example: United States by state and major metropolitan areas

[SALES_METRICS]

The specific sales metrics you want to visualize

Example: Revenue, units sold, average order value, customer acquisition cost

[PRODUCT_TYPE]

The products or services being analyzed

Example: SaaS subscription software with three pricing tiers

[DATA_FORMAT]

How your data is currently structured

Example: CSV files with columns for date, state, city, product_tier, revenue, units

Example Output

## Geographic Sales Visualization Strategy ### Primary Visualizations **1. Choropleth Map - Revenue by State** - Tool: Tableau or Power BI with built-in mapping - Color scheme: Blue gradient (light to dark) representing revenue intensity - Interactive features: Hover tooltips showing exact revenue, units sold, and YoY growth - Drill-down capability: Click state to view metropolitan area breakdown **2. Bubble Map - Metropolitan Performance** - Bubble size: Total revenue - Bubble color: Average order value (green-yellow-red scale) - Overlay: Customer acquisition cost as secondary metric **3. Supporting Charts** - Horizontal bar chart: Top 10 performing states with growth indicators - Line chart: Monthly revenue trends for top 5 regions - Heat map: Product tier performance by geographic region ### Implementation Roadmap 1. **Week 1**: Data cleaning and geocoding validation 2. **Week 2**: Primary map development and testing 3. **Week 3**: Supporting chart integration and dashboard layout 4. **Week 4**: Interactive features and mobile optimization ### Key Insights to Highlight - Revenue concentration patterns and market penetration gaps - Seasonal geographic variations in sales performance - Product-market fit variations by region - Correlation between population density and sales velocity ### Data Quality Considerations - Standardize state/city naming conventions - Handle missing geographic coordinates - Account for sales territory boundary changes

Pro Tips for Best Results

Start with a simple choropleth map before adding complex interactive features
Use consistent color schemes across all visualizations to avoid confusion
Include population density or market size data to normalize sales performance comparisons
Test your visualizations with actual stakeholders to ensure clarity and usefulness
Consider seasonal patterns when selecting time periods for geographic analysis