Calltouch Source

Renta supports data export from Calltouch to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select Calltouch;
  3. Add a Calltouch account that has the necessary data;
  4. Choose the added Calltouch account;
  5. Specify the destination you want to import the data into;
  6. 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.

NameDescription
CallsReturns all calls data.
RequestsReturns all requests data.
OrdersReturns 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:

  1. Install the extension Renta Spreadsheets Add-on.
  2. Then go to Google Sheets and in the Tools tab select Renta
  3. 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

NameDescriptionType
callIdThe unique identifier for a call in a calltouch.INTEGER
attributionCall attribution model.STRING
callerNumberCaller numberSTRING
redirectNumberRedirect 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
dateDate of the callDATE
datetimeDate and time of the callDATE
waitingConnectWaiting time for a response.INTEGER
durationThe duration of the conversation.INTEGER
phoneNumberCalled number.STRING
successfulCall statusSTRING
uniqueCallUnique callSTRING
targetCallTarget callSTRING
uniqTargetCallUniquely targeted callSTRING
callbackCallCallback callSTRING
sourceSourceSTRING
mediumMediumSTRING
keywordKeywordSTRING
urlThe address where they hit the site.STRING
callUrlThe page address on which the visitor made a call.STRING
refThe address from which you went to the site.STRING
utmSourceThe value of the utm-tag utm_source.STRING
utmMediumThe value of the utm-tag utm_medium.STRING
utmCampaignThe value of the utm-tag utm_campaign.STRING
utmContentThe value of the utm-tag utm_content.STRING
utmTermThe value of the utm-tag utm_term.STRING
sessionIdThe unique identifier for the calltouch session.INTEGER
clientIdThe unique identifier for Universal Analytics.STRING
yaClientIdThe unique ID for Yandex.Metrica.STRING
sipCallIdThe 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
userAgentInformation about the device from which you visited the site.STRING
ipThe IP address of the visitor.STRING
order-createdDatecontract creation dateDATE
order-completedDatedate of contract signingDATE
order-orderDateOrder dateDATE
order-orderNumberOrder numberSTRING
order-plannedAmountEstimated order amountFLOAT
order-completedAmountReal order amountFLOAT
order-phoneNumberOrder phone numberSTRING
order-sourceOrder sourceSTRING
order-sessionIdOrder session IDSTRING
order-utmSourceOrder utm_sourceSTRING
order-utmMediumOrder utm_mediumSTRING
callreferenceIdThe unique identificator of the call.STRING
siteIdIdentificator for the site.STRING
yandexDirect-campaignIdIdentificator of the campaign from Yandex Direct ad.INTEGER
yandexDirect-adGroupIdIdentificator of the group from yandex direct ad.INTEGER
yandexDirect-adIdIdentificator of the ad from Yandex Direct ad.INTEGER
yandexDirect-criteriaIdPhrase identificator from Yandex Direct ad.INTEGER
googleAdWords-campaignIdCampaigns identificator from Google Adwords ad.INTEGER
googleAdWords-adGroupIdAdgroups identificator from Google Adwords ad.INTEGER
googleAdWords-creativeIdIdentificator of the creative from Google Adwords ad.INTEGER
googleAdWords-criteriaIdIdentificator of the phrase of the customer from Google Adwords.INTEGER
mapVisits.sessionDateParameter contains customers visit history.Добавить в маппинг: Array(Nullable(DateTime))
mapVisits.sessionIdParameter contains customers visit history.ARRAY(STRING)
mapVisits.ipParameter contains customers visit history.ARRAY(STRING)
mapVisits.cityParameter contains customers visit history.ARRAY(STRING)
mapVisits.sourceParameter contains customers visit history.ARRAY(STRING)
mapVisits.mediumParameter contains customers visit history.ARRAY(STRING)
mapVisits.keywordParameter contains visit history.ARRAY(STRING)
mapVisits.urlThe urls visit history.ARRAY(STRING)
mapVisits.refParameter contains customers history.ARRAY(STRING)
mapVisits.utmMediumUtm-tags visit history.ARRAY(STRING)
mapVisits.utmSourceUtm-tags visit history.ARRAY(STRING)
mapVisits.utmTermUtm-tags visit history.ARRAY(STRING)
mapVisits.utmContentUtm-tags visit history.ARRAY(STRING)
mapVisits.utmCampaignUtm-tags visit history.ARRAY(STRING)
mapVisits.guaClientIdThe identificator of clients visit history.ARRAY(STRING)
callTags.categoryCategory of the calltag.ARRAY(STRING)
callTags.typeType of the calltag.ARRAY(STRING)
callTags.namesNames of the calltags.ARRAY(STRING)
dateDate of the callDATE
datetimeDate and time of the callDATE
sourceSourceSTRING
mediumMediumSTRING
keywordsKeywordsSTRING
urlThe address where they hit the site.STRING
refThe address from which you went to the site.STRING
utmSourceThe value of the utm-tag utm_source.STRING
utmMediumThe value of the utm-tag utm_medium.STRING
utmCampaignThe value of the utm-tag utm_campaign.STRING
utmContentThe value of the utm-tag utm_content.STRING
utmTermThe value of the utm-tag utm_term.STRING
sessionIdThe unique identifier for the calltouch session.INTEGER
guaClientIdThe unique identifier for Universal Analytics.STRING
yaClientIdThe unique ID for Yandex.Metrica.STRING
ipThe IP address of the visitor.STRING
siteIdIdentificator for the site.STRING
yandexDirect-campaignIdIdentificator of the campaign from Yandex Direct ad.INTEGER
yandexDirect-adGroupIdIdentificator of the group from yandex direct ad.INTEGER
yandexDirect-adIdIdentificator of the ad from Yandex Direct ad.INTEGER
yandexDirect-criteriaIdPhrase identificator from Yandex Direct ad.INTEGER
googleAdWords-campaignIdCampaigns identificator from Google Adwords ad.INTEGER
googleAdWords-adGroupIdAdgroups identificator from Google Adwords ad.INTEGER
googleAdWords-creativeIdIdentificator of the creative from Google Adwords ad.INTEGER
googleAdWords-criteriaIdIdentificator of the phrase of the customer from Google Adwords.INTEGER
mapVisits.sessionDateParameter contains customers visit history.Добавить в маппинг: Array(Nullable(DateTime))
mapVisits.sessionIdParameter contains customers visit history.ARRAY(STRING)
mapVisits.ipParameter contains customers visit history.ARRAY(STRING)
mapVisits.cityParameter contains customers visit history.ARRAY(STRING)
mapVisits.sourceParameter contains customers visit history.ARRAY(STRING)
mapVisits.mediumParameter contains customers visit history.ARRAY(STRING)
mapVisits.keywordParameter contains visit history.ARRAY(STRING)
mapVisits.urlThe urls visit history.ARRAY(STRING)
mapVisits.refParameter contains customers history.ARRAY(STRING)
mapVisits.utmMediumUtm-tags visit history.ARRAY(STRING)
mapVisits.utmSourceUtm-tags visit history.ARRAY(STRING)
mapVisits.utmTermUtm-tags visit history.ARRAY(STRING)
mapVisits.utmContentUtm-tags visit history.ARRAY(STRING)
mapVisits.utmCampaignUtm-tags visit history.ARRAY(STRING)
mapVisits.guaClientIdThe identificator of clients visit history.ARRAY(STRING)
requestTypeType of the request.STRING
browserCustomers browser.STRING
cityCustomers city.STRING
attributionCall attribution model.STRING
subjectThe voluntary forms name on users website.STRING
uniqTargetRequestThe unique target request.BIT
uniqueRequestThe unique request.BIT
requestNumberThe number of the request.STRING
requestIdThe identificator of the request.INTEGER
targetRequestThe target Request.BIT
statusStatus.STRING
client_fioClients full name.STRING
client_clientIdThe clients identificator.INTEGER
client_phones.phoneNumberThe phone number of client.ARRAY(STRING)
client_phones.phoneTypeType of the phone.ARRAY(STRING)
client_contacts.contactTypeThe contact type of clients.ARRAY(STRING)
client_contacts.contactValueArray that contains clients email.ARRAY(STRING)
dateDate of the callDATE
datetimeDate and time of the callDATE
visit_sourceSourceSTRING
visit_mediumTransition channel.STRING
visit_keywordThe keyword order.STRING
visit_utmSourceThe value of the utm-tag utm_source.STRING
visit_utmMediumThe value of the utm-tag utm_medium.STRING
visit_utmCampaignThe value of the utm-tag utm_campaign.STRING
visit_utmContentThe value of the utm-tag utm_content.STRING
visit_utmTermThe value of the utm-tag utm_term.STRING
siteIdIdentificator for the site.STRING
requestTypeType of the request.STRING
client_fioClients full name.STRING
completedAmountCompleted Amount.FLOAT
isDeletedShows if the order is deleted or not.BIT
managerManager that is responsible for the order.STRING
orderNumberNumber of the order.STRING
orderDateDate of the order.STRING
order_callIdThe identificator of call.INTEGER
order_durationDuration of the order.FLOAT
order_phoneNumberPhone number of the order.STRING
order_typeType of the order.STRING
order_aniSTRING
order_dateCallOrders date of the call.STRING
order_requestNumberNumber of request order.STRING
orderStatusStatus of the order.STRING
plannedAmountDeals budget.FLOAT
serviceServices name that is using Calltouch API.STRING

_______________________________________________
If you have any questions – please contact us!