Skip to content

What are the STATUS and LOGS columns

BetterMerge records each campaign’s activity in your Google Sheet, next to the recipients it belongs to, so you can see what happened to every row without leaving the sheet.

When a campaign starts, BetterMerge adds two columns at the right of the sheet tab:

  • STATUS (Campaign Name) shows the latest state of each row, such as SENT or OPENED.
  • LOGS (Campaign Name) records what happened and when, such as when the email was sent, opened or clicked, and why a row was skipped.

Each campaign gets its own pair of columns, so a follow-up campaign on the same sheet doesn’t overwrite the first campaign’s results.

Example of the status and logs columns in google sheet.

Status Meaning
SENT The email was sent. The log names the sending address when you send from an alias.
OPENED The recipient opened the email. Needs open tracking.
CLICKED The recipient clicked a link. Needs click tracking.
UNSUBSCRIBED The recipient used the unsubscribe link.
REPLIED The recipient replied. Needs reply detection.
BOUNCED The email couldn’t be delivered. Needs bounce detection.

These rows got no email. The other rows keep sending.

Status Meaning
PREVIOUSLY UNSUBSCRIBED The address unsubscribed from one of your earlier campaigns. See Manage your contacts.
PREVIOUSLY BOUNCED An earlier email to this address bounced.
SKIPPED Email verification found the address invalid.
ATTACHMENT MISSING No file matched the row’s personalized attachment rule. Related statuses are ATTACHMENT AMBIGUOUS, ATTACHMENT NOT ACCESSIBLE and ATTACHMENT TOO LARGE.
SENT, with “(Duplicate)” in the log The same address appears earlier in the sheet and was already emailed, so this row was skipped.

ERROR means the email wasn’t sent or its delivery failed. The log says which. Check the delivery logs for details.

  • Don’t rename, move or delete the status and logs columns while a campaign is running.
  • Don’t insert rows in the middle of the sheet while a campaign is running. Add new rows at the end.
  • Once a campaign is complete, filter the STATUS column to find rows that need attention, such as skipped or bounced ones.
  • Before a follow-up, use segmentation rules or sheet filters to pick who gets it.

Next, learn about segmenting contacts to send targeted emails.

New to BetterMerge?Start free — 50 emails/day, no credit card. Questions? Contact support.

BetterMerge is an independent product not affiliated with, endorsed by, or connected to Google LLC. Gmail, Google Sheets, Google Workspace, and Google Workspace Marketplace are trademarks of Google LLC.