What you will learn in this article:
How to configure the Amazon Customer Data integration within the Admetrics Data Studio.
The correct method for formatting and sharing Google Drive folders for automated data syncing.
Prerequisites
To get started, you’ll need to share a Google Drive folder with Admetrics. You can name the files as you like, but the sheet names and column headers must follow our provided format. The schema for each sheet is outlined on the schema page. You can access the template via the example sheet or the TSV file.
Step 1: Set Up Google Drive Integration
Log into your Data Studio account and go to the data integration settings.
Click Add Integration.
Choose: Amazon Customer Data.
Name the integration (for example, “Amazon Customer Data Import”) and click Save.
Step 2: Create a Copy of the Template
You’ll see a popup with a link and an email address.
Click on the link labeled this Google Sheet or this TSV file.
In the Google Sheet, go to File → Make a Copy.
Save the copy in a new folder in your Google Drive.
We recommend creating multiple sheets on either a daily, weekly, or monthly basis. This streamlines the data loading process and helps manage your exports more efficiently.
Step 3: Share the Google Drive Folder
Share the folder (not the individual file) where you saved the copy with the email address provided in the popup. E.g., [email protected]. Also, make sure to include [email protected] so that we can access the sheet in case any issues occur.
Step 4: Update Customer Data
Open the copied sheet and enter your customer data.
The following column is required:
order_id: A unique identifier created by a seller to track a specific transaction (e.g.,123-1234567-7654321).
The following columns are optional but recommended for better coverage:
customer_id: Unique identifier for the customer (e.g.,1213445912).email: Email address of the customer (e.g.,[email protected]).first_name: First name of the customer (e.g.,Max).last_name: Last name of the customer (e.g.,Mustermann).default_address_country_code: The two-letter code for the country of the customer's default address (e.g.,DE).default_address_city: The name of the city, district, village, or town of the customer's default address (e.g.,Berlin).default_address_zip: The zip or postal code of the customer's default address (e.g.,10178). Please ensure that the column is formatted as ‘Plain Text’ so that any zip/postal codes that begin with 0 are not preserved.phone_number: Contact phone number for the customer (If you don’t have this, leave it blank).customer_created_at: Timestamp when the customer profile was created (e.g.,2022-09-01 14:00:00).Other tabs in the sheet can be left empty.
Important Note: Google Sheets has a limit of 10 million cells. For more details on how to share data if you encounter this limit, please refer to the following section.
Step 5: Data Import
The Admetrics system will automatically scan the shared folder for any updates or new sheets.
It will bulk import any sheets that have been added to the folder and updated since the last scan.