What you will learn in this article:
How to set up the Google Drive PPS data source in Admetrics.
How to correctly share and organize your sheets with Admetrics.
How to map customer answers to the right traffic channels.
Which formatting does your Google Sheets require.
1. Why PPS Integration is a Game-Changer for Your Marketing
In a world of iOS14+ and strict privacy regulations, technical tracking alone is often no longer enough. Combining your Admetrics data with direct customer feedback (Zero-Party Data) gives you back full control over your marketing strategy.
Your benefits at a glance:
Close tracking gaps: Capture conversions that couldn't be technically attributed due to ad blockers or restrictive cookie settings.
Make "Dark Social" visible: Finally understand the impact that channels like podcasts, word-of-mouth, or offline events have on your success.
Validate attribution: Use your customers' feedback as a "second opinion" to confirm your digital attribution models and optimize them with even greater precision.
Better budget allocation: When you know where your customers actually perceive your brand, you can invest your budget where it has the maximum impact.
Holistic Customer Journey: Connect the hard data world of ROAS and CAC with the real voice of your customers for a true 360° view of your performance.
2. Setting Up the Data Source
The first step is to establish the connection between your Google Drive and the Admetrics platform.
2.1 Adding the Data Source and Using the Service Account
Go to the Data Sources settings in your Admetrics dashboard and add a new Google Drive PPS source. Once you have created it, Admetrics automatically generates a unique service account email address.
Copy this address, as it is the key to data access: You must share your Google Sheets (or the entire folder) with this email address and grant view access.
2.2 Best Practices for Organization
To ensure the import runs smoothly, we recommend creating a dedicated folder in your Google Drive for your PPS exports and sharing that folder with the service account.
Tip:
Instead of maintaining one giant document, you should split the sheets by date (e.g., one new file per month).
Admetrics is smart: During each import process ("pull"), we automatically load all sheets that have been newly created or modified since the last pull.
3. Mapping the Answers
Once the data has been loaded, we need to teach Admetrics which answer belongs to which channel.
3.1 Performing the First Pull
Important to note: The mapping interface is only visible after the first successful data pull. Admetrics first needs a data basis to show you the available options.
3.2 Assigning Answers
To start the mapping, click on the corresponding data source in the settings and select Edit. Here, you will see a list of all the answers your customers have provided.
The 5-Answer Rule: To minimize "noise" and free-text answers, we only show answers that have been given at least 5 times.
For each relevant answer, use the dropdown menu to select the traffic source that this value should be assigned to (e.g., "Instagram" → "Social Ads").
4. Google Sheet Requirements
For Admetrics to process the data correctly, your sheet must have a specific structure. Please ensure that the column headers are named exactly as shown in the following example.
4.1 Column Structure
Your table (CSV or Google Sheet) must contain the following two columns:
order_id: The unique order number from your shop.
answer: The answer the customer selected in the survey.
The third column is optional and can be left empty:
order_date: The date of the order (format: YYYY-MM-DD).
*Example of the table structure
Note:
If you need help with the setup or would like to map answers immediately (before the first regular pull), please feel free to contact us. We can provide manual support if needed to speed up the process for you.
Good luck with optimizing your attribution! Your Admetrics Team.