Public Similarweb Connector API

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the prefix internal_ in their names. Public API procedures do not have such prefix in their names.

Total Traffic

get_engagement_averageVisitDuration

Returns the average visit duration on the given domain

Parameter
<is_total> (optional): True/False: True returns total data, False returns data for either desktop or mobile engagement. Default True.
<is_desktopmobile> (optional): IGNORED if is_total=True. True/False: True returns desktop engagement only, False returns mobile engagement only.
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Start Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.
<country> (optional): Country to filter the results. Default: world

Example

CREATE VIEW similarweb_examples.example_get_engagement_averageVisitDuration AS SELECT
        *
    FROM
(CALL "similarweb.get_engagement_averageVisitDuration"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'DE'
))a

get_engagement_bounceRate

Returns the bounce rate on the given domain

Parameter
<is_total> (optional): True/False: True returns total data, False returns data for either desktop or mobile engagement. Default True.
<is_desktopmobile> (optional): IGNORED if is_total=True. True/False: True returns desktop engagement only, False returns mobile engagement only.
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Start Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.
<country> (optional): Country to filter the results. Default: world

Example

CREATE VIEW similarweb_examples.example_get_engagement_bounceRate AS SELECT
        *
    FROM
(CALL "similarweb.get_engagement_bounceRate"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'DE'
))a

get_engagement_pagesPerVisit

Returns the average number of pages per visit on the given domain

Parameter
<is_total> (optional): True/False: True returns total data, False returns data for either desktop or mobile engagement. Default True.
<is_desktopmobile> (optional): IGNORED if is_total=True. True/False: True returns desktop engagement only, False returns mobile engagement only.
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Start Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.
<country> (optional): Country to filter the results. Default: world

Example

CREATE VIEW similarweb_examples.example_get_engagement_pagesPerVisit AS SELECT
        *
    FROM
(CALL "similarweb.get_engagement_pagesPerVisit"(
    "is_total" => FALSE,
    "is_desktopmobile" => TRUE,
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-04',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'US'
))a

get_traffic

Returns the Estimated Number of Visits for the domain on a daily, weekly, or monthly basis for desktop and mobile users. Visits are the basic unit behind SimilarWeb’s web insights and the basis for most of SimilarWeb’s measurements. A visit is defined as an entry to a web domain from a different web domain or from the beginning of an empty browsing session, and expires after 30 minutes of inactivity. During the duration of the visit, activity occurring within the domain, for example, clicking on articles and pictures, is measured as page-views. SimilarWeb’s definition of a visit is identical to Google Analytics’ definition, which means SimilarWeb can be used to make direct comparisons with the most popular analytics suite on the market.

Parameter
<is_total> (optional): True/False: True returns total data, False returns data for either desktop or mobile traffic. Default True.
<is_desktopmobile> (optional): IGNORED if is_total=True. True/False: True returns desktop traffic only, False returns mobile traffic only.
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Daily/Weekly/Monthly: Returns data in requested format
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.
<country> (optional): Country to filter the results. Default: world

Example

CREATE VIEW similarweb_examples.example_get_traffic AS SELECT
        *
    FROM
(CALL "similarweb.get_traffic"(
    "is_total" => FALSE,
    "is_desktopmobile" => FALSE,
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-06',
    "granularity" => 'Weekly',
    "main_domain_only" => FALSE
))a

get_uniquesVisitors

Returns monthly uniquedesktop visitors

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

Example

CREATE VIEW similarweb_examples.example_get_uniquesVisitors AS SELECT
        *
    FROM
(CALL "similarweb.get_uniquesVisitors"(
    "domain" => 'cnn.com',
    "start_date" => '2016-04',
    "end_date" => '2016-09',
    "main_domain_only" => FALSE
))a

get_desktopVsMobileSplit

Returns the desktop vs mobile web traffic share split

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM).
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

Example

CREATE VIEW similarweb_examples.example_get_desktopVsMobileSplit AS SELECT
        *
    FROM
(CALL "similarweb.get_desktopVsMobileSplit" (
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-08',
    "main_domain_only" => FALSE
))a

Desktop Traffic

get_globalRank

Allows you view the Global of the domain

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Daily/Weekly/Monthly: Returns data in requested format
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

CREATE VIEW similarweb_examples.example_get_globalRank AS SELECT
        *
    FROM
