Instructional Queries
      Back to home
      1. Knowledge Base
      2. Intentwise Explore (AMC)
      3. Instructional Queries

      DSP Campaign Performance by Geo Location

      Learn more about DSP Campaign Performance by Geo Location query and how you can utilize it on Intentwise Explore (AMC)

      DSP Campaign Performance by Geo Location

      The Campaign Performance by Geo Location dashboard helps you understand how your DSP campaigns are performing across different geographies. It provides both a high-level overview and detailed breakdowns, so you can identify which regions, campaigns, and audiences are driving sales and efficiency.  

      Dashboard Overview

      At the top of the dashboard, you’ll find key performance metrics such as:

      • Impressions – Total number of ad impressions served.

      • Unique Reach – Distinct users reached across campaigns.

      • Detail Page Views – Number of users who visited product detail pages.

      • Purchased Users – Number of unique users who made a purchase.

      • Total Sales – Sales revenue generated from DSP campaigns.

      • Spend – Total advertising spend.

      • Purchase Rate – Conversion rate from impressions to purchases.

      This overview helps you quickly gauge the reach and effectiveness of your campaigns.

      Geographic Performance Map

      The Geographic Performance Map provides a visual representation of performance across countries and regions. Larger and darker circles indicate higher sales volume.

      For example, in the screenshot below, the majority of sales are concentrated in the United States, with hotspots in New York, California, and Illinois.

      Top 10 Regions by Total Sales

      The dashboard also highlights the Top 10 Regions by Total Sales, along with ROAS (Return on Ad Spend).

      For instance:

      • New York generated $281 in sales with a ROAS of 3.9.

      • Illinois drove $175 in sales with a ROAS of 4.1.

      • California contributed $125 in sales, but at a higher ROAS of 6.0.

      This view makes it easy to identify high-value regions where your ad spend is most effective.

      Top 5 Campaigns by Total Sales

      Next to the regional data, you can see the Top 5 Campaigns by Total Sales.

      For example:

      • Drones Hobby Kit – Consideration led with $400 in sales.

      • Drones – Radio Controller Retargeting followed with $375 in sales.

      • Drones – Retargeting contributed $216 in sales.

      This allows you to compare performance across campaigns and evaluate which strategies are driving conversions.

      Detailed Geographic Performance

      Finally, the Detailed Geographic Performance table provides a granular view of performance across regions, including:

      • Total Sales

      • Unique Reach

      • Detail Page Views

      • Purchased Users

      • Purchase Rate

      • Spend

      • Impressions

      • ROAS

      For example:

      • California generated $125 in sales from 7,664 unique users, with a ROAS of 6.0.

      • New York drove $281 in sales at a 4.34% purchase rate and a ROAS of 3.9.

      • Illinois delivered $175 in sales, converting at 4.98% with a ROAS of 4.1.

      How it works

      1. Navigate to Intentwise Explore

      2. Go to Queries > Query Library

      3. Search for and add "DSP Campaign Performance by Geo Location" to your saved queries

      4. Fill in the required parameters and run the query (see this article for detailed settings)

      5. Once executed, access the results under the Insights section for product-level metrics and visualizations.

      This table is particularly useful for advertisers who want to make data-driven decisions about where to scale spend and which geographies deliver the strongest ROI.

      For more information, refer to our data model. 

      Key Use Cases

      • Identify high-value regions: Spot states or countries where your campaigns deliver the strongest sales and ROAS.

      • Budget allocation: Shift spend toward geographies with the highest purchase rates and returns.

      • Campaign comparison: Understand which campaigns perform best in different regions.

      • Regional optimization: Tailor messaging and targeting strategies based on geographic results.

      • Market expansion: Discover untapped geographies where impressions are high but conversion rates are low.

      Recommendations

      • Double down on high-ROAS regions. If a state like California shows a ROAS of 6.0, consider scaling spend there.

      • Optimize underperforming regions. If impressions are high but purchase rates are low, refine targeting or creative for those geographies.

      • Test localized campaigns. Run campaigns with region-specific messaging where performance is strong.

      • Balance acquisition and efficiency. Consider both purchase rate and ROAS when reallocating budget.

      • Use campaign filters. Evaluate how different campaign types (e.g., retargeting vs. consideration) perform across geographies.

      Frequently Asked Questions (FAQs)

      What are instructional queries?

      Amazon Marketing Cloud's (AMC) instructional queries provide pre-written SQL code that AMC users can use as is or modify for common measurement and analytics tasks. 

      Can I filter by specific campaigns or ad types?

      Yes, you can filter by campaign name to view only the relevant geo performance.