---
title: Custom Attribution Last Touch
description: Learn more about the instructional query, Custom Attribution Last Touch, and how to use it on Intentwise Explore (AMC).
---

[Skip to content](https://help.intentwise.com/custom-attribution-last-touch#main-content)

![footer-logo.png\]](https://help.intentwise.com/hs-fs/hubfs/footer-logo.png?width=210&height=40&name=footer-logo.png)

Open main navigation

Close main navigation

 Advice and answers from Intentwise

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.intentwise.com/?hsLang=en)
2. [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en)
3. [Instructional Queries](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries)

# Custom Attribution Last Touch

## Learn more about the instructional query, Custom Attribution Last Touch, and how to use it on Intentwise Explore (AMC).

### Custom Attribution Last Touch

Use the "Custom Attribution - Last Touch" instructional query in Amazon Marketing Cloud (AMC) to identify the final touchpoints before purchase and understand what drives conversions. 

This query assigns full conversion credit to the final ad interaction that occurred before purchase. It helps marketers:    

- Identify the last campaign or channel that influenced a purchase
- Evaluate the performance of lower-funnel strategies
- Allocate spend more effectively based on closing impact

#### Dashboard Overview ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Sep-17-2025-09-42-32-2027-AM.png?width=670&height=302&name=image-png-Sep-17-2025-09-42-32-2027-AM.png)

At the top of the dashboard, you see **summary KPIs** under the Last Touch attribution model:

- **Unique Reach (40.57M)** – Distinct shoppers reached across campaigns.
- **Total Sales ($1.98M)** – Revenue attributed to the final ad exposure before purchase.
- **Purchased Users (51.64K)** – Unique users who converted.
- **Total Purchases (72.26K)** – Number of purchase events tied to last-touch exposures.
- **Impressions (97.37M)** – Total ad impressions served.
- **Clicks (511.50K)** – Clicks on ads.
- **CTR (0.53%)** – Click-through rate.
- **AOV ($20.6)** – Average revenue per purchase.

This top section gives you a **high-level view** of campaign performance when measured by last-touch attribution. 

#### Top 5 Campaigns by Total Sales ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Sep-17-2025-09-43-42-5061-AM.png?width=670&height=479&name=image-png-Sep-17-2025-09-43-42-5061-AM.png)

This section ranks the **campaigns that closed the most sales** under the Last Touch model.

- **Drone Camera** led with **$308.8K in sales** and **14.4K units sold**.
- **Drone Batteries** followed with **$294.4K in sales** and **11.9K units sold**.
- **Drone Decals** contributed **$192.3K** across 8K units.
- **Handheld Drones** generated **$90.4K** in sales.
- **Drone App** added **$88.3K**.

This helps identify which campaigns acted as the final touchpoint most effectively.

#### Performance by Ad Type ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Sep-17-2025-09-44-02-0963-AM.png?width=670&height=457&name=image-png-Sep-17-2025-09-44-02-0963-AM.png)

This visualization compares **Total Sales** and **Conversion Rate** across ad types.

- **DSP** delivered the highest attributed sales (**$1.29M**) and the strongest **conversion rate (0.75%)**.
- **Sponsored Products (SP)** contributed **$604.1K**, but with a lower conversion rate (**0.10%**).
- **Sponsored Brands (SB)** added **$84.1K** in sales at a modest conversion rate.
- **Sponsored Display (SD)** was the smallest driver with **$6.55K in sales** and a **0.06% conversion rate**.

This highlights which ad types perform best as last-touch “closers” in the funnel.

#### Campaign Performance Table 

The table provides a **granular breakdown** of each campaign’s contribution under the Last Touch model.

For each campaign, you can see:

- **Unique Reach** – Distinct shoppers reached.
- **Impressions** – Number of times ads were served.
- **Clicks** – Number of ad clicks.
- **Total Sales** – Revenue attributed to the campaign as the final exposure.
- **Purchased Users** – Unique converters.
- **Total Purchases** – Number of purchase events.
- **AOV** – Average revenue per purchase.
- **CTR** – Click-through rate.

