-
Notifications
You must be signed in to change notification settings - Fork 0
How to match the main metrics in Linkfire app
Felipe S. Mezzarana edited this page Oct 4, 2023
·
7 revisions
| Metric | Description | Aggregation type | Condition |
|---|---|---|---|
| Visits | Number of visits to landing pages or redirects on links. Scrapers and bots etc. are excluded. Repeated visits are included. | Count of rows | where type='pageview' |
| Sessions | Visitor activity in a 10-minute window where repeated activity is excluded. | Count of rows | where type='pageview' and newsession='true' |
| Click-throughs | Click-throughs to services and other destinations. This includes repeated click-throughs if a visitor clicks through more than once in a session and redirects. | Count of rows | where type='event' and eventcategory='service' |
| Streams | Tracked streams from services that provide attribution data to Linkfire. The traffic raw dataset does not included Youtube and Apple Music streams. | Count of rows | where type='conversion' and ((convsource='Pandora' and convtype='played') OR ((convsource in ('deezer', 'anghami', 'boomplaymusic') and convaction='Play')) |
| Items sold | Tracked sales from sources that provide attribution data to Linkfire. | Count of rows | where type='conversion' and convsource not in ('Pandora', 'deezer', 'anghami', 'boomplaymusic') |
| Earnings | The value of the items sold. | Sum of 'Convvalue' | Same as Items sold |
| Items with commission | Tracked sales with commission from sources that provide attribution data to Linkfire. Excluding transactions tracked using affiliate token owned by Linkfire. | Count of rows | where type='conversion' and convsource not in ('Pandora', 'deezer', 'anghami', 'boomplaymusic') and convtoken not in ('1l3vpUI', '1000lsEM','361433', '316451') and convvalue != 0 |
| Commission | The value of the items with commission. | Sum of 'Convvaluesecond' | Same as Items with commission |
| Calculated metric | Description | Calculation approach |
|---|---|---|
| Click-through rate | Percentage of click-throughs against the number of visits. Click-through rate includes redirects on content links. | Click-throughs / visits * 100 |
| Streams per click-through | Ratio of streams against the number of click-throughs. | Streams / Click-throughs |
| Items sold per click-through | Ratio of items sold against the number of click-throughs. | Items sold / Click-throughs |