Importing Existing Users

Last Updated: Jan 17, 2017 10:38PM PST

If your team is joining Apsalar from another mobile attribution tracking solution, your existing users' attribution information can be uploaded and brought into your Apsalar platform!  Your existing users imported data will be available in our Traffic Cohort, Cohort Report, and Revenue Analysis Report where applicable.

While we understand your existing users' dataset can be formatted in a variety of ways, we require that a flat file be provided for uploading your users in the format specified below, to ensure a smooth process.

We support ingesting existing users who installed, as well as their events and revenue events.  Installs, events, and revenue events are imported separate and so three separate files must be provided for each.  Please note that we only support importing devices with advertising IDs (IDFA or AIFA).

When creating your historic user data files, please follow the steps below. If data is not provided in this format, delays in processing or rejection of the file can occur. Apsalar will examine the data files provided and inspect for duplicate installs. If duplicates are found, the duplicates will be removed and a file with unique advertising IDs will be used for the data on-boarding. Duplicate advertising IDs are only allowed in non-revenue event and revenue event files.

Please provide your files in unix encoded '.tsv' (tab separated file) format. other file types will not be accepted.

 

Table of Contents

File Type
File Naming Convention
How will Apsalar retrieving your data files
Historical Data Column Definitions
Sample File Layout with data (Historical Installs)
Sample File Layout with data (Non-Revenue Events)
Sample File Layout with data (Revenue Events)
 

File Type 

unix encoded '.tsv' (tab separated file) other file types will not be accepted.

 

File Naming Convention 

Please use the following naming convention to keep your data files organized:
 

File Naming Convention:

YYYYMMDD_App-Name_API-key_Data-Type.tsv

YYYYMMDD

The date the file is delivered to Apsalar in 4-digit Year, 2-digit Month, 2-digit Day format.

App-Name

The “App-Name” should be the Name of the App as you expect to refer to the App in the Apsalar UI.

API-key

The “API-key” is your main Apsalar account username.

Data-Type

The “Data-Type” is equal to “installs”, “non-revenue-events”, or “revenue-events”.

 

Filename Examples: 

20160115_myappname_apsalar_installs.tsv

20160115_myappname_apsalar_non-revenue-events.tsv

20160115_myappname_apsalar_revenue-events.tsv



 

How will Apsalar retrieving your data files

Please post these files on your own (s)FTP location, and provide (s)FTP credentials for Apsalar to download.

FTP Details Needed:

Host name: 

ftp.yourhost.com

Username: 

myusername

Password:

mypassword

Remote Folder location: 

/apsalar

 

Historical Data Column Definitions

Column Name

Column Definition

Example Value

Keyspace

This is the designated keyspace corresponding to the device entry. Value should be: “IDFA” for iOS or “AIFA” for Android. No other ID Types are allowed and will be dropped from the file.

IDFA

App Longname

Long name (bundle ID) of application.

com.myapplicationname.deal

App Store URL

Enter the URL from the appropriate app store for your application


For Android applications on the Google PlayStore, we encourage entering the market:// link . Campaigns run with AdWords require the use of the market:// for proper attribution on AdWords' platform.

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

Advertising ID

The device advertising identifier associated with the device corresponding to the designated keyspace.

21B1927D-15D9-190B-1C5EA1E19B2C

Campaign Name

The campaign name for the attribution.  We recommend a generic name to track all your existing users.

Existing Users

Campaign Group

The campaign group name for the attribution.  We recommend a generic name to track all your existing users.

Existing Users

Campaign Source

The network to which this device is attributed to.  For organic installs, please provide the value of “Existing-Organic".

Applovin

Install Time

The install time in epoch timestamp format.

1446059281

Event Name

The event name - we recommend this match the name you will implement using the Apsalar SDK

MyRevenueEventName

Event Time

The event time in epoch timestamp format

1446059281

Revenue Amount

The amount of revenue was recorded for this event

2.00

Currency Code

The three-letter ISO 4217 currency code for the transaction

USD

 

 

Sample File Layout with data (Historical Installs)

Keyspace

App Longname

App Store URL

Advertising ID

Campaign Name

Campaign Group

Campaign Source

Install Time

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

21B1927D-15D9-190B-1C5EA1E19B2C

Existing Users

Existing Users

Applovin

1446059281

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

BAED20C5-34FB-484A-A4B4-D36591368537

Existing Users

Existing Users

Existing-Organic

1446059281

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

95312836-7ed4-48ab-d87c-22e48c58433e

Existing Users

Existing Users

Inmobi

1446059281

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

72289994-8bb2-26ba-a26a-90b79d63125b

Existing Users

Existing Users

Google

1446059281


 

Sample File Layout with data (Non-Revenue Events)

Keyspace

App Longname

App Store URL

Advertising ID

Event Time

Event Name

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

21B1927D-15D9-190B-1C5EA1E19B2C

1446059281

Login

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

BAED20C5-34FB-484A-A4B4-D36591368537

1446059281

Add_to_cart

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

95312836-7ed4-48ab-d87c-22e48c58433e

1446059281

Registration

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

72289994-8bb2-26ba-a26a-90b79d63125b

1446059281

Product_view

 

Sample File Layout with data (Revenue Events)

Keyspace

App Longname

App Store URL

Advertising ID

Event Time

Event Name

Revenue Amount

Currency Code

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

21B1927D-15D9-190B-1C5EA1E19B2C

1446059281

Purchase

2.00

USD

IDFA

com.iosTravelApp

https://itunes.apple.com/us/app/myAppName/id123456789?mt=8

BAED20C5-34FB-484A-A4B4-D36591368537

1446059281

Purchase

75.00

USD

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

95312836-7ed4-48ab-d87c-22e48c58433e

1446059281

Checkout

250.00

USD

AIFA

com.AndroidGame

https://play.google.com/store/apps/details?id=com.myAppName.android

72289994-8bb2-26ba-a26a-90b79d63125b

1446059281

Checkout

12.50

USD

 

support@apsalar.com
http://assets0.desk.com/
apsalarinc
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
Invalid characters found
/customer/en/portal/articles/autocomplete