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 form: 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.
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 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 Columns¶
The sales funnel table consists of the grouping columns on the left followed by statistical 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 list of statistical columns (CSV report column names written in parentheses):
- Clicks (
clicks) – total number of clicks.
- Uniques (
uniques) – approximate number of unique visitors as per uniqueness of their IP addresses.
- FP (
- Money Hits (
money_hits) – number of visitors that have been shown the money page.
- Money Uniques (
money_uniques) – number of unique visitors that have been shown the money page.
- Safe Hits (
safe_hits) – number of visitors that have been shown the safe page.
- GIVT (
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 (
sivt) – sophisticated invalid traffic, that is, the number of browser fingerprints that Adspect consciously filtered out as bad traffic.
- MIA (
- Quality (
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 parapgraph.
- Expenses (
expenses) – total traffic cost computed as a sum of costs of each click, if passed via URL parameter.
- Conversions (
conversions) – total number of conversions as accounted via the postback mechanism.
- CR (
cr) – conversion rate computed as conversions / clicks.
- Revenue (
revenue) – gross revenue of the funnel as accounted via the postback mechanism.
- Profit (
profit) – net profit computed as revenue − cost.
- ROI (
roi) – return of investment computed as profit / cost.
- CPC / CPM (
cpc) – cost per click computed as cost / clicks, and cost per mille computed as CPC × 1000.
- CPA (
cpa) – cost per action computed as cost / conversions.
- EPL (
epl) – earn per lead computed as revenue / conversions.
- eCPM (
ecpm) – effective cost per mille computed as revenue / clicks × 1000.
Click log contains detailed information on every click that was processed by Adspect.
Click Log Columns¶
Click log consist of the following columns:
- 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 – ISO 3166-1 alpha-2 country code of the visitor;
- OS – name of the visitor’s operating system;
- Browser – name of the visitor’s browser;
- Engine – name of the visitor’s browser’s engine;
- Cost – cost of the click or payout of the conversion;
- Sub ID – subaccount ID of the click;
- Click ID – unique ID of the click;
- Mode – stream mode at the moment of click;
- Status – page displayed to the visitor, and a list of reasons if the click was blocked.
CSV Click Log Columns¶
Click log in CSV format consist of the following columns:
timestamp– date and time of the event;
account_id– account ID;
stream_id– stream ID;
ip_address– IP address of the visitor;
asn– autonomous system number of the visitor;
country_code– ISO 3166-1 alpha-2 country code of the visitor;
os– name of the visitor’s operating system;
browser– name of the visitor’s browser;
engine– name of the visitor’s browser’s engine;
cost– cost of the click, if passed via URL parameter;
sub_id– subaccount ID of the click;
click_id– unique ID of the click;
mode– stream mode at the moment of click;
sequence– click processing stage:
- 0 – basic checks;
- 255 – conversion;
target– target page shown to the visitor:
- 0 – safe page;
- 1–255 – money page with the corresponding ordinal number;
tags– list of mnemonic tags that represent particular filtering reasons (see below.)