Sync Apple Search Ads data to Sourcetable
Apple Search Ads
Sync Apple Search Ads data to Sourcetable
All your business data, synced in a spreadsheet.
Find out how to make the most of your Apple Search Ads data with Sourcetable
Sourcetable Benefits
Query advertising campaign data quickly & easily
Apple Search Ads allow app owners to target users who are interested in their app’s services, and get their app displayed among the top results in Apple’s App Store search pages, while controlling costs and measuring the success of their campaigns. Syncing Apple Search Ads data to Sourcetable, and combining it with inputs from other key platforms and databases, allows businesses to keep track of advertising campaigns on Apple’s App Store and elsewhere, and how they interact with other important activities and metrics, easily and at a glance.
Automation
Use Sourcetable to compile key data from Apple Search Ads and other platforms quickly and intuitively, automate processes in one easy-to-use spreadsheet, and free up time to focus on other important aspects of your business.
Accessibility
Query inputs and data from Apple Search Ads and multiple other databases and platforms in Sourcetable, without having to learn SQL. Make your advertising campaign data readily available to everyone on your team, all in one place.
Visualizations
Sourcetable’s full suite of visualization tools caters for all your reporting needs - from bar charts to line graphs, burn charts, mapping, scatter plots, and more. Create visually striking live dashboards to share with your team and identify the core app acquisition metrics that matter most to your business.
How to get the most of Apple Search Ads with Sourcetable
Smart Templates
Use out of the box tried and tested templates in order to cross-reference Apple Search Ads data and enable data collaboration across your entire organisation
Quick Analysis
Query your App Store advertising campaign data quickly and easily in intuitive cross-channel reports
Ease Of use
Compile all your Apple Search Ads data into a single spreadsheet, identifying key business insights behind the numbers in order to improve the performance of your campaigns.
Who uses Apple Search Ads data in Sourcetable
📈 Marketing and Advertising professionals
👷🏿 Sales and Sales Ops folk
🚀 Founders
👨💻 App Developers
👩🏼💼 Product Managers
🏢 Ecommerce businesses
Here's a sample of Apple Search Ads data that will be available in your Sourcetable spreadsheets:
AD_GROUP_HISTORY
Contains the information of campaign history, organisation, name, start time, end time, status, cpa and cpc information
AD_GROUP_REPORT
Contains the information of Ad group history, average cpa fields, taps, conversion rate, and local spend currency and amount
CAMPAIGN_HISTORY
Contains organisation information, campaign name, status, budget information, start and end time of campaign and whether campaign has been deleted or not
CAMPAIGN_REPORT
Contains information regarding the campaigns and fields like campaign history, average CPA information fields, local spend currency, and amount and download information fields
COUNTRY_OR_REGION_HISTORY
Contains the information of campaign history, modification time, and country or region information
KEYWORD_HISTORY
Contains AD group history, campaign history, text, status, match type, bid amount and currency
KEYWORD_REPORT
Contains information regarding the keywords and contains information about impressions, taps, average cpa information, download information, and installation information
NEGATIVE_KEYWORD_HISTORY
Contains the information regarding the Ad group history, campaign history, text, status, match type and deleted flag
ORGANIZATION
The organisation is the company using the service, it contains fields like name, currency, payment model, timezone and role name
SEARCH_TERM_REPORT
A reporting table which contains the information regarding the search term fields, campaign history, AD group history, keyword history, Average CPA fields, bid amount and currency, download and installation fields
TARGETING_DIMENSIONS_HISTORY
Contains the information of AD group history, type, value and modifcation time
Sample companies
Online businesses integrating Apple Search Ads with Sourcetable have access to all relevant data and main App Store ad campaign KPIs.
-
Retail online stores
(eCommerce) -
B2B Platforms
-
App developers
-
Software as a Service
(SaaS) companies -
B2C Marketplaces
Popular Use Reports & Use Cases
Create analytics reports using Apple Search Ads data
Apple Search Ads + Sourcetable
Automate Apple Search Ads reports on a daily, weekly or monthly cadence
Apple Search Ads + Sourcetable
Analyze Apple Search Ads data on app downloads and user logins
Apple Search Ads + Sourcetable
Use Sourcetable as an ETL source to combine Apple Search Ads with other data sets
Apple Search Ads + Sourcetable
Warehouse Apple Search Ads data to create a historical record
Apple Search Ads + Sourcetable
What makes Sourcetable special?
Interconnectivity
Connect, sync and query your Apple Search Ads data together with findings from 30+ other sources
Automation
Automate your Apple Search Ads data and reports so you can free up time to focus on what matters most: promoting your app and selling your product
Collaboration
Create views and workflow templates to drive decisions based on data from Apple Search Ads and other platforms, and share among team members, no knowledge of SQL required