Reporting

Adspect reporting is a comprehensive and valuable source of analytical information on your affiliate campaigns performance and traffic quality. It lets you do the following:

Evaluate traffic quality wholly or per source, publisher, ad spot, etc;
Build sales funnels of various depth and with flexible filtering by any traffic attributes;
Obtain detailed information about any particular click;
Download reports in CSV format.

Reporting section in your clients area is split into three parts:

Report parameters: date range, time zone, funnel groupings, filters;
Sales funnel table;
Click log table.

Once report parameters are set, hit the Report button to build a sales funnel report and pull its click log. You may delete data by these parameters from Adspect reporting by pressing the Delete button.

Both tables have a Download .CSV button in the bottom left corner, for downloading reports in CSV format. You may import them into Microsoft Excel, Apple Numbers, Google Sheets, or similar spreadsheet software.

Important

Please do not select overly broad date ranges as it will lead to huge dataset fetching and additional strain on our servers. We limit the total number of rows that will be included in a report, so you may get an incomplete report if its date range is too broad.

Sales Funnels

Sales funnels are produced by splitting click log into groups and computing summary statistical metrics on per-group basis. Adspect offers a dozen of different groupings: by date, stream, country, subaccount, etc. Grouping may be nested, e.g. Date + Stream would first split data by dates and then by individual streams on each date. This way you can combine different groupings to analyze various sales funnels.

Sales Funnel Metrics

The sales funnel table consists of the grouping columns on the left followed by metrics columns. Some of them display a gray percentage value following a slash–that is the percentage of the total number of clicks, for convenience.

The following table describes sales funnel metrics:

Metric	Description
Clicks	Total number of clicks.
Uniques	Approximate number of unique visitors as per uniqueness of their IP addresses.
FP	Number of visitors that successfully produced a JavaScript fingerprint. This figure may be less than the total number of clicks for various reasons, most often due to inability of dumb bots to run JavaScript code.
Money Hits	Number of visitors that have been shown the money page.
Money Uniques	Number of unique visitors that have been shown the money page.
Safe Hits	Number of visitors that have been shown the safe page.
GIVT	General invalid traffic, that is, the number of visitors blocked by superficial filters such as IP address blacklists, user agent matching, targeting, day parting (schedule), etc.
SIVT	Sophisticated invalid traffic, that is, the number of browser fingerprints that Adspect consciously filtered out as bad traffic.
MIA	Clicks missing in action, the figure = the number of visitors that failed to produce or submit a browser fingerprint. As mentioned above, these are often dumb bots with missing JavaScript support. Another common reason is network latency, especially evident in traffic with slow connection rates, e.g. 3G/EDGE, when visitors manage to close the tab or window before their fingerprint is submitted.
Quality	Percentage of money hits in the whole click volume. This is the best metric for evaluating traffic quality as a whole and may be used to compare different traffic sources, publishers, ad spots, etc. Especially useful with grouping by sub ID for compiling blacklists of bot-ridden zones, as described in the dedicated paragraph.
Expenses	Total traffic cost computed as a sum of costs of each click, if passed in a click URL parameter.
Conversions	Total number of conversions.
CR	Conversion rate = conversions / clicks.
Revenue	Total revenue computed as a sum of payouts of each conversion, if passed in postback.
Profit	Net profit = revenue − cost.
ROI	Return on investment = profit / cost.
CPC / CPM	Cost per click (CPC) = cost / clicks. Cost per mille (thousand clicks) (CPM) = cost / clicks × 1000.
CPA	Cost per action = cost / conversions.
EPL	Earn per lead = revenue / conversions.
eCPM	Effective cost per mille (thousand clicks) = revenue / clicks × 1000.

Click Log

Click log contains detailed information on every click that was processed by Adspect.

Click Log Columns

Click log consist of the following columns:

Column	Description
Timestamp	Date and time of the click or conversion.
IP Address	IP address of the visitor.
ASN	Autonomous system number of the visitor.
Stream	Name of the stream and a link to it.
Country	Country code in two-letter format.
OS	Operating system.
Browser	Browser.
Engine	Browser engine.
Languages	List of browser languages.
Sub ID	Sub ID.
Click ID	Click ID.
Cost	Click cost or conversion payout.
Mode	Stream mode at the moment of the click.
Status	Page displayed to the visitor, and a list of reasons if the click was blocked. Money – money page displayed Safe – safe page displayed Acquiring JS fingerprint – intermediate click processing stage where Adspect waits for the visitor’s browser to submit its fingerprint collected by a special script

CSV Click Log Columns

Click log in CSV format consist of the following columns:

Column	Description
`timestamp`	Date and time of the click or conversion.
`ip_address`	IP address of the visitor.
`asn`	Autonomous system number of the visitor.
`account_id`	Account ID.
`stream_id`	Stream ID.
`country_code`	Country code in two-letter format.
`os`	Operating system.
`browser`	Browser.
`engine`	Browser engine.
`languages`	List of browser languages.
`sub_id`	Sub ID.
`click_id`	Click ID.
`cost`	Click cost or conversion payout.
`mode`	Stream mode at the moment of the click.
`sequence`	Click processing stage: 0 – basic check 1 – JavaScript fingerprint check 255 – conversion
`target`	Displayed page: 0 – safe page 1–255 – money page with the corresponding ordinal number
`tags`	List of mnemonic tags that represent particular filtering reasons.

Tags

Each blocked click has tags that indicate why it was blocked. The most common tags are described below. Other tags not listed in the table indicate various bot signatures.

Tag	Description
`L1`, `L2`, `L3`, `L4`	Blocked by the corresponding filtering level.
`ORG`	Blocked organization.
`SKIP`, `SKIPX`	Skipped by delayed start.
`BL`	IP address blacklisted in stream IP/ASN blacklist.
`GBL`	IP address blacklisted in global IP/ASN blacklist.
`WL`	IP address not whitelisted in stream or global IP/ASN whitelist.
`UNIQ`	Non-unique visitor.
`BOT`	Public bot (Googlebot, Facebot, Twitterbot, etc.)
`NOGEO`	IP address has no officially assigned country code.
`GEO`	Country mismatch.
`OS`	Operating system mismatch.
`BROWSER`	Browser mismatch.
`LANG`	Browser language mismatch.
`NOLANG`	No browser language information.
`TZ`	Time zone mismatch.
`IPTZ`	Browser time zone does not match IP address time zone.
`RULE`	Visitor blocked by stream URL rule(s).
`UARE`	Visitor blocked by stream user agent blacklist.
`REF`	Visitor blocked by stream referrer filter.
`NOPAGE`	No money page in stream settings, or all money pages disabled.
`EMBED`	Embeddeding detected (`<iframe>`, `<embed>`, `<object>`, etc.)