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.
📌 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.