The CData Excel Add-In for Snapchat Ads supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT AdSquads.Name, Ads.DeliveryStatus FROM AdSquads, Ads WHERE AdSquads.Id=Ads.AdSquadId

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT AdSquads.Name, Ads.DeliveryStatus FROM AdSquads LEFT OUTER JOIN Ads ON AdSquads.Id=Ads.AdSquadId