Fields listing for Piwik

Times a visitor accepted one or more consent types, but not all.

Times a visitor changed their consent.

When consent was given by the visitor: for the first time or changed later on.

A button on your consent form: agree all, reject all, save choices or close.

Clicks on one of the buttons on the form: accept all, reject all, save choices, close.

Times a visitor is served a consent form.

What consent was given by the visitor: full, any or none.

Where visitors clicked to consent or not: a popup or bottom bar, reminder, privacy settings on a page.

A visitor consents or not to A/B testing and personalization.

A visitor consents or not to analytics.

A visitor consents or not to conversion tracking.

A visitor consents or not to marketing automation.

A visitor consents or not to remarketing.

A visitor consents or not to user feedback.

Times a visitor agreed to A/B testing and personalization.

Times a visitor agreed to analytics.

Times a visitor agreed to conversion tracking.

Times a visitor agreed to marketing automation.

Times a visitor agreed to remarketing.

Times a visitor agreed to user feedback.

A visitor consents or not to the custom consent type.

Times a visitor agreed to custom consent.

Times a visitor gave their first consent.

Times a visitor accepted all consent types.

Times a visitor didn't consent to anything.

Times a visitor ignored the consent form without making any decision.

The percentage of returning visitors.

The total value of abandoned carts in the local currency, excluding discounts, shipping, and taxes. Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.

The total value of abandoned carts, excluding discounts, shipping, and taxes, converted to the site or app currency. Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.

The total value of abandoned carts, excluding discounts, shipping, and taxes, converted to the base currency (USD). Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.

The total number of abandoned carts. An abandoned cart happens when a shopper places products in a cart but doesn't complete a purchase.

The number of abandoned carts during a session.

The name of your Google Ads account.

The unique number that’s assigned to each Google Ads account.

The name of an action performed by the user in SharePoint such as Like, Comment, Share.

The combination of a unique number that’s assigned to each group and each ad in Google Ads. Ad group ad ID = Ad group + Ad ID.

The unique number that’s assigned to each ad group in Google Ads.

The name of your ad group in Google Ads.

The network where your ad was displayed. The networks are: content, mixed, search, search partners, unknown, unspecified, YouTube search, and YouTube watch.

The number of times shoppers added products to their carts.

The number of adds to cart during a session.

The author of content created in SharePoint.

The department of content author.

The full name of content author.

The job title of content author.

The office of content author.

Average cost-per-click (CPC) is the amount you’ve paid for your ad divided by its total clicks. Average CPC = (Cost / Click) * 100%.

The average ranking of your website’s URL for the one or more keywords. For example, if your site’s URL appeared at position 3 for one keyword and position 7 for another keyword, the average position would be 5 ((3+7)/2).

The percentage of sessions during which visitors viewed only one page and didn’t continue to another page view, goal conversion, or order. Bounce rate = (Bounces / Sessions) * 100%.

A bounced or non-bounced session. Bounce is when a visitor viewed an entry page but didn’t continue to another page view, goal conversion or order.

The number of sessions during which visitors viewed an entry page but didn’t continue to another page view, goal conversion, or order.

The name of the visitor’s browser engine.

The language of the visitor’s browser.

The name of the visitor’s browser.

The version of the visitor’s browser.

The content of an online campaign taken from utm_content.

The ID of an online campaign taken from utm_id.

The unique number that’s assigned to each campaign in Google Ads.

The name of an online campaign taken from utm_campaign.

The name of your campaign in Google Ads.

The percentage of sessions during which shoppers abandoned their carts. Cart abandonment rate = Sessions with abandoned cart / Sessions * 100%.

The percentage counted as: Product adds to cart / Product detail views * 100%. This metric helps you gauge how product details affect cart additions.

The channel of the incoming traffic. The channels are: direct entry, search engine, website, and campaign.

The city from which a visitor entered your site or app.

The number of times people click on your ad.

The number of clicks on your website URLs from Google Search results. It doesn’t include clicks on paid Google Ads search results.

The number of posted comments and comment replies.

The number of comments and comment replies during a session.

The number of times a content block was displayed to visitors.

The number of content impressions during a session.

The percentage of visitors who interacted with displayed content. Content interaction rate = (Content interactions / Content impressions) * 100%.

The number of times visitors interacted with a content block, for example, clicked an element in a content block.

The number of content interactions during a session.

The name of the tracked content block.

The piece of the tracked content block.

The target of the tracked content block.

