Recent Articles
How to Export to SQL
Power My Analytics can export your marketing data to a SQL database hosted on the server of your choice, so you can run complex queries over your data and integrate it with a variety of applications. PMA currently supports three SQL database types as ...
Group Locations by Your Own Hierarchy Using a Data Builder Lookup Table
If your location scorecards are missing stores, or grouping them under the wrong regions or managers, there are only two causes. This article helps you identify which one you have, then walks you through both fixes: enabling missing locations in your ...
Get Your Data Builder Table Data Into Your Own Code
You built a data table in Data Builder and want its rows in your own script, warehouse, or scheduled job. This guide covers the two ways to do that and helps you pick the right one. The short version: the Power My Analytics API has no Data Builder ...
Why Your CPM, CTR, and CPC Totals Look Wrong in Power BI, Data Studio, or Google Sheets (and How to Fix Them)
Why Your CPM, CTR, and CPC Totals Look Wrong in Power BI, Data Studio, or Google Sheets (and How to Fix Them) If the totals row in your report shows a CPM, CTR, or CPC that does not match your ad platform, your data is fine: the totals row is doing ...
How to Connect to Mixpanel
Connecting your Mixpanel account to Power My Analytics allows you to centralize your product analytics data for more efficient reporting and analysis. This guide will walk you through creating a Mixpanel Service Account, finding your Project ID, and ...