Importing Web Queries into Google Sheets

The flexible nature of Web Queries means that Marketers can automatically import their data directly into the spreadsheet of their choice. Traditionally, many marketers have used Microsoft Excel for this purpose, but more recently we've updated Web Queries to support Google Sheets as well as Excel. There are a few benefits to using Google Sheets ins...

Multi - Client Reporting

Multi-Client Reporting is a feature that allows users to run a report across multiple clients. The results are then rolled into a single report located in the All Clients view. You can run multi-client queries on All Clients in the Customer or by using the custom client tags that you have defined (running a report on All Clients in the Line of Busin...

Reports

The Marin platforms have been built to offer complete control over your data at all times, including a variety of different reporting options.  We recommend using the Table of Contents at right to skip around between the sections that are most relevant to your workflow. Note: Reports created in Marin Search won't automatically be carried over to Mar...

"The specified report request contains at least one account for which you have insufficient privileges to access" Error Message

If you try to run/pull a report across multiple client accounts but the report fails and you receive the following error message: Error: com.marin.mscm.services.ServiceFault: The specified report request contains at least one account for which you have insufficient privileges to access.   What Causes This Issue This error occurs when you try to run ...

Adding or Changing Email Addresses in Email Report Fails

If adding or changing email addresses in the Report Templates, if you click Run Report, you may encounter the following error message: Error: java.lang.NullPointerException   What Causes The Issue? This problem is most commonly caused by having a carriage return (space or invalid email character) in the email recipients field under Report Settings i...

Avoiding Report Processing Failure and Reduce Processing Time

A report may take a long time to process or may even fail if: There are lots of objects (i.e. keywords, creatives, etc.) within the report. This can result in a large amount of data rows to be processed. Calculated columns and/or custom columns are included in the report. The system will need to recalculate the values for each object. Including non-...

Configuring Date Format in Reports

When creating a report, you may notice the data sometimes uses commas. The commas could make the date unusable in Excel, as Excel would use commas not as a delimiter for thousands, but as a separator for decimals. What Causes The Issue? This problem is caused because the locale of your MarinOne client account is different from that of your Excel. He...

Creating a Report with Filters does Not Work

Even though you create a one-time or recurring report with filters, the actual report does not adhere to some or all of these filters, and shows all data instead of data for specific filtered campaigns. What Causes The Issue? This can happen if you are multi-tabbing or applying multiple filters and adjusting the grid at the same time. When you are a...

Data in Alerts is Not Accurate

You create an alert with some filters to specify when the alert should work; however, when the alert is triggered, the data contained within it is not accurate. For example, you may choose to have an alert which shows only accounts where day by day change in publisher cost is greater than 20%. However, when the alert is triggered, there is actually ...

Data Missing In Recurring Reports

You may notice there is data missing within a recurring report (conversions or publisher data) even though there is data present in the application. What Causes The Issue? There are two potential causes for this issue: This problem is most commonly caused by running your recurring report before that data has finished processing in the application. T...

Formatting Errors When Running Reports with Different Locale Settings

The format of reports in MarinOne is configured by the Locale setting, which you can access by following these steps: Click Admin module in the bottom-left. Click on the Clients & Users tab and the Clients sub-tab. Double click on the desired client to launch its settings in the Side Panel.  Under the Geographic section, hover over the Locale fi...

Keywords Appear in Report But Not in the Grid

You may notice that when you run a report , it shows keywords that are not actually visible in the platform when you filter. For example, you could run a report and see 1000 broad keywords; however if you filter the grid for active broad keywords, you see zero. What Causes The Issue? This is a rare issue that will only occur in the following circums...

Newly Added Campaigns Do Not Appear in Recurring Reports

When you add new campaigns, you can see them in MarinOne, but they don't show up the recurring reports. What Causes The Issue? This problem is most commonly caused by having more than 100,000 rows in your report. When creating a report manually, it will contain all rows. However, automatically generated reports can include up to 100,000 rows. How To...

Recurring Report Not Running

When trying to run a a recurring report, you're redirected to the Dashboard page in the platform, and the report does not get kicked off. You may also come across an error where you are unable to view your columns in the report preview. What Causes The Issue? This problem most commonly occurs when there are multiple recurring reports with the same n...

Recurring Reports Not Being Delivered via Email

If you have set up recurring reports to be delivered to specific email addresses on a regular basis (daily, for example), you may find that, despite the report being set up correctly, it is not being delivered via email. How To Diagnose The Issue The first thing to double-check is that your email address is entered correctly within the specific Repo...

Recurring Reports Not Running as Expected

You may encounter the situation that daily recurring reports aren't running automatically. What Causes This Issue? This problem is most commonly caused by having a campaign with a different time zone from that of the platform. For example, you are based in the UK, but the platform client account is in the (GMT-1000) Hawaii Standard time zone (due to...

Report Columns Disappearing After Editing Report Templates [Marin Search]

After editing Report Templates, newly added columns may disappear. What Causes The Issue? This is a known issue with the platform. Our engineers are aware of it and we will endeavor to fix the problem in a future release. In the meantime you can use the workaround below to resolve the issue. How To Fix The Issue Please make sure you are viewing the ...

Report Date Format is Not Consistent When Imported to Excel

When downloading a report with a long date range and opening it in Excel, you may find that some of the dates are in date format while others are in text format. What Causes The Issue? This problem is most likely caused by an Excel locale setting trying to change the date format. How To Fix The Issue To workaround this problem, follow these steps: D...

Rows in Recurring Reports are Incomplete or End at 100,000

When comparing a one-time report with a recurring report, you may notice a discrepancy between the total number of rows. More specifically, the recurring report will have fewer rows than the one-time report – most likely ending at 100,000 rows. What Causes The Issue? This problem is not a fault, rather it is because of a limitation of recurring repo...

Solving Problems with Web Query Reports

Web Query reports are very useful analytical tools, but you may sometimes encounter problems which prevent you from using them effectively – or at all. This article lists some common problems with web queries as well as how best to deal with them. Potential Problems With Web Queries Here are some of the most common problems: The web query simply doe...

The Number of Metric Columns in Report Builder and the Exported Report Do Not Match

You add some new DOCL(Date of Click) or DOC(Date of Conversion) metric columns in your recurring report from the Report Templates, and it looks successful as you see all the newly added columns in the report settings preview. However, the exported report is missing the added columns and/or other columns such as Conversion Types and Conversions / Rev...

A Completed Report Shows Blank Values for Certain Objects

A completed report shows no metrics for several objects. By ‘no metrics’, we mean that the value is blank, and not just zero. For example, under Impressions the value for an object contains no data whatsoever. What Causes The Issue? This issue is most commonly caused by an object being out of sync with the publisher. You can confirm this by locating...

History Graph Showing Incorrect Data

What Is The Issue? You may encounter the History graph showing incorrect data, for example, the graphs in your Microsoft account reference numbers from your Google account. What Causes The Issue? This is a known issue caused by the cache and cookies from your browser. How To Fix The Issue You can fix the issue by logging out of the platform, clearin...

Percentage Change Columns Do Not Appear in Reports

You may notice that when running your reports, the Change % columns do not appear as expected. Example columns include Click Change % and Pub. Cost Change %. This happens when you choose to view the report data by day, week or month. What Causes The Issue? There are multiple scenarios that can cause this problem: Scenario 1 This problem is due to th...

Publisher Data Not Imported as Expected

You may encounter a situation where publisher data (i.e. cost, click etc.) is not imported into the platform as expected. What Causes The Issue? This problem is possibly caused by platform enhancements that are underway. This can cause data processing from publishers to run more slowly and therefore the data may not load as quickly as usual. How To ...

Report Shows Data for Dates That Were Not Selected

When running a report and using either the Show by week or Show by month view option, you may notice that the report includes data for days that you did not select. For example, if a month ends in the middle of the week, your report may include data for the latter half of that week, even though it is not in the month you selected. What Causes The Is...

Values and Headlines are Mismatched in a Report

You may notice that the formatting for data in a report does not align with the column headers. Some values in the report match the column header, but others don't, and appear in a new row of data. What Causes The Issue? This problem is most commonly caused by a carriage return in one of the values, which gets the remaining data in the report to app...