ad:personam Google Looker Studio connector
Our Data Studio Service offers ad:personam users a streamlined way to connect their advertising campaign data directly to Looker Studio using a private connector. This service is exclusively available to subscribed users.
Ciro Scognamiglio
Last Update 9 måneder siden
Step-by-Step Guide to Using the ad:personam Looker Studio Connector
- Initiate the Connection : Click the "Connect ad:personam to Looker Studio" button on our platform. This action will redirect you to our private connector page on Google Looker Studio.
- Authorize the Application : Authorize our application to access your ad:personam data. Rest assured, your data security and privacy are paramount, and access is strictly used for report generation purposes.
- Configure Your Data Source : Enter the necessary information to configure your data source:
- Advertiser IDs: Enter one or multiple advertiser IDs separated by commas to include data from multiple campaigns.
- ad:personam Username: Input your username associated with your ad:personam account to validate the data access.
- Opt for a Report Template : Optionally, you can select "Use report template for new reports" if you wish to use our pre-designed template tailored for advertising data analysis. This option simplifies the setup process and provides you with a robust starting point for data exploration.
- Finalize the Connection : Click "CONNECT" to establish the connection. Once connected, you will be able to create and customize reports using your ad:personam data in Looker Studio.
Enhancing Your Reports with Calculated Data Fields
To maximize the insights from your ad:personam data, we recommend incorporating several calculated fields into your reports. These fields help translate raw data into actionable analytics, providing deeper insights into campaign performance.
Suggested Calculated Fields:
- CTR (Click-Through Rate): SUM(clicks) / SUM(imps), expressed as a percentage. This metric measures the effectiveness of your advertisements in generating clicks.
- Completion Rate: SUM(video_completions) / SUM(video_starts), expressed as a percentage. Indicates the proportion of video ads played through to completion.
- Conversion Rate: SUM(total_convs) / SUM(imps), expressed as a percentage. Reflects the efficiency of campaigns in driving conversions.
- CPA (Cost Per Acquisition): SUM(total_cost_buying_currency) / SUM(total_convs). Calculates the cost incurred for each conversion.
- CPC (Cost Per Click): SUM(total_cost_buying_currency) / SUM(clicks). Indicates the average cost paid per advertisement clicked.
- CPCV (Cost Per Completed View): SUM(total_cost_buying_currency) / SUM(video_completions). Measures the cost of each completed view of a video ad.
- CPM (Cost Per Thousand Impressions): SUM(total_cost_buying_currency) / SUM(imps) * 1000. Represents the cost per thousand impressions.
- View Rate: SUM(imps_viewed) / SUM(view_measured_imps), expressed as a percentage. This metric assesses the visibility rate of your ads.
Learn more about calculated fields and how to implement them in your reports.
Additional Notes on the ad:personam Connector and Authorization
- Beta Status of the Connector: Please note that the ad:personam connector is currently in beta. This means that while it is fully functional, it has not yet been verified or reviewed officially. We appreciate feedback from our users to improve the service.
- Authorization Warnings: When you attempt to authorize the ad:personam connector in Google Looker Studio, you may encounter a warning indicating that the app is unverified. This is a standard warning for all apps that have not yet completed Google's verification process.
- Handling the Authorization Warning:
- Click on "Advanced" in the warning dialog. This will allow you to proceed despite the warning.
- Then click on "Continue to use the connector". By doing so, you acknowledge the risks as this connector is still in the beta phase and has not been verified by Google.
- Privacy and Security: We assure our users that no personal data is required by the ad:personam connector to function. Our priority is to maintain high standards of privacy and security.
Access to Legacy Dashboards for Existing Users
Legacy Dashboard Access: For users who have been with ad:personam before the introduction of our new Looker Studio connector, we have good news. If ad:personam previously created a dashboard specifically for your advertiser account, you can continue to access this dashboard. Simply click on "Your Advertiser Legacy Dashboard" in our interface. This option ensures that long-standing users can still leverage historical data and insights without disruption while also exploring new functionalities with the Looker Studio connector.