Querying Bronto using ShufflePoint

Summary

Bronto is an Email Service and Marketing Automation Provider.

The integration with Bronto is fairly straightforward and allows you to pull all the major email marketing metrics into Excel with a single query. That data can then be easily matched with data from other tools, i.e. Google Analytics traffic or commerce data, via a key such as a campaign ID.

Setup

To set up the integration you must login to your Bronto account and retrieve your API key. Instructions on doing this can be found in Bronto's documentation here: http://dev.bronto.com/question/how-get-api-key.

Once you have your Bronto API key simply login to ShufflePoint and go to the "Manage Datasources" page. Scroll down to the "Credential or Key Based Datasources" and find Bronto. Insert your API key and click "Update datasources."

Once this is done you can test a query either in the query tool or a ShufflePoint-connected Excel workbook.

Running Queries

Get standard campaign metrics

SELECT
  METRICS br:numSends, br:numDeliveries, br:deliveryRate, br:numBounces, br:bounceRate, 
       br:uniqOpens, br:openRate, br:numClicks, br:clickRate, br:ctr ON COLUMNS
  DIMENSIONS br:date, br:campaignName ON ROWS
FROM default
  WHERE TIMEFRAME last90Days