Though a strange request, we're not asking the 'why' but the 'how' ...
We have a situation where a marketer is sending an email from Marketing Cloud to a Salesforce (Salescloud) report, using Marketing Cloud Connect.
During the send configuration process, they marketer isn't informed how many records are on the Salesforce Report they are about to send to.
Ultimately what has happened (due to wider permissions issues in Salesforce) - the marketer sends to a 'filtered' report without the correct filters working and therefore sends the email to a much larger audience than they had anticipated.
What we'd like to do is add in a fail-safe, that should the Salesforce Report have greater than 1000 records, then cancel the send (i.e. prevent the send from going to the incorrect audience).
We've thought about adding AMPScript to the Email / Template (below) but we have some caveats with this across the organisation - i.e. marketers could copy an existing email rather than creating from New Template etc
%%[ if _isTestSend == False then Var @rcount, @finalcount Set @rcount = __DataSourceName set @finalcount = DataExtensionRowCount(@rcount) If @finalcount >=1000 The RaiseError("Subscriber Count Limited Reached",False) ENDIF EndIF ]%%
Do you have any thoughts / suggestions of how we could enable something Business Unit wide that would fail a send if over a threshold?