The following is the standard operating procedure for updating the spreadsheet: Email, Bot & Push Notification Stats
To update the Email Stats (total sent, open rate & click rate):
- Open up the RMRS InfusionSoft website.
- Select the icon in the top-right corner and click “Email and Broadcasts” under Marketing.
- Select “Email and Broadcasts” from the menu below the word “Marketing”.
- Select “View Email Broadcasts”.
- Hold Control (Windows)/Command (Mac) on your keyboard and select “Antonio Centeno”, “Antonio Centeno” and “Olena Centeno”.
- Click “Search”.
- Under “Date”, find the email you are looking for.
- Under “Status”, check that it says Sent.
- “Stopped By User” means that someone has stopped it, either to edit and reschedule it or to cancel it.
- “Scheduled” means email is scheduled to be sent.
- Under “Total”, you will see the total number of recipients. Fill this information into the spreadsheet under “Total Sent”.
- Under “Report”, click View.
- Here you will see the open rate percentage (opens) and click rate percentage (clicks). Fill this information into the spreadsheet under “Open Rate” and “Click Rate”.
To update the Email Stats (number of clicks):
- Open up the RMRS InfusionSoft website.
- Select the icon in the top-right corner and click “Settings” under CRM.
- Click Tags from the menu below “Contact & Company Settings”.
- In the “Search” box, type in the date of the broadcast sent following this pattern: first 3 letters of month – day – year (–##).
- For example, if an email was sent on September 15, 2018, you would search: sep-15-18.
- Under “Number of People”, click Show Number to see the number of clicks.
- Tags ending in -video indicate number of clicks to video. Fill this information into the spreadsheet under “Clicks to Video”
- Tags ending in -sponsor indicate number of clicks to sponsor. Fill this information into the spreadsheet under “Clicks to Sponsor”
- Tags ending in -rbu or -rebrandu indicate number of clicks to ReBrandU. Fill this information into the spreadsheet under “Clicks to Sponsor” as “# RBU”.
To update the Facebook Bot Messenger Stats:
- Login to Manychat.
- Click on ‘Broadcasting’ on the left.
- Scroll down to ‘History’ and find the chatbot that was sent the day you need to update the stats for. (Ignore the ones that say ‘YouTube Post’.)
- Under “Sent” you’ll see a number. Put that in the ‘Total Sent’ column.
- Under “Read(%)” you’ll see a number with a percentage in brackets. Put the percentage in the ‘Open Rate’ column.
- Under “Clicked (%)” you’ll see a number with a percentage in brackets. Put the percentage in the “Click Rate” column.
- Put the number in the “Clicks” column.
To update the Push Notification Stats:
- Login to https://app.onesignal.com/
- Click anywhere on this the blue graph under “Total Users Per Day”:
- Select “Messages” from along the top menu bar
- Find the message sent for the date you are updating.
- Add numbers from “Sent” to the “Total Sent” column in the spreadsheet.
- Add percentage from “Click” to the “CTR” column in the spreadsheet.