(CALL "similarweb.get_globalRank"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE
))a

get_geographyDisribution

Allows you view the Global of the domain
Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

Example

CREATE VIEW similarweb_examples.example_get_geographyDisribution AS SELECT
        *
    FROM
(CALL "similarweb.get_geographyDisribution"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-02',
    "main_domain_only" => FALSE
))a

get_rank_reach

Allows you to input a domain and recieve 4 web traffic intelligence metrics: Global Rank, Country Rank and Traffic Geography, Traffic Reach, Traffic Sources Distribution

Parameter
<domain> (optional): The domain name, for which statistics are optional

Example

CREATE VIEW similarweb_examples.example_get_rank_reach AS SELECT
        *
    FROM
(CALL "similarweb.get_rank_reach"(
    "domain" => 'cnn.com'
))a

get_trafficReach

Allows you to input a domain and recieve a "Traffic Reach" web traffic intelligence metric, which is the estimated percentage of the internet users, out of the entire internet traffic, who visited the domain over the last 6 months, week by week. TrafficReach displays 26 dates over the last 6 months and the estimated percentage of internet users who visited the domain on that date. Please note that a call to this procedure implies a call to the service, which will return additional data, that is dropped. Consider using get_rank_reach procedure (which will be called internally) if you need additional traffic metrics.

Parameter
<domain> (optional): The domain name, for which statistics are optional

Example

CREATE VIEW similarweb_examples.example_get_trafficReach AS SELECT
        *
    FROM
(CALL "similarweb.get_trafficReach"(
    "domain" => 'cnn.com'
))a

Categories & Tags

get_similarWebsites

Returns 20 Similar Websites and their similarity score for a given domain. The ability to return a list of related websites according to a specific website or topic was SimilarWeb’s first breakthrough. Search engines will return websites based on a specific query, but will not recognize that users who visit NBA.com would also find relevant content on ESPN’s website. The similarity system is based on a number of inputs including website structure, link analysis, user surfing behavior and a large community of user rankings. Under the hood, a supervised learning algorithm generates accurate results which are then cross validated and tested in-house by our data quality team

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "google.com". One request to this API is worth 3 hits. Please note that sending one request to the SimilarSites API results in 3 hits being counted against your total number of monthly hits

Example

CREATE VIEW similarweb_examples.example_get_similarWebsites AS SELECT
        *
    FROM
(CALL "similarweb.get_similarWebsites"(
    "domain" => 'cnn.com'
))a

get_leadingReferrals

Leading Referrals Returns a list of additional websites that were frequently visited by the same visitors of a given domain, along with their affinity score.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "google.com". One request to this API is worth 3 hits. Please note that sending one request to the Leader Referrals API results in 3 hits being counted against your total number of monthly hits.

Example

CREATE VIEW similarweb_examples.example_get_leadingReferrals AS SELECT
        *
    FROM
(CALL "similarweb.get_leadingReferrals"(
    "domain" => 'cnn.com'
))a

get_audienceInterests

Returns a list of additional websites that were frequently visited by the same visitors of a given domain within the browsing session, along with their affinity score.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM).
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

Example

CREATE VIEW similarweb_examples.example_get_audienceInterests AS SELECT
        *
    FROM
(CALL "similarweb.get_audienceInterests"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-08',
    "main_domain_only" => FALSE
))a

get_websiteTags

Returns the 10 top Tags to any and their relevance score for a given domain. The tagging system returns a list of tags for a given site that best describe the site’s content. The tagging system is used as an input for SimilarWeb’s similarity and categorization engines, but is also useful for categorization tasks that require open ended and dynamic results. The tag engine is capable of generating over 500 thousand unique, descriptive tags using URL analysis, word density, html and link analysis, search engine keywords and a number of external data sources.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "google.com". One request to this API is worth 3 hits. Please note that sending one request to the Website Tags API results in 3 hits being counted against your total number of monthly hits

Example

CREATE VIEW similarweb_examples.example_get_websiteTags AS SELECT
        *
    FROM
(CALL "similarweb.get_websiteTags"(
    "domain" => 'cnn.com'
))a

get_categoryRank

