marketingclouded

<h2 style="text-align:center;font-family: Roboto, sans-serif;">
  Weekly Growth
</h2>

<table style="width:100%;border:2px solid black;font-family: Roboto, sans-serif;">
<tr><th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Week Starting On:</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">New Subscribers</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Unsubscribes</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Net Growth</th>

marketingclouded

<h2 style="text-align:center;font-family: Roboto, sans-serif;">
  Weekly Send Log
</h2>
<table style="width:100%;border:2px solid black;font-family: Roboto,sans-serif;">
<tr><th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Week Starting</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Sent</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Opens</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Clicks</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Bounces</th>
  </tr>

marketingclouded

<h2 style="text-align:center;font-family: Roboto, sans-serif;">
  Weekly Growth
</h2>

<table style="width:100%;border:2px solid black;font-family: Roboto, sans-serif;">
<tr><th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Week Starting On:</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">New Subscribers</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Unsubscribes</th>
<th style="background-color:#031445;color:#fff;padding:10px;border-bottom:1px solid black;text-align:center;">Net Growth</th>

marketingclouded

%%[
SET @Inactives = DataExtensionRowCount("Inactive_Subscribers")
]%%

<p style="font-family: Roboto, sans-serif; font-size:20px;">
  There are currently <b>%%=FormatNumber(v(@Inactives), "N0")=%%</b> subscribers who not opened an email in more than 90 days.
</p>

marketingclouded

<h2 style="text-align:center;font-family: Roboto, sans-serif;">
  Performance of Scheduled Emails<br>Sent in Prior 28 Days 
</h2>

%%[

SET @EmailRows = LookupRows("Email_Performance_Sched_Last_28Days", "Return", 1)
SET @EmailCount = RowCount(@EmailRows)

IF RowCount(@EmailRows) > 0 THEN

marketingclouded

SELECT *
FROM Subscriber_Last_Open
WHERE LastOpenDate < DATEADD(d,-90,GETDATE()) AND Status = 'Active'

marketingclouded

Select SubscriberID, 
  DateDiff(day,LastOpenDate,LastSentDate) AS 'DateDiff'
FROM Subscriber_Last_Open

marketingclouded

SELECT
  g.SubscriberID,
  MAX(a.EventDate) AS 'LastOpenDate',
  MAX(a.JobID) AS 'JobID',
  y.EmailName
FROM Subscriber_Last_Open g
JOIN _Open a
ON g.SubscriberID = a.SubscriberID
JOIN _Job y
ON a.JobID = y.JobID

marketingclouded

SELECT
  e.EmailAddress,
  e.SubscriberID,
  e.Status,
  e.DateJoined,
  e.DateUnsubscribed,
  MAX(d.EventDate) AS 'LastSentDate',
  COUNT(d.SubscriberID) AS Sent
FROM _Subscribers e
JOIN _Sent d

marketingclouded

<script runat="server">
    Platform.Load("core", "1.1.1");
	
    var api = new Script.Util.WSProxy();
	
	try {
	
        var FolderName = "Reporting";
        var FolderAttributes = Folder.Retrieve({ Property: "Name", SimpleOperator: "equals", Value: FolderName });
        var FolderID = FolderAttributes[0].ID;