Skip to content
Gallery
Miscellaneous
Miscellaneous
Tables Doc
Share
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
[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).
42. AA_KA_sponsored_display_product_ads
Purpose: Individual product ads for Sponsored Display campaigns. Often references a specific ASIN or creative ID.
Typical Fields: Ad ID, ASIN or creative info, associated campaign/ad group, status, cost/bid details.
43. AA_KA_sponsored_display_targetings
Purpose: Holds targeting definitions for Sponsored Display—for example, audience targeting, product targeting, or category targeting.
Typical Fields: Target ID, targeting expression/type, bid, status, associated ad group/campaign.
44. AA_KA_sponsored_product_ad_groups
Purpose: Ad group–level data for Sponsored Products.
Typical Fields: Ad group ID, name, default bid, status, associated campaign ID.
45. AA_KA_sponsored_product_ads
Purpose: Individual ads within Sponsored Products campaigns (product-level or creative-level references).
Typical Fields: Ad ID, ASIN, SKU or creative references, associated ad group/campaign, status/bid.
46. AA_KA_sponsored_product_campaigns_v3_mm
Purpose: The campaign-level table (version 3) for Sponsored Products ads.
Typical Fields: Campaign ID, name, daily budget, start/end date, status, bidding strategy.
47. AA_KA_sponsored_product_campaigns_v3_mm_dynamicBidding
Purpose: An extended or variant of Sponsored Products campaign data that specifically tracks dynamic bidding settings or performance.
Typical Fields: Similar to the standard campaign table but includes columns for dynamic bidding adjustments, rules, or multipliers.
48. AA_KA_sponsored_product_keywords
Purpose: Houses keyword-level targeting for Sponsored Products campaigns.
Typical Fields: Keyword text, match type, bid, status, associated campaign/ad group.
49. AA_KA_sponsored_product_targetings_v3_mm
Purpose: Holds product/category/auto target definitions for Sponsored Products (v3).
Typical Fields: Target ID, targeting type (ASIN-based, category-based, auto, etc.), bid, status, associated campaign/ad group.
50. FB_KA_customcampaigns_data
Purpose: Holds general reporting data for custom Facebook ad campaigns. Typically includes metrics such as impressions, clicks, spend, and associated campaign/ad set IDs for analysis.
51. FB_KA_customcampaigns_data_action_values
Purpose: Focuses on action value metrics (e.g., total value from purchases, add-to-cart values, or other custom “action” values) tied to those same Facebook campaigns. Often used to calculate ROAS or revenue.
52. FB_KA_customcampaigns_data_actions
Purpose: Stores action-level data—e.g., a breakdown by type of Facebook event (purchase, lead, add-to-cart). This table often enumerates how many of each action occurred within each campaign.
53. FB_KA_customcampaigns_data_conversion_values
Purpose: Tracks conversion-related monetary values (similar to action values) but typically aligned with standard Facebook “conversion” events. Useful for seeing how much revenue or value each conversion yields.
54. FB_KA_customcampaigns_data_conversions
Purpose: Focuses on count of conversions (e.g., number of purchases, sign-ups, etc.) attributed to each Facebook campaign/ad. Usually aligns with standard or custom conversion events.
55. FB_KA_customcampaigns_data_outbound_clicks
Purpose: Captures outbound clicks from Facebook ads—how many times users clicked out to a website or destination. Helps measure traffic from the ads to external landing pages.
56. FB_KA_customcampaigns_data_purchase_roas
Purpose: Specifically tracks purchase-based Return on Ad Spend (ROAS) for custom campaigns. Typically merges purchase value with ad spend data to compute ROAS.
57. FB_KA_customcampaigns_data_scd
Purpose: Potentially a Slowly Changing Dimension or snapshot table storing changes over time for the custom campaigns data. May hold multiple historical records for each campaign/metric.
58. FB_KA_customcampaigns_data_website_purchase_roas
Purpose: Another variant of the ROAS table, specifically for “website purchase” events. Usually used to isolate the conversions happening on a website (e.g., a brand’s e-commerce site)
59. FINAL_SKU_MASTER
Purpose: A master reference table for product SKUs across channels. It maps each SKU to details like product name, brand, category, MRP, tax rate, or other standardized fields.
60. Final_customerID
Purpose: Typically assigns a unique ID to customers across multiple data sources. Could unify phone/email from different systems into one “master” customer identifier.
61. GA4_GA_KA_orders_by_source_property271892133
Purpose: Holds Google Analytics 4 e-commerce order data for property ID “271892133,” probably reflecting orders broken down by traffic source/medium.
Columns might include transaction revenue, items purchased, user source, user medium, etc.
62. GA4_GA_KA_orders_by_source_property271892133__dbt_tmp ---- Does not exist.
Purpose: A temporary or intermediate table (indicated by “_dbt_tmp”) used by DBT or a similar ETL/ELT process. Houses partial or staged data for the main GA4 orders table before final transformations.
63. GA4_GA_KA_orders_by_source_property271892133_scd
Purpose: A Slowly Changing Dimension or historical snapshot version of the above GA4 orders table. May keep history of changes in source/medium or other dimension attributes across time.
64. GA4_GA_KA_orders_by_source_property271892133_scd__dbt_tmp ---- Does not exist.
Purpose: Another temporary staging table used by DBT for the “scd” version (the slowly changing dimension approach). Typically does intermediate merges or transformations before finalizing the SCD table.
65. ASP_US_BR_TRAFFIC_FACT_ITEMS
Purpose: The same type of traffic metrics as above—page views, sessions, conversions—but specifically for the U.S. (Amazon.com) Brand Registry environment.
66. ASP_BR_TRAFFIC_FACT_ITEMS
Purpose: Captures daily traffic metrics (e.g., page views, sessions) at the item (ASIN) level for Amazon Seller Central (Brand Registry), typically in non-US marketplaces.
///// Signing off 14/02/2025 //////

