| A | B | C | |
|---|---|---|---|
1 | |||
2 |  | ||
3 | |||
4 | Overview | ||
5 | |||
6 | This workbook was created by the iPullRank team along with a Looker Studio dashboard (https://bit.ly/ipr-ai-db). Data varies from one citation service to another, so you can use this as a guide. Any cell with a formula is indicated with a yellow background. You'll want to be extra careful around those cells. | ||
7 | |||
8 | Steps to Use Template | ||
9 | 1) Drop your data into the Sample Citations Data worksheet. | ||
10 | 2) In Looker Studio:  a) Click the Edit button at the top of the dashboard, if you're not already in Edit mode. b) Make a copy of this dashboard (File > Make a copy...).  c) Connect to your updated Google Sheet (In the Copy this report dialog, under New Data Source, click Create Data Source > Create New Data Source > Google Sheets > select your worksheet > click the Connect button).  d) Apply the new data source (Click Replace Data Source when prompted).  e) Verify each chart by clicking on a chart while in Edit mode, checking the Data Source under the Setup panel on the right, and ensuring it’s pointing to your updated sheet. f) If your data doesn't update, click the 3 dots next to the View/Edit button in the upper-right corner and select Refresh data from the menu. | ||
11 |