Add estimated_spend to Market IQ prompt

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • ALL Languages

      Add estimated_spend from dev_data_engineering.dma_quartile.vw_smart_scout_us_search_term_product_paids and dev_data_engineering.dma_quartile.vw_smart_scout_us_products (joined by product) to the Market IQ prompt. Use the sum of sponsoredbrandspend, sponsoredvideospend, topspotspend, and topgroupspend as estimated_spend. Display this only as an approximation and not as an absolute for brand/seller/category aggregation. Use estimated spend share (product/brand total). Data is in dev this week, moving to prod soon.

            Assignee:
            Unassigned
            Reporter:
            Victor Maricato
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: