Snapchat Ads has 'composite' creatives that consist of multiple other creatives. The individual creatives that these are made up of are listed in 'composite_properties' of the composite creative in the API, but are not brought in via the Fivetran connector. The individual creatives that the composite creative is made up of ARE brought in through the creative_history table, but we have no way to link them to the parent ad and creative. Essentially, all of the creative data for the IDs that make up the composite creative are useless right now.
We need the ability to match ads to all of the creatives that they use so that we can complete our Snapchat ads integration. Right now lots of the spend is missing because we can't use it if we don't have creative data, such as what UTMs it was using.