When you create a report using the Amazon DSP (V3) integration, a unique table name is generated for each selected report type and dimension combination. This helps standardize and organize your datasets across subscriptions.
Overview
Amazon DSP reports support thousands of metric and dimension combinations, and each combination produces a distinct schema. To handle this, Openbridge pre-generates a unique combination ID for every permutation of dimensions within a report type. This ID becomes part of the destination table name.
The table naming pattern is: amzn_ads_dsp_{report_type}_r{combination_id}
Example: An Audio/Video report configured with campaign, ad, and creative dimensions maps to combination ID 18, producing the table amzn_ads_dsp_audio_and_video_r18:
{ "id": 18, "dimensions": ["campaign", "ad", "creative"], "alias": "audio_and_video_1cdef549c0c5537255354e9631b840fe" }Removing creative from the configuration changes both the report schema and the combination ID. The new combination ID is 8, producing a different table — amzn_ads_dsp_audio_and_video_r8:
json
{ "id": 8, "dimensions": ["campaign", "ad"], "alias": "audio_and_video_d7415c0269f588d632099daec589675d" }In short, your table name is a function of the report type and the specific dimension combination you select when activating the report. Different combinations always produce different tables with their own schemas.
Table Name Format
The table name follows this structure:
amzn_ads_dsp_<report_type>_r<report_id>
report_type: The selected report type (e.g.,audience,campaign-creative,supply-source, etc.)report_id: A unique numeric identifier based on the selected dimensions.
Example
If you choose:
Report Type:
CampaignDimensions:
Creative
This might map to report_id = 16, and your final table name would be:
amzn_ads_dsp_campaign_r16
The table name is visible directly in the UI so you can reference or use it confidently.
Behind the Scenes
We use an internal mapping like this to determine the report_id:
{
"report_type": "campaign",
"reports": [
{
"id": 16,
"dimensions": ["creative"]
},
...
]
}We match your selected dimensions to the appropriate id and generate the table name accordingly.
Why This Matters
Helps ensure standardized naming for easier querying and analysis.
Supports consistent report tracking across projects and subscriptions.
Lets you reference the exact structure of the data easily.