Learn how to set up your data connectors to start pulling data from your ad networks and other sources into Singular.
See also: Data Freshness and Update Times.
By default, the Data Connectors page only shows data connectors from which data has been pulled in the last 30 days.
To show the full list of connectors, toggle Show connectors without data in the last 30 days:
You can't create multiple connectors to the same ad network with the same credentials.
If you don't find the existing connector in the list, try toggling Show connectors without data in the last 30 days:
This is probably because there was no data for yesterday in the ad network.
The “Latest Date Queried” means that Singular queried the data connector for data about this day, but sometimes that data is empty - for example, if you did not run any campaign using this ad network on this date.
Sometimes this is because you are pulling campaign data and ad monetization data from the same network, and this requires two separate data connectors.
Another possibility is that your organization has simply added multiple data connectors for the same ad network, each with its own login credentials.
Singular uses different methods to pull data, depending on the way the ad network (or other source) makes its data available. The data connector may be based on the ad network's API, reports transferred as files (by FTP, Google Drive, etc.), emails, dashboard access, or even a combination of two or more of these methods.
Adding a Data Connector
To get the required API authentication credentials:
- Log into your Apple Search Ads account.
- Go to Settings > API and click Create API Certificate.
- Select the certificate you just created and click Actions > Download Certificate. A ZIP file is downloaded to your computer containing the two credentials you need. Open the files (if you are unable to open them, change the file extention to .txt).
- Copy the entire contents of the .key file into the "API Authentication: RSA Private key file" field (including "-----BEGIN PRIVATE KEY-----", "-----END PRIVATE KEY-----").
- Copy the entire contents of the .pem file into the "API Authentication: Certificate .pem file" field (including "-----BEGIN CERTIFICATE-----", "-----END CERTIFICATE-----").
To get your Vungle reporting API key, see Vungle's instructions.
Additional instructions: Singular's special integration with Vungle relies on S3 reporting and needs to be configured for you by Vungle. To finish setting up the Vungle data connector, send a message to firstname.lastname@example.org including your Vungle account email and your campaign start dates (if the campaigns have been launched already). CC your Vungle and Singular representatives. It may take up to 72 hours to configure your integration on Vungle's side.
After you add a data connector, Singular starts pulling data immediately. You will see that the connector status on the page is ● Pending. Check back later to see when the pull is done.
The next data pulls will be carried out daily at midnight your local time. You can look at the Next Update column to see when the next pull is scheduled.
Connector Statuses and Messages
|● Active||Singular has data for yesterday from this connector and we are not aware of any login issues.|
|● Inactive||There is a login issue or data delay (data for yesterday should be available at the expected daily time, which by default is 8 a.m. local time).|
|● Pending||You have recently added this connector and Singular is pulling data from it for the first time.|
|● No Integration||Singular has no integration with this ad network for pulling campaign reporting or ad monetization data.|
The green status indicates that Singular was able to pull data for yesterday, but sometimes there is still an issue you need to fix. Check the message to see what you need to do.
This usually happens when you have removed an account from a self-attributed network (SAN) such as Facebook, but have not removed it from your account list in Singular. You can easily solve this by editing the data connector as mentioned in the message.
This data connector has been set up to receive reports by email, but Singular has not received an email report. Contact the ad network to notify them.
Hover over the connector and select the Edit icon. Re-input your credentials to make sure they are correct. If you are authorizing the connection using a network such as Facebook, make sure you are logged into the correct network user (and not a personal user, for example).
This is the last day for which Singular has pulled data successfully from this data connector. If everything is working correctly, this should be today/yesterday.
This is the date and time in which Singular last pulled data from this data connector. It’s where you can see how fresh the data that you see in Singular is.
|Latest Date Queried||Last Updated||Next Update|
|If you are checking the connector status on Jan 2, while data is being pulled, you will see:||Dec 31||Jan 1st 12:04 AM||In Progress|
|If you are checking the connector status on Jan 2 after data has been pulled, you will see:||Jan 1st||Jan 2nd 12:04 AM||Jan 3rd 12:04 AM|
|If you are checking the connector status right after you have added a data connector, you will see:||-||-||In Progress|
Note: The “Last Updated” date always applies to the freshness of the data from the “Latest Date Queried” but does not necessarily apply to earlier dates.
For example, if the “Latest Date Queried” is yesterday and the “Last Data Import” date-time is today at 00:04 a.m., you know that the data you see in Singular for yesterday is up to date as of 00:04 a.m. -- but the data you see in Singular for 3 days ago may be less fresh than that.
Click Run Test Report to automatically run a report in Singular’s report query page for the selected data connector. This allows you to check what data Singular is pulling from this data connector.
The parameters for the test report are:
- The report covers yesterday only.
- The dimensions and metrics are all ad network data (rather than attribution tracker data).
The raw data CSV is a copy of the last data import Singular pulled from this data connector for the date you see in the "Latest Date Queried" field. Usually, this means the data for yesterday.
You can download the raw data CSV by hovering over a data connector and clicking the Raw Data CSV icon.
The data in this CSV-formatted file is "raw" in that it has not undergone currency conversions or any of Singular’s other data processing steps. However, the dimension names are mapped to Singular dimension names.
You can use the Raw Data CSV to troubleshoot some issues with your data. For example, if you see missing or unexpected data in your Singular reports for a certain ad network, the Raw Data CSV can show you if the problem already existed when the data was pulled from the ad network.