Explore

Tables Doc

1. maplemonk.KA_ams_sb_traffic

Description:

Stores raw hourly traffic metrics for Sponsored Brands (SB) ads from the Amazon Advertising API.

2. maplemonk.KA_ams_sb_conversion

Description:

Holds conversion metrics for Sponsored Brands (SB) ads from the Amazon Advertising API, including attributed sales, conversions, and new-to-brand data under a 14-day attribution window.

3. maplemonk.KA_AA_SB_CONSOLIDATED_HOURLY_DATA

Description:

A consolidated hourly view of Sponsored Brands traffic and conversion metrics. Created by joining KA_ams_sb_traffic and KA_ams_sb_conversion on matching keys, aggregated by date and hour.

4. maplemonk.KA_ams_sd_traffic

Description:

Stores raw hourly traffic metrics for Sponsored Display (SD) ads.

5. maplemonk.KA_ams_sd_conversion

Description:

Holds conversion metrics for Sponsored Display (SD) ads with a 14-day attribution window.

6. maplemonk.KA_AA_SD_CONSOLIDATED_HOURLY_DATA

Description:

A consolidated hourly view for Sponsored Display ads, combining KA_ams_sd_traffic and KA_ams_sd_conversion.

7. maplemonk.KA_ams_sp_traffic

Description:

Stores raw hourly traffic metrics for Sponsored Products (SP) ads.

8. maplemonk.KA_ams_sp_conversion

Description:

Holds conversion metrics for Sponsored Products (SP) ads.

9. maplemonk.KA_AA_SP_CONSOLIDATED_HOURLY_DATA

Description:

A consolidated hourly view for Sponsored Products ads, joining KA_ams_sp_traffic and KA_ams_sp_conversion.

10. maplemonk.KA_amazon_ads_campaign_details

Description:

Stores campaign-level metadata (names, statuses, etc.) for Amazon Ads campaigns.

11. maplemonk.KA_amazon_ads_adgroup_details

Description:

Contains ad group metadata for campaigns.

12. maplemonk.KA_amazon_ads_ad_details

Description:

Details about individual ads (often for product-level or creative-level details).

13. maplemonk.KA_amazon_ads_targeting_details

Description:

Holds targeting metadata (e.g., audience-based, product-based, or keyword-based targeting) for ads.

14. maplemonk.KA_amazon_ads_keyword_details

Description:

Contains keyword-level metadata (e.g., status, bid, match type) for campaigns.

15. maplemonk.KA_amazon_ads_profile_details

Description:

Contains Amazon Ads profile-level metadata, linking profiles to countries, seller IDs, and account types.

16. MapleMonk.KA_secondary_sales_consolidated

Description:

A table containing secondary sales data (e.g., quantity sold) from multiple channels/marketplaces, used to determine share of sales by marketplace and date.

17. maplemonk.ASP_BR_TRAFFIC_FACT_ITEMS

Description:

Contains traffic data (page views, sessions) for Seller Central (Brand Registry) items.

18. maplemonk.KA_Amazon_Vendor_Central_Traffic_Fact_Items

Description:

Contains traffic data for Vendor Central items (similar to ASP_BR_TRAFFIC_FACT_ITEMS but for Vendors).

19. maplemonk.KA_AMAZON_ADS_HOURLY_DATA_CONSOLIDATED_INTERMEDIATE

Description:

An intermediate union of the three Sponsored Ads consolidated tables (SB, SD, SP), enriched with campaign/ad group/ad/targeting/profile details. This table standardizes the columns and unifies them under a single structure for further processing.

20. maplemonk.KA_AMAZON_ADS_HOURLY_DATA_CONSOLIDATED

Description:

A further-enriched dataset that adjusts the raw metrics (sales, spend, impressions) using logic to split or attribute sales across different Amazon channels/marketplaces. It joins the intermediate table with:

KA_secondary_sales_consolidated (units/quantity)

ASP_BR_TRAFFIC_FACT_ITEMS (views for Seller Central)

KA_Amazon_Vendor_Central_Traffic_Fact_Items (views for Vendor Central)

to allocate partial or full credit to a specific channel, based on share of units or page views.

///// Signing off 12/02/2025 //////

21. maplemonk.KA_AMAZONADS_MARKETING

Description:

A final aggregated table that summarizes daily ad performance (clicks, spend, impressions, conversions, ad sales, etc.) for reporting or BI dashboards.

Notes on Common Columns

