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 settings page 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:
To download a file compatible with Microsoft Excel add &excel=true to the API call URL
Triggered Emails Report
Action to use in URL : triggered_emails_report
The report specify the performance of triggered emails on daily basis.
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
Product Recommendations Report
Action to use in URL : recommendations_report
The report specify the performance of onsite product recommendations
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:
- 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