Welcome to Data Builder Beta!

What is Data Builder?

Data Builder is a powerful tool within your Power My Analytics hub that allows you to:

• Create customized datasets from your data warehouse
• Blend data from multiple sources into unified tables
• Control exactly which fields and date ranges to include
• Easily connect your datasets to Looker Studio, BigQuery, etc.

Think of it as your data workshop where you can craft exactly the data views you need for your reports and analysis.

Getting Started

Step 1: Access Data Builder

Navigate to Data Builder in your hub's main navigation bar (located below Sources).

Step 2: Create Your First Dataset

A dataset is like a folder that contains one or more data tables. Here's how to create one:

1. Click "+ Create Dataset"
2. Name your Dataset - Choose a clear, descriptive name (e.g., "Q1 Campaign Analysis", "Client ABC Reports", "Social Media Performance")
3. Set Available Data Range - Choose how much historical data to include:
   • This controls the maximum date range for all tables in this dataset
   • You can override this for individual tables later
   • Default: Last 30 days (perfect for most reporting needs)
     

Step 3: Add Data Tables

Data tables are where your actual metrics and dimensions live. To create one:

1. Click "Create Data Table" within your dataset
2. Choose Your Sources:
   • Single Source: Select one platform (e.g., just Facebook Ads)
   • Blended: Combine multiple platforms (e.g., Facebook Ads + Google Ads + LinkedIn Ads)
     
     
3. Select Your Fields:
   • Use the search bar to find specific metrics
   • Browse categories: "Most Popular" (expanded by default) or "All"
   • Toggle between Dimensions and Metrics
   • Drag fields to reorder them
     
     
     
     
4. Configure Options:
   • Name your data table
   • Set sorting preferences
   • Apply filters if needed
   • Adjust row limits (default: 1,000,000)

Key Features

Data Blending Made Simple

Combine data from multiple platforms in one table. For example:

• Create a unified view of all your ad platforms
• Blend e-commerce data with advertising metrics
• Compare organic and paid social performance side-by-side

Smart Field Organization

• Metadata Table: System fields like data source and platform names
• Date Table: All date-related dimensions in one place
• Compatible Fields Only: We automatically show only fields that work together

Flexible Date Ranges

• Set a master range for your dataset
• Override with custom ranges for specific tables
• Perfect for quarterly reports, campaign analysis, or year-over-year comparisons

Important Beta Notes

Current Limitations

⚠️ Looker Studio Connection To connect your Data Builder datasets to Looker Studio:

1. Go to Reports > Looker Studio in your hub
2. Select the "Power My Analytics" connector (not individual platform connectors)
3. Choose your dataset from the list
   
   

⚠️ Spreadsheet Integration

• Google Sheets and Microsoft Excel integration is coming soon
• Currently, Data Builder works with:
  • Looker Studio (via the Power My Analytics connector)
  • BigQuery exports
  • SQL exports
  • FTP exports

Beta Feedback

As a beta user, your feedback is invaluable! Please share:

• Feature requests
• Bug reports
• Workflow suggestions
• Performance feedback

Reply to this email with "Data Builder Beta" in the subject line.

Common Use Cases

For Agencies

• Create separate datasets for each client
• Blend performance data across multiple sources
• Blend client data for internal reporting

For E-commerce

• Blend advertising costs with sales data
• Calculate true ROAS across all platforms
• Track product performance with filtered views

For Marketing Teams

• Unify metrics across all channels
• Create executive dashboards
• Build campaign-specific analyses

Quick Tips

1. Start Simple: Create a single-source dataset first to get familiar with the interface
2. Use Templates: Once you create a dataset structure you like, duplicate it for similar needs
3. Name Clearly: Use descriptive names for both datasets and tables - your future self will thank you
4. Preview Often: Use the preview feature to verify your data before creating reports

Next Steps

Ready to dive in? Here's your action plan:

1. Create your first dataset with a descriptive name
2. Add a data table with your most important metrics
3. Connect to Looker Studio using the Power My Analytics connector
4. Build your report and share your feedback!

Need Help?

• Onboarding: Schedule a session at https://calendly.com/pma-support/onboarding

Thank you for being a Data Builder beta tester! Your early adoption and feedback help us create the best possible experience for all Power My Analytics users.