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:
- Log in to AB Tasty at: https://app.abtasty.com/login,
- From the dashboard, click Insights > Data Explorer.
- 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. - 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. |
|
Longitude |
The approximate longitude from which the user viewed the page/website. |
|
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.
Comments
0 comments
Please sign in to leave a comment.