Using Data Explorer

The Data Explorer functionality enables you to run queries on the data of a specific AB Tasty account.

This means you can collect precise behavioral data linked to your campaigns.

Queries are run via a form. Two types of indicators are available: dimensions and metrics. Dimensions coincide with a description or feature of your data. For instance, you can collect data on the user’s visitor ID, the type of device they used, their browser, as well as their country or city.

Metrics coincide with the quantitative measurement of your data. For instance, you can find out the number of visitors, sessions, transactions, page views as well as the average price of a purchased item.

Dimensions and metrics can be combined, and you may select as many as you like.

When you run a query via the data explorer, AB Tasty queries the Universal collect (Ariane) database.

The results are displayed under the form, in a table that combines all the information. This raw data can be processed by data analysts and used to create statistics to complement the reporting function.

Creating a query

To create a query using the data explorer, apply the following steps: 

1. Log in to AB Tasty at: https://app.abtasty.com/login,
2. From the dashboard, click Insights > Data Explorer.
3. Fill in the various fields.
   
   

   👍	To delete an indicator, click the cross to the left of it. To delete all indicators from a field, click the cross to the right of the field.

4. Click Run the query.

Filling in the form

To fill in the form, you need to enter the following fields:

Accounts

Use the drop-down list to select the account you want to collect information on. The accounts for which you have administrator status are displayed.

Start date

Select the date starting from which you want to collect information. To do this, enter a date manually using the YYYYMMDD format or use the calendar to select one.

 

End date

Select the date up to which you want to collect information. To do this, enter a date manually using the YYYYMMDD format or use the calendar to select one.

Dimensions

Dimensions coincide with a description or feature of your data.

You can select as many dimensions as you like from the following:

Category	Value	Description
General	Date	The date on which the session was opened.
	Week	The week of the current calendar year.
	Customer ID	The customer ID (unique number).
	Is New Visitor	The visitors visiting the page for the first time.
Traffic source	Medium	How the user accessed the website (newsletter, etc.).
	Referral path	The path via which the visitor accessed the website/page.
	Source	The page which enabled the user to access the website/page.
Device	Browser name	The name of the browser used.
	Browser version	The version of the browser used.
	Device	The type of device used to view the website/page (Smartphone, tablet, computer).
	Operating system	The operating system used.
	Operating system version	The version of the operating system used.
	Browser size	The size of the browser window (width x height format).
	Flash version	The Flash version used.
	Language	The chosen browser language.
	Screen Colors	The color depth on the user’s screen.
	Screen resolution	The resolution on the user’s screen.
	Screen resolution width	The width of the resolution on the user's screen.
Geo network	Country	The country from which the user viewed the page/website.
	Country ISO code	A two-character ISO 3166-1 country code for the country associated with the IP address.
	Least specific subdivision ISO code	A string of up to three characters containing the region-portion of the ISO 3166-2 code for the region associated with the IP address.
	Most specific subdivision ISO code	A string of up to three characters containing the region-portion of the ISO 3166-2 code for the region associated with the IP address.
	Region	The State/region from which the user viewed the page/website.
	City	The city from which the user viewed the page.
	City ID	Users' city ID, derived from their IP addresses or Geographical IDs
	Latitude	The approximate latitude from which the user viewed the page/website. Cities north of the equator have positive values and cities south of the equator have negative values.
	Longitude	The approximate longitude from which the user viewed the page/website. Cities east of the prime meridian have positive values and cities west of the prime meridian have negative values.
Page tracking	Hit ID	The unique hit ID.
	Hit number	The index of the hit in the current session.
	Min hit number
	Hit hour	The hour at which the hit is recorded.
	Hit minute	The minute at which the hit is recorded.
	Hit referer	The name of the reference hit.
	URL	The complete URL from which the visitor landed.
	Page Path	The page path.
	Next Page Path	The next page path.
	Hostname	The domain name.
	Page title	The page title. Several pages can have the same title.
	Is Entrance page	The page via which the visitor landed on the website.
E-commerce	Transaction ID	The transaction ID, provided by the e-commerce tracking method.
	Affiliation	The transaction name.
	Currency code	The code (based on the ISO 4217 standard) of the local currency with which the transaction was made.
	Item count	The number of items in the transaction (better use the corresponding metric)
	Item transaction ID	The transaction ID during an item purchase.
	Name	The name of the product included in the transaction.
	Category	The category of the product included in the transaction.
	Product SKU	The identifier of the product purchased on the website.
Event Tracking	Event category	The event category.
	Event Action	The type of action of the event.
	Event Label	The event label.
	Event Value	The total value of the events.