Returns the category of a given domain and its global rank within its given category. The category result is completly identical to the "Website Categorization API" output, but includes also the category rank. The categorization algorithm is able to accurately classify an unknown website as one of 25 main categories and 219 sub-categories. The ability to algorithmically generate categories for a given list of websites is enormously powerful and can be used for lead generation, marketing segmentation and online filtering. SimilarWeb’s categorization engine uses a multi-class learning algorithm to generate a category for a given website using website content tags, similarity results and a learning set of 2.5M categorized websites. SimilarWeb’s categorization results are constantly improving through machine learning and incorporation of customer input. Category results are rigorously cross validated and tested.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com". One request to this API is worth 3 hits. Please note that sending one request to the SimilarSites API results in 3 hits being counted against your total number of monthly hits.

Example

CREATE VIEW similarweb_examples.example_get_categoryRank AS SELECT
        *
    FROM
(CALL "similarweb.get_categoryRank"(
    "domain" => 'cnn.com'
))a

get_topSites

Provides lists of top sites, by category and country. For example, you can get a list of the top Shopping sites in the United States. 

Parameter
<category> (optional): The category you wish to investigate. If left blank, ‘All Categories’ will be requested.
<country> (optional): The country you wish to investigate. If left blank, ‘Worldwide’ will be requested.

Example

CREATE VIEW similarweb_examples.example_get_topSites AS SELECT
        *
    FROM
(CALL "similarweb.get_topSites"(
    "category" => 'Autos_and_Vehicles~Aviation',
    "country" => 'Germany'
))a

get_topSites_categories

Provides the list of categories for calling the get_topSites procedure. This procedure does not use your Api Key

Parameter

Example

CREATE VIEW similarweb_examples.example_get_topSites_categories AS SELECT
        *
    FROM
(CALL "similarweb.get_topSites_categories"(
))a

get_topSites_countries

Provides the list of countries for calling the get_topSites procedure. This procedure does not use your Api Key

Parameter

Example

CREATE VIEW similarweb_examples.example_get_topSites_countries AS SELECT
        *
    FROM
(CALL "similarweb.get_topSites_countries"(
))a

Desktop Traffic Sources

get_desktopTrafficSources

Allows you to break down a domain’s traffic by the following source type: Direct, Referrals, Search (Organic and Paid), Mail, Social, and Display Ads. This endpoint returns a detailed overview of traffic sources broken down by source type and traffic share.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Daily/Weekly/Monthly: Returns data in requested format
<main_domain_only> (optional): True /False: True returns data for main domain only, False returns data for subdomains as well
<country> (optional): Country to focus

Example

CREATE VIEW similarweb_examples.example_get_desktopTrafficSources AS SELECT
        *
    FROM
(CALL "similarweb.get_desktopTrafficSources"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'DE'
))a

get_desktopTrafficSourcesDeep

Allows you to break down a domain’s traffic by the following source type: Direct, Referrals, Search (Organic and Paid), Mail, Social, and Display Ads. This endpoint returns a high-level month-over-month overview of traffic broken down by traffic source

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Daily/Weekly/Monthly: Returns data in requested format
<main_domain_only> (optional): True /False: True returns data for main domain only, False returns data for subdomains as well
<country> (optional): Country to focus

Example

CREATE VIEW similarweb_examples.example_get_desktopTrafficSourcesDeep AS SELECT
        *
    FROM
(CALL "similarweb.get_desktopTrafficSourcesDeep"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'DE'
))a

get_socialReferrals

The Social Referrals API returns the leading social networks sending traffic to a given domain, as well as traffic share per social network.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<granularity> (optional): Daily/Weekly/Monthly: Returns data in requested format
<main_domain_only> (optional): True /False: True returns data for main domain only, False returns data for subdomains as well
<country> (optional): Country to focus

Example

CREATE VIEW similarweb_examples.example_get_socialReferrals AS SELECT
        *
    FROM
(CALL "similarweb.get_socialReferrals"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "granularity" => 'Monthly',
    "main_domain_only" => FALSE,
    "country" => 'DE'
))a

get_searchKeywords

Returns the top organic or paid search keywords for the given domain and % organic search traffic per keyword and change from last month (10 results/hit)

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True /False: True returns data for main domain only, False returns data for subdomains as well
<page> (optional): For pagination. Enter for more than 10 results. Please see the TotalCount in the output to find out, whether pagination is optional
<isOrganic> (optional): True/False: True for the top organic keywords, False for the top paid keywords

Example

CREATE VIEW similarweb_examples.example_get_searchKeywords AS SELECT
        *
    FROM
