With Two Minute Reports’ Snapchat Ads Connector, you must connect your Snapchat ad account to Google Sheets. TMR will pull real-time metrics, extract insights, and enable you to plan your next steps without writing any code. Before connecting your Snapchat Ads to Google Sheets, ensure you have the following permission:
Required permissions
To connect your Snapchat ad account with Two Minute Reports, you need Account Admin or Campaign Manager access.
Once you confirm this prerequisite, follow the steps below to connect Snapchat Ads to Google Sheets via TMR.
Step 1: Install and launch Two Minute Reports
Begin by installing TMR in Google Sheets using this step-by-step tutorial: How to install TMR in Google Sheets?
Once done, you can connect your Snapchat Ads account to extract campaign data directly into Google Sheets.
Step 2: Create a new Connection to your Snapchat Ads account
| A Connection is a link between the data source and the Connector. For example, you must use the Snapchat Ads Connector to create a Connection with your Snapchat Ads account to get your ads data. |
Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.
When the “Adding New Connection” dialog box appears, complete the following three key steps to access your Snapchat Ads accounts:
- Selecting the Snapchat Ads Connector
- Authenticate your account
- Enable the respective accounts with the Snapchat Ads Connector
Choose Snapchat Ads from the available options, and authorize your Connection by entering your login credentials.
After successful authentication, you will see a screen showing your Account name, ID, Connection name, and Status, as shown below:
Enable the toggle for the ad accounts you intend to query. Please note that you cannot extract data from the disabled ad accounts.
| To ensure the connected accounts are reflected in the TMR sidebar, click “Refresh Connections.” |
Now, you can extract Snapchat Ads KPIs into Google Sheets for actionable ad performance insights.
Step 3: Fetching Snapchat Ads data to Google Sheets
- You must create a new query by navigating to the Data Queries section to extract specific Snapchat Ads campaign data.
- Click Add and choose the Snapchat Ads accounts you wish to analyze.
- You can manage multiple clients’ Snapchat Ads accounts under one interface. Simply select one or more accounts to obtain actionable campaign insights.
- Alternatively, you can add your client and map their corresponding Snapchat Ads account in the Clients section.
- Click “Manage Clients” and map the necessary account details, then click “Save & Close” to save your client’s details for future reference.
- Next, add the Snapchat metrics and dimensions you want to track and select the date range to visualize your campaign performance.
- Configure your data reporting by selecting relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the information that matters.
Once you finish these steps, click Run Query to visualize the output.
Now, you can use different Google Sheet features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to visualize your Snapchat Ads campaigns.
| Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action. |
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ Schedule Refresh feature has further capabilities. Continue reading about this feature: “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please contact our support team at support@twominutereports.com.