LinkedIn Ads Optimization Dashboard

How to use this dashboard

Step 1: Get your data from LinkedIn

1. In LinkedIn Campaign Manager, go to Advertise > Export.
2. Select Ad set performance (broken out by day) as the report type.
3. Download the export and open it. This gives you one row per ad set per day, which is exactly the format this dashboard expects.

Step 2: Prepare your Google Sheet

1. Open the downloaded file in Excel or Google Sheets (File > Import > Upload). LinkedIn's export is UTF-16 encoded and tab-separated. Both Excel and Sheets' Import handle this automatically when you open/import the file directly (don't copy-paste raw text, it can scramble the encoding).
2. The first 4 rows are report metadata ("Report Start", "Report End", "Date Generated") plus a blank row. Delete these top rows so your sheet's row 1 is the actual header row starting with Start Date (in UTC).
3. Once imported, copy the header row and all data rows into the first tab of your working Google Sheet, starting at cell A1. Don't add extra header rows above it.
4. Keep the LinkedIn column names exactly as exported. This dashboard specifically reads: Start Date (in UTC), Campaign Name, Ad Set Name, Clicks, Total Spent, Impressions, Leads, Conversions, and Campaign Status.
5. Each month, export fresh data from LinkedIn and paste the new day-wise rows underneath the existing ones (don't overwrite history). The dashboard picks up everything currently in the sheet.

Step 3: Connect the sheet to this dashboard

1. Download the Apps Script code: apps_script_code.gs
2. In your Google Sheet, go to Extensions > Apps Script, delete any starter code, and paste in the downloaded file's contents.
3. Update the SHEET_NAME constant near the top of the script if your tab isn't named "Sheet1".
4. Click Deploy > New deployment → type Web app.
5. Set "Execute as" to Me, and "Who has access" to Anyone. Click Deploy and authorize when prompted.
6. Copy the URL ending in /exec, paste it into the box above, and click Connect.

Alternative: Upload the raw CSV directly

If you just want a quick look, you can upload the LinkedIn export file as-is using the "Upload CSV" button above. No sheet or Apps Script setup needed.

Important: LinkedIn only keeps day-wise (daily breakdown) data for the trailing 6 months. If you want to analyze performance over a longer period, uploading a single CSV export won't have that history. Connecting a Google Sheet and pasting in each month's export, building up history over time, is the only way to retain more than 6 months of daily data for trend analysis.

Once connected, this dashboard shows spend, CTR, CPC, leads, and conversions by campaign and ad set, with sortable tables, date-range filters, and trend charts. The sheet connection talks directly to your own Google Apps Script endpoint. Nothing passes through any other server. Uploaded CSVs are parsed entirely in your browser.

No data connected yet

Click "How do I use this?" above for setup steps, then connect your Google Sheet to see your campaign performance.