Skip to main content
All CollectionsSalesforce Marketing CloudSFMC - Broadcast Email Message Experiments with Classic Test & Send Methodology
SFMC - Queries
SFMC - Queries

Queries created in Salesforce Marketing Cloud

Updated over a week ago

The Jacquard app creates three queries in Automations > Activities > Query > PhraseeData > <yourExperimentName>-Phrasee folder.

  1. <yourExperimentName>-Splits
    This query populates Data Extensions > PhraseeData > <yourExperimentName> > <yourExperimentName>-Splits data extension with a random selection of the email target audience. 

  2. <yourExperimentName>-SplitResults
    ​    Scheduled to run 30 minutes before the main send. This query gets the metrics for the split test email using the Salesforce Marketing Cloud assigned job ID.

  3. <yourExperimentName>-Winner
    ​    This query is scheduled to run four days after the main send and sends Jacquard the metrics of the main send.

Did this answer your question?