Amplitude Source

Renta supports data export from Amplitude to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select Amplitude;
  3. Add a Amplitude account that has the necessary data;
  4. Choose the added Amplitude 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

NameDescriptionType
server_received_timeAmplitude timestamp (UTC) of when our servers receive the event.DATE
dateDate (YYYY-MM-DD) of the annotation.DATE
appproject/app id, only appears when the deletion is done for multiple projectsINTEGER
device_carrierWhat device carrier the user has.STRING
schemaAmplitude's data structure.INTEGER
cityThe current city of the user.STRING
user_idA readable ID specified by you.STRING
uuidUnique user ID.STRING
event_timeAmplitude timestamp (UTC) which is the client_event_time adjusted by the difference between server_received_time and client_upload_time.DATE
platformPlatform of the device.STRING
os_versionThe version of the mobile operating system or browser the user is using.STRING
amplitude_idThe Amplitude ID.INTEGER
processed_timeUTC ISO-8601 formatted timestamp.DATE
user_creation_time UTC ISO-8601 formatted timestamp.DATE
version_nameName of the version.STRING
ip_addressIP address of the user.STRING
payingWhether the user is paying or not.STRING
dmaThe current Designated Market Area of the user.STRING
client_upload_timeocal timestamp (UTC) of when the device uploaded the event.DATE
insert_idA unique identifier for the event.STRING
event_typeName of the event type.STRING
libraryLibrary.STRING
amplitude_attribution_idsID of amplitude attribution.ARRAY(STRING)
device_typeType of the device.STRING
device_manufacturerManufacturer of the device.STRING
start_versionStart version.STRING
location_lngLongitude of the user.STRING
server_upload_timeThe time in milliseconds since epoch (Unix Timestamp) that our event servers accepted the upload request.DATE
event_idAn incrementing counter to distinguish events with the same user_id and timestamp from each other.INTEGER
location_latThe current Latitude of the user.STRING
os_nameThe name of the mobile operating system or browser that the user is using.STRING
amplitude_event_typeAmplitude specific identifiers based on events Amplitude generates.STRING
device_brandWhat device brand the user is on.STRING
device_idA device specific identifier, such as the Identifier for Vendor (IDFV) on iOS.STRING
languageWhat language the user has set.STRING
device_modelWhat device model the user is on.STRING
countryWhat country the user is in.STRING
regionWhat geographical region the user is in.STRING
is_attribution_eventAmplitude Is Attrivbution EventBIT
adidID of the ad.STRING
session_idID of the session.INTEGER
device_familyWhat device users family use.STRING
sample_rateThe sample rate.STRING
idfa(required for iOS) The Identifier for Advertiser or the Identifier for Vendor.STRING
client_event_timeLocal timestamp (UTC) of when the device logged the event.DATE
space_nameSpace name.STRING

Quotes and limits

Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.

Limits for Amplitude:

  • 360 queries per hour

Link to the official documentation