How to get daily, monthly or weekly reports?

Reports are for you if you'd like to get a deeper look into your campaigns' performance. 

IN THIS ARTICLE

1. How to download reports
2. Types of CSV reports: daily, weekly, monthly
3. Details of your reports
4. FAQ

Download daily, monthly and weekly CSV reports

Please remember that only users with admin rights can access the  Reports section.

Open your Woodpecker account and navigate to:

  1. Settings
  2. My Profile
  3. Reports
  4. To get the file, click the green icon next to the corresponding report.

 

There are 3 types of reports:

  • daily - yesterday's statistics,
  • weekly - last 7 days,
  • and monthly - last month.

Example: We've downloaded the reports today afternoon, November 28. Here are the dates the reports cover:

  • daily - from 2019-11-27, 00:00 until 2019-11-28, 00:00. In the report, you can see the statistics form yesterday. Today's statistics aren't included.
  • weekly - from 2019-11-21, 00:00 until 2019-11-28, 00:00, last 7 days (21,22,23,24,25,26,27) without today's statistics. 
  • monthly - from 2019-10-28, 00:00 until 2019-11-28, 00:00, last month.
    If we download the report on December 1, we'll get the report from November. If the month is 31 days long, let's say November and the previous one 30 days long, e.g. November, we'll get statistics from November 30 until December 31 when downloading them on December 31st.

Each report type is divided into 3 categories:

  • General statistics per campaign
  • Number of messages sent from each level in campaigns
  • Open rate per campaign

How to read your CSV report?

On top of the file, you can find the type of statistics you've downloaded and the corresponding date (YYYY-MM-DD), for example,  open_rate_by_campaign_2019-11-19-2019-11-20.

I. General statistics per campaign

This report will give you an overview of your campaign's performance, presenting basic statistics, like the number of sent messages, how many of them were bounced or opened. Here you'll also check your open - or click rate, prospects' statuses or interest level.

Here's the example:

Record What it means
campaign_id unique identifier of the campaign in the application, in short Campaign's ID
campaign campaign’s name
campaign_status: 

Campaign's status
    RUNNING - that means your campaign is still active
    COMPLETED - your campaign has finished
    PAUSED - your campaign was put on hold
mailbox email account which was used to send campaign 
sent number of emails sent within a particular time
bounced_sent proportion of bounced to sent emails
opened the number of opened emails 
opened_rate  the percentage of opened to delivered emails
clicked your click rate
opt_out  the number of prospects who unsubscribed
responded the number of responses
responded_rate the percentage of responded to delivered emails
interested_yes/maybe/no the number of prospects with interest level assigned to them


II. Number of messages sent from each level in campaigns

This report will show you how many messages in each campaign's level ( Email #1, Email #2,...) were sent within a particular time (day, week, month).

Record What it means
campaign_id    unique identifier of the campaign in the application, in short Campaign's ID
campaign campaign’s name
sent_date

when the emails were sent

email_number  email's number in your campaign's sequence, for example, 3 - Email #3, 6 - Email #6
path In case you didn't add any condition to your campaign, this field will remain empty. 
If you added a condition, in the column you can see the record YES/NO until the moment your campaign splits into 2 Paths and will be assigned as such. You'll see there either YES or NO.
sent how many emails from each campaign's level were sent
Learn more about paths and conditions here.

III. Open rate per campaign

This report focuses on opens. Check which emails have been sent and delivered to your prospect and what was their open rate.

Record What it means
campaign_id unique identifier of the campaign in the application, in short Campaign's ID
campaign campaign’s name
sent_date 

when the emails were sent

mailbox email account which was used to send campaign 
path in case you didn't add any condition to your campaign, this field will remain empty. 
If you added a condition, in the column you can see the record YES/NO until the moment your campaign splits into 2 Paths and will be assigned as such. You'll see there either YES or NO.
email_number 
email's number in your campaign's sequence, for example, 3 - Email #3, 6 - Email #6.
sent number of emails sent within a particular time
delivered how many of sent messages were delivered to your prospects
opened the number of opened emails 
opened_rate  the percentage of opened to delivered emails



FAQ

Q: What’s the difference between Summary Emails and Daily or monthly, weekly CSV reports?

Summary Emails cover yours from Monday-till-Monday Woodpecker performance. Every Monday you'll receive an email with statistics like: 

  • the number of emails you've sent,
  • opens, 
  • and replies you received to all your campaigns.

Learn more about How to get a Weekly Summary of your campaigns' results?

Reports, however, present you a more detailed view of the sent emails during the time covered in the report.

Q: I can't access Reports. Why?

Reports can be accessed only by users with admin rights. Please check your Woodpecker account. In case you're not sure, let us know.

Q: What is CSV?

CSV stands for Comma-separated value. CSV file format uses a comma as a field separator and new line as a new data record. Woodpecker uses CSV files to import and export the data.

You can export your sheet to a CSV file from any web or desktop sheet editor. 

Q: Is it possible to get an automated daily CSV report from email statistics?

At the moment it isn't possible. We're working on this feature though! Check our Roadmap to be up-to-date with the newest feature releases. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us