Connector Improvement: Adding Required Columns to Amazon DSP
CompletedAmazon DSP is missing some necessary columns:
1. Campaign Data: According to the Amazon documentation, the CAMPAIGN table is likely the one we need to pull data from. The documentation lists a TOTAL_COST column as available, but this column is not included in our table. We need the TOTAL_COST column to sum it with the THIRD_PARTY_FEES column for calculating total daily spend. Can the TOTAL_COST column be added to the CAMPAIGN table?
2. Clicks and Impressions: We surface clicks and impressions on our platform. While the CAMPAIGN table includes the GROSS_IMPRESSIONS column, it does not include the GROSS_CLICK_THROUGHS column. Can the GROSS_CLICK_THROUGHS column be added to the CAMPAIGN table?
3. Reported Revenue: To feed an ad channel into our models, we require reported revenue. While the CAMPAIGN table includes a CHECKOUT_VALUE_SUM column, the SALES_14D column, as described in the Amazon documentation, would seemingly be a better choice. Can the SALES_14D column be added to the CAMPAIGN table?
-
Official comment
Hi Sara,
Thank you for raising this improvement. Adding update here since these fields were added long back.
They are available in Amazon DSP Connector - CAMPAIGN Table except SALES_14D as this is not available in API Documentation.
Thank You,
Vishal
Please sign in to leave a comment.
Comments
1 comment