Renta supports data export from GetIntent to following destinations:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
Integration creating in data warehouse (DWH)
- Go to integrations catalog;
- Select GetIntent;
- Add a GetIntent account that has the necessary data;
- Choose the added GetIntent account;
- Specify the destination you want to import the data into;
- 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:
- 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 |
|---|---|---|
| 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 |