ADVERTISER_ID: Typically an internal Amazon Ads entity representing the brand or agency’s account.

MARKETPLACE_ID: An internal Amazon identifier for each marketplace (e.g., A21TJRUUN4KGV for Amazon.in).

profileId / PROFILEID: Each Amazon Ads account (brand or seller) can have multiple profiles; this ID ties the data to the correct account.

CURRENCY: Commonly “USD,” “INR,” etc.

Attribution Window: Most of these tables use a 14-day attribution window. Metrics like ATTRIBUTED_SALES_14D, ATTRIBUTED_CONVERSIONS_14D refer to conversions happening within 14 days of a click/view.

Summary

Tables 1–2, 4–5, 7–8: Raw Amazon Ads data for Sponsored Brands (SB), Sponsored Display (SD), and Sponsored Products (SP).

Tables 3, 6, 9: Consolidated hourly-level data for SB, SD, and SP, respectively.

Tables 10–15: Dimension tables holding metadata for campaigns, ad groups, ads, targeting, keywords, and profiles.

Table 16–18: Sales or traffic data from external sources (secondary sales, brand registry, vendor central).

Tables 19–20: Staging and final consolidated tables at the hourly level, combining all sponsored ad data with dimension data and marketplace share logic.

Table 21: The final daily summarized marketing table for reporting.

⁠

- maplemonk.FINAL_SKU_MASTER

MAPLEMONK.KA_sales_consolidated

MAPLEMONK.KA_GA_Sessions_Consolidated

maplemonk.KA_GA_ORDER_BY_SOURCE_CONSOLIDATED

KA_UNICOMMERCE_RETURNS_INTERMEDIATE

⁠

maplemonk.KA_UNICOMMERCE_fact_items⁠

⁠

KA_UNICOMMERCE_fact_items_intermediate_final

MapleMonk.KA_AVP_GET_VENDOR_SALES_REPORT

MAPLEMONK.KA_AMAZON_VENDOR_CENTRAL_FACT_ITEMS

maplemonk.ASP_BR_TRAFFIC_FACT_ITEMS

KA_AMAZONADS_MARKETING

MapleMonk.KA_ASP_US_GET_SALES_AND_TRAFFIC_REPORT_ASIN

MapleMonk.KA_AVP_GET_VENDOR_TRAFFIC_REPORT

///// Signing off 13/02/2025 //////

Queries

US ASP Business Reports Fact Items

US Amazon Ads Campaign Mapping

US Amazon Ads Fact Items

US Amazon Seller Partner Fact Items

UTM Mapping

Unicommerce Fact Items

Unicommerce Tally Fact Items

Vendor Central Fact Items D-3

[Old] Amazon Ad Fact Items India

[Old] Amazon Sales Cost Source

[Old] Final SKU Master

34. Maplemonk.AA_KA_profiles

Desc: This table is related to the information about different accounts based in countries.

35. AA_KA_profiles_accountInfo

Purpose: Stores profile-level information about Amazon Ads accounts, such as advertiser IDs, marketplace associations, and basic account metadata (e.g., country codes, brand registrations).

36. AA_KA_sponsored_brands_ad_groups

Purpose: Holds ad group–level details for Sponsored Brands campaigns.

Typical Fields: Ad group ID, name, status, default bid, campaign association.

37. AA_KA_sponsored_brands_ads_v4_mm

Purpose: Contains individual ads/creatives for Sponsored Brands (version 4).

Typical Fields: Ad ID, associated campaign/ad group, creative assets, headlines, brand name references, etc.

38. AA_KA_sponsored_brands_campaigns

Purpose: Stores campaign-level data for Sponsored Brands (sometimes called “headline search ads”).

Typical Fields: Campaign ID, campaign name, budget, status, start/end dates, brand entity references.

39. AA_KA_sponsored_brands_keywords

Purpose: Contains keyword targeting for Sponsored Brands campaigns.

Typical Fields: Keyword text, match type (broad/phrase/exact), bid, status, associated ad group/campaign.

40. AA_KA_sponsored_display_ad_groups

Purpose: Ad group–level details for Sponsored Display ads.

Typical Fields: Ad group ID, name, default bid, campaign link, ad group status, etc.

41. AA_KA_sponsored_display_campaigns

Purpose: Campaign-level data for Sponsored Display ads.

Typical Fields: Campaign ID, name, budget, start/end date, status, targeting type (e.g., product/category/audience-based).

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.