How to export and analyze campaign results from Scrab dashboards

If you run campaigns with Scrab and need to make sense of what actually happened, this guide is for you. We'll cut through the hype and show you, step by step, how to export your campaign data and actually learn something from it—whether you're reporting up to your boss or just trying to figure out what actually worked. No vague dashboards, no “insights” that don’t mean anything. Just practical steps, honest advice, and a few warnings about what’s worth your time.

1. Get Oriented: What Scrab Dashboards Can (and Can’t) Tell You

First things first: Scrab dashboards are fine for a quick glance—say, did this campaign totally flop or not—but they’re not built for deep, flexible analysis. You get totals, averages, sometimes a graph or two. If you want to, say, compare last month’s performance to this month’s or slice by different segments, you’re going to hit a wall.

Here’s what Scrab dashboards are decent for: - Spotting obvious trends (big spikes or dips) - Seeing high-level metrics (impressions, clicks, conversions) - Sharing a screenshot with someone who just wants a quick look

Here’s what you can’t easily do in the dashboard: - Export raw data for custom analysis - Slice and dice by multiple filters (unless your plan includes advanced dashboards, which, let’s be real, are often paywalled) - Combine Scrab data with data from other tools

If you need to do anything more than basic surface-level reporting, you’ll want to export your data. Here’s how.

2. Exporting Campaign Results from Scrab

Step 1: Log In and Navigate to Your Campaign

  • Log in to your Scrab account.
  • Head to the “Campaigns” tab—usually found in the main left-hand menu.
  • Click on the specific campaign you want to analyze. If you handle a lot of campaigns, use the search or filter tools to narrow things down.

Pro tip: Scrab sometimes changes menu names; if you don’t see “Campaigns,” look for “Projects” or “Results.” It’s the section with all your campaign performance data.

Step 2: Find the Export Option

  • Once inside the campaign dashboard, look for an “Export” button.
  • It’s usually at the top right, sometimes disguised as a download icon (downward arrow).
  • If you don’t see it immediately, check under a “More” or “...” menu.
  • Some Scrab plans only allow exports in certain formats (CSV, XLS). If you’re on a free or basic tier, you might get only a summary export, not the raw data. Annoying, but that’s how it goes.

Heads up: If you truly can’t find the export option, Scrab support can be slow. Sometimes, logging out and back in magically makes the button appear. No idea why.

Step 3: Choose Your Export Settings

  • Select the export file format. CSV is the safest bet—easy to open in Excel, Google Sheets, or import into something more powerful later.
  • Pick your date range. By default, Scrab often only exports the last 30 days, so double-check this.
  • Decide if you want summary data (aggregated numbers) or detailed data (each row is an event or user).
  • Click “Export” or “Download.” You’ll usually get a file in your downloads folder, or it’ll show up in your email.

What actually works: Always grab the most detailed export you can. Summary exports are too limited for real analysis.

3. Cleaning and Preparing Your Exported Data

Don’t just open your CSV and start poking around. Scrab’s exports are notorious for: - Weird column names (e.g., “conv_amt” instead of “Conversion Amount”) - Empty columns or rows - Date formats that make no sense (e.g., 20240605 for June 5, 2024)

Step 1: Open and Inspect

  • Open the CSV in Excel or Google Sheets.
  • Do a quick scan. Are all the columns there? Any gibberish?
  • If you see “null,” “N/A,” or blank cells, that’s normal. Scrab likes to include every possible field, even if it’s empty.

Step 2: Clean Up

  • Rename columns to something you’ll understand later (e.g., “clicks” instead of “clk_ct”).
  • Delete columns you don’t need. If you’re not using “Campaign Budget Remaining,” nuke it.
  • Standardize date formats. If you’re stuck with weird numbers, use Excel’s DATE function or Google Sheets’ DATEVALUE() to convert them.
  • Check for duplicate rows. Sometimes Scrab exports the same row twice, especially if you have overlapping filters.

Pro tip: Save this cleaned version as a new file. If you mess up, you can always go back to the original.

4. Analyzing Your Campaign Results

Now you’ve got a clean spreadsheet. Here’s where you actually figure out what’s working.

Step 1: Define What Matters

Don’t get distracted by every metric Scrab throws at you. Focus on what actually matters for your campaign. Usually, that’s: - Click-through rate (CTR) - Conversion rate - Cost per conversion - Total spend vs. total return

Everything else is just noise unless you have a specific reason to dig deeper.

Step 2: Start With Simple Summaries

  • Use SUM, AVERAGE, and COUNT functions in Sheets or Excel to get the basics.
  • Build a quick pivot table to see results by:
    • Date
    • Audience segment
    • Channel or creative
  • Look for obvious outliers. Did one ad spend 10x more than the others? Did a particular day tank your overall results?

Step 3: Ask Real Questions

Instead of just reporting numbers, try to answer questions like: - Did we actually get more conversions this month, or did we just spend more? - Which audience segment performed worst? Is it worth turning them off next time? - Are any results way off compared to previous campaigns?

Step 4: Visualize (But Don’t Get Fancy)

A quick line graph or bar chart goes a long way. Don’t waste time making your spreadsheet pretty. You’re not presenting to a boardroom (unless you are, in which case, good luck).

What works: Use conditional formatting in Sheets/Excel to highlight high and low performers. It’s fast and makes patterns jump out.

5. What to Ignore (and Why)

Scrab, like a lot of tools, loves to give you “vanity metrics.” Here’s what you can safely ignore unless you have a very good reason: - “Impressions” with no context—who cares if nobody actually clicked? - “Engagement rate” on automated actions. It’s easy to fudge these. - “Estimated reach”—this is almost always just a guess. - Any metric labeled “AI Score” or “Predicted Lift.” These are black boxes. Don’t base your next campaign on a number you can’t explain.

6. Combining Scrab Data with Other Sources

If you really want to know what’s going on, you’ll probably need to compare Scrab results to what you see in Google Analytics, your CRM, or sales data.

  • Export those other data sources as CSVs.
  • Line up the date ranges and campaign IDs.
  • Use VLOOKUP or JOIN functions to combine things in Sheets or Excel.
  • Watch out for mismatched time zones—Scrab may export in UTC, while your other tools use local time. This will mess up your comparisons if you’re not careful.

Pro tip: If you’re doing this often, consider automating it with a script or using a tool like Zapier or Make. But don’t overcomplicate it unless you really need to.

7. Reporting and Next Steps

Once you’ve got your answers, don’t overthink the report. Most people just want: - What worked, what didn’t - The main numbers (conversions, spend, ROI) - One or two charts, tops

Skip the fluff. If someone asks for a “deep dive,” make sure they actually want it—you could waste hours slicing data nobody cares about.

Keep It Simple and Iterate

Exporting and analyzing campaign results from Scrab isn’t rocket science, but it’s not “one click and done,” either. The dashboards are fine for a quick glance, but the real value comes when you dig into the actual data yourself—even if it means cleaning up a messy spreadsheet.

Don’t get lost in the weeds. Start simple, answer the important questions, and improve your process each time. The more you do it, the faster and smarter you’ll get. And if you run into roadblocks, remember: half the time, it’s not you—it’s the tool.