This functionality is designed to automatically export data from MVPs to Google Sheets . This allows you to monitor the effectiveness of advertising campaigns in real time, analyze key metrics, and quickly identify the most effective acquisition channels. Data in the spreadsheet is updated every 10 minutes during the current week , ensuring the relevance of analytics and transparency of all processes. The first export after connection generates statistics for the entire period and saves the data in a separate "All Data" sheet. All subsequent exports are broken down by week.

🧭 Instructions for setting up data export to Google Sheets:

1. Create an account here (if you don't have one yet).

2. Copy the service email address, which will look like this: aaa-xxx@constant-height.iam.gserviceaccount.com

3. Create a new Google Sheet and save the part of the URL highlighted after /d/ and before the next / - this is your Sheet ID.
Example:

https://docs.google.com/spreadsheets/d/23Mdsa3zqRasdas800k5bx68/edit?gid=0#gid=0

In this example, 23Mdsa3zqRasdas800k5bx68 is the required part.

4. Add service mail to the document as an editor.

5. Connect the API - Go to the Google Cloud console and add the " Google Sheets API " service to your project.

6. Rename the sheet in your table to download (required - this is required for the download to work correctly).

7. Generate an access key:

• On the service settings page, create a new key in JSON format.
• Once created, the browser will automatically download the file.
• If the download does not start, make sure pop-ups are allowed in your browser settings.

8. Send us:

• Key file (JSON);
• Your Google Sheets ID (from step 3).

👨‍💻After this, specialists will connect your table to the system and set up automatic data upload.

Key statistics columns

• Name - the name of the advertising campaign or the name of the spot (you select this when transferring the data from step 8 to the specialist).
• Clicks - the number of clicks on the tracking link on the landing page.
• Subscribers (sub) - the total number of dirty subscribers, excluding unsubscribes.
• Dialogues (chat_s) - the total number of dialogues with users.
• Unsubscribes (unsub_s) - the number of users who unsubscribed.
• Sales sum (dep_summary) is the total amount of deposits.
• Repeat sales amount (redep_summary) - the total amount of all repeat deposits.
• Number of registrations (reg_count) - total number of registrations.
• Number of sales (dep_count) - the total number of deposits.
• Number of repeat sales (redep_count) - the total number of repeat deposits.
• Link to chat - a link to a chat with the client inside the MVP.
• Campaign Name - traffic source (Google, TikTok, Facebook, etc.).