Renta supports data export from Calltouch to following destinations:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
Integration creating in data warehouse (DWH)
- Go to integrations catalog;
- Select Calltouch;
- Add a Calltouch account that has the necessary data;
- Choose the added Calltouch account;
- Specify the destination you want to import the data into;
- Go to the settings screen and set necessary configuration:
Report type
Report type consists of the unique set of parameters and metrics available for uploading to DWH. Each Report Type has its own parameters and metrics collection.
| Name | Description |
|---|---|
| Calls | Returns all calls data. |
| Requests | Returns all requests data. |
| Orders | Returns all orders data. |
Parameters
Parameters contains the list of parameters and metrics available for export. Specify the parameters required for uploading.
As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.
Filters
Call attribution model
In this tab you can choose how inserting data will be filtered: by last interaction or by last indirect.
Bind to
In this tab you can tie your report with either by date of calls or by date of session.
Unique
In this tab you can choose the uniqueness of inserting data: unique, repeated or both.
Target
In this tab you can choose targeting of inserting data: target, untarged or both.
Unique-Target
In this tab you can combine the previous 2 filters: uniquely targeted, non-unique targets or both.
Callback
In this tab you can choose how inserting data will be filtered: by associated with transactions or by non associated with transactions.
With orders
In this tab you can choose how inserting data will be filtered: by last interaction or by last indirect.
Date range type
Choose the inserting period. You can specify any historical time interval.
To select the necessary time, enter the date from which you want to start uploading data in the “From” field, then enter the end date in the “To” field.
If you want the data in the table to be updated daily and supplemented with new days, then enter “Yesterday” in the “To” field.
Detailed instructions for working with a date range.
Integration name
There is an auto generated name for your integration and here you can edit it as much as you like.
Both Cyrillic and Latin are permitted, but not more than 100 symbols.
The integration name is displayed on the Integration List page.
Table name
There is an auto generated name for your table and here you can edit it as much as you like.
Only Latin is permitted, numbers and “_” symbol.
Update time
You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.
In that case your integration will update in period from 5 AM to 6 AM.
Integrations are updating according to the time zone selected in your profile settings.
Overwrite period
Data overwrite period is a retrospective update of data for the selected period.
For instance you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.
Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.
Integration creating in Google Spreadsheets
Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:
- Install the extension Renta Spreadsheets Add-on.
- Then go to Google Sheets and in the Tools tab select Renta
- Press the Run button.
After that a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.
Data Structure
| Name | Description | Type |
|---|---|---|
| callId | The unique identifier for a call in a calltouch. | INTEGER |
| attribution | Call attribution model. | STRING |
| callerNumber | Caller number | STRING |
| redirectNumber | Redirect number If the call forwarding number is not one (the dialing group is configured for several numbers or the call forwarding number is foreign), then the value 'undefined' will be substituted. | STRING |
| date | Date of the call | DATE |
| datetime | Date and time of the call | DATE |
| waitingConnect | Waiting time for a response. | INTEGER |
| duration | The duration of the conversation. | INTEGER |
| phoneNumber | Called number. | STRING |
| successful | Call status | STRING |
| uniqueCall | Unique call | STRING |
| targetCall | Target call | STRING |
| uniqTargetCall | Uniquely targeted call | STRING |
| callbackCall | Callback call | STRING |
| source | Source | STRING |
| medium | Medium | STRING |
| keyword | Keyword | STRING |
| url | The address where they hit the site. | STRING |
| callUrl | The page address on which the visitor made a call. | STRING |
| ref | The address from which you went to the site. | STRING |
| utmSource | The value of the utm-tag utm_source. | STRING |
| utmMedium | The value of the utm-tag utm_medium. | STRING |
| utmCampaign | The value of the utm-tag utm_campaign. | STRING |
| utmContent | The value of the utm-tag utm_content. | STRING |
| utmTerm | The value of the utm-tag utm_term. | STRING |
| sessionId | The unique identifier for the calltouch session. | INTEGER |
| clientId | The unique identifier for Universal Analytics. | STRING |
| yaClientId | The unique ID for Yandex.Metrica. | STRING |
| sipCallId | The unique identifier of the session with the Calltouch PBX. Its value is sent to your equipment in case of using SIP trunk redirection. It can be useful when integrating with your PBX. | STRING |
| userAgent | Information about the device from which you visited the site. | STRING |
| ip | The IP address of the visitor. | STRING |
| order-createdDate | contract creation date | DATE |
| order-completedDate | date of contract signing | DATE |
| order-orderDate | Order date | DATE |
| order-orderNumber | Order number | STRING |
| order-plannedAmount | Estimated order amount | FLOAT |
| order-completedAmount | Real order amount | FLOAT |
| order-phoneNumber | Order phone number | STRING |
| order-source | Order source | STRING |
| order-sessionId | Order session ID | STRING |
| order-utmSource | Order utm_source | STRING |
| order-utmMedium | Order utm_medium | STRING |
| callreferenceId | The unique identificator of the call. | STRING |
| siteId | Identificator for the site. | STRING |
| yandexDirect-campaignId | Identificator of the campaign from Yandex Direct ad. | INTEGER |
| yandexDirect-adGroupId | Identificator of the group from yandex direct ad. | INTEGER |
| yandexDirect-adId | Identificator of the ad from Yandex Direct ad. | INTEGER |
| yandexDirect-criteriaId | Phrase identificator from Yandex Direct ad. | INTEGER |
| googleAdWords-campaignId | Campaigns identificator from Google Adwords ad. | INTEGER |
| googleAdWords-adGroupId | Adgroups identificator from Google Adwords ad. | INTEGER |
| googleAdWords-creativeId | Identificator of the creative from Google Adwords ad. | INTEGER |
| googleAdWords-criteriaId | Identificator of the phrase of the customer from Google Adwords. | INTEGER |
| mapVisits.sessionDate | Parameter contains customers visit history. | Добавить в маппинг: Array(Nullable(DateTime)) |
| mapVisits.sessionId | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.ip | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.city | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.source | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.medium | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.keyword | Parameter contains visit history. | ARRAY(STRING) |
| mapVisits.url | The urls visit history. | ARRAY(STRING) |
| mapVisits.ref | Parameter contains customers history. | ARRAY(STRING) |
| mapVisits.utmMedium | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmSource | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmTerm | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmContent | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmCampaign | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.guaClientId | The identificator of clients visit history. | ARRAY(STRING) |
| callTags.category | Category of the calltag. | ARRAY(STRING) |
| callTags.type | Type of the calltag. | ARRAY(STRING) |
| callTags.names | Names of the calltags. | ARRAY(STRING) |
| date | Date of the call | DATE |
| datetime | Date and time of the call | DATE |
| source | Source | STRING |
| medium | Medium | STRING |
| keywords | Keywords | STRING |
| url | The address where they hit the site. | STRING |
| ref | The address from which you went to the site. | STRING |
| utmSource | The value of the utm-tag utm_source. | STRING |
| utmMedium | The value of the utm-tag utm_medium. | STRING |
| utmCampaign | The value of the utm-tag utm_campaign. | STRING |
| utmContent | The value of the utm-tag utm_content. | STRING |
| utmTerm | The value of the utm-tag utm_term. | STRING |
| sessionId | The unique identifier for the calltouch session. | INTEGER |
| guaClientId | The unique identifier for Universal Analytics. | STRING |
| yaClientId | The unique ID for Yandex.Metrica. | STRING |
| ip | The IP address of the visitor. | STRING |
| siteId | Identificator for the site. | STRING |
| yandexDirect-campaignId | Identificator of the campaign from Yandex Direct ad. | INTEGER |
| yandexDirect-adGroupId | Identificator of the group from yandex direct ad. | INTEGER |
| yandexDirect-adId | Identificator of the ad from Yandex Direct ad. | INTEGER |
| yandexDirect-criteriaId | Phrase identificator from Yandex Direct ad. | INTEGER |
| googleAdWords-campaignId | Campaigns identificator from Google Adwords ad. | INTEGER |
| googleAdWords-adGroupId | Adgroups identificator from Google Adwords ad. | INTEGER |
| googleAdWords-creativeId | Identificator of the creative from Google Adwords ad. | INTEGER |
| googleAdWords-criteriaId | Identificator of the phrase of the customer from Google Adwords. | INTEGER |
| mapVisits.sessionDate | Parameter contains customers visit history. | Добавить в маппинг: Array(Nullable(DateTime)) |
| mapVisits.sessionId | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.ip | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.city | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.source | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.medium | Parameter contains customers visit history. | ARRAY(STRING) |
| mapVisits.keyword | Parameter contains visit history. | ARRAY(STRING) |
| mapVisits.url | The urls visit history. | ARRAY(STRING) |
| mapVisits.ref | Parameter contains customers history. | ARRAY(STRING) |
| mapVisits.utmMedium | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmSource | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmTerm | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmContent | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.utmCampaign | Utm-tags visit history. | ARRAY(STRING) |
| mapVisits.guaClientId | The identificator of clients visit history. | ARRAY(STRING) |
| requestType | Type of the request. | STRING |
| browser | Customers browser. | STRING |
| city | Customers city. | STRING |
| attribution | Call attribution model. | STRING |
| subject | The voluntary forms name on users website. | STRING |
| uniqTargetRequest | The unique target request. | BIT |
| uniqueRequest | The unique request. | BIT |
| requestNumber | The number of the request. | STRING |
| requestId | The identificator of the request. | INTEGER |
| targetRequest | The target Request. | BIT |
| status | Status. | STRING |
| client_fio | Clients full name. | STRING |
| client_clientId | The clients identificator. | INTEGER |
| client_phones.phoneNumber | The phone number of client. | ARRAY(STRING) |
| client_phones.phoneType | Type of the phone. | ARRAY(STRING) |
| client_contacts.contactType | The contact type of clients. | ARRAY(STRING) |
| client_contacts.contactValue | Array that contains clients email. | ARRAY(STRING) |
| date | Date of the call | DATE |
| datetime | Date and time of the call | DATE |
| visit_source | Source | STRING |
| visit_medium | Transition channel. | STRING |
| visit_keyword | The keyword order. | STRING |
| visit_utmSource | The value of the utm-tag utm_source. | STRING |
| visit_utmMedium | The value of the utm-tag utm_medium. | STRING |
| visit_utmCampaign | The value of the utm-tag utm_campaign. | STRING |
| visit_utmContent | The value of the utm-tag utm_content. | STRING |
| visit_utmTerm | The value of the utm-tag utm_term. | STRING |
| siteId | Identificator for the site. | STRING |
| requestType | Type of the request. | STRING |
| client_fio | Clients full name. | STRING |
| completedAmount | Completed Amount. | FLOAT |
| isDeleted | Shows if the order is deleted or not. | BIT |
| manager | Manager that is responsible for the order. | STRING |
| orderNumber | Number of the order. | STRING |
| orderDate | Date of the order. | STRING |
| order_callId | The identificator of call. | INTEGER |
| order_duration | Duration of the order. | FLOAT |
| order_phoneNumber | Phone number of the order. | STRING |
| order_type | Type of the order. | STRING |
| order_ani | STRING | |
| order_dateCall | Orders date of the call. | STRING |
| order_requestNumber | Number of request order. | STRING |
| orderStatus | Status of the order. | STRING |
| plannedAmount | Deals budget. | FLOAT |
| service | Services name that is using Calltouch API. | STRING |
_______________________________________________
If you have any questions – please contact us!