(CALL "similarweb.get_searchKeywords"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "main_domain_only" => FALSE,
    "page" => 1,
    "isOrganic" => TRUE
))a

get_organicOutgoingLinks

Returns a list of outgoing links from the desired domain, as well as the traffic share of each link

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.

Example

CREATE VIEW similarweb_examples.example_get_organicOutgoingLinks AS SELECT
        *
    FROM
(CALL "similarweb.get_organicOutgoingLinks"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "main_domain_only" => FALSE
))a

get_referrals

Returns the referring websites for the given domain, and traffic share per referer

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well.

Example

CREATE VIEW similarweb_examples.example_get_referrals AS SELECT
        *
    FROM
(CALL "similarweb.get_referrals"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "main_domain_only" => FALSE
))a

get_keywordCompetitors

Provides streamlined access to all the domains that are competing against the chosen domain for the same Organic or Paid keywords. The higher the site returned is ranked, the more keywords it has in common with the analyzed domain.

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM)
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only, False returns data for subdomains as well
<page> (optional): For pagination. Enter for more than 10 results. Please see the TotalCount in the output to find out, whether pagination is optional
<isOrganic> (optional): True/False: True for the top organic keywords, False for the top paid keywords

Example

CREATE VIEW similarweb_examples.example_get_keywordCompetitors AS SELECT
        *
    FROM
(CALL "similarweb.get_keywordCompetitors"(
    "domain" => 'cnn.com',
    "start_date" => '2016-01',
    "end_date" => '2016-07',
    "main_domain_only" => FALSE,
    "page" => 1,
    "isOrganic" => TRUE
))a

Web Traffic Sources

get_adNetwork

Returns leading Ad Networks sending traffic to a given domain as well as traffic share per Ad Network

Parameter
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "cnn.com", "edition.cnn.com"
<start_date> (optional): Start Month (YYYY-MM). To retrieve Last 28 days pass null for the start_date & end_date parameters.
<end_date> (optional): End Month (YYYY-MM)
<main_domain_only> (optional): True/False: True returns data for main domain only; False returns data for subdomains as well

Example

CREATE VIEW similarweb_examples.example_get_adNetwork AS SELECT
        *
    FROM
(CALL "similarweb.get_adNetwork"(
    "domain" => 'cnn.com',
    "start_date" => '',
    "end_date" => '',
    "main_domain_only" => FALSE
))a

get_trafficShare

Returns the top countries that bring the most traffic to the domain and their share of traffic in percent. Please note that a call to this procedure implies a call to the service, which will return additional data, that is dropped. Consider using get_rank_reach procedure (which will be called internally) if you need additional traffic metrics.

Parameter
<domain> (optional): The domain name, for which statistics are optional

Example

CREATE VIEW similarweb_examples.example_get_trafficShare AS SELECT
        *
    FROM
(CALL "similarweb.get_trafficShare"(
    "domain" => 'cnn.com'
))a

get_trafficSourcesDistribution

Allows you to input a domain and recieve a "Traffic Sources Distribution" web traffic intelligence metric, which is the relative share of each traffic source for the most recent month. Please note that a call to this procedure implies a call to the service, which will return additional data, that is dropped. Consider using get_rank_reach procedure (which will be called internally) if you need additional traffic metrics. To obtain the same data in one row, consider using get_trafficSourcesDistributionAsColumns.

Parameter
<domain> (optional): The domain name, for which statistics are optional

Example

CREATE VIEW similarweb_examples.example_get_trafficSourcesDistribution AS SELECT
        *
    FROM
(CALL "similarweb.get_trafficSourcesDistribution"(
    "domain" => 'cnn.com'
))a

get_trafficSourcesDistributionAsColumns

Allows you to input a domain and recieve a "Traffic Sources Distribution" web traffic intelligence metric, which is the relative share of each traffic source for the most recent month. Please note that a call to this procedure implies a call to the service, which will return additional data, that is dropped. Consider using get_rank_reach procedure (which will be called internally) if you need additional traffic metrics. To obtain the same data in two rows, six columns, consider using get_trafficSourcesDistribution.

Parameter
<domain> (optional): The domain name, for which statistics are optional

Example

CREATE VIEW similarweb_examples.example_get_trafficSourcesDistributionAsColumns AS SELECT
        *
    FROM
