Check out Amazon Advertising for Humans. Now publicly available 🚀

SQL Notes



This is not going to be a full SQL tutorial (expansive topic) but mostly just notes for myself to reference for a specific project, they may be useful for others however. I am going to be working mostly with a partitioned Data Catalog in AWS Athena.

Query a specific partition

SELECT campaignid as "Campaign ID",
	campaignname as "Campaign Name",
	impressions as "Impressions",
FROM "AwsDataCatalog"."name_of_database"."name_of_table"

WHERE CAST(profile_id as bigint) = 1363579156439011

limit 10;

Amazon Ad Analytics For Humans

Advertising reports automatically saved and displayed beautifully for powerful insights.
portfolios page sunburst chart