This app captures analytics data and stores it in a private analytics database hosted by Amazon Web Services in the United States of America.

The app collects limited information to help us determine the areas to focus on our future releases. We include the Support Entitlement Number (SEN) and other anonymous identifiers to improve the customer support experience. All fields that could potentially contain personally identifiable information are cleansed of that data before it is transmitted to our servers.

You can opt-out at any point by toggling the analytics option to "off" within the app's Global Configuration screen.

Install

This data is collected each time the app is installed.

{
  "event": {
    "timestamp": "2021-01-14T09:57:24.266Z",
    "created_at": "2021-01-14T09:57:24.266Z",
    "id": "60001584c7f07c0001209773"
  },
  "eventInfo": {
    "type": "installed"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://bobswift21.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.856.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

Uninstall

This data is collected each time the app is uninstalled.

{
  "event": {
    "timestamp": "2021-01-13T06:17:00.678Z",
    "created_at": "2021-01-13T06:17:00.678Z",
    "id": "5ffe905c700de90001a09cdc"
  },
  "eventInfo": {
    "type": "uninstalled"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://bobswift21.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.851.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

Global configuration

This data is collected when the administrator changes the app's global configuration.

{
  "event": { 
	"timestamp": "2021-02-15T05:41:33.630Z", 
	"created_at": "2021-02-15T05:41:33.630Z", 
	"id": "602a098debb0130001027568" 
  }, 
  "eventInfo": { 
	"userId": "5d28bc13cbb3670c1fa15a6b", 
	"type": "globalConfig", 
	"settings": { 
	  "transactionIsolation": { 
		"newValue": "NONE", 
		"oldValue": "READ_COMMITTED" 
	  }, 
	  "limit": { 
		"newValue": "5000", 
		"oldValue": "1000" 
	  }, 
	  "rowsPerPage": { 
		"newValue": "100", 
		"oldValue": "50" 
	  } 
	} 
  }, 
  "hostInfo": { 
	"host": "https://harinath.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
	"links": { 
	  "marketplace": [ 
	    { 
		  "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql" 
		} 
	  ], 
	  "self": [ 
		{ 
		  "href": "https://harinath.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
	  ] 
    }, 
    "host": { 
	  "product": "Confluence" 
    }, 
    "lastUpdated": "2021-02-15T05:04:34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "org.swift.confluence.sql", 
    "installedDate": "2021-02-15T05:04:32Z" 
  }
}

New macro

This data is collected on the first instance when a user creates a page and inserts the macro.

{
  "event": {
    "timestamp": "2021-01-14T12:08:09.730Z",
    "created_at": "2021-01-14T12:08:09.730Z",
    "id": "600034298d85f10001977434"
  },
  "eventInfo": {
    "pageId": "146440216",
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "type": "macroConfigured"
  },
  "hostInfo": {
    "host": "https://bobswift27.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://bobswift21.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

Page render

This data is collected each time the page with an SQL for Confluence macro is refreshed.

{
  "keen": {
    "timestamp": "2021-01-14T12:05:49.682Z",
    "created_at": "2021-01-14T12:05:49.682Z",
    "id": "6000339d6205f400018a1c87"
  },
  "eventInfo": {
    "pageId": "146440216",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "renderTime": 27545.864999992773,
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "type": "pageRender"
  },
  "hostInfo": {
    "host": "https://bobswift27.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://bobswift21.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

Analytics data - Cloud

Install

Uninstall

Global configuration