Russian online stores database

Database size 487,471 rows
Language of data russian
Support period  ? 30 days
Update date 3/25/2016
Database formats CSV, JSON, XML, SQL, MS Excel

DOWNLOAD FILES

# File name Size Notes
1 csv_full.zip 13 mb Full database in CSV format
2 csv_sample.zip 101 kb Sample database in CSV format
3 excel_full.zip 22 mb Full database in MS Excel format
4 excel_sample.zip 184 kb Sample database in MS Excel format
5 json_full.zip 15 mb Full database in JSON format
6 json_sample.zip 111 kb Sample database in JSON format
7 mssql_full.zip 15 mb Full database in MS SQL Server format
8 mssql_sample.zip 107 kb Sample database in MS SQL Server format
9 mysql_full.zip 15 mb Full database in MySQL format
10 mysql_sample.zip 107 kb Sample database in MySQL format
11 oracle_full.zip 15 mb Full database in Oracle format
12 oracle_sample.zip 107 kb Sample database in Oracle format
13 postgresql_full.zip 15 mb Full database in PostgreSQL format
14 postgresql_sample.zip 107 kb Sample database in PostgreSQL format
15 xml_full.zip 20 mb Full database in XML format
16 xml_sample.zip 127 kb Sample database in XML format

DESCRIPTION

hide

The database contains information about 21,934 online stores divided into 19 categories (see Table below). The following information is provided for each store:

  • Online store address (URL);
  • Home page title;
  • Number of visitors by month from August 2015 to January 2016;
  • Online store product category;
  • Number of pages indexed by Yandex.

Advanced statistics for the most popular 6,339 online stores:

  • Average time spent on website;
  • Average number of pages viewed;
  • Bounce rate;
  • Traffic sources (by countries, by social networks, paid traffic, etc.);
  • Referring websites;
  • Organic and paid keywords;
  • Interests of the online store users;

The Contacts table shows contact details, emails and phone, of 17,045 online stores. Number of unique emails is 16,518.

The information was collected using Yandex and Google search engines, as well as Rambler TOP-100 and Similarweb.com services.



Distribution of online stores by categories

Category Number of online stores
Autos and vehicles 2126
All for online stores 42
For business 856
For adults 218
For children 1190
For animals 263
House, country cottage, garden 3811
Books 211
Beauty and health 1835
Clothes, shoes, accessories 2234
Gifts, flowers 1115
Food 704
Sports, tourism, hunting 1126
Construction, repair 2548
Department stores 40
Hobby 861
Digital goods 149
Consumer electronics 1973
Jewelry 221
Unspecified category 411

Availability of online stores contact details

Number of online stores with phone or email as contact details 17,045
Number of online stores with phone as the only contact detail 12,934
Number of online stores with email as the only contact detail 12,193

Structure of online store database

# Table name Description Number of rows
1 AdsSites List of referring advertising websites. Analogue of the AdsSites field in the Links table where these websites are listed in a single line. 1,010
2 AudienceInterestsCategories Interests of a particular online store visitors grouped by categories (eg., “Shopping > Consumer Electronics”). Analogue of the InterestsCategories field in the Links table where these categories are listed in a single line. 25,538
3 Contacts Online stores contact details (phone and email). 48,553
4 CountriesTraffic Traffic sources by countries. Analogue of the Countries field in the Links table where these countries are listed in a single line. 30&,795
5 Keywords The keywords referring users to an online store from search engines. Analogue of the OrganicKeywords and PaidKeywords field in the Links table where these words are listed in a single line. 18,354
6 Links Main table. List of online stores and their characteristics. 21,934
7 SocialTraffic Social networks traffic sources. Analogue of the SocialTrafficSources field in the Links table where these networks are listed in a single line. 8,903
8 Traffic Number of visitors and online stores websites views provided by the Rambler TOP-100 service. IMPORTANT: the statistics can be significantly underestimated for some stores. 21,594
9 VisitorsRelevantTopics Interests of the users who visited a relevant online store. Analogue of the RelevantTopicsForSiteVisitors field in the Links table where these interests are listed in a single line. 310,790


Links main table screenshot
Links main table screenshot.
AudienceInterestsCategories table screenshot.
AudienceInterestsCategories table screenshot.
Contacts table screenshot.
Contacts table screenshot.
CountriesTraffic table screenshot.
CountriesTraffic table screenshot.
Keywords table screenshot.
Keywords table screenshot.
SocialTraffic table screenshot.
SocialTraffic table screenshot.
Traffic table screenshot.
Traffic table screenshot.
VisitorsRelevantTopics table screenshot.
VisitorsRelevantTopics table screenshot.


Links table fields description

# Field name Field description
1 ID Unique record identifier
2 Link Online store address (eg., ozon.ru)
3 Zone Website domain extension (ru, com, ua, etc.)
4 Title Home page title
5 TimeOnSite Average time spent by users on the online store website
6 PageViews Average number of pages views
7 BounceRate Bounce rate
8 Countries TOP-5 traffic sources countries
9 TrafficSources_Direct Share of direct traffic, %
10 TrafficSources_Refferals Share of referrals traffic, %
11 TrafficSources_Search Share of search engines traffic, %
12 TrafficSources_Social Share of social networks traffic, %
13 TrafficSources_Mail Share of mailing traffic, %
14 TrafficSources_Display Share of advertising traffic, %
15 TopRefferingSites TOP-5 referring websites
16 TopDestinationSites TOP-5 destination websites
17 OrganicSearches Share of organic search from clause 11, %
18 PaidSearches Share of paid search from clause, 11%
19 OrganicKeywords The words referring visitors to websites from organic search
20 PaidKeywords The words referring visitors to websites from search engine advertising
21 SocialTrafficSources Social networks traffic sources
22 AdsSites Advertising traffic sources on other websites
23 InterestsCategories Online store visitors’ interests grouped by categories (for example, Autos and Vehicles, Shopping, Shopping > Home and Garden, Shopping > Consumer Electronics)
24 AlsoVisitedWebsites Also visited websites
25 RelevantTopicsForSiteVisitors Users’ interests
26 SimilarSitesByRank Websites similar by the number of visitors
27 SimilarSitesBySimilarity Websites similar to this website
28 Visitors_01_2016 Number of visitors in January 2016
29 Visitors_11_2015 Number of visitors in November 2015
30 Visitors_10_2015 Number of visitors in October 2015
31 Visitors_09_2015 Number of visitors in September 2015
32 Visitors_08_2015 Number of visitors in August 2015
33 Category1 The 1st level category
34 Category2 The 2nd level category
35 YandexIndex Number of pages indexed by Yandex
36 YandexIndexParsed Date the pages indexed by Yandex are parsed on