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:
Creating an API connection app that will load the report into Alli Cloud Storage
Creating an Alli Cloud Storage datasource that grabs your report file
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).
1. Create inMobi API App
Go to Marketplace Apps, Add a New App, Create a New “Moloco Platform Data” App.
Next, input values for the API Key, Account ID, and Date range you wish to pull.
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.
2. Create Alli Cloud Storage Datasource
Go to Data Sources, Add a New Datasource, & select “Alli Cloud Storage”.
For additional configuration, choose “Alli Marketplace” and paste in your filename from the API execution.
Next, create the dimensions and metrics by uploading this csv template in the Define your Data section:
You will need to manually set the date column as “Date Timestamp” from the dropdown:
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.
After creating your datasource, copy the ID from the datasource URL to use in the next step.
3. Create a Force Sync App
Finally, you’ll make a Marketplace Force Sync app for the datasource.
Trigger the sync to run after the API app you created initially.
Paste in the datasource ID you copied from before.
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.