Amazon Attribution Connector

Amazon Attribution is a free, advertising and analytics measurement solution that provides insight into the on-Amazon impact of your marketing strategies across non-Amazon channels including search, social, display, video, email, affiliate/influencer campaigns.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Amazon Attribution

Amazon AttributionYour warehouseLive

profile12 columnsSynced

product_report33 columnsSynced

performance_report_by_adgroup21 columnsSynced

performance_report_by_creative21 columnsSyncing

performance_report_by_campaign19 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Amazon Attribution

Amazon Attribution

Data source

Authenticating...

Ready to connect

Overview

Amazon Attribution in your warehouse.
Ready for your agents.

Amazon Attribution is a free, advertising and analytics measurement solution that provides insight into the on-Amazon impact of your marketing strategies across non-Amazon channels including search, social, display, video, email, affiliate/influencer campaigns. Weld's Amazon Attribution connector is fully managed: it extracts data from Amazon Attribution, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Amazon Attribution data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Amazon Attribution is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 6
fields: 110
relationships: 5

Loading diagram…

advertiser_name

performance_report_by_adgroup

advertiser_name

attributed_add_to_cart_clicks_14_d

attributed_detail_page_views_clicks_14_d

attributed_purchases_14_d

performance_report_by_campaign

advertiser_name

attributed_add_to_cart_clicks_14_d

attributed_detail_page_views_clicks_14_d

attributed_purchases_14_d

attributed_sales_14_d

attributed_total_add_to_cart_clicks_14_d

performance_report_by_creative

advertiser_name

attributed_add_to_cart_clicks_14_d

attributed_detail_page_views_clicks_14_d

advertiser_name

attributed_purchases_14_d

attributed_detail_page_views_clicks_14_d

product_category

account_info_marketplace_string_id

account_info_id

account_info_type

account_info_name

account_info_sub_type

account_info_valid_payment_method

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Amazon Attribution.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Amazon Attribution context, finds the tables it needs and queries your warehouse.

Agent contextAmazon Attribution tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextAmazon Attributiontables6fields110joins5

>

How many profile rows do we have per profile? Use our Amazon Attribution data.

Reading the Amazon Attribution context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.amazon_attribution.profile

raw.amazon_attribution.profile

+ 4 more Amazon Attribution tables

●weld·get_reference_schema

⎿profile · 12 columns

joins profile on profile_id

●weld·run_query

⎿select j.id, count(*) from {{raw.amazon_attribution.profile}} p

join {{raw.amazon_attribution.profile}} j on p.profile_id = j.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Amazon Attribution data in your warehouse

>Ask about your Amazon Attribution dataMCP

Destinations

Load Amazon Attribution into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Amazon Attribution setup guide

Step-by-step instructions to configure and start syncing.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Amazon Attribution connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Amazon Attribution ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "amazon-attribution",
    "destination_schema_name": "amazon-attribution_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Amazon Attribution data to work.

Connect Amazon Attribution, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Amazon Attribution

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors