All Collections
Reporting
Exporting Reports Via API
Exporting Reports Via API
Joel Lang avatar
Written by Joel Lang
Updated over a week ago

You can use the reports export API to automatically or manually request reports in CSV format.
The first line of the report contains columns names.

How to Export Reports

To export reports you need an API access point. Get it from the settingspage on the console.
Find the Reports export API section and copy the access URL from there. If required click Get new reports export access URL first.

The API access URL is in this format:
​https://cbar.barilliance.com/api/export.php?sid=1&key=65a7d277a74814fb50d8b62 To use the API you need to add parameters such as action, from_date and to_date.

A full API call URL looks like this:
​http://cbar.barilliance.com/api/export.php?sid=575&key=65a7d277a74814fb50d8b62&action=triggered_emails_report&date_from=2015-02-08&date_to=2015-02-11&excel=true


Excel csv file format

To download a file compatible with Microsoft Excel add &excel=true to the API call URL.

Exporting report for multiple sites

To export multiple sites in the same report:

Available Reports

Triggered Emails Report

Action to use in URL : triggered_emails_report

The report specify the performance of triggered emails on daily basis.
Columns explanation:
sent_date - The date of sending. format: 2015-02-08
sent - Number of emails sent
opened - Number of emails opened
clicked - Number of emails clicked
converted - Number of emails which resulted in conversion
sales - Total sales generated from the rule
email_type - 0 = Cart Abandonment, 1=Email My cart, 2= Site Abandonment (no cart items or purchase), 3= Post Purchase, 4= Back to stock 5= Visit Summary
rule_number - Which Barilliance rule triggered this email
site_id - Your site id

Personalization Report

Action to use in URL : personalization_report
​
The report specify the performance of onsite personalization rules

Columns Explanation:

siteId - Site Id

ru_rule_id - Rule Id

ru_name - Rule name

exposed - Number of rule exposures

bounced - Number of sessions where visitor bounced during first rule exposure.

clicked - Number of times the rule content was clicked (applies to some of the rules).

cart - Number of sessions in which a visitor has added items to cart after being exposed.

purchased - Number of sessions in which a visitor has purchased after being exposed.

revenue - Revenue of purchases that occurred after the visitor was exposed to the rule.

goals - Number of sessions when a URL set as rule goal was reached after rule exposure.

br - Bounce rate. percentage of bounces on the rule first exposure.

ctr - Click Through Rate - Percentage of exposures that resulted in click (where applicable)

cr - Conversion Rate - % of sessions which ended in conversion after rule exposure

ge - Goals Rate - % of exposures after which the visitor has visited the rule goal URL.

atcr - Add to Cart Rate - % of sessions which ended in add to cart after rule exposure

aov - Average order value of purchases that occured after rule exposure.

Product Recommendations Report

Action to use in URL : recommendations_report

The report specify the performance of onsite product recommendations

Columns explanation:
date - The date of this report row. format: 2015-02-08
uniques_exposed - number of unique visitors who have been served with recommendations
uniques_clicked - number of unique visitors who clicked on recommendations
uniques_converted - unique visitors who have bought a product clicked as recommendation
value - the total amount in the site currency of revenues generated by clicked products
views - Number of page views in which a recommendation widget was shown
clicks - Number of clicks on recommendations
views_H - Home page views with at least one recommendations widget
views_P - Product page views with at least one recommendations widget
views_C - Category page views with at least one recommendations widget
views_S - Search page views with at least one recommendations widget
views_Sc - Cart page views with at least one recommendations widget
views_O - 'other' page type views with at least one recommendations widget
views_OOS - Out of stock page views with at least one recommendations widget
views_U - Unspecified page views with at least one recommendations widget
views_Pu - Purchase page views with at least one recommendations widget

The following columns represent number of clicks on the various page types:

clicks_H
clicks_P
clicks_C
clicks_S
clicks_Sc
clicks_O
clicks_OOS
clicks_U
clicks_Pu

General notes

  • Date format is YYYY-MM-DD in New York time zone

  • By default the recommendations are produced by the recommendation engine also for pages that does not have a visible widget. Therefore you should ignore the data for page types which doesn't contain a visible widget.

  • Possible return values in case of error: invalid access key, invalid action, no results, invalid sid (wrong site id), wrong date format

Did this answer your question?