We are using a salesforce table call "invoice", mapped into Marketo. This table has some fields that are historized, which data is stored in a "history" table that we have mapped too (and it is therefore a second level table):
The result is that we now have some advanced constraints in the "has Invoice" filters.
But when we try to use the constraints:
we get an error and the smart campaign will not save:
The end of it is that SFDC history tables do not have a timestamp field and are therefore not supported by Marketo...
Hence this idea: Enable sync and leverage of SFDC History tables as custom objects