GurbachanBlog

  Workflow: Journey Builder> Automation Studio> New Automation Enter Query: Drag and drop Schedule in  Start with a Starting Source and the SQL Query> Choose Query> Create New Query Activity> Name your file and add your query (Field name thats part of the DE you create separately- Example: FirstName, LastName, Subscriber Key) Create a new DE in Email Studio with the query field> Select The test DE which was created: Select Target DE and Save & Run Workflow: Select All Activities and Run Workflow: Activity Details: Run Completed with updated DE Edit/ add another query: Copy Source DE and create a new DE with same fields that we are running in SQL: Run the updated SQL Query added Activity and DE updated with Records: Completed Status: Received error: When the Query field and the DE created field does not match When an existing Query is being run, if we try to run another query Fixed the error by matching same field Waiting for existing query to complete

 Track Past  campaigns  AB test reports. AB Summary Report:   Provides a summary of A/B test results , helping marketers compare different email versions. Send report in email: Account Send Summary:   Tracks total sends, responses, and engagement rates across multiple accounts. Attribute by tracking event: The Attribute By Tracking Event report displays how your subscribers reacted to a certain email send, based on a specific tracking event and a particular attribute. Campaign Process Analytic Details Report: Measures the performance of emails within a campaign . The Campaign Process Analytics Detail Report shows key workflow metrics for each Campaign whose Deployment Date is in the selected Range. Key metrics include: Last Completed State, Number of Comments Total/Open, Number of Rounds, Duration of Process. You can use the metrics provided in this report to evaluate effectiveness, throughput and bottlenecks of the approval process. Conversion Tracking Statist...