The type of page the user interacted with. For example, a news page.

The continent from which a visitor entered your site or app.

A unique identifier of the browser.

An enabled or disabled support for cookies in the visitor’s browser.

The amount you’ve paid for your ads in Google Ads.

The country from which a visitor entered your site or app.

The number of created objects. The creation is counted when a user creates a page, file, and the like.

The number of times a content was created during a session. For example, a page was published or a file was uploaded.

Click-through rate (CTR) measures how often people click your ad in Google Ads after it’s shown to them. (CTR = (Clicks / Impressions) * 100%).

The click-through rate. CTR = (Clicks / Impressions) * 100 .

The local currency tracked with an event.

The currency set in your Google Ads account settings. It's imported with other Google Ads data.

The currency set in the site or app settings at the time the event was tracked, used during data processing.

The date of the exchange rate used for currency conversion.

The exchange rate used for currency conversion.

The action of the custom event.

The category of the custom event.

The name of the custom event.

The value of the custom event.

The number of tracked custom events.

The number of custom events during a session.

Year Month Day such as 20240401.

Day of the week

Day of the year

The number of days since the visitor had their first session.

The number of days since the visitor made their last order.

The number of days since the visitor had their last session.

The number of object deletions. The deletion is counted when a user deletes a page, file, and the like.

The number of times a content like page or file was deleted.

The department of SharePoint user.

A media region where people receive similar content on TV, radio, newspaper, and internet.

The brand of the visitor’s device.

The model of visitor’s device.

The type of the visitor’s device.

An enabled or disabled Director plugin in the visitor’s browser.

The total discount value applied to the order in the local currency.

The total discount value applied to the order, converted to the site or app currency.

The total discount value applied to the order, converted to the base currency (USD).

The time taken to resolve the server’s IP address.

The URL of the downloadable file clicked by the visitor.

The number of clicks on links to downloadable files.

The number of download events during a session.

The number of object edits. The edit is counted when a user edits a page, file, and the like.

The number of times a content was edited during a session.

The number of page views for a page that was the first during a session.

The percentage of sessions that started on a selected page. It works only with these dimensions: page URL, page title, session entry URL. Entry rate = (Entries / Sessions) * 100%.

The type of event such as a page view, download, outlink, performed by a visitor.

The number of events performed by visitors.

The number of events during a session.

The average number of events in a session.

The percentage of sessions that finished on a selected page. Exit rate = (Exits / Sessions) * 100%.

The percentage of sessions that finished on a selected event. Exit rate (events) = (Exits / Unique page views) * 100%.

The number of page views for a page that was the last during a session.

The number of file openings. The file opening is counted when a user clicks a file in SharePoint to open it. It doesn’t include openings of attachments from list items. (See: Item attachment views).

The number of times a file was opened during a session.

The type of a file such as xls, docx, pdf.

The URL of a file the user interacted with. The URLs of attachments added to list items are not tracked.

An enabled or disabled flash plugin in the visitor’s browser.

The full name of SharePoint user.

Google Click ID which is assigned to the click on the ad and passed to the landing page.

An enabled or disabled Gears plugin in the visitor’s browser.

The percentage of sessions during which visitors completed a goal. Goal conversion rate = (Sessions with a completed goal / Sessions) * 100%.

The total number of completed goals, repeated goals included.

The number of completed goals during a session.

The name of the goal.

The revenue generated by a goal in the local currency.

The revenue generated by a goal, converted to the site or app currency.

The revenue generated by a goal, converted to the base currency (USD).

The name of the goal.

Hour of the day

The number of times your ad was served on Google or Google Network.

The number of times any URL from your site appeared in Google search results and was seen by a visitor. It doesn’t include paid Google Ads search impressions.

IPv4 address of a visitor. For filtering and segmenting purpose only.

IPv6 address of a visitor. For filtering and segmenting purpose only.

The number of item attachment views. The item attachment view is counted when a user views an item attachment on the list by clicking on it.

The number of item attachment views during a session. The item attachment view is counted when a user opens an item attachment on the list by clicking on it.

The number of shares of items on the list.

The number of item shares during a session.

The number of item views. The item view is counted when a user sees an item on the list by clicking on it or entering a direct URL.

The number of item views during a session. The item view is counted when a user views an item on the list by clicking on it or entering a direct URL.

An enabled or disabled Java plugin in the visitor’s browser.

The job title of SharePoint user.

The keyword that a visitor used in a search engine or a keyword added as a campaign parameter.

