Analytics data - Cloud

Owned by Smita Nair
Last updated: Sept 09, 2022 by Nisha Shantilal
6 min read

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://xxxxxxxxxx.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://xxxxxxxxxx.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": "NONE", 
	  "limit": "5000",  
	  "rowsPerPage": "100"
	} 
  }, 
  "hostInfo": { 
	"host": "https://xxxxxxxxxx.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
	"links": { 
	  "marketplace": [ 
	    { 
		  "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql" 
		} 
	  ], 
	  "self": [ 
		{ 
		  "href": "https://xxxxxxxxxx.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" 
  }
}

Data source profile configuration

This data is collected when a Confluence administrator creates or updates a data source profile.

{
  "event": {
    "timestamp": "2021-02-22T04:54:49.969Z",
    "created_at": "2021-02-22T04:54:49.969Z",
    "id": "603339196d6b8400015ac5e6"
  },
  "eventInfo": {
    "profileName": "test",
    "type": "profileAdded",
    "userId": "5d28bc13cbb3670c1fa15a6b",
    "settings": {
      "userName": "",
      "authType": "basic",
      "password": "",
      "limitRowsProcessed": null,
      "limitQueryTime": null,
      "hostName": "",
      "portNumber": 243,
      "databaseName": "",
      "databaseType": "postgresql"
    }
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-02-22T04:18:51Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-22T04:18:47Z"
  }
}


Macro configuration

This data is collected when a user inserts or updated the configuration of an SQL for Confluence page 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://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.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://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.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"
  }
}

Error

This data is collected whenever a user encounters an error using SQL for Confluence.

{
  "event": {
    "timestamp": "2021-02-24T12:26:49.161Z",
    "created_at": "2021-02-24T12:26:49.161Z",
    "id": "603646096cd44b00010da39d"
  },
  "eventInfo": {
    "pageId": "1000177665",
    "parameters": {
      "pagination": "false",
      "pageSize": 25,
      "queryTimeout": 120,
      "limit": "50",
      "dataSource": true,
      "showSql": "true",
      "rowsPerPage": 25
    },
    "type": "pageRender",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "macroId": "3b319870-29ab-4256-a67e-2de2b0e77ae4",
    "error": {
      "message": "Profile Not Found"
    },
    "renderTime": 6548.155000000406,
    "macroName": "sql-query"
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-02-24T08:22:43Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-24T08:22:41Z"
  }
}

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.