Direct SQL Access
AdLibertas offers customers the ability to access their datasets directly using Amazon Athena.
With just your credentials, AdLibertas will collect data from all of your data sources, unify, and store the compressed data in a customer-specific AWS account. You can use Amazon Athena to directly SQL-query your normalized data from here.
Since Athena is an easy to use serverless Amazon-managed service, teams can get directly access their data using standard SQL. And since AdLibertas is pulling and storing the data, there is no need for data engineering effort to get up and running.
AdLibertas customers can contact their account representative to request access to Athena. You will be given:
A Sign-in URL:
https://example.signin.aws.amazon.com/consoleUser name:
example_accountOne-time Password:
*******- A Sign-in URL: https://example.signin.aws.amazon.com/console
- User name: example_account
- One-time Password: *******
Note: Once you have access to the AWS Management Console you will have administrative access for the purposes of Amazon Athena access and while data can’t be deleted via Athena, account access does allow the ability to permanently alter datasets.
Once you have access to your account:
- 2.
- 3.Change Region to
Us-West-2 - 4.Change workgroup to your
example_account - 5.Change database to your
example_account
While AdLibertas out-of-the box user-level reporting allows highly sophisticated reports to be constructed without the need for custom SQL, customers do have the need to create more complex queries that are out of scope from a UI. Most often, these customers will lean on writing their own queries to access the data. A popular use case is downloading the members of an AB test, then running user-level event counts to gain more sophisticated insights into test-outcome probabilities and confidence, not already supported.
Since all audiences are readily available for SQL export, customers can easily export user IDs for the purposes of targeting or CRM management. A great example would be running a report on your top-performing users, then giving them a special offer to incentivize retention or conversion.
Last modified 8mo ago