The keyword matching option that you’ve used for keywords in Google Ads. The match types are: broad, exact, and phrase.

Geographic latitude at which a visitor entered your site or app.

The number of likes that content has received. It doesn’t include comment likes.

The number of likes given to pages during a session.

The time of the event in the visitor's time zone.

Geographic longitude at which a visitor entered your site or app.

The category of the source such as organic (unpaid search in the search engine), cpc (paid search in the search engine), referral (web referral), email (email campaign), and the like.

Month and day

Month of the year

The title of the page that was viewed next.

The URL of the page that was viewed next.

Week of the year

The type of an object the user interacted with such as Page, List, File.

The office of SharePoint user.

The name of the visitor’s operating system.

The version of the visitor’s operating system.

The unique identifier (ID) of the order.

The percentage of sessions during which shoppers completed their orders. Order conversion rate = Sessions with order / Sessions * 100%.

The percentage counted as: Orders / Product detail views * 100%. This metric helps you gauge how product details affect product sales.

The total number of orders placed in your online store. An order is placed when a shopper completes the checkout process and pays for the product.

The number of orders placed during a session.

The name of the visitor’s organization, such as a business, educational, government unit. The organization is a company to which the internet service provider has sublet the IP address range. When an organization is not identified, this dimension contains the name of the internet service provider instead of the name of the business.

Day and time of the event in the site’s time zone.

The URL of the external domain that was clicked by the visitor.

The number of clicks on links to external domains.

The number of clicked outlinks during a session.

An accurate bounce rate for a page URL or page title. The percentage of sessions during which visitors viewed only that page and didn’t continue to another page view, goal conversion, or order. Page bounce rate = (Bounces / Entries) * 100%.

The page loading time on the visitor’s device.

The time taken to create the render tree, layout, and finally draw the website in the browser.

The title of the page on which an event took place.

The URL of the page on which an event took place.

The number of times a page was visited.

The number of page views during a session.

An enabled or disabled PDF plugin in the visitor’s browser.

The title of the page that was viewed previously.

The URL of the page that was viewed previously.

The brand of the product in your online store.

A category that includes all product category levels in your online store. Example: "Clothes/Men/T-shirts".

The first-level category of the product in your online store.

The second-level category of the product in your online store.

The third-level category of the product in your online store.

The fourth-level category of the product in your online store.

The fifth-level category of the product in your online store.

The number of times shoppers viewed the product detail page.

The number of product detail views during a session.

The name of the product in your online store.

The price of the product in the local currency.

The price of the product, converted to the site or app currency.

The price of the product, converted to the base currency (USD).

The total number of products. When a customer orders two iPhone 14s, the product quantity will be 2, and the unique product count will be 1.

The value calculated by multiplying the product price by the product quantity in the local currency.

The value calculated by multiplying the product price by the product quantity, converted to the site or app currency.

The value calculated by multiplying the product price by the product quantity, converted to the base currency (USD).

The stock-keeping unit of the product in your online store.

The variant of the product in your online store. Example: color and size.

The number of page promotions such as: Add page to navigation, Post as news, Save as template.

The number of promotions during a session. The promotion is tracked when a user performs one of these actions: Promote: Add page to navigation, Promote: Post as news on this site, Promote: Save as template, Pin to top.

The name of the visitor’s internet service provider.

Quarter of the year

An enabled or disabled QuickTime plugin in the visitor’s browser.

An enabled or disabled RealPlayer plugin in the visitor’s browser.

The URL of the page that referred a visitor to your site or app.

The number of times shoppers removed products from their carts.

The number of removes from cart during a session.

The number of horizontal and vertical pixels on the visitor’s device.

The number of horizontal pixels on the visitor’s device.

The number of vertical pixels on the visitor’s device.

A new or returning visitor.

The total order value in the local currency, including subtotal, tax, shipping and discounts.

The total order value, including subtotal, tax, shipping and discounts, converted to the site or app currency.

The total order value, including subtotal, tax, shipping and discounts, converted to the base currency (USD).

ROAS (return on ad spend) is a web analytics metric that shows how much revenue is generated for every dollar spent on Google Ads. ROAS is a ratio of revenue from conversions to ad spend. A ROAS of $3.20 means that each $1 spent on ads generated $3.20 in revenue. Formula: ROAS = (Sum of revenue + Sum of goal revenue) / Cost (Google Ads).

The category of the keyword used in the search engine on your site or app.

Queries that generated impressions of your website’s URLs in Google organic search results.

The keyword used in the search engine on your site or app. It works only with these metrics: searches, unique searches. .

The count of searches on your site or app.

The number of searches on your site or app.

The time taken to establish a connection with the web server.

The time taken to receive the first byte of response from the server to the browser’s request.

The title of the first visited page during a session.

The URL of the first visited page during the session.

The page title of the last visited page during the session.

The URL of the last visited page during the session.

List of goals on which user converted during the session. It can be used only for filtering purposes.

List of goals on which user converted during the session. It can be used only for filtering purposes.

The number of the session counted for a visitor. Each time a visitor starts a session, a session counter increments for that visitor.

The title of the second page visited by a visitor during a session.

The URL of the second page visited by a visitor during a session.

The duration of a session measured from the first to last event during a visit.

The number of sessions performed by visitors. A session starts with the first event and ends 30 minutes after the last event (after the session is over).

The number of shares such as: Copy link or Send message.

The number of shares during a session. The share is tracked when a user performs one of these actions: Promote: Send email, Promote: Copy page link, Document library: Item share, In the top bar: Send by email.

The total shipping cost of the order in the local currency.

The total shipping cost of the order, converted to the site or app currency.

The total shipping cost of the order, converted to the base currency (USD).

A stage that a shopper completed during a session. The stages are: No shopping activity, Ordered, Abandoned cart, Ordered and abandoned cart.

An enabled or disabled Silverlight plugin in the visitor’s browser.

The number of searches on your site or app during a session.

The origin of the incoming traffic such as direct, a search engine (for example, google) or a domain (example.com).

A dimension that combines two dimensions: source and medium. Source is the origin of the incoming traffic. Medium is the category of the source.

The region, state, province, and the like from which a visitor entered your site or app. It's the principal subdivision coded in ISO-3166.

The region, state, province, and the like from which a visitor entered your site or app. It's the secondary subdivision coded in ISO-3166.

The total order value in the local currency, excluding shipping and discounts.

The total order value, excluding shipping and discounts, converted to the site or app currency.

The total order value, excluding shipping and discounts, converted to the base currency (USD).

The total tax amount of the order in the local currency.

The total tax amount of the order, converted to the site or app currency.

The total tax amount of the order, converted to the base currency (USD).

The time of one or more redirects that occurred. Transactions that don’t have any HTTP redirections are not included in calculating the average value.

The amount of time the visitor spent on the page.

The time from the user request (for example, click a link or submission of the URL in the browser) to the point when page content and main scripts are loaded and the user can interact with the page. It’s the time of the transaction between the client and the server.

The time taken to process the page document HTML and CSS.

The total number of products in the cart.

The number of times a content block was uniquely displayed to visitors. Each unique combination of a content name, piece, and target is counted once per session.

The number of unique content impressions during a session.

The number of times visitors uniquely interacted with a content block, for example, clicked an element in a content block. Each unique combination of content name, piece, and target is counted once per session.

The number of unique content interactions during a session.

The number of tracked unique custom events. Each unique combination of an event category, action, and name is counted once per session.

The number of unique custom events during a session.

The number of unique clicks on links to downloadable files. When a visitor clicks the same link many times during a session, it will be counted only once.

The number of unique download events during a session.

The number of uniquely completed goals. Repeated goals are counted only once per session.

The number of unique items in an order or an abandoned basket.

The number of unique clicks on links to external domains. When a visitor clicks the same link many times during a session, it will be counted only once.

The number of uniquely clicked outlinks during a session.

The number of times a page was uniquely visited. If a visitor views a page several times during one session, it will be counted only once.

The number of unique page views during a session.

The number of unique products. When a customer orders two iPhone 14s, the product quantity will be 2, and the unique product count will be 1.

The number of the product purchases (orders with the product added to the cart).

The number of unique searches on your site or app. Each unique combination of a search keyword and category is counted once per session.

The number of unique searches on your site or app during a session.

The number of uploaded files.

The number of times a file was uploaded during a session.

The ID of the visitor coming from an external source.

The number of visitors with the User ID.

A unique identifier of the visitor.

The number of unique IP addresses with the IPv4 protocol.

The number of unique visitors. Every visitor is counted once, even if they visit the site or app many times in a given date range.

Week of the year

Week of the year

An enabled or disabled Windows Media Player plugin in the visitor’s browser.

Year such as 2017.

Year and month.

Year, month, day, and hour.

Year and quarter.

Year and week.