Forums & Knowledge base/How-To

Manual data import with CSV files

Support
posted this on June 29, 2010 16:26

One of Mopapp's nicest features is the ability to auto-import the orders and sales data from the multiple stores where you sell your applications.

However, if for some reason you don't want to use this feature (because you're using a store we don't integrate with, maybe a custom-made e-commerce script on your server, or because you don't want to share your credentials with us, even if they would be encrypted and safe), you still have the option to upload the CSV files with the data, let us import it, and then work with the charts we build as you would do with data from automatic imports.

You can import CSV files from My Account => Data Import.

 

Manual data import for iTunes Connect

  1. Login at https://itunesconnect.apple.com/
  2. Click "Sales and Trends"
  3. Set the Report Period option to Daily
  4. Select a day from the third drop-down box
  5. Click Download
  6. Repeat for any other day or week you want to import
    NOTE: only daily and weekly reports can be imported through the manual CSV upload. Monthly reports are only supported by the automatic import.

Manual data import for Handango

  1. Login at http://developer.handango.com/Login.jsp?siteId=1216
  2. Click "Accounting" on the left-hand side menu
  3. Click "Sales Reports" below Accounting on the left-hand side menu
  4. Select the Monthly option
  5. Select a month
  6. Click Submit and download the file (Note: Handango will charge a fee for this export)

Manual data import for MobiHand / MobiReach

  1. Login at https://www.mobireach.com/login.asp
  2. Click Reports => Customer/Orders => CSV Reports
  3. Select the month and year
  4. Click Download

Manual data import for Android Market / Google Play

  1. login at https://play.google.com/
  2. for each of your apps, go click Statistics
  3. change the period the graph is displayed for: set to All time
  4. at the top of the page, click Export as CSV
  5. verify All metrics and All dimensions are checked 
  6. Click Export

Manual data import for RIM App World

  1. Login at https://appworld.blackberry.com/isvportal/home/home.seam
  2. Click "Download Reports" on the left-hand side menu
  3. You might now see a list of zip files available for download: choose the ones whose filename contains the word "purchases". If no such zip file is available, or none of the available suits your needs, go to the next point.
  4. Click Schedule Report
  5. Set the Reporting Data Type option to Purchases. If such an option is not available, you can also select Download Summary, but mind that, while this format can be imported into Mopapp, it contains very little information so your reports will miss values such as country, device. etc.
  6. Choose the product you're interested in.
  7. Set the start and end dates
  8. Select Sort Results By Date Only
  9. Click "Generate Report"

An email will inform you when the report is ready. It will then show in the list described in point 3.

Manual data import for Google Android Market / Google Checkout

  1. Login at https://checkout.google.com/
  2. Click "Download data to spreadsheet (.csv)"
  3. Set the From and To dates
  4. Set the "Orders with status" option to All
  5. Select the "Include more buyer and order information columns (up to 500 results will be returned)" checkbox
  6. Click Download

Manual data import for GetJar

  1. Login at http://developer.getjar.com/
  2. Click Analytics => Downloads from the menu bar at the top
  3. Select your application from the drop-down list under the menu bar, on the left-hand side
  4. Select the desired dates in the Date Range drop-down box, on the right-hand side
  5. Click "Download Report (csv format)" just above the chart, on the right-hand side

 

Manual data import for CSV files in Mopapp's own format

If you're using your own e-commerce script, or are using an external third-party store that we currently don't integrate with, don't despair, you can still integrate with Mopapp! All you need to do is export your sales data, and convert it in our own CSV format, as follows:

ApplicationId,Date,Country,Type,Quantity,Currency,Revenue,Profit,Device,Email
56,2010-05-01 05:00:00,US,1,1,USD,4.99,3.49,BlackBerry Bold 9000,user1@example.com
47,2010-05-01 04:30:23,FR,1,1,EUR,1,0.7,Nexus One,user2@example.com
83,2010-05-01,,1,2,USD,10,7,Palm Pre,

Here is what the various comma-separated values mean:

  • ApplicationId: the application ID, as assigned by Mopapp once you register the application. To find out this ID, go to My Account => Applications and copy the value of the "Mopapp ID" column for the desired application.
  • Date: the date of the transaction, in one of the following formats: yyyy-MM-dd HH:mm:ss or yyyy-MM-dd
  • Country: the two-letter code representing the customer's country. For example US for USA, IT for Italy, DE for Germany etc. This value is optional (you can pass an empty value, but you'll need to leave the space for it. The third order line in the sample above is an example).
  • Type: possible values:
    • 0 if the sale is from a new customer
    • 1 if this is an update from an existing customer
    • 2 if this is a refund for a sale transaction: note that refund transactions should have been preceded by a sale transaction for the original order at some point, so that the final sums are correct (that is, the amount of the refund is subtracted from an amount that includes the value for the positive original order)
    • 3 if this is a refund for an upgrade transaction. Notes for Type=2 apply here as well
  • Quantity: an integer with the quantity of items purchased
  • Currency: the three-letter code for the currency used in the sale. Possible values are USD, EUR, GBP, CAD, JPY, AUD and INR. Note that the currency is totally independent from the country: so for example an American customer might purchase in USD, but a German customer might purchase in USD too, not necessarily in EUR (it usually depends on the store settings and the customer preferences).
  • Revenue: a floating-point value with the amount paid by the customer. Use "." (dot) as the decimal separator, not "," (comma). Note: in case of quantity > 1, this amount refers to the total order, not a single unit.
  • Profit: a floating-point value with the net amount you get from the sale. This is usually the revenue minus some processing fee. Use "." (dot) as the decimal separator, not "," (comma). Note: in case of quantity > 1, this amount refers to the total order, not a single unit.
  • Device: the model of the customer's device. You might not know this, so this is an optional value. Refer to the Country value for more notes.
  • Email: the customer's email address. You might not know this, so this is an optional value. Refer to the Country value for more notes.

Note: the first line, with the titles, should be included in the uploaded file, just like it is in the sample above.

Note: Identical lines are considered as the same sale, and therefore only the first one will be imported.
So if, for example the following csv is not valid:

ApplicationId,Date,Country,Type,Quantity,Currency,Revenue,Profit,Device,Email
83,2010-05-01,USA,0,1,USD,10,7,Palm Pre,
83,2010-05-01,USA,0,1,USD,10,7,Palm Pre,
83,2010-05-01,USA,0,1,USD,10,7,Palm Pre,

The correct form is:

ApplicationId,Date,Country,Type,Quantity,Currency,Revenue,Profit,Device,Email
83,2010-05-01,USA,0,3,USD,30,21,Palm Pre,