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 through the example sheet.
Step 1: Set Up Google Drive Integration
Log into your Data Studio account and go to the data integration settings.
Click Add Integration.
Choose Google Sheet: Orders.
Name the integration (for example, “Cross-Matching Sheet”).
Leave the Shop filter option blank, and then click Submit.
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.
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]
Step 4: Update Customer Data
Open the copied sheet and enter your customer data.
The following columns are required:
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.
The following column is optional but recommended for better coverage:
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.
Google Sheet Limit
Google Sheets has a limit of 10 million cells.
For more details of how to share data if you encounter this limit refer to the section here.
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.