To query traffic data for a specific article in Advanced Queries, you can use our 'page path' filter as shown below:
When using this filter, it's important to enter the precise page path (URL) that our tracking script collects from your website when visitors load the page.
As a first step, remove the protocol ("https://") and "www." characters from the front of the canonical page URL that you want to query.
Next, make sure you use the correct page path format. Each site that we track follows one of two formats for how we collect and store the website's page paths; with or without the domain name. The default setting is to include the domain name in the page path, so for example:
domain.com/page-path-here.html
sub.domain.com/page-path-here.html
Some sites have Chartbeat configured to use page paths without the domain included:
/page-path-here.html
There are two ways you can determine which of these path formats to use for the site you are querying...
Option 1: In the Advanced Queries builder, add any metric (e.g. Pageviews) and the Page path group, then click "Preview data". This will return path sample data that shows which type of page path formatting to use in your path filtered queries.
Option 2: Hover over any article in the Top Pages list of your Real-Time Dashboard to see the page path format used for this site. Remember, you're checking to see if the path we collect for your site includes or does not include the domain portion of the page URL, "yoursite.com".
If you don't see any data in your Advanced Queries report after running a query with the page path filter, please check that the formatting of your path is accurate. If the article was published on the same day that you are running a report, there may not be any data available yet in Advanced Queries.