How to match the main metrics in Linkfire app - GetLinkfire/raw-data-documentation GitHub Wiki

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