![](https://help.intentwise.com/hs-fs/hubfs/image-png-Sep-17-2025-09-44-41-8443-AM.png?width=670&height=284&name=image-png-Sep-17-2025-09-44-41-8443-AM.png)

Example insights from the table:

- **SP-A Drone Camera (Catchall)** generated **$88.3K in sales** with **3,281 converters**.
- **SP-A Handheld Drones** drove **$34.7K** with a strong CTR (**0.57%**).
- **SB Drone Batteries** delivered **$15.3K** in sales with **508 converters**, despite a modest CTR (**0.11%**).

This table allows you to drill down and compare performance across individual campaigns.

### How It Works

1. Navigate to **Intentwise Explore![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-10-54-49-9056-AM.png?width=3342&height=2082&name=image-png-Jun-26-2026-10-54-49-9056-AM.png)**
2. Go to **Queries \> Query Library![](https://help.intentwise.com/hubfs/image-png-Jun-26-2026-10-47-13-8319-AM.png)**
3. Search for and add **"Custom Attribution - Last Touch"** to your saved queries![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-10-56-08-6726-AM.png?width=3340&height=2080&name=image-png-Jun-26-2026-10-56-08-6726-AM.png)
4. Fill in the required parameters and run the query *(see [this article](https://help.intentwise.com/amc-queries-explained?hsLang=en) for detailed settings)![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-10-56-38-8940-AM.png?width=3344&height=2080&name=image-png-Jun-26-2026-10-56-38-8940-AM.png)*
5. Once executed, access the results under the **Insights** section for campaign-level metrics and visualizations.![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-11-03-35-0940-AM.png?width=3334&height=2082&name=image-png-Jun-26-2026-11-03-35-0940-AM.png)

For more information, refer to our [data model](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/amazon-marketing-cloud#iq-custom-attribution-last-touch).

### Key Use Cases

- **End-of-Funnel Analysis:** Identify which ads or channels are driving conversions
- **Budget Optimization:** Shift investment toward the most impactful touchpoints
- **Performance Reporting:** Attribute conversions to the most recent interactions

**Tip:** Use this alongside multi-touch attribution models to get a balanced view of influence across the funnel

### Recommendations

- **Use in combination.** Relying only on Last Touch may overvalue retargeting campaigns. Compare with multi-touch models for balance.
- **Spot “closer” campaigns.** Campaigns that repeatedly show up as last-touch drivers may deserve more budget for bottom-funnel performance.
- **Evaluate ACOS and ROAS carefully.** Last Touch can make ROAS look inflated for retargeting-heavy campaigns, so consider it as part of a bigger attribution picture.
- **Segment by ad type.** Analyze how DSP, SP, SD, and SB each contribute as final touchpoints.
- **Use for tactical optimization.** Last Touch is useful for campaign-level fine-tuning but should not be the only attribution model for strategic decisions.

### 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. 

#### **How is Last Touch different from First Touch attribution?**

*Last Touch* credits the final ad exposure before purchase. *First Touch* credits the first ad exposure that introduced the shopper to the brand.

- [Getting started](https://help.intentwise.com/getting-started?hsLang=en)
- [Intentwise AI Gateway](https://help.intentwise.com/intentwise-ai-gateway?hsLang=en)
- [Intentwise Ad Optimizer](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#main-content)

    - [Account and Campaign Setup](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#account-and-campaign-setup)
    - [Optimization](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#optimization)
    - [Reporting](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#reporting)
    - [Dashboard Overview](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#dashboard-overview)
    - [Resources](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#resources)
    - [Amazon DSP](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#amazon-dsp)
    - [Additional Features](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#additional-features)
    - [Walmart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#walmart)
    - [Criteo](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#criteo)
    - [Instacart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#instacart)
- [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#main-content)

    - [AMC](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#amc)
    - [Instructional Queries](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries)
- [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#main-content)

    - [Kickstart Guide](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#kickstart-guide)
    - [Configuring Reporting Tools](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-reporting-tools)
    - [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline)
    - [Data Sources](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#data-sources)
    - [Looker (Google Data) Studio Tutorials](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#looker-google-data-studio-tutorials)
    - [Intentwise Templates](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-templates)
    - [Intentwise Analytics Cloud features](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-analytics-cloud-features)
    - [White Label](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#white-label)
- [Intentwise Marketplace Intelligence](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#main-content)

    - [Content Analytics (CA)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#content-analytics-ca)
    - [Share Of Voice (SOV)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#share-of-voice-sov)
- [Frequently Asked Questions (FAQs)](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#main-content)

    - [Access and Setup](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#access-and-setup)
    - [Billing](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#billing)
    - [Platform](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#platform)
    - [Reporting](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#reporting)

intentwise.com Help Center

Copyright © 2026, Intentwise Inc.