#67 KA_US_amazon_ads_campaign_details

Holds campaign‐level metadata for Amazon Ads in the US marketplace. Typically includes fields such as campaign name, status, budget, start/end dates, and targeting strategy.

#68 KA_US_amazon_ads_keyword_details

Stores keyword‐level information for Amazon Ads (US). Contains keyword text, match type, bid, status, and association to a specific campaign or ad group.

#69 KA_US_amazon_ads_profile_details

Contains profile/account details (in US) for Amazon Ads, including advertiser IDs, country codes, and basic account or brand info.

#70 KA_US_amazon_ads_targeting_details

Holds product or category targeting definitions for US Amazon Ads—e.g., the ASINs, categories, or audiences that the ad is targeting, with corresponding bid and status.

#71 KA_US_amazon_fact_items_TEMP_Category

A temporary or intermediate table for Amazon fact items (US). Likely merges raw order/transaction data with product category mappings before final consolidation.

#72 KA_Unicommerce_Tax_get_copy_of_tally_gst_report

A table capturing Tally GST report data derived from Unicommerce, presumably focusing on tax or invoice info. May have line‐item records detailing GST amounts per order.

#73 KA_Unicommerce_Tax_get_copy_of_tally_gst_report_scd

A Slowly Changing Dimension version of the same Tally GST data, preserving historical snapshots of tax or invoice details over time.

#74 KA_Unicommerce_get_copy_of_tally_gst_report

Similarly stores Tally GST or invoice details from Unicommerce, but possibly with slightly different transformations or columns than #72.

#75 KA_Unicommerce_get_copy_of_tally_gst_report_scd

Again, the SCD variant that keeps historical changes for the data in #74.

#76 KA_amazon_ads_ad_details

Contains individual ad (creative) metadata for Amazon Ads. Each record usually ties an ad ID to a product/ASIN, status, and associated campaign or ad group.

#77 KA_amazon_ads_adgroup_details

Ad group–level metadata for Amazon Ads: ad group name, default bid, status, and link to the parent campaign.

#78 KA_amazon_ads_campaign_details

Stores campaign‐level info for Amazon Ads (likely in non‐US or combined region). Overlaps with #67 but perhaps for a different marketplace or aggregated approach.

#79 KA_amazon_ads_keyword_details

Holds keyword targeting data for Amazon Ads (similar to #68, but possibly a broader or different region). Includes keyword text, match type, bids, status.

#80 KA_amazon_ads_profile_details

Contains profile/account data for Amazon Ads (general or global version). Includes advertiser IDs, brand details, marketplace linking, etc.

#81 KA_amazon_ads_targeting_details

Product/category targeting definitions for Amazon Ads (general version). Similar to #70 but for a different region or brand scope.

#82 KA_amazon_vendor_central_po_fact_items

Stores purchase order (PO) details for Amazon Vendor Central. Each row typically represents a PO item with fields like PO number, product ID, quantity, cost, or shipping status.

#83 KA_customerID_test_Final

Likely a lookup or “final” table linking customer phone/email to an internal unified ID, enabling cross‐channel identification of customers.

#84 KA_exchange_rates

A table capturing exchange rate references—often daily or monthly rates for different currencies (USD, INR, etc.).

#85 KA_exchange_rates_rates

Potentially a more granular or detailed sub‐table containing actual numerical exchange‐rate entries per date and currency pair.

#86 KA_exchange_rates_scd

The Slowly Changing Dimension variant that records historical exchange rate changes over time, preserving old rates for reference.
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.