Getting started
Required setup
Optional setupTutorials and examples
Onboarding guides
Tips and tricks
P&L Report
Target metricsMore information
Attribution models
Bayesian statistics
Frequently asked questions
Metrics overview
User journey tracking
Product level metrics
TagsData UpdatesSideloading
Google Sheets
The Google Sheet sideloading mechanism provides a seamless way for customers to integrate and update their data with the Admetrics dashboard.
To facilitate this process, customers are required to share a Google Drive folder with Admetrics. The Admetrics system is designed to frequently scan this shared folder for any updates or new additions. It automatically bulk loads all sheets that have undergone changes or have been added since the last refresh cycle. Customers have the flexibility to update existing sheets with new data or introduce new data by adding separate sheets to the drive folder.
While the names of the files themselves are not critical, it is imperative that the sheet names and column names within these files strictly adhere to the specifications provided. Example Sheet on Google Spreadsheets
We expect 5 sheets in each file:
- Orders
- Lineitems
- Products
- Customers
- Refunds
The schema of each sheet is explained on the schema page.
Setup
Share the Google driver folder containing your data with the email address shown in the datasource admin.
Amazon S3
Similar to the Google Sheets mechanism, the Amazon S3 sideloading process enables customers to seamlessly integrate and update their data with the Admetrics dashboard using a shared Amazon S3 bucket.
Customers must share an S3 bucket with Admetrics by applying the appropriate bucket policy (see Setup). This Bucket is supposed to contain one folder for each data delivery.
Folder structure
The folder within your bucket is supposed to be named like this:
your-bucket-name/REPORTDATE_INTERVAL_STARTDATE_INTERVAL_ENDDATE
So for example if you deliver data for the time range 2024-01-01 till 2024-01-31 on the 4th of February the folder would be called:
your-bucket-name/2024-02-04_2024-01-01_2024-01-31
This naming ensures we can identify recency of the dataset and the time frame it covers.
Dataset files
The dataset in this folder needs to consist of 5 separate files in TSV format.
- products.tsv
- lineitems.tsv
- products.tsv
- customers.tsv
- refunds.tsv
The schema of each file is explained on the schema page.
Setup
To share an S3 bucket with Admetrics, add a bucket policy that grants specific permissions to our AWS account ID 292397901148. Below is an example policy that you can apply to your bucket. This policy allows Admetrics to list the bucket contents and get objects from the bucket, enabling the sideloading process:
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "AdmetricsAccess",
"Effect": "Allow",
"Principal": {
"AWS": "arn:aws:iam::292397901148:root"
},
"Action": [
"s3:ListBucket",
"s3:GetObject"
],
"Resource": [
"arn:aws:s3:::your-bucket-name",
"arn:aws:s3:::your-bucket-name/*"
]
}
]
}
Replace your-bucket-name with the name of your actual S3 bucket. After applying this policy, ensure the bucket and files are properly configured according to the Admetrics specifications.