Pinpoint Proyect and Campaing Names as table for QuickSight

To find the campaign name for a specific campaign ID in Amazon Pinpoint, you can use the Amazon Pinpoint API or the AWS CLI.

You can get the campaign details using the aws pinpoint get-campaign command, which will return the CampaignName field.

Alternatively, you can retrieve the list of all campaigns for your Pinpoint application using the aws pinpoint get-campaigns command, and then find the campaign name that matches the campaign ID you have.

If you only have the campaign ID and the Pinpoint metrics table in S3, you can use the campaign ID to look up the campaign name in the Pinpoint API or the AWS CLI as described in the previous step.