PPC Advertising Report Template
for Google Sheets + Data Studio

integration_instructions Setup Instructions

Google Sheets (required)

1. Start a free trial or log in to Power My Analytics.

2. Under data sources, connect your PPC Advertising account(s) to Power My Analytics.

3. Install and open Power My Analytics for Google Sheets.

4. In the sidebar, select PPC Advertising from batch_predictionCreate Template, which can be found under addAdd report.

5. Follow the sidebar prompts to configure the data source(s) and/or account(s).

6. Choose a date range, then click Set Range and Finish button to create your report.

Google Data Studio (optional)

1. Open PPC Advertising for Google Data Studio, then clickmore_vertMore options and select content_copy Make a copy.

2. On the Copy this report popup, click the Select a datasource dropdown from the New Data Source column, then click CREATE NEW DATA SOURCE.

3. Under Google Connectors, select Google Sheets, then select the PPC Advertising Spreadsheet and Worksheet that correspond with the Original Data Source column.

4. Once the data source(s) have been selected, click the Copy Report button.

Pro Tip: Click the alarmSchedule refresh button in the Power My Analytics sidebar for Google Sheets to automatically update your data for both reports periodically.