Adding a data source is essential to creating a report in Google Sheet, as it allows you to connect to a specific data set and access the required information for your report.
This article explains the steps to add an Apple search ads data source in Google Sheet, which involves generating an API key from Apple search ads Dashboard and using it to configure the data source in Two Minute Reports (TMR) configuration. By adding this data source, you can create a new query config using the newly created data source and create an Apple search ads report from scratch.
Step 1: Install and Launch Two Minute Reports
Install Two Minute Reports, if you have not done already.
Sign in to any Google Sheet and go to Add-ons -> Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Two Minute Reports will be installed for you with the e-mail you are sign in to Google Sheets.
Open Google Sheets and go to Extensions -> Two Minute Reports -> Launch.
Step 2: Connect Apple Search Ads to Google Sheets
Once you launch, You get the Two Minute Reports (TMR) sidebar opened at the right side of the Google Sheet. By default you will have the Data Queries bar open.
Click on the Menu icon located at the top left corner of the TMR sidebar, then select the “Data Sources” option.
Now, You will be redirected to the Data Sources section in the sidebar. Click on Add+ to create your new Apple search Ads Data Source
In the TMR sidebar, click on the “Select your source type” option to view all available data sources. From there, select Apple search ads from the Data source dropdown and give your Data Source a name.
Once you select your Data source. You would need to fill 4 credentials, which are : client id, Team id and key id. You would need to get these credentials from the Apple search ads dashboard. For that, you would need to copy this public key and paste it in the Apple ads dashboard.
Step 3: Generate API credentials from your Apple Search Ads dashboard
To connect your Apple Search Ads data source to Two Minute Reports, you’ll need to generate API credentials from your Apple Search Ads dashboard. However, it’s important to note that only accounts with an API Account Manager or API Account Read Only user role can generate these credentials. If your account is an Account Admin user role, you won’t be able to generate them.
If you don’t already have an account with the necessary user role, you can easily create one and invite the same as a user with API Account Manager or API Account Read Only access to share your account. This can be any Apple Search Ads account other than your Admin Account.
Here are the steps to invite a user with the appropriate access:
- Log in to your Apple Search Ads dashboard with your Account Admin role account.
- Click on your account name, located in the top right section of the dashboard, and select the settings option next to it.
- Go to the User Management tab.
- Click on Invite User.
- Provide the name and Apple ID of the person you want to share your account with.
- Select User Access and Role as API Account Manager or API Account Read Only, then click “Send Invite.”
- The invitee will receive an email explaining that they’ve been invited to an Apple Search Ads account. Accept the invite to get access.
Go to your Apple Search Ads Dashboard, click on sign in and choose the Advanced option
You would need to sign in to your Apple Search ads account with API Account Manager or API Account Read Only user role to connect, use your Apple ID and password and click on that arrow icon to log in.
You will get the Apple Search ads campaign dashboard once you log in with your account.
Now, click on your Account name placed on the top right section and select the settings option next to your account name.
You would now be redirected to the API credentials page. You now have to paste the public key copied from Two Minute reports sidebar and paste it here in the Public key space of the Apple Search ads dashboard and click on Save.
Step 4: Add the API credentials in TMR configuration.
Copy Client id, Team id and Key id from the Apple Search ads dashboard and paste it in the TMR sidebar and click on Test Connection. Once your connection is successful, you would get a successfully authenticated message, Click Yes to save the configuration and proceed.
You can check your newly created Apple Search ads Data source in the Data Sources section of TMR sidebar.
Step 5: Getting Apple Search Ads data in Google Sheets
Click on the menu icon and select Data Queries. Click on +Add to start creating a new Data query.
When creating a new Data Query, you will need to give it a name and select the appropriate Data Source. In this case, select the newly created Apple Search ads Data Source for your Data Query.
Next, you will need to specify where the data should be displayed in the sheet. Once you have done that, add the appropriate Metrics and Dimensions for your Data Query, and select a suitable date range according to your needs. Finally, click on the “Run query” button to retrieve the data and display it in the selected location on the sheet.
Once your query is run successfully, you will have the option to save the Query. Click Yes to save it. You can now check your saved query in the Data Queries section.
Step 6: (Optional) Schedule Automatic data Refresh and email
Once you have fetched data once, you might want to get new data from your database at periodic intervals. You can do this creating a new schedule under the “Schedule Reports” section. You can schedule updates hourly, daily, weekly or monthly based on your needs.
You could also create a report and ask Two Minute Reports to email that report with updated data automatically. Under the email section enter the email Id of the recipients and save your new schedule.
When the time comes, Two Minute Reports will automatically fetch new data from your queries, and email your report to the said recipients. You have freed a lot of your time from mundane reporting tasks.
There are other features with Two Minute Report’s schedule refresh or data refresh feature. You may read our guide How to Refresh Data Automatically in Google Sheets.
I hope this article helped you create a new Data source and a query for Apple search ads from Scratch.