(CALL "similarweb.get_trafficSourcesDistributionAsColumns"(
    "domain" => 'cnn.com'
))a

parse_trafficReach

Allows you to parse the previously obtained traffic reach that is stored temporarily in the XML format, originating from the call to get_rank_reach procedure

Parameter
<trafficReach> (optional): Traffic reach in XML format

Example

CREATE VIEW similarweb_examples.example_parse_trafficReach AS SELECT
        *
    FROM
(CALL "similarweb.parse_trafficReach"(
    "trafficReach" => (Select TrafficReach From (call "similarweb.get_rank_reach"(
    "domain" => 'cnn.com'
	))x)
))a

parse_trafficShare

Allows you to parse the previously obtained traffic geography that is stored temporarily in the XML format, originating from the call to get_rank_reach procedure

Parameter
<trafficShare> (optional): Traffic geography in XML format

Example

CREATE VIEW similarweb_examples.example_parse_trafficShare AS SELECT
        *
    FROM
(CALL "similarweb.parse_trafficShare"(
    "trafficShare" => (Select TopCountryShares From (call "similarweb.get_rank_reach"(
    "domain" => 'cnn.com'
	))x)
))a

parse_trafficSourcesDistribution

Allows you to parse the previously obtained traffic source distribution that is stored temporarily in the XML format, originating from the call to get_rank_reach procedure. Data is returned in two columns, one row per each source type. To return data in one row, consider using parse_trafficSourcesDistributionAsColumns.

Parameter
<trafficShares> (optional): Traffic source distribution in XML format

Example

CREATE VIEW similarweb_examples.example_parse_trafficSourcesDistribution AS SELECT
        *
    FROM
(CALL "similarweb.parse_trafficSourcesDistribution"(
    "trafficShares" => (Select TrafficShares From (call "similarweb.get_rank_reach"(
    "domain" => 'cnn.com'
	))x)
))a

parse_trafficSourcesDistributionAsColumns

Allows you to parse the previously obtained traffic source distribution that is stored temporarily in the XML format, originating from the call to get_rank_reach procedure. Data is returned in one row. Each column corresponds to a particular source type. To return data in two columns, consider using parse_trafficSourcesDistribution.

Parameter
<trafficShares> (optional): Traffic source distribution in XML format

Example

CREATE VIEW similarweb_examples.example_parse_trafficSourcesDistributionAsColumns AS SELECT
        *
    FROM
(CALL "similarweb.parse_trafficSourcesDistributionAsColumns"(
    "trafficShares" => (Select TrafficShares From (call "similarweb.get_rank_reach"(
    "domain" => 'cnn.com'
	))x)
))a

Mobile App + Mobile Web

get_appDetails

Returns the Title, Image, Publisher, Price, Main Category, Main Category ID, and Rating for the requested application

Parameter
<isGooglePlayStore> (optional): True/False: True for Google Play Store, False for iOS Apple Store
<appId> (optional): Enter the ID of the app (e.g. "com.yahoo.mobile.client.android.mail" for Play Store, "442911228" for Apple Store)

Example

CREATE VIEW similarweb_examples.example_get_appDetails AS SELECT
        *
    FROM
(CALL "similarweb.get_appDetails"(
    "isGooglePlayStore" => TRUE,
    "appId" => 'com.yahoo.mobile.client.android.mail'
))a

get_googleAppInstalls

Returns the estimated range of installs for a given app (Available only for Google Play Store)

Parameter
<appId> (optional): Enter the ID of the app (e.g. "com.cnn.cnnmoney")

Example

CREATE VIEW similarweb_examples.example_get_googleAppInstalls AS SELECT
        *
    FROM
(CALL "similarweb.get_googleAppInstalls"(
    "appId" => 'com.cnn.cnnmoney'
))a

get_relatedApps

Returns the list of all mobile apps (App Store / Play Store) related to a given domain

Parameter
<isGooglePlayStore> (optional): True/False: True for Google Play Store, False for iOS Apple Store
<domain> (optional): Enter your target domain including only the top-level and second-level names, ie: "google.com"

Example

CREATE VIEW similarweb_examples.example_get_relatedApps AS SELECT
        *
    FROM
(CALL "similarweb.get_relatedApps"(
    "isGooglePlayStore" => TRUE,
    "domain" => 'cnn.com'
))a