Reports are automatically generated and delivered via email to the email address used when you signed up for the service. The email will contain a link to download the report file. You can also access the reports directly from the UI under the report folder through the Explore feature.

     
*Please note that during this initial beta release, only Daily reporting will be active. All other reporting periods will be made available shortly.

Report Format

Reports are generally in .xlsx format that can be opened through Excel, Google Sheets, Tableau or other BI Tools.

Data categories are organized as sheets and each sheet contains the data in table format.

Data categories

daily

This is a running 30 day report that provides traffic statistics and trends over time.

The column definitions are the following:

• date – A date represented in YYYYMMDD format
• page_view – The total number of pageviews for a specific date
• session – The total number of sessions for a specific date
• uniq – The total number of unique visits for a specific date
• new – The total number of new visits for a specific date
• repeat – The total number of repeat visits for a specific date

site-path

This report lists the combination of site and pages accessed within a 24hr period.

The column definitions are the following:

• site – The domain name of the site being accessed
• path – The specific page path that was accessed
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions to a page

rsite

This report lists the different referring sites that were logged within a 24hr period.

The column definitions are the following:

• rsite – The domain name of the referring site (note: an empty rsite means a Direct Access)
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions from a referrer

title

This report lists the page by their page title accessed within a 24hr period.

The column definitions are the following:

• title – The page title of the page being accessed
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions to page

camp

The column definitions are the following:

• camp – The campaign setting name
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions from a campaign

site

This report lists the sites accessed within a 24hr period.

The column definitions are the following:

• site – The domain name of the site being accessed
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions for a site

skey

This report lists the different search keywords that were logged within a 24hr period.

The column definitions are the following:

• skey – The search keyword used
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions from a search keyword

rgn

This report lists the different country/regions that were logged within a 24hr period.

The column definitions are the following:

• rgn – The country and region (state, prefecture, etc.)
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions from a country:region

ua

This report lists the different browser-os combinations that were logged within a 24hr period.

The column definitions are the following:

• ua – The useragent browser and OS combination
• page_view – The number of pageviews
• session – The number of total sessions
• uu – The number of unique visitors
• new_session – The number of new visitor sessions
• bounce – The total number of single page access then immediate exit
• bounce_rate – The ratio of bounces vs total sessions for a useragent

cv-summary-[conversion]

If you established a Conversion setting, then this report lists the overall conversion statistics for the specific [conversion] setting.

The column definitions are the following:

• uid – The identifier for the user
• ua – The useragent browser and OS combination
• ip – The IP of the user
• title – The title of the conversion page that the user accessed
• count – The number of times the user accessed the conversion page

The conversion feature allows you to set conversion goals for your site or app. Conversion goals can be any event or action that users perform on your site which has value to you. This can include things like sign-ups, downloads, purchases, etc.

Add Conversion Goal

To create a new conversion setting, follow these steps:

1. Click on the Add Setting icon.

2. This will bring up the conversion screen as shown below.

From here, you can enter the settings or conditions to define a conversion event.  To add a setting you must enter the following:

a. Name – This is the name for this setting. Try using something descriptive such as “Newsletter Sign-Up” to make it easy to identify.
b. Comment – This is an optional field. You can add any description or comment regarding this setting here.
c. Value – This is a multipart entry for the setting. Including

* AND | OR - Select AND if you want to make all conditions have to be met to be counted as a conversion. 
             Select OR if you want to make any condition to be met to be counted as a conversion
* Type - Currently only Path is available. Path means page-path which mean page URL.
* Condition - The condition selector lets you select what are matching conditions 
              (e.g - equal to, not equal to, include, not include, etc.)
* Value - The value field is for entering the specific conversion item such as the page-path 
          (e.g. - /newsletter/sign-up)
* Add - This button lets you add more than one Type/Condition/Value combination for your conversion setting.

3. Click on the Save button to save your setting.

The User Setting feature is accessible by clicking on your username.

It allows you to manage the user settings for your account. From here you can do the following account maintenance tasks:

Change Password

Whenever you need to change your password you can do so here. Simply enter your current password and the new password twice and then Save your new setting. The Reset button will clear the fields.

Basic Info

This section allows you add or modify your contact information. There are two read only fields which are User Name and Start Date. The remaining fields are standard contact information in case you want to be contacted by phone or mail. If you ever need to cancel your account, simply click on the Cancel Subscription button and confirm your request.

Setting

This section allows you to updated the email address associated with your account as well as the Time Zone. Time zone settings will affect report files as well as log file time stamps.

The Explore feature is the file manager tool for the MyData Service. With it, you can access both the raw log files for your site tracker as well as the processed report files.

The data is organized in a folder and file structure, where individual files reside under various folders or subfolders. The two main folders are the data and report folders. Under both, you will find files organized under year, month and day subfolders.

There are a set of utilities at the top of the table that perform a variety of functions including:

1. Download icon allows you to choose files or folders to download from the current path.
2. Upload icon allows you to choose files to upload to the current path.
3. Folder icon allows you to create a new folder in the current path.
4. Information icon will calculate the total number of files and bytes in the current path.
5. Refresh icon will get the latest list of files.
6. Current Path displays which folders and files you have currently selected.
7. Copy Path allows you to copy the path string.
8. Delete icon allows you  to delete the file or folder from the current path.

Working with files

Navigate to the file you want to work with by expanding the relevant folders. Click on the file name to open a file screen. From here you have the option to either Download or Delete the chosen file.

Files are in csv format and can be opened using Excel, Google Sheets or most spreadsheet software.

Working with folders

When you want to download all the files under a specific folder, instead of downloading each file one by one, you can do so by using the download files function.

Simply select the lowest folder level where all your target files are located, and then click on the download files icon.

The Download folder screen will pop up notifying you which folder you are downloading from, the total number of files in that folder, and the total data size in bytes.

Click on the Download icon to begin downloading files to your local storage. Folders are downloaded as a compressed tar files so will need to be decompressed with an unzipping tool.

File Definitions

Log File

Log files are generated hourly and stored under the date subfolder. Each row corresponds to an event logged by the tag server (e.g. – pageview, file download, etc.).

The column definitions are the following:

1. GID – Your Group ID
2. Timestamp – Unix time in seconds
3. Visitor ID – The best (usually oldest) cookie or ID from COK1, COK3, JDAT or DVID
4. IP – The IP address of the visitor
5. Site – The domain name of the site being tracked
6. Path – The page that was accessed
7. Referrer – The domain name of any referring site
8. Ref Path – The specific page from the referring site (if any) that visitor came from
9. User Agent – The useragent of the visitor
10. Custom – Any custom data set by you
11. Cookie1 – 1st party cookie set by Javascript
12. JDAT – Username from Javascript’s local storage
13. Cookie3 – 1st/3rd party cookie set by Tag server
14. DVID – Mobile Device ID
15. Res_W – Screen width
16. Res_H – Screen height
17. Win_W – Browser width
18. Win_H – Browser height
19. Title – Page title
20. Protocol – The protocol http/https/etc

Logs can be used for further analysis using other tools such as Pivot Billions, Essentia, Power BI or Tableau.

Step 1. Client DNS Admin creates host name for the domain hosted by client for tag service (example – tag.clientdomain.com). This action is performed by the DNS admin in their hosted DNS service (or their DNS server).

The new DNS record set should use AuriQ Systems Application Load Balancer DNS name as the record target.

mydata-load-balancer-1957641897.us-east-1.elb.amazonaws.com

Example

In the example shown below, we use Amazon Route 53 to create our host name for the tag service using the following settings:

1. Name:   demotagtest.pivotbillions.com
2. Type:   CNAME
3. Target:  mydata-load-balancer-1957641897.us-east-1.elb.amazonaws.com

(Please note that if you are not using Route 53, your DNS configuration settings may differ.)

Step 2. From the AuriQ Systems UI, client will access the Tag Setting section. From here select the Request SSL Certificate option as shown here:

Step 3. Enter the host name created in step 1 into the Domain Name Field and click on the Request button.

After the “Need to verify through DNS” message displays, click on the Cancel button to close the form.

Step 4. The Tag Setting section should now display the following options.

Click on the SSL Certificate Status option to open the status window as shown below:

Step 5. From the Tag Status window, copy the DNS record shown below (Name, Type, Value) and then send this to your DNS Admin to add it to Client DNS server

Your DNS Admin will need to create a DNS record using these settings to validate the SSL cert.

1. Name (only include portion within quotes and exclude domain)
2. Type (select CNAME option)
3. Value (only include portion within quotes)

(Please note that if SSL cert is not validated within 72 hours, then you will need to request a new SSL cert.  This requires selecting the Remove SSL Certificate option and then starting over from Step 2.)

Example

In the example shown below, we use Amazon Route 53 to create our host name for the tag service using the values from the Tag Status image above.

(Please note that if you are not using Route 53, you may need to disable the option to resolve the Value of your DNS setting, otherwise this may cause an error.)

Step 6. After the DNS information has been configured the new SSL certificate should change from “Pending Validation” to “Success”. (Please note this may take up to 15-20 minutes).

Before

After

Step 7. Next click on the Attach SSL Certificate option.

You will be asked to confirm by clicking on the Attach button to attach the SSL certificate.

Step 8. The Tag Setting options will change after attaching the SSL certificate to what is shown below.

Step 9. You can now copy and paste the new custom tracking tag into your web pages anywhere between the <body></body> html tags.

Step 10. After you’ve installed your custom tag, you can verify if they are working properly by clicking on the View log option.

This will pop up the Tag Log that shows real-time firing of the tracking tag.

Step 1. Go to https://mydata.pivotbillions.com

Step 2. Click on the Sign up link towards the bottom of the login box.

Step 3. In the sign up box, enter a Username, Email address and Password and then click on the Sign up button.

Step 4. You will be prompted for a verification code that will be sent to the email address you entered.

Step 5. Copy and paste your verification code from the email sent to you and then click on the Confirm Account button.
     

Step 6. At this point you will be logged into the UI as shown below.