AB Tasty	Campaign ID	The ID of the AB Tasty campaign.
	Variation ID	The ID of the AB Tasty campaign variation.
Platform or device	Hit type	The type of hit (such as “campaign”, “pageview”, “event”, etc.).
	Hit Campaign ID	The campaign ID.
	Hit variation ID	The ID of the variation viewed by the visitor.
	Hit Queue time	The time difference (in milliseconds) between the moment the reported hit arrived and the moment it was sent.
	Data Source	The data source of a result.
Custom variable	Custom Variable Index	The index of the custom variable.
Custom dimension	Custom Dimension Index	The index of the custom dimension..
	Custom Dimension Value	The value of the custom dimension.
Custom metric	Custom Metric Index	The index of the custom metric.
	Custom Metric Value	The value of the custom metric.
E-commerce	Transaction Revenue	The total transaction revenue.
Application Information	Screen Name	The name of the screen.
NetPromoterScore	NPS Score	Les rating (from 0 to 10) given by the visitors to the NPS survey.
	NPS Feedback	The comments given to the NPS survey by the visitors.

Metrics

Metrics are the figures extracted from the database. They are expressed in the form of numbers. You can select as many as you like from the following:

Category	Value	Description
Sessions	Sessions	The total number of sessions.
	Number of sessions per user	The total number of sessions divided by the number of users.
	Percentage of new sessions	The percentage of new sessions.
	Session duration	The duration (in seconds) of a user session.
	Bounces	The total number of sessions for a unique page.
	Bounce rate	The percentage of sessions of a unique page.
	Avg session duration	The average duration (in seconds) of a user session.
	Hits	The total number of hits for a user.
Users	Users	The total number of users.
	New users	The number of sessions recorded as a new user.
	Revisit	The number of times users revisit a specific page.
Page tracking	Pageviews	The total number of pages seen by a user.
	Unique pageviews	The number of sessions during which a specific page was viewed at least once.
	Pages / session	The average number of pages seen during a session, including repeated views of the same page.
	Pages / user	The average number of pages seen by a user.
E-commerce	Transactions	The total number of orders generated by your website.
	Unique transactions	The number of times a product (or set of products) was included in an order.
	Revenue	The total revenue of the transaction (excluding shipping and tax).
	Avg order value	The average revenue of an e-commerce transaction.
	Revenue per user	The total revenue of the transaction (excluding shipping and tax) divided by the total number of users.
	Shipping	The total shipping cost.
	Tax	The total tax related to the transaction.
	Transaction rate	The transaction rate.
	Transaction rate per user	The transaction rate per user.
	Items quantity	The total number of items purchased.
	Unique purchases	The number of purchased products belonging to the same category.
	Items revenue	The total cost of the transaction (excluding shipping and tax).
	Items per purchase	The average number of items per transaction.
	Avg item price	The average price of a purchased item.
Event tracking	Total events	The total number of events for a user across all categories.
	Unique events	The number of unique events. Events with different sessions are considered as separate events.
NetPromoterScore	NPS Count	The number of users who gave a rating via the NPS widget.
	NPS Promoters	The number of promoters (users who gave a rating of 9 or 10).
	NPS Passives	The number of passives (users who gave a rating of 7 or 8).
	NPS Detractors	The number of detractors (users who gave a rating of 0 to 6).
	NPS	The final rating (% of detractors - % de promoters).
Base	Ghost	Selecting no specific metric.

⚡	The more dimensions and metrics you select, the longer the results take to load.

Filters

You can filter your search results. To do this, you need to use specific syntax. 

Operator	Syntax	Example
Or	,	campaignId==123456,campaignId==789321
And	;	device==desktop;device==mobile
Equal (String)	==	city==PARIS
Contains	=@	itemName=@tshirt
Regex	=~	campaignId=~^\d{6}$
Equal (digit)	==	transactionRevenue==13.37
Less or equal THAN	<=	sessions<=1500
Greater or equal than	>=	hits>=500
Less than	<	pageviews<42
Greater than	>	shipping>4

Sorting

Once you have chosen the dimensions and metrics you want to see, you can sort the results in ascending or descending order.

Choose at least one metric to enable value selection in the Sort field.

Max

Indicate the maximum number of results you want to see. The more information there is, the longer it takes for the results to load. If you want to limit loading time for the results, you may narrow down the number of results.

Viewing results 

Search results are displayed underneath the form, as a JSON table. Depending on the volume of collected information, the results may take several minutes to load.

To export the results in CSV format, click the Export (CSV) button in the top right-hand section of the screen.

Related articles:

Developer portal - Universal Collect

Account information

Access rights and user management