Reports: Charts: Add Metric

 

The Add Metric page allows you to select what metric you would like to include in your chart. You must first select the metric group in the drop-down box before selecting a particular metric.

 

The metric groups are:

 

Clickstream - Recipients who visited particular pages on your Web site.

Clickthrough - Mailing recipients who clicked on links in your mailings.

Forwards - Mailing recipients who forwarded your mailings.

Interest - Interest levels of recipients who visited particular pages on your Web site.

Mailings - Delivery success, failure and related statistics.

Members - Membership data; what kinds of members are on your list(s).

Misc - SQL query charts; only server admins can add metric here, anyone can run it.

Opens - Recipients who opened a particular mailing.

Purchases - Recipients who purchased after receiving a mailing.

Server Performance - Information about how ListManager is running.

 

Once you have selected a metric, you will be taken to a second page which will ask additional information about charting the particular kind of metric you have selected.

 

Draw

Select whether to show the Data line, or the Trend line for this metric.

 

End Date

The ending date for this chart, in YYYY/MM/DD format. Leave blank for today's date.

 

List

The list to track this metric for.

 

Number of Days

The number of days to chart. The default is Forever, or all the data available.

 

Mailing

The events that resulted from the mailing selected here. If you would like to compare events from multiple mailings, you must add each as an additional metric to your chart.

 

Maximum Interest Stage

The maximum Interest Stage to display. For example, you may want to only display results with an Interest Stage under 90.

 

Maximum Value for Demographic Field

(Purchases metric only) Display members with this maximum value for the demographic field you select. For example, you may want to only display results for those whose "Children" field is less than 5.

 

Member Demographic

(Member metric only) Chart members with information for the demographic field you select here. Only demographic fields in the ListManager members_ table will be available for charting.

 

Minimum Count

The minimum amount of data to be displayed in your chart. For example, you may want to only display clickthroughs if they are over a certain number.

 

Minimum Interest Stage

The minimum Interest Stage to display. For example, you may want to only display results with an Interest Stage over 50.

 

Minimum Value for Demographic Field

(Purchases metric only) Chart members with the minimum value for the demographic field you select. For example, you may want to only display results for those whose "Children" field is greater than 1.

 

Minimum # of Bounces

(Member metric only) The minimum number of permanent failures to display for this chart.

 

Performance Metric Type

(Server Performance metric only) The type of server performance data to display for this chart.

 

SQL Query

(Misc metric only), and only available to server admins. Enter a valid SQL query; an example for the LABEL/COUNT metric would be:

 

SELECT Domain_, count(*) as Count_ FROM members_ WHERE List_='listmanager-discuss' GROUP BY Domain_ ORDER BY Count_ DESC

 

which displays the number of members per domain.

 

Note: It is recommended that before you paste your SQL statement into this box, that the statement be tested in the Run your own SQL Query page, to see if there is an error in the statement. If a faulty statement was entered, this will show you the error, which may be helpful in revising the statement. If a faulty statement is entered in the chart SQL query, you will see the chart displayed as "Sorry, there is no data to chart".

 

Web Page Name

The name of the web page for this Action Tag.

 

More

 

1. Reports: Charts

1.   Reports: Charts: Essentials

2.   Reports: Charts: Advanced

3.   Reports: Charts: Add Metric

4.   Reports: Charts: Chart

5.   Reports: Charts: Table

 

 



Reports: Charts: Advanced Reports: Charts: Chart