Marketing Analytics

Airbook offers a suite of plug-and-play marketing templates designed to address specific use cases across the marketing analytics spectrum. These templates come with pre-baked SQL queries, allowing users to plug in their integrations, optimize the SQL, and instantly derive insights. This guide introduces you to some of the key marketing templates available in Airbook.

Top Marketing Templates

Website Conversion Rate Optimization

  • Description: Analyze website user behavior data to optimize the conversion rate. Understand user behavior, identify design issues, and propose solutions.
  • Data Sources: Google Analytics, Hotjar, Google Optimize.
  • ​Access Template​

Web Analytics

  • Description: Dive deep into web traffic and user behavior. Identify traffic sources, analyze user behavior, and gauge website performance.
  • Data Sources: Google Analytics, GoogleSearchConsole, GoogleTagManager.
  • ​Access Template​

Marketing ROI Analysis

  • Description: Analyze marketing campaigns by their ROI. Identify high-performing campaigns, determine cost-effectiveness, and understand revenue-generating customer segments.
  • Data Sources: Facebook Ads, Google Ads, Salesforce.
  • ​Access Template​
More templates here- https://app.airbook.io/templates​

How to Use the Templates

  1. 1.
    Access the Template: Click on the provided link for the desired template.
  2. 2.
    Duplicate the Template: Click 'Duplicate' to copy this template to your Airbook workspace.
  3. 3.
    Plug in Your Integration: Connect your data sources, such as Google Analytics, Salesforce, etc.
  4. 4.
    Optimize the SQL: If necessary, make adjustments to the pre-baked SQL queries to better suit your data structure or specific needs.
  5. 5.
    Run the Template: Execute the queries to instantly derive insights and visualizations.
Airbook's marketing templates are designed to streamline your analytics process, providing you with actionable insights in a fraction of the time. Whether you're looking to optimize your website's conversion rate, analyze your web traffic, or measure the ROI of your marketing campaigns, Airbook has a template tailored for your needs.