Skip to main content
Skip table of contents

How to Pull Moloco Platform Data

Here’s a step-by-step of how to pull detailed mobile app performance data for Moloco.

This set-up process has 3 main steps:

  1. Creating an API connection app that will load the report into Alli Cloud Storage

  2. Creating an Alli Cloud Storage datasource that grabs your report file

  3. Creating a Force Sync app that refreshes the datasource each day (the automated equivalent of pressing the “Load Data” button)

To get started, you will need a Moloco Account ID and API Key. These can be found respectively under “Ad Account Settings” and “User Settings → API Access” in the Moloco platform. (contact your onboarding team or the PMG team member managing the account for credentials).

Screenshot 2024-07-17 at 15.20.35.png
Screenshot 2024-07-17 at 15.20.49.png

1. Create inMobi API App

Go to Marketplace Apps, Add a New App, Create a New “Moloco Platform Data” App.

Screenshot 2024-07-16 at 11.06.07.png

Next, input values for the API Key, Account ID, and Date range you wish to pull.

Screenshot 2024-07-16 at 11.08.22.png

Once your app is set up and has run successfully (don’t forget to set a schedule!), go to Executions, open up the most recent one, and copy the filename at the bottom.

Screenshot 2024-08-26 at 16.25.01.png

 

2. Create Alli Cloud Storage Datasource

 Go to Data Sources, Add a New Datasource, & select “Alli Cloud Storage”.

Screenshot 2024-05-22 at 14.16.03.png

 

For additional configuration, choose “Alli Marketplace” and paste in your filename from the API execution.

Screenshot 2024-08-26 at 16.26.32.png

Next, create the dimensions and metrics by uploading this csv template in the Define your Data section:

molococolumns.csv

You will need to manually set the date column as “Date Timestamp” from the dropdown:

Screenshot 2024-05-22 at 17.43.28.png

And set the following Attribute / Metrics as “Numbers only” in their respective dropdowns.

impressions

revenue

video_play1q

engaged_views

clicks

skan_conversionvalue

video_play2q

installs

skan_conversion

video_play3q

spend

skan_conversioncount

 video_play4q

You may also want to set default values for Site_ID, Site_Title, Site_Domain to avoid errors in ALLI for blank rows of data.

Screenshot 2024-07-17 at 15.47.45.png

After creating your datasource, copy the ID from the datasource URL to use in the next step.

Screenshot 2024-07-16 at 11.19.54.png

 

3. Create a Force Sync App

Finally, you’ll make a Marketplace Force Sync app for the datasource.

Force Load App.png

Trigger the sync to run after the API app you created initially.

Screenshot 2024-07-16 at 11.22.40.png

Paste in the datasource ID you copied from before.

Screenshot 2024-07-16 at 11.23.46.png

Run the Force Sync app, give it a bit to load, and VIOLA!

Copy CodeCopy Code

A good way to QA to make sure you’ve brought in the data is by navigating back to your App, check to see that dates / rows that were loaded in that file, and confirm that your datasource dates / rows match.

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.