GetIntent Source

Renta supports data export from GetIntent to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select GetIntent;
  3. Add a GetIntent account that has the necessary data;
  4. Choose the added GetIntent account;
  5. Specify the destination you want to import the data into;
  6. Go to the settings screen and set necessary configuration:

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.

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

Name Description Type
imps Shows INTEGER
unique_imps Unique shows INTEGER
clicks Clicks INTEGER
cpm CPM FLOAT
cpc CPC FLOAT
ctr CTR PERCENTS
budget Budget(spent) FLOAT
view_rate Percent of views PERCENTS
pcc Post Click Conversion INTEGER
apcc Assosiated Post Click Conversion INTEGER
pvc Post View Conversion INTEGER
cpa CPA FLOAT
data_cost Spent on segments FLOAT
ag_rev Agent discrount(RUB) FLOAT
ag_rev_prc Agent discrount(percent) PERCENTS
xclicks Abnormal clicks INTEGER
video_completion_25 Amount of views 25% of video PERCENTS
video_completion_50 Amount of views 50% of video PERCENTS
video_completion_75 Amount of views 75% of video PERCENTS
video_completion_100 Amount of views 100% of video PERCENTS
an_sessions Sessions from GA/YM INTEGER
an_bounce_rate Bounces from GA/YM PERCENTS
an_pageviews_per_session Pageviews per session from GA/YМ FLOAT
an_avg_session_duration Average session duration from GA/YМ FLOAT
robots Robots from YM PERCENTS
passing_index Passing index (sessions/clicks) PERCENTS
anomaly_impression Abnormal impressions INTEGER
os Operation systems STRING
day Day TIMESTAMP
ssp SSP STRING
city Cities STRING
hour Hours INTEGER
month Months INTEGER
app_id Name and ID of the mobile app STRING
domain Domain(format test.main_site.net) STRING
is_app Filter for mobile apps. Shows if there was an impression BOOLEAN
minute Minutes INTEGER
browser Users browser STRING
country Users country STRING
site_id Inner ID of the object. “Site”gives an understanding, which conversion counted INTEGER
is_video Filter that shows if there was an impression on video BOOLEAN
is_native Filter that shows if there was an impression on native ad BOOLEAN
campaign_id Name and ID of the campaign INTEGER
creative_id Name and ID of the creative INTEGER
device_type Type of the device (desktop/mobile/etc) STRING
week_number Weeks number INTEGER
app_category Mobile app category STRING
advertiser_id Name and ID of the advertiser INTEGER
click_anomaly Reason why click indicated as abnormal STRING
creative_size Size of the creative STRING
user_segments Name of the segments that are related to user INTEGER
browser_version Users browser version STRING
conversion_name Name of the conversion STRING
content_category Category of the content STRING
full_region_code Regions STRING
top_level_domain Top level domain (i.e. for the domain test.main_site.net it’s main_site.net) STRING
campaign_currency Campaigns currency STRING
campaign_group_id Name and ID of the campaigns group INTEGER
dmp_segment_billed Segemnts that were used for the targeting STRING
video_inventory_format Format of the inventory (in-stream/out-stream/etc) STRING