Follow these simple steps to get started with Sudonum’s Data Studio Connector:
Step 1: Go to the Sudonum Data connector
Follow this link. You can also find the connector directly from Data Studio by clicking on Create, selecting Data Source and searching for “Sudonum”.
Step 2: Connect with your Google account to create a data source
Click on the blue "Create Data Source" button that appears when you hover over the Sudonum Data Connector.
The connector will load with the message "Data Studio requires authorisation to use this community connector". Click on the "Authorise" button and choose the account that you want to connect with and a pop-up window will load, telling you that the Sudonum Data Connector wants to access your Google account. This will link your Google account to the connector service. Click on “Allow” to continue.
Step 3: Log in with your Sudonum API login details
Once you’ve linked your Google account, the connector will reload and a “Credentials” category will appear next to the “Authorise” category. You now need to enter your Sudonum API username and password in the “Credentials” category.
Step 4: Set your data query parameters
If your Sudonum username and password are valid, a form will load where you can enter your query parameters for the data you would like to load into Data Studio.
Please note the following rules, which apply to all data queries:
Entering no parameters:
Entering no parameters is the most common option, and will return all your call detail records for a 13 month period.
Your report will be live (i.e. updated continually) and will only include the most recent historical data for the past 13 months, up to and including two hours prior to the present moment.
All your numbers and different call contexts (e.g. call-tracking, voice-call, sip, etc.) will be included, but you will still be able to add a filter for these in your report after creating it.
The local date included in the report will default to UTC, although there is already a UTC date included in the dataset.
Entering specific dates:
Specifying a “Start Date” will load all call detail records from that date until the current date and time.
This is generally not recommended because the start date will be fixed and your report will keep loading all the historical data from the start date, which can lead to slower loading times over time. You can, however, remove or edit the start date at any time.
Entering an “End Date” returns call detail records for a 13 month period starting 13 months prior to the date entered.
If you enter both a “Start” and “End” date, you will receive all call detail records within this specified date range.
These options are normally used when a report for a fixed period of time (e.g. a given month) is required. The report will not be updated to include more recent call detail records beyond the “End Date”.
Choosing a timezone:
From the “Timezone” dropdown you can select a timezone for the local date that will be included in the report. There is a separate field with a UTC date included regardless of your choice here.
Make a selection if you want your local timezone to appear in the report. If you don't make a selection, you will have two separate date fields which will both have UTC timezone.
At the bottom of the form is a checkbox titled "Use report template for new reports". This is checked by default and will load a predefined report template with your data. You will still be able to edit this report, but this is a good starting point for displaying your data.
NB. There is a limit of 1 000 000 records, which will include data from the “Start Date” and might not include data up until the “End Date”.
Step 5: Create a report
After entering your query parameters (remember, not entering any parameters will return all your call detail records for a 13 month period), click on “Connect” in the top right corner. The data source will load and you will be able to see all the different fields for your data.
Once you see this, click on “Create Report”. When you do, a pop-up will appear telling you that "You are about to create a new report with this data source". Confirm this by clicking on “Create Report”.
That’s it. If you chose to use our “Report Template”, you will now have 2 pages of visualizations containing your data, automatically laid out for you.
Interacting with your data in Data Studio
If you click on the “View” button in the top right corner, you can interact with your data. From here, you can change the date, filter on a specific Sudonum number and watch the data change based on your selection.
If you click on the “Edit” button in the top right corner, you can change any of the visualizations and filters or add new ones to customise the data according to your needs. Enjoy!
Removing authorisation for Sudonum Data Studio Connector
Remove your authorisation from the connector directly in Data Studio by clicking on Create, selecting Data Source and searching for “Sudonum”. Then click on the menu item in the top right of the "Sudonum Data" card and